What this worksheet does
It normalizes an annual, monthly or per-payment quoted rate without guessing whether the contract is flat or reducing. It then models entered fees and equal end-of-period repayments. The source is your current written offer.
Terms from the written offer
Use one currency code or declared unit throughout. Defaults are examples, not market terms.
Offer cash-flow estimate
Payment per repayment period—
Net proceeds received—
Opening balance owed—
Total repayments—
Total borrowing cost—
Normalized nominal annual rate—
Estimated effective annual cost rate—
Interest applies to—
The effective annual cost rate is an IRR estimate using equal end-of-period payments and the frequency selected. It is not a regulated APR and may differ because of exact dates, day counts, taxes, rounding, irregular instalments or local fee rules.
Repayment schedule
| Payment | Opening balance | Interest | Principal | Other charge | Total payment | Closing balance |
|---|
Before signing
Match the result to the lender’s dated repayment schedule. Confirm every mandatory charge, exact disbursement, late and early-settlement terms, insurance, compulsory savings, licence and the disclosure required by your regulator.
Privacy and exports
Calculations and exports run locally. Do not enter names, account numbers or identity details. Copy, CSV, JSON and PDF exports are available without signup or network submission.
Decision boundary
This is a planning estimate, not financial advice, an offer, approval, affordability assessment, provider ranking or recommendation. A lower modelled cost does not establish suitability.
Microfinance offer questions
Does the rate basis choose flat or reducing interest?
No. Rate basis and interest method are separate contract terms and separate inputs.
Why distinguish withheld and financed fees?
Withheld fees reduce the cash you receive. Financed fees increase the amount you owe, and you must declare whether they also accrue interest.
Why can the lender’s annual disclosure differ?
Legal conventions may use actual payment dates, prescribed day counts, taxes, rounding and different treatment of charges. Use the regulated disclosure as the legal reference.