Mortgage Scenario Comparison (Pro) United Kingdom

This mortgage scenario calculator compares up to three rate and term options on one loan: monthly payment, total interest, total repaid and the cheapest.

Mortgage Scenario Comparison (Pro) United Kingdom
£
%
years
%
years
%
years

What it does

The Mortgage Scenario Comparison (Pro) puts up to three rate-and-term combinations for the same loan side by side, showing the monthly payment, total interest and total repaid for each, and which is cheapest overall.

Data sources & parameters

This calculator uses standard financial formulas and runs entirely in your browser. It needs no external rate data — your result is computed only from the values you enter above.

We always strive to use the latest data for every variable so our results and reports are as accurate as possible. Even so, errors are possible — you should not rely on this tool or its report alone, and we accept no liability for any decision made based on it.

The formula

Monthly = Loan × i / (1 − (1 + i)^-n), where i = rate / 12 and n = years × 12

How it works

For each scenario the tool amortises the same loan amount at its own interest rate over its own term, then compares the total repaid across all three to identify the cheapest and the saving against the most expensive. Computed server-side.

Where it is used

  • Comparing a lower rate against a shorter term
  • Weighing a longer term for lower payments against higher total interest
  • Deciding between competing mortgage offers on the same loan

What the mortgage scenario calculator does

The calculator puts up to three rate and term combinations for the same loan side by side, showing the monthly payment, total interest and total repaid for each and which is cheapest overall. You see all three outcomes together instead of running separate calculations.

The deal with the lowest monthly payment is not necessarily the cheapest over its life, and the lowest headline rate does not always win once the term is counted. This Pro tool shows those trade-offs so the decision rests on total cost.

How the comparison works

Each scenario is a standard repayment mortgage: the same loan repaid at that scenario’s rate over its term with a level monthly payment that clears the balance by the end. The total repaid is the monthly payment times the number of months, and the total interest is the total repaid minus the loan. The tool works out all three for each scenario, then ranks them on total repaid and shows the saving of the cheapest against the most expensive.

Why monthly payment and total cost diverge

A lower monthly payment often means a higher total cost. A longer term spreads the repayment over more months, so each payment is smaller, but the debt is outstanding for longer and interest builds up over more years.

On a £250,000 loan at 5% over 25 years, the monthly payment is £1,461.48. Over 30 years at the same rate it falls to £1,342.05, noticeably easier on the budget. But the 25-year mortgage repays about £438,443 in total and the 30-year one about £483,139, so the lower payment costs about £44,700 more over the life of the loan.

Rate versus term

A third scenario in that example lowers the rate instead: 4.5% over 25 years. The monthly payment is £1,389.58, between the other two, but the total repaid is about £416,874, the lowest of the three, saving about £66,265 against the 30-year option.

So rate and term must be weighed together. A modest cut in the rate over a sensible term can beat both a longer term at the same rate and a shorter term at a higher rate, and ranking the scenarios on total repaid shows which.

What the tool leaves out

The calculator uses no tax figures and adds no fees, which keeps the comparison like for like but leaves real-world costs outside the model. For genuine offers, account separately for arrangement and product fees, cashback, early repayment charges and the rate that applies when an introductory period ends. A deal that looks cheapest here can lose its place once a large product fee is included.

Assumptions and sensible use

The model assumes one fixed rate for the whole term of each scenario and a capital and interest repayment structure. Real mortgages often move to a higher standard variable rate after an initial fixed or discounted period, so a long projection at a low introductory rate can be optimistic. Where an offer has an introductory rate, run a scenario at the likely follow-on rate too.

Enter your loan amount, set up to three combinations worth weighing, and compare the monthly payment, total interest and total repaid before using the cheapest-overall result to shortlist. For an actual mortgage decision, confirm the figures and wider costs with a qualified mortgage adviser.

This is general information only and not financial advice.

About This Mortgage Scenario Calculator

Use this mortgage scenario calculator to get an instant estimate based on the figures you enter. Adjust the inputs above to match your situation, or browse all our calculators to plan your next step.

Frequently asked questions

What does the mortgage scenario calculator compare?
It applies up to three rate and term combinations to one loan amount. For each it shows the monthly payment, the total interest and the total repaid, then tells you which scenario costs least overall and by how much.
Why can a lower monthly payment cost more in total?
A longer term reduces each monthly payment because the balance is repaid more slowly, but interest is charged on that balance for more years, so the total interest and total repaid are usually higher even though the monthly figure looks more comfortable.
Is a lower rate always the best choice?
A lower rate reduces the cost of borrowing, but the term matters just as much. A low rate over a long term can cost more overall than a slightly higher rate over a shorter term. Compare the total repaid, not just the rate or the monthly payment.
Does this tool include fees or taxes?
No. It applies the standard repayment formula to the loan, rate and term you enter, without arrangement fees, product fees or tax. When comparing real offers, add those costs separately, since they can change which option is cheapest.
Why is this a Pro server-side tool?
The scenario comparison runs on the server rather than in your browser, which keeps the comparison logic and detailed breakdown a premium output. You enter the figures and receive the monthly payment, total interest, total repaid and the cheapest-scenario result for each option.

About the author

Taha Kheirandish

Written and reviewed by

Taha Kheirandish

Economics student and independent researcher

Taha Kheirandish reads tax codes the way other people read maps — to find out where a system actually leads, not where it claims to go.

He is an economics student, and his work here is comparative by design. A pension deferral bonus in Quebec, a commuting allowance in Germany, a rent-increase ceiling in the Netherlands: each is a decision a government made about how money should move, and each reads differently once you set it beside eight others. He builds and checks these calculators across nine markets from primary sources — the regulation rather than a summary of it, the ministry’s own circular rather than a news item quoting it.

That is the editorial standard of the site as well as his habit. Every rate, threshold and bracket here carries the document it was read from and the date it takes effect, and gets re-checked when the law moves rather than when someone happens to notice.

He is a researcher, not a licensed adviser, and nothing on this site is personal financial advice. It is arithmetic done carefully with its sources shown — so that you can check it, and take it to someone who is.

Leave a Reply

Your email address will not be published. Required fields are marked *