What the calculator works out
Give it the amount, the annual interest rate and the term, and it returns the monthly payment, the total you'll repay, how much of that is interest and the month of the final payment. Mortgages, personal loans and car finance all use the same repayment maths. The currency symbol is for display only – no exchange rates are applied.
The Overpayments section takes a regular extra amount each month, a one-off lump sum or both. The loan is then run again month by month, with the extra money going straight off the balance, and you see how much sooner you're debt-free and how much interest you've saved.
How the monthly payment is worked out
Take the amount borrowed L, the number of months n and the monthly rate r (the annual rate divided by 12), and the monthly payment P is:
P = L × r ÷ (1 − (1 + r)−n)
At a rate of 0% the payment is simply the amount divided by the number of months. An interest-only loan costs L × r a month instead, and the full amount is still owed when the term ends.
Worked example
Borrowing £200,000 over 25 years at 5% gives a monthly rate of 0.05 ÷ 12, which is 0.004167, and n = 300 months. The payment comes to £1,169.18 a month.
| Measure | Result |
|---|---|
| Monthly payment | £1,169.18 |
| Total repaid (300 × £1,169.18) | £350,754 |
| Total interest | £150,754 |
| With an extra £100 a month | Paid off in 258 months, 3 years 6 months sooner |
| Interest saved by overpaying | About £24,500 |
The extra £100 makes the payment £1,269.18 and clears the loan in 258 months instead of 300. The 258th payment is a small one that mops up the last of the balance, which is why it isn't 257.
Interest first, capital later
Early payments are mostly interest, because interest is charged every month on the whole balance still owed. In month 1 of the example, £200,000 × 0.05 ÷ 12 is £833.33, so only £335.85 of the £1,169.18 payment reduces the debt.
The balance shrinks, so the interest does too, and the split tips the other way until almost all of the last payment is capital. The amortisation table shows the shift year by year, or month by month if you expand it.
Overpayments and early repayment
Small regular overpayments early in the term do the most, because every pound paid early stops interest being charged on it for all the years that follow.
Check the agreement for an early repayment charge or a yearly limit on overpayments before you start – many fixed-rate mortgages allow 10% of the balance a year without penalty.
What the figures leave out
- The rate is assumed to stay the same for the whole term, so variable, tracker and fixed-then-variable deals will differ once the rate changes.
- Some lenders charge interest daily rather than monthly, which can move the figures by a few pence or pounds.
- Arrangement fees, insurance and other charges aren't included.
This calculator is for illustration only and is not financial advice. Always check the figures with your lender or provider before making a decision.