Skip to content

Mortgage calculator: monthly payment and amortisation schedule

This mortgage calculator works out the monthly repayment from the loan amount, interest rate and term, then breaks down the interest and the amortisation schedule. Add an insurance rate if you pay one.

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.

Yearly bars for a loan of 100,000 at 3% over 20 years: the payment stays at 554.60, but the interest share falls every year while the share of principal repaid grows.

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.

Term2%3%4%
10 years920.13965.611,012.45
15 years643.51690.58739.69
20 years505.88554.60605.98
25 years423.85474.21527.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

MonthPaymentInterestPrincipalBalance
11,109.20500.00609.20199,390.80
21,109.20498.48610.72198,780.08
31,109.20496.95612.25198,167.83
41,109.20495.42613.78197,554.05
51,109.20493.89615.31196,938.74
61,109.20492.35616.85196,321.89
71,109.20490.80618.40195,703.49
81,109.20489.26619.94195,083.55
91,109.20487.71621.49194,462.06
101,109.20486.16623.04193,839.02
111,109.20484.60624.60193,214.42
121,109.20483.04626.16192,588.26

Year-by-year summary

YearInterestPrincipalBalance at year end
15,898.667,411.74192,588.26
25,673.207,637.20184,951.06
35,440.917,869.49177,081.57
45,201.548,108.86168,972.71
54,954.918,355.49160,617.22
64,700.778,609.63152,007.59
74,438.918,871.49143,136.10
84,169.069,141.34133,994.76
93,891.049,419.36124,575.40
103,604.529,705.88114,869.52
113,309.3110,001.09104,868.43
123,005.1210,305.2894,563.15
132,691.6810,618.7283,944.43
142,368.6910,941.7173,002.72
152,035.9211,274.4861,728.24
161,692.9711,617.4350,110.81
171,339.6411,970.7638,140.05
18975.5112,334.8925,805.16
19600.3312,710.0713,095.09
20213.7413,095.090.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

Frequently asked questions

What is the monthly payment on a 200,000 mortgage over 20 years?
At 3%, 1,109.20 a month before insurance; at 4%, 1,211.96. Enter your own rate for your figure.
And on 100,000?
554.60 a month at 3% over 20 years, before insurance.
20 or 25 years: which is better?
Over 25 years the monthly payment is lower but you pay more interest. For 100,000 at 3%, that is 474.21 a month and 42,263.49 of interest over 25 years, against 554.60 and 33,103.24 over 20 years. It comes down to the payment you can comfortably afford.
How much will I still owe when my fixed rate ends?
Open the last year of the fixed period in the schedule and read the balance column. For 200,000 at 3% over 20 years, a five-year fix leaves 160,617.22 to remortgage.
Why is the last payment a few pence different?
Payments are rounded to the penny, and the last one absorbs the small differences.
Is this the APR?
No. The APR or APRC includes all compulsory fees; this calculator uses the nominal rate.
Does it handle interest-only mortgages?
No, it models repayment mortgages. On an interest-only loan you pay just the interest each month (500 a month on 200,000 at 3%) and still owe the full 200,000 at the end.
Is my data stored?
No. Only your chosen currency is remembered, on your own device.