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.
Signal Lab · Model
Amortisation Schedule
Level-payment loan amortisation — payment, interest, principal, and remaining balance.
Illustrative sample (500k · 6.5% · 7 years). Not financial advice.
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
Download a prompt or export the Excel workbook from your current inputs.
Takes your current inputs — stays on your device.