unposted.ca
unposted.ca

Settled by the data

Fixed vs variable, year by year

The fixed-or-variable question is usually argued with today's rates and a guess about tomorrow. Here it's settled with what actually happened. For each year a 5-year term was signed, we take what that year's borrowers really got, on both sides, and follow the Bank of Canada prime rate that actually came next, to the dollar of interest each paid over the full term on a $500,000 mortgage. Across the 15 completed cohorts, variable came out ahead in 11.

SignedFixed rateVariable startFixed paidVariable paidWinner
20075.19%5.32% (P0.93)$121,588$59,922Variable by $61,666 *
20085.24%4.38% (P0.37)$122,792$59,338Variable by $63,454
20093.90%2.55% (P+0.30)$90,692$72,979Variable by $17,713
20103.80%1.90% (P0.85)$88,311$49,076Variable by $39,235
20113.64%2.25% (P0.75)$84,506$50,340Variable by $34,165
20122.99%2.65% (P0.35)$69,111$58,424Variable by $10,686
20132.99%2.58% (P0.42)$69,111$57,848Variable by $11,263
20142.94%2.35% (P0.65)$67,931$56,164Variable by $11,767
20152.59%2.05% (P0.65)$59,692$58,830Variable by $863
20162.39%2.15% (P0.55)$55,000$60,631Fixed by $5,630
20172.69%2.08% (P0.87)$62,043$53,487Variable by $8,556
20183.19%2.46% (P1.24)$73,836$56,640Variable by $17,196
20192.69%2.85% (P1.10)$62,043$74,161Fixed by $12,118
20201.97%1.75% (P0.70)$45,188$94,206Fixed by $49,019
20211.79%1.25% (P1.20)$40,999$93,901Fixed by $52,901

Interest paid over the completed 5-year term on a $500,000 mortgage, 25-year amortization. The variable path is simulated as an adjustable-payment mortgage: each month's rate is the real Bank of Canada prime minus that cohort's discount, with the payment recalculated as prime moves. Rates are achievable medians from shared offers, not a market average. A * marks any cohort whose variable sample is thin (fewer than 25 offers), where the year's result leans on fewer data points. This is history, not a prediction; the next five years are their own question. As of 2026-07-17.