Buy vs. Rent Calculator
Should you buy or rent your next home?
It's a question that more and more seem to be asking themselves.
In order to make your decision process a little bit easier, I've created the ultimate Buy vs. Rent Calculator.
This Excel file takes into account 20+ data points based on your personal situation and assumptions to create a robust and comprehensive model.
After adding your assumptions, you'll get a detailed overview of:
- Your mortgage amortization schedule
- Your buying scenario, including total housing costs accounting for inflation over the term of your loan, as well as your home equity pre and post selling costs
- Your rental scenario over time, including total costs and investment portfolio growth, assuming you'd invest the downpayment you would have made on a home purchase
- Your results, including whether buying is ever a good option, and if it is, your breakeven year
I initially created this model to scratch my own itch. I spent many hours tweaking and refining it to make it comprehensive, without compromising on the simplicity. And since creating this model, I've used it several times to purchase properties or consider different purchasing opportunities.
Every time, it's helped me understand my situation much better and make sound financial decisions.
I hope it can do the same for you.