Numrica logonumrica
Free tools. No signup. Just math.

Numrica · Personal finance · 7 min read

Variable rate vs fixed rate mortgage: what 20 years of data actually shows

Most borrowers make the rate-type decision by looking at one number: the initial monthly payment. The variable rate is lower today, so they take the variable rate. The fixed rate costs more upfront, so it gets dismissed as expensive. That reasoning treats a 25-year financial commitment like a short-term trade — and it produces predictably bad outcomes when rate cycles turn.

The choice between variable and fixed is not about which rate is lower right now. It is about how much uncertainty you are willing to absorb over the full term of the loan, and what that uncertainty costs you in both money and planning. Those are different questions, and they require the same tool: a simulation that runs both options to completion.

How variable rate mortgages work

A variable rate mortgage (also called a tracker or adjustable-rate mortgage) links your interest rate to a benchmark — typically Euribor in the eurozone, the Bank of England base rate in the UK, or SOFR in the United States. Your lender adds a fixed spread on top of that benchmark: Euribor + 1.2%, for instance. The benchmark moves; the spread stays constant.

When benchmarks are low, your payment is low. When benchmarks rise — as they did sharply across all major economies in 2022–2023 — your payment rises with them, typically with a 3–6 month lag depending on your reset frequency. Most variable mortgages reset every 3 or 6 months. The borrower absorbs the full benefit of falling rates and the full cost of rising ones. The lender bears neither.

Running the simulation: three scenarios over 25 years

The setup: €200,000 mortgage, 25-year term, variable at Euribor 6M + 1.2% spread (starting at 4.5%), fixed at 3.8%. This reflects current market rates across the eurozone and UK for a well-qualified borrower.

ScenarioVariable total interestFixed total interestDifference
Rates rise 2% over 5 years€182,400€143,600Fixed saves €38,800
Rates stay flat (no change)€154,200€143,600Fixed saves €10,600
Rates fall 2% over 5 years€126,800€143,600Variable saves €16,800

The pattern is asymmetric. In the adverse scenario (rates rise), fixed outperforms by €38,800 — nearly 20% of the original loan. In the benign scenario (rates fall 2 points), variable saves €16,800. The range of outcomes for the variable mortgage spans €55,600 depending on rate trajectory. The fixed mortgage has one outcome regardless of what happens to benchmarks.

The asymmetry that most comparisons miss

When analysts compare variable vs fixed, they usually show a single scenario — typically the one that happened historically in their country of analysis. A Portuguese borrower who took a variable mortgage in 2014, when Euribor was near zero, paid dramatically less than a fixed-rate borrower for six years. That same borrower, when Euribor crossed 4% in 2023, saw monthly payments increase by €400–600 on a €200,000 loan. Both facts are true. Neither tells the whole story.

The relevant comparison is not "which rate was lower in hindsight" but "what is the full range of outcomes, and can I absorb the downside?" A borrower who takes a variable mortgage in 2025 at Euribor + 1.2% and rates rise another 2 points faces a payment shock of roughly €250/month on a €200,000 loan — on top of the payment they already accepted. For households operating near the limit of their debt service ratio, that shock is not theoretical. It is the mechanism by which properties get sold in distress.

What the initial payment difference actually buys

At current market rates, the gap between variable and fixed initial payments on a €200,000, 25-year mortgage is roughly €80–120/month. Over the first year, the variable borrower saves approximately €1,000–1,400. That is the real price of rate certainty — not the total interest comparison, which extends across 25 years of unknown rate paths. The question is whether that premium is worth paying given your specific circumstances.

Three factors consistently push toward fixed: income that is itself variable or uncertain (making additional payment volatility dangerous), a loan-to-value ratio above 75% (less buffer if forced to sell), or a planning horizon that requires predictable monthly costs — a business with tight cash flow, a household with young children and rising expenses, a borrower near retirement with fixed income. Three factors push toward variable: substantial financial reserves that can absorb payment increases of €300–400/month without stress, a short intended hold period (selling within 5–7 years before the rate cycle fully turns), or a market where fixed rates carry a meaningful premium that the simulation suggests variable would outperform even in adverse scenarios.

The hybrid option and what it actually changes

Many lenders offer a hybrid structure: a fixed rate for an initial period (typically 2, 5, or 10 years) followed by a conversion to variable. The initial fixed period provides payment certainty during the highest-stress years of a mortgage — when the loan balance is largest and household finances are often tightest from the purchase itself. After the fixed period expires, the borrower faces the variable structure — but by that point, the balance is lower, the rate environment may have shifted, and the option to refinance to a new fixed product exists.

Hybrid structures do not eliminate rate risk; they defer and reduce it. They are often a sensible middle ground for borrowers who cannot absorb near-term payment volatility but believe rate environments may improve over a 5–10 year horizon.

Three things to do before signing

Run both options to completion, not just year one. The initial payment comparison is the least useful data point in the decision. What matters is total interest paid across the loan term under realistic rate scenarios. Use the Numrica mortgage calculator to simulate your specific loan amount, term, and current rate options — and look at total cost, not just monthly payment.

Stress-test your budget against a 2-point rate increase. If your variable rate is currently 4.5%, calculate what your payment becomes at 6.5%. Then calculate it at 7.5%. If either scenario breaks your budget — forces you to cut savings, defer necessary expenses, or sell — you are not positioned to take variable rate risk, regardless of what the initial payment looks like. The stress test is not pessimism. It is the minimum due diligence on a 25-year commitment.

Separate the rate decision from the lender decision. Banks bundle the rate type with their best promotional rates in ways that obscure the true comparison. The lowest variable rate from one lender versus the lowest fixed rate from another is not a clean comparison — spread, fees, penalty clauses on early repayment, and the lender's track record on spread increases at reset all affect the real cost. Get both options from the same lender on the same day, then compare against the market.

The initial payment is the wrong anchor for a 25-year decision. The right question is: across the full range of plausible rate paths, which outcome can you live with — and which one could sink you?

Simulate your mortgage across variable and fixed scenarios — no signup required.

→ Open the mortgage calculator

Results are illustrative. Actual rates, spreads, and payment structures vary by lender, region, and borrower profile. This article is educational and does not constitute financial advice. Consult a qualified financial professional before making mortgage decisions. Rate scenarios used are for illustration only and do not constitute a forecast.

About the author: Pedro Roriz teaches corporate finance and management accounting at IPOG, one of Brazil's leading business schools, with over 15,000 students trained. He founded TAG Business Solutions in 2016 — a financial BPO and CFO-as-a-service firm operating in Brazil and Portugal. He is also the creator of Numrica.com.