The formula
How to calculate mortgage payoff date
This puts a date on the mortgage and shows what an overpayment moves it to. Because overpayments go entirely to capital, the effect on the end date is much larger than the size of the payment suggests.
The two figures are the same calculation at different payment levels. The saving is the difference between total repayments in each case, which is entirely interest you no longer pay.
Fill in the following:
- Balance outstanding
- Interest rate (%)
- Monthly payment
- Monthly overpayment
Everything recalculates as you type, and the numbers in the address bar update with it, so a link to this page carries your figures with it.
The order the fields are filled in makes no difference to the result — the calculator recomputes the whole formula from whatever is currently in every field, not step by step. That means it is safe to adjust one number, watch the result change, and adjust it back, without worrying about resetting anything first.
Why mortgage payoff date matters
Most people who look up a mortgage payoff date calculation already have a specific number in mind — a quote, an offer, a target — and want to check it rather than learn the theory behind it. This page is built for that: enter your own figures, see the result immediately, and change any field to see how the answer moves without redoing the arithmetic from scratch each time.
Beyond a one-off check, the same calculation is worth revisiting whenever the underlying numbers change — a new interest rate, a change in income, a different term. Because the figures live in the page's own web address, coming back to update just one field and compare the new result against the old one takes seconds rather than starting again from a blank page.
The reason a page like this exists at all, rather than leaving the calculation to a spreadsheet or a textbook appendix, is that the formula behind mortgage payoff date is fiddly enough to get wrong by hand but not complicated enough to need specialist software. That middle ground — real enough maths to matter, simple enough to check instantly — is exactly what a dedicated calculator is for, and it is why the same figure recalculated here should match a careful manual calculation almost exactly.
A calculator like this one is often bookmarked and returned to repeatedly over months rather than used once, particularly for anything tied to an ongoing plan such as a mortgage, a savings goal or an investment being tracked. Because the figures live in the web address rather than only in memory, coming back to the same page with updated numbers is quicker than starting from a blank spreadsheet each time.
Worked example
Here is the calculation with the starting values:
- Balance outstanding: 180,000
- Interest rate: 4.5 %
- Monthly payment: 1,100
- Monthly overpayment: 200
That gives:
- Years to clear with the overpayment: 16.3 years
- Years to clear without it: 21.2 years
- Interest saved: 25,112.5
These figures are only the calculator's own starting values, included so the working is visible rather than hidden inside the tool above. Replace them with your own numbers and the same arithmetic applies — nothing about the method changes, only the inputs feeding it.
Reading the result
A £200 monthly overpayment on a £180,000 balance typically removes four to five years and tens of thousands in interest. The effect is largest early in the term, when the balance — and therefore the interest it accrues — is at its biggest.
Where this goes wrong. Most fixed-rate deals cap penalty-free overpayments at 10% of the balance a year. Exceeding it triggers an early repayment charge, often 1–5% of the excess.
A useful check on any unfamiliar result is to compare it against a rough mental estimate first — round the inputs to convenient numbers and see whether the calculator's answer lands in roughly the same territory. A wildly different figure usually means one of the fields was entered in the wrong unit, most often a percentage typed as a whole number where a decimal was expected, or the reverse.
Compare the mortgage rate against the return you would earn after tax. An overpayment is a guaranteed, tax-free return equal to the rate; investing may beat it, but not with certainty. Clear higher-rate unsecured debt before either.
Reducing the term saves far more interest, because the balance falls faster. Reducing the payment gives you flexibility now. Some lenders default to reducing the payment unless you specify otherwise.
The headline figure is years to clear with the overpayment. With 180,000 balance outstanding, 4.5 % interest rate and 1,100 monthly payment, that comes to 16.3 years. Change any field and the figure moves with it.
Whenever one of the underlying figures changes — a new interest rate, a different balance, an updated term — since the result only reflects what is currently in the fields. There is no need to keep a separate record of past results; the web address for a filled-in version already carries the figures used to produce it.
Not unless a tax rate or a fee is explicitly one of the inputs above. Where it is not, the figure shown is a gross calculation, and any tax due depends on your personal circumstances and current tax rules, which are worth checking separately.
The arithmetic itself is exact — the calculator applies the formula shown above precisely, with no rounding until the final figure is displayed. The uncertainty, where it exists, is entirely in the inputs: an estimated rate or an approximate balance carries that same approximation through to the result.