What you enter stays on this device.
Method and sources checked on by the Calkavo editorial team · Our method
Embed this calculator on your site
Paste this code into your page (HTML block). The calculator appears in a frame, ad-free, and stays free. Keep the link under the frame: it shows where the tool comes from.
The monthly repayment on a fixed-rate loan comes from the annuity formula M = C × t ÷ (1 − (1 + t)^−n), where t is the annual rate divided by 12; borrowing 100,000 at 3% over 20 years costs 554.60 a month.
Two worked examples
A repayment mortgage is paid back in equal monthly instalments. Divide the annual rate by 12 to get t, count the months (n), and the annuity formula gives the repayment.
M = C × t ÷ (1 − (1 + t)^−n)
Borrow 300,000 at 6% over 30 years and t is 0.5%, n is 360, so you repay 1,798.65 a month. A smaller loan of 200,000 at 3% over 20 years costs 1,109.20 a month and 66,206.43 in interest over the term. In its first month, 500 goes on interest and only 609.20 comes off the balance.
Monthly repayments per 100,000 borrowed
Figures before insurance, by rate and term, in any currency. The repayment scales with the amount, so double it for 200,000 (to within a penny) or multiply by 1.5 for 150,000.
| Term | 2% | 3% | 4% |
|---|---|---|---|
| 10 years | 920.13 | 965.61 | 1,012.45 |
| 15 years | 643.51 | 690.58 | 739.69 |
| 20 years | 505.88 | 554.60 | 605.98 |
| 25 years | 423.85 | 474.21 | 527.84 |
What is left when a fixed rate ends
On a fixed-rate deal the rate is set for only part of the term, and the balance then has to be remortgaged. The schedule tells you how big it will be. For the 200,000 loan at 3% over 20 years, 160,617.22 is still owed after five years and 114,869.52 after ten. Halfway through, then, more than half the loan is still outstanding, even though 47,973.52 of interest has already gone, 72% of the total.
Half a point more, or five extra years
Keep the 200,000 over 20 years. Going from 3% to 3.5% adds 50.72 a month (1,159.92) and 12,174.23 of interest. At 4%, the repayment reaches 1,211.96 and the interest 90,870.79. That spread is roughly what is at stake when you shop around for your next deal.
Stretching the term works the other way. At 3% over 25 years the repayment drops to 948.42, but interest climbs to 84,527.18, which is 18,320.75 more than over 20 years. Weigh the 160.78 you save each month against that extra cost.
Reading the amortisation schedule
Each month, interest is the outstanding balance times t. The rest of the payment repays principal, which cuts the balance by the same amount, so the principal share grows with every payment. The last payment is adjusted by a few pence or cents so that the loan is cleared exactly.
The first 12 months of a 200,000 loan at 3% over 20 years
| Month | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | 1,109.20 | 500.00 | 609.20 | 199,390.80 |
| 2 | 1,109.20 | 498.48 | 610.72 | 198,780.08 |
| 3 | 1,109.20 | 496.95 | 612.25 | 198,167.83 |
| 4 | 1,109.20 | 495.42 | 613.78 | 197,554.05 |
| 5 | 1,109.20 | 493.89 | 615.31 | 196,938.74 |
| 6 | 1,109.20 | 492.35 | 616.85 | 196,321.89 |
| 7 | 1,109.20 | 490.80 | 618.40 | 195,703.49 |
| 8 | 1,109.20 | 489.26 | 619.94 | 195,083.55 |
| 9 | 1,109.20 | 487.71 | 621.49 | 194,462.06 |
| 10 | 1,109.20 | 486.16 | 623.04 | 193,839.02 |
| 11 | 1,109.20 | 484.60 | 624.60 | 193,214.42 |
| 12 | 1,109.20 | 483.04 | 626.16 | 192,588.26 |
Year-by-year summary
| Year | Interest | Principal | Balance at year end |
|---|---|---|---|
| 1 | 5,898.66 | 7,411.74 | 192,588.26 |
| 2 | 5,673.20 | 7,637.20 | 184,951.06 |
| 3 | 5,440.91 | 7,869.49 | 177,081.57 |
| 4 | 5,201.54 | 8,108.86 | 168,972.71 |
| 5 | 4,954.91 | 8,355.49 | 160,617.22 |
| 6 | 4,700.77 | 8,609.63 | 152,007.59 |
| 7 | 4,438.91 | 8,871.49 | 143,136.10 |
| 8 | 4,169.06 | 9,141.34 | 133,994.76 |
| 9 | 3,891.04 | 9,419.36 | 124,575.40 |
| 10 | 3,604.52 | 9,705.88 | 114,869.52 |
| 11 | 3,309.31 | 10,001.09 | 104,868.43 |
| 12 | 3,005.12 | 10,305.28 | 94,563.15 |
| 13 | 2,691.68 | 10,618.72 | 83,944.43 |
| 14 | 2,368.69 | 10,941.71 | 73,002.72 |
| 15 | 2,035.92 | 11,274.48 | 61,728.24 |
| 16 | 1,692.97 | 11,617.43 | 50,110.81 |
| 17 | 1,339.64 | 11,970.76 | 38,140.05 |
| 18 | 975.51 | 12,334.89 | 25,805.16 |
| 19 | 600.33 | 12,710.07 | 13,095.09 |
| 20 | 213.74 | 13,095.09 | 0.00 |
What the calculator leaves out
It uses the nominal rate. The APRC of a real offer also includes arrangement, valuation and broker fees. Use the calculator to compare scenarios; your lender's offer and its European Standardised Information Sheet (ESIS) are what count. If your lender collects payments by direct debit from an account abroad, check the IBAN you give them, since one wrong digit can get the first payment rejected.
To compare two offers as a percentage, the percentage calculator is handy. If your deposit is held in another currency, try the currency converter.
Method and sources
References used:
This tool is checked by automated tests against known cases. Spotted a mistake? Report it on the contact page.
Last updated