Rent vs Buy Calculator – Excel Template

Compare the true cost of renting with buying a home over 15 years, including mortgage, fees, growth and equity.

• Automatic summary: Loan amount, Monthly mortgage payment, Cash needed upfront, Buying is cheaper from year
• Calculated for you: Year, Rent paid in year, Cumulative rent, Mortgage paid in year, Owner costs in year, Cumulative cost of buying, Home value, Loan balance, Lost return on upfront cash, Net cost of buying, Better option
• Colour-coded status and progress highlights
• Built-in chart that updates as you type
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.