01

Short answer

Calculate the amortisation schedule to the end of the fixed-rate period. Remaining debt determines refinancing risk; test higher, equal and lower follow-on rates as scenarios.

02

Important variables

  • Price, rent and holding period
  • Rate, principal and remaining balance
  • Buying, maintenance and selling cost
  • Appreciation and alternative return
RATIOXA TOOLRun your own numbersMortgage calculator →
03

Worked example

If €250,000 remains after ten years, a follow-on rate rising from 3% to 5% initially adds about €417 monthly interest.

04

Break-even: What changes the result?

Test the main driver as a cautious, central and optimistic range. Also check whether the ranking reverses at a crossover or remains robust across the range.

05

Common mistakes

  • Comparing mortgage payment directly with rent
  • Omitting transaction cost or remaining debt
  • Treating appreciation as guaranteed
07

Sources & assumptions

Continue learning

Continue with your numbers

Was this guide helpful?