Mortgage Amortisation Schedule Calculator UK
Generates the full month-by-month amortisation schedule of a repayment mortgage, showing interest, capital and the balance owed for each instalment.
On a 25-year repayment mortgage at a 4.5% interest rate, about two thirds of the first monthly instalment goes on interest, and the interest paid over the whole term comes to about two thirds of the amount borrowed. This calculator shows how that split changes month by month, so you can see the exact balance still owed at any point in the term.
Repayment mortgages, where each monthly payment covers both interest and part of the capital, are the usual structure for a home loan in the UK. The calculator uses the standard annuity method: the instalment stays the same for the whole term, while the share going on interest falls as the balance shrinks. The same mechanics apply to a terraced house in Leeds on a 25-year deal or a flat in Edinburgh on a 30-year deal, with only the balance, rate and term changing.
Each row of the schedule shows four figures: the instalment, the interest charged for the month, the capital repaid and the balance left afterwards. The monthly rate is the annual interest rate divided by 1200, and the interest each month is the previous balance multiplied by that monthly rate. Because the instalment is fixed, any capital repaid early in the term stops attracting interest for many years.
Length of term matters as much as the rate. Stretching a mortgage from 25 to 30 years lowers the instalment but raises the total interest, and the schedule makes that trade-off visible month by month.
Enter the balance you still owe rather than the original loan, because the schedule runs forward from that point. The figures assume the rate stays constant. Tracker and variable rates can change during the term, and the schedule does not follow those changes. Fees, buildings insurance and early repayment charges are not included, so treat the results as an estimate.
The explanation below uses metric units; the calculator works in either system.
The result updates automatically.
The loan balance still owed to the lender
Number of years left on the agreement
The reference rate the loan is linked to
The margin the lender adds on top of the reference rate
Estimated monthly repayment
Value calculated using the standard repayment method, with equal instalments
- Nominal interest rate (NIR)
- 4.40 %
- Total interest paid
- £120,411
- Total paid over the life of the loan
- £270,411
Monthly repayment schedule
| Month | Repayment | Interest | Principal | Outstanding balance |
|---|---|---|---|---|
| 1 | £751.14 | £550.00 | £201.14 | £149,798.86 |
| 2 | £751.14 | £549.26 | £201.88 | £149,596.98 |
| 3 | £751.14 | £548.52 | £202.62 | £149,394.36 |
| 4 | £751.14 | £547.78 | £203.36 | £149,191.00 |
| 5 | £751.14 | £547.03 | £204.11 | £148,986.89 |
| 6 | £751.14 | £546.29 | £204.86 | £148,782.03 |
| 7 | £751.14 | £545.53 | £205.61 | £148,576.43 |
| 8 | £751.14 | £544.78 | £206.36 | £148,370.07 |
| 9 | £751.14 | £544.02 | £207.12 | £148,162.95 |
| 10 | £751.14 | £543.26 | £207.88 | £147,955.07 |
| 11 | £751.14 | £542.50 | £208.64 | £147,746.43 |
| 12 | £751.14 | £541.74 | £209.40 | £147,537.03 |
How it works
Formula
How the calculation works
Mortgage Amortisation Schedule: How Repayments Split Over Time
A mortgage amortisation schedule is a month-by-month record of a loan. It shows how much of each repayment goes on interest, how much reduces the capital, and how much is still owed afterwards. This calculator builds that schedule from four inputs: the outstanding balance, the remaining term, the interest rate and the number of instalments that follow from the term. It is most useful when you want to understand how a repayment mortgage works, not only what the monthly figure is.
Why the instalment stays constant
Repayment mortgages are typically calculated on an annuity basis. The instalment, shown as P in the formula, is set so that the loan is exactly cleared after the last payment when interest is charged each month on the outstanding balance. Because the instalment is fixed, the mix inside it has to change. At the start the balance is at its highest, so interest takes the largest share. As capital is repaid, the balance falls, the interest falls with it, and a growing share of the same instalment goes on capital.
Reading each column of the schedule
Each row contains four figures. The instalment is the total paid in that month and, under this method, it is the same in every month. The interest is the balance from the previous month multiplied by the monthly rate. The capital repaid is the instalment minus the interest. The balance is the amount still owed after that payment, which is the previous balance minus the capital repaid. At the end of the term the balance should reach zero. A lender's own schedule may differ slightly from this one because of the way it rounds each figure, so the lender's statement is the one to rely on.
The monthly rate and the interest rate
The interest rate, shown as AIR in the formula legend, is the yearly rate quoted on the loan. Dividing it by 1200 turns a percentage into a monthly decimal in one step, which is the convention used in this calculator. For example, an interest rate of 4.5% gives a monthly rate of 0.00375. The rate that applies to your loan is the one stated in your mortgage offer, which will say whether the rate is fixed or variable. The APR quoted in a mortgage illustration is a different figure and should not be entered here, because the calculator works with the interest rate alone.
Why the interest share falls over time
The interest share starts high because the balance is largest in the early months. Using a 25-year term at a 4.5% interest rate as an illustration, about two thirds of the first instalment is interest. The interest share falls steadily over the term, and the capital share grows each month, because the same instalment is applied to a balance that keeps shrinking. Overpayments made in the early years have the largest effect for the same reason. They remove interest that would otherwise be charged on a large balance for many years.
Total interest and what it reveals
Adding the interest column across all rows gives the total cost of borrowing before fees. On a 25-year term at a 4.5% interest rate, that total comes to about two thirds of the original amount borrowed, which shows how much a long term can add. Total interest is useful when comparing a rate reduction, a change in term, a balance transfer or a remortgage, because each one saves interest that has not yet been charged. A small change in rate or term can have a larger effect on the total than the monthly figure suggests.
Term length and total cost
Term is one of the strongest influences on the total cost of a mortgage. A shorter term means higher monthly instalments but lower total interest. A longer term reduces the instalment and makes the mortgage easier to afford month to month, but it increases the total interest paid over the life of the loan. The remaining term can be changed without altering the other inputs, so you can compare how the monthly figure and the schedule respond. The term you can take depends on the lender's own criteria, so check what is available before planning around a particular length.
Edge cases
With a zero rate, the formula cannot be evaluated as written, and each instalment is simply the balance divided by the number of instalments. With a term of one instalment, the single payment clears the balance in one row. With a zero or negative balance, or a zero term, there is no meaningful repayment to schedule and the inputs should be checked.
When to use this calculator
Use it to see the split between interest and capital, to check the balance you will owe on a future date, or to estimate the effect of a change in term. It is also a sensible first step before speaking to a lender, because it shows how the balance falls and whether a planned overpayment would make a real difference.
Common mistakes
Four errors come up often. The first is entering the original loan amount rather than the balance still owed, which overstates the remaining interest. The second is entering the APR in place of the interest rate, because the calculator works with the interest rate alone. The third is entering months where the calculator expects years, or the reverse. The fourth is ignoring fees, insurance and early repayment charges, which increase the real cost of the loan but do not appear in the schedule.
Limitations and rate changes
The schedule assumes the rate stays constant for the whole term. In practice, a variable rate can change whenever the lender revises it, and a fixed rate ends when its fixed period does, after which the balance usually moves to a new deal or to the lender's standard variable rate. Each change restarts the calculation from the balance outstanding at that point, so the schedule should be read as a snapshot. For exact figures, use the schedule supplied by your lender and the terms in your mortgage offer. MoneyHelper, run by the Money and Pensions Service, offers free, impartial guidance on mortgage options.
Frequently asked questions
What is a mortgage amortisation schedule?
An amortisation schedule is a month-by-month table that shows how each repayment on a loan is divided between interest and capital. For every month of the term it records the instalment, the interest charged, the capital repaid and the balance still owed after the payment. It tells you at any point how much remains to be repaid and what the total interest will be by the end of the term. It is an estimate based on a constant rate, so the figures set out by your lender are the ones that govern your mortgage.
Why does so much of my monthly payment go on interest at the start?
Interest is charged each month on the balance still owed. At the start of a mortgage that balance is at its highest, so interest takes the largest share of the fixed instalment. As capital is repaid, the balance falls, the interest falls, and a greater share of the same payment goes on capital. Near the end of a repayment mortgage, the instalment is almost entirely capital. With a 25-year term at a 4.5% interest rate, about two thirds of the first instalment is interest.
How is the monthly repayment worked out on a repayment mortgage?
The instalment is calculated with an annuity formula. It multiplies the capital outstanding by the monthly rate and by one plus the monthly rate raised to the number of instalments, then divides by one plus the monthly rate raised to the number of instalments, minus one. The monthly rate is the annual interest rate divided by 1200, and the number of instalments is the remaining term in years multiplied by 12. The formula keeps the instalment constant for the whole term, which is why the schedule can be built from it month by month.
Does the schedule change when my interest rate changes?
Yes, on a variable-rate mortgage. The rate can change during the term, and when it does, the instalment for the remaining term changes too. Fixed-rate deals keep the same rate until the fixed period ends. This calculator assumes a constant rate for the whole remaining term, so it gives an estimate. Your mortgage offer and your lender's statements set out how and when a rate change takes effect.
What is the difference between interest and capital in each instalment?
Interest is the charge for borrowing the balance that is still owed during that month. Capital is the part of the instalment that reduces the balance. The two add up to the instalment, so when interest is higher, capital is lower by the same amount. Over the full term, the capital repaid adds up to the original amount borrowed, while the interest adds up to the total cost of borrowing before fees.
Can I use the schedule to plan an overpayment?
Yes. The schedule shows the balance at any future month, which is the starting point for judging how an overpayment would change the remaining term or the instalment. An overpayment made early removes interest that would have been charged on the larger balance for many years. Some mortgages allow overpayments without charge, while others apply an early repayment charge, so check your mortgage terms with your lender before making a payment. MoneyHelper offers free guidance on mortgage choices.
Related calculators
UK Mortgage Repayment Calculator
Calculates the monthly repayment on a UK capital and interest mortgage from the loan amount, term, reference rate and lender margin.
Mortgage Overpayment Calculator: New Payment and Savings
Work out the new monthly repayment and total interest saved when you overpay part of a UK repayment mortgage, with the term kept the same.
Mortgage Outstanding Balance Calculator
Calculates the mortgage balance still owed after a chosen number of years, with capital repaid, interest paid and the share of the loan cleared.
Constant Amortisation Calculator with Monthly Schedule
Calculates declining instalments under constant amortisation, with a month-by-month schedule of interest, capital repaid and balance outstanding.
By RivoCalc · Reviewed under our editorial methodology · Updated 25 July 2026
This calculator gives estimates for information only, based on a repayment schedule with a constant rate for the whole term. It is not financial advice. Actual figures depend on your mortgage offer, changes in the reference rate, and other costs such as fees, insurance and early repayment charges. For advice on your situation, speak to a mortgage adviser authorised by the Financial Conduct Authority (FCA) or to your lender.
