An amortization schedule generator that builds a complete month-by-month payment table for any fixed-rate loan or mortgage. Each row splits the payment into interest and principal and shows the falling balance — so you can see precisely how a loan is paid down, and how an extra monthly payment shortens the term. For borrowers comparing offers, planning overpayments, or checking a lender’s figures.
How it works
First the fixed monthly payment is set with the amortising formula M = P · r(1+r)ⁿ ⁄ ((1+r)ⁿ − 1), where r is the monthly rate (annual rate ÷ 12 ÷ 100) and n is the term in months. Then the tool walks month by month:
- Interest = current balance × monthly rate
- Principal = (fixed payment + any extra) − interest
- New balance = balance − principal
It repeats until the balance hits zero, totalling the interest and counting the months to get the payoff time. Early rows are interest-heavy; later rows are principal-heavy.
Example
A £200,000 loan at 5.5% over 25 years has a payment of about £1,228/month:
- Month 1: interest ≈ £917, principal ≈ £311, balance ≈ £199,689
- Total interest over 25 years: about £168,000
Add £200 extra each month and the loan clears in roughly 20 years, cutting total interest by around £40,000.
| Month | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | £1,228 | £917 | £311 | £199,689 |
| 120 | £1,228 | £676 | £552 | £146,900 |
| 300 | £1,228 | £6 | £1,222 | £0 |
Everything is calculated in your browser; no loan details ever leave your device.