Simulation: Should I rent or buy?

I’ll build a simulation tool here. Until I complete it you should check out my Google Sheet that can run the numbers for now. For now, you will need to make a copy of the sheet to input your own values.

You fill in your inputs in Column B and the sheet will try to calculate some outputs on suggested equivalent rent levels in column E through G. The sheet suggests some values in Column C – some are based on my general intuition or research; some are based on calculations on the input fields in Column B. All the final values are calculated from the Column B inputs though so if you lower your down payment from 20% the sheet will calculate a suggested bank loan for you in Column C but you’ll need to note it in Column B before the changes take effect.

A hidden assumption in the sheet is that all the interest paid is within the 100,000 kr progression limit for tax deductions for a couple or 50,000 kr for a person filing individually. I’ll build a proper amortization table at some point to better capture outliers, but even a 4 million kr property at 2.5% will stay within this limit for a couple. Also, the deduction is just lowered a bit after 100,000 kr but is not completely removed so the calculation error is not too big.

I’d appreciate any input you have! Either comment here on the page, at my post here, or reach out to me by email. Don’t judge me by the ugliness of it all though 😉

Leave a Reply

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