Rent vs. Buy Calculator
Originally published: 07/09/2020 07:16
Last version published: 18/09/2020 23:02
Publication number: ELQ-43237-2
View all versions & Certificate
certified

Rent vs. Buy Calculator

Rent or Buy your Next Home? This Calculator can help decide what's right for you!

Description
The model compares the net value generated by buying a home vs. renting one, until mortgage pay-off, assuming availability of the same initial sum of money. Target home price assumed as starting sum for the “Rent” scenario and target home price less down-payment assumed for the “Buy” scenario.

The procedure requires:
• selecting a target home price and a target rent price for properties of comparable size and location (or same property);
• replacing default numbers with data tailored to your personal situation, for more accurate results.

More specifically, data to be entered include, for the “Buy” scenario:
• Target Home Price
• Buying Closing Costs (% of home cost)
• Annual Property Tax, Home Insurance, Maintenance (% of home value)
• Annual Property Appreciation %
• Down-payment %
• Mortgage Rate (fixed/variable)
• Mortgage Term (or time horizon, if no mortgage is taken)
• Selling Closing Costs (for the sake of uniform comparison, sale is assumed at the end of the mortgage term, at the estimated appreciated value)

And for the “Rent” scenario:
• Target Monthly Rent
• Security Deposit
• Renter’s Insurance (% of annual rent)
• Annual Rent Appreciation %

Based on the above, the model calculates mortgage repayment schedule and value generated during the time horizon for the 2 scenarios, taking into account all costs plus return on the invested liquidity.

This Best Practice includes
1 Excel workbook

Domenico Cristarella offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


2.5 / 5 (2 votes)

please wait...