Mortgage Outstanding Balance Calculator

How the calculation works

Outstanding balance: how much you still owe the lender

The outstanding balance, also called the capital outstanding or the amount still owed, is the part of a mortgage that has not yet been repaid. Interest is charged on this figure, so knowing it helps borrowers make better decisions about overpayments, remortgaging and switching to a new deal when the current one ends. It is also the starting point for any conversation with a lender about the mortgage.

The annuity method and the shifting split of each payment

The calculator uses the annuity method. The monthly payment is fixed for the whole term, but the split between interest and capital changes every month. In the early years, interest on the full loan absorbs most of each payment. As the balance falls, the interest part shrinks and the capital part grows, even though the total payment does not change.

This creates a practical consequence. In the first ten years of a 30-year mortgage, the balance falls much more slowly than a straight line would suggest. Using the formula with a constant rate of 4% a year, the balance after five years is about 90% of the original loan. After ten years it is about 79%, and after 25 years about 26% remains. The reduction is geometric rather than linear, so the largest falls happen in the later part of the term.

These figures are worked examples for a constant rate and monthly payments. They are not forecasts for any real mortgage, and your own schedule will depend on your rate, term and any changes made during the loan.

The formula behind the calculator

The calculator uses the expression B(k) = C × [(1+r)^n − (1+r)^k] / [(1+r)^n − 1]. Here C is the original loan, r is the monthly interest rate, n is the total number of monthly payments and k is the number of payments already made. The annual nominal rate i is divided by 1200 to give r, so a rate of 4% a year becomes a monthly rate of about 0.33%.

The formula works in monthly steps. Years are converted to months by multiplying by 12, which is why the term and the years elapsed are both entered in years. A lender's own calculation method, including how it charges interest between payment dates, can produce a slightly different balance from the result here. The difference is usually small, but it grows if you have made irregular payments or overpayments.

Limits on the inputs: loan amount, term and zero rate

The formula is valid only when the inputs make sense. The loan amount C must be positive, since a zero or negative value does not describe a loan and gives meaningless balances. The term n must be at least one year, that is at least 12 monthly payments, because with n = 0 the denominator (1+r)^n − 1 is zero. The same denominator is zero when the rate is 0%, because r is then zero and every power of (1+r) equals one. For a 0% loan the balance falls in a straight line, and the balance is C × (n − k) / n. This is the limit the expression approaches as r tends to 0, so it is the figure to use when the rate is zero.

Why the early years matter most for overpayments

An overpayment made early removes capital that would otherwise attract interest for many years. A lump sum paid in year two therefore saves more interest in total than the same sum paid near the end. Later in the term, the outstanding balance is smaller and the remaining interest is lower, so each overpayment has a smaller effect.

Depending on the lender, an overpayment can either shorten the term or reduce the monthly payment, and the choice changes the total interest saved. The terms of your own deal set out any limit on overpayments without a charge and any early repayment charges that apply. Check your mortgage offer before deciding, and ask the lender to confirm the figure in writing.

Remortgaging and product transfers

When a fixed or discounted deal ends, the borrower usually moves to the lender's standard variable rate unless a new deal is arranged. A product transfer keeps the same lender, while remortgaging moves the loan to a new lender. In both cases, the balance on the day of the change sets the amount the new deal must cover.

The balance and the property's current value together give the loan-to-value ratio, or LTV, which lenders use when they assess a new application. Because the LTV depends on the balance, a precise figure matters before comparing offers. Use the redemption figure rather than this estimate when you request a new offer.

Interest rate type and what the calculator assumes

The calculator assumes a single constant rate for the whole term. Real UK mortgages often differ. A fixed-rate deal holds the rate for an initial period, for example two, five or ten years, and then the mortgage moves to the lender's standard variable rate. A tracker mortgage follows a reference rate, such as Bank Rate, which the Bank of England sets, or SONIA (the Sterling Overnight Index Average), which the Bank of England publishes, plus a fixed margin. Its monthly payment and balance path change whenever the reference rate moves.

For a tracker or variable loan, enter the current rate as a rough guide and recalculate after each change. The result then shows the balance under that rate only, not the balance you will actually owe at the end of the term.

What the calculator does not include

The model leaves out several features that change the balance path:

• overpayments already made or planned,
• fees added to the loan,
• payment holidays or changes to the monthly payment,
• changes in the interest rate during the term,
• interest-only or part-and-part repayment structures,
• a mix of fixed and variable periods within the same mortgage.

If any of these apply, the real outstanding balance will differ from the estimate. An interest-only part, for example, does not reduce the capital at all during its term.

Common mistakes

Several errors appear often when people use a balance calculator. The first is entering the years remaining as the total term. The formula needs the full term from the start of the mortgage, plus the years already elapsed. The second is comparing the outstanding balance with the total cost of clearing the mortgage. The total still to pay is larger, because it includes all the interest that will accrue until the final payment.

The third mistake is confusing the balance with the redemption figure. The redemption amount can include early repayment charges and interest accrued to a specific date. The fourth is forgetting that the rate changes at the end of a fixed period, which means the old monthly payment may no longer apply. Finally, some people use the original loan amount when comparing a remortgage, which ignores all the capital already repaid.

Where to find the exact figure

The most reliable figure comes from your lender. Your online account and, where provided, the annual statement show the current balance. For the exact amount needed to repay the mortgage on a particular date, request a redemption statement. Keep a note of the date, so that the figure can be compared with the result of this calculator on the same day.

When to speak to a mortgage adviser

If you are considering a large overpayment, a remortgage, a product transfer or a change to your repayment terms, speak to a mortgage adviser authorised by the Financial Conduct Authority (FCA). The FCA regulates mortgage lending and advice in the UK. An authorised adviser can review your mortgage offer, explain early repayment charges and compare deals across the market. Check the Financial Services Register to confirm that an adviser is authorised before you proceed.

Summary

The balance depends on the interest rate, the full term and the number of payments made, and it falls slowly at first on a repayment mortgage. This calculator gives a planning figure for a constant rate. Confirm the exact amount with your lender before making any decision about overpayments or remortgaging.