Amortisation Schedule
Level-payment loan amortisation — payment, interest, principal, and remaining balance.
Measures the fixed periodic payment and how each period splits interest vs principal.
Use it when sizing facilities, comparing terms, or explaining debt service.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
Amortisation Schedule
Level-payment loan amortisation — payment, interest, principal, and remaining balance.
Sample figures (500k · 6.5% · 7 years).
Loan inputs
Principal, annual rate, and term in years. Assumes level monthly payments. Persist locally · Jump to results
Payment and schedule
Monthly payment summary, then year-aggregated schedule.
Equations
- Payment = P × r(1+r)^n ÷ ((1+r)^n − 1) · r = annual÷12 · n = months
| Year | Interest | Principal | Ending balance |
|---|
How this is calculated
- Level monthly payment from the standard amortising loan formula
- Each month: interest = balance × monthly rate; principal = payment − interest
- Schedule below aggregates interest and principal by year
Illustrative — not financial advice. Fees, balloon payments, and rate resets are out of scope.
Take it with you
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.