Overview

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)
  • Term
  • Selling Closing Costs (sale assumed at the end of 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.

Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
INFLATION CALCULATOR (46 COUNTRIES)
22
0
This model actually includes two calculators: year-on-year inflation calculator flat rate inflation calculator   The first one calculates the equivalent…
PREPAID EXPENSE & UNEARNED INCOME CALCULATOR
494
37
THE MODEL CALCULATES MONTHLY AMORTIZATION FOR PREPAID EXPENSES AND/OR UNEARNED INCOME, GENERATING RELEVANT ACCOUNTING ENTRIES. Prepaid expenses represent expenditures that have been…
NET TOTAL RETURN ON BOND INVESTMENT CALCULATOR
690
24
CALCULATE NET TOTAL RETURN ON BOND INVESTMENT DENOMINATED IN ANY CURRENCY, broken-down by trading gains (realized & unrealized), foreign exchange gains (realized…
ANALYTICAL RETURN ON INVESTMENT (ROI) CALCULATOR
774
79
This tool calculates return of an investment denominated in any currency, split between Realized and Unrealized and further dissected into…
FINANCIAL MANAGEMENT SYSTEM
1,041
85
FULLY FLEDGED ACCOUNTING AND FINANCIAL MANAGEMENT PACKAGE FOR PRIVATE INVESTORS, SMALL FINANCIAL SERVICE BUSINESSES AND PROFESSIONALS A comprehensive tool to…
DEPRECIATION SCHEDULE CALCULATOR
1,060
72
CALCULATE DEPRECIATION OF AN ASSET USING 4 OF THE MOST POPULAR DEPRECIATION METHODS. Fully editable version available. This excel tool will calculate the…
See All