Rent versus Buy Calculator

November 12th, 2017 | Posted in Real Estate, Rent vs Buy, Tools

If you want to jump right in to the Rent versus Buy Calculator to test your own assumptions, please download the excel file here

[Mar. 2023 update: version 3.2 of the spreadsheet has been uploaded. Many thanks to Alexander K. and Keith H., kind readers of the site who pointed out the correct way to calculate the tax shield on US mortgage interest payments. The spreadsheet now reflects a comparison between the standard tax deduction and the itemized tax deduction in your scenario.]

The Rent Versus Buy Debate

It is often said that “buying is always better than renting” or that “renting is flushing money down the drain”.

The argument is as follows: When you rent, your rent payments help your landlord pay their mortgage, while making you none the richer. However, when you buy a home, your monthly payments go towards your own mortgage, which increases your net worth.

Seems simple, right? Not so fast.

There are several factors which make this decision more complicated to assess:

• Homeownership comes with many more costs than just your mortgage payment. You’ll also pay fees such as property taxes, home maintenance, and condo fees. It is important to compare the total annual costs to buy or rent a comparable home.
• Transaction fees to buy / sell a home. When you buy a home, you’ll pay for legal fees, home inspection fees, and land transfer taxes. When you sell your home, you’ll pay a real estate agent (typically 4-6% of the total sale price) to find buyers, and negotiate / close the deal. This can add up to tens of thousands of dollars.
• A mortgage is essentially renting money from the bank. With every mortgage payment you make, a portion will go towards reducing the mortgage ‘principal’, and the remaining portion will go towards interest payments. Any dollar you spend on interest does not build your net worth. As an example, the total interest payments that you’d make on a $175,000 mortgage (over a 25 year term and a 4% interest rate) are over $100,000. This is $100,000 that you’ve paid to the bank to rent their money.
• Opportunity costs. If you choose to rent your home, the money that would have been used for a down payment, plus the money that you would have spent on buying transaction fees, can be invested. Furthermore, if the ongoing total costs of renting your home are lower than the ongoing total costs of buying a comparable home, each year you’ll generate additional savings that can be invested.

This is not to say that renting is always better than buying. All I’m saying is that in some situations, renting will be better from a financial standpoint, and in other situations, buying will be better.

To help you make this important financial decision, I’ve built a “Rent versus Buy Calculator”. This is a tool that takes in assumptions for the renting and buying scenarios, and then spits out answers and outputs (including your net worth over time, the total annual cost of each scenario, sensitivity and breakeven analyses, and more).

First things first, please download the rent versus buy calculator here (actually download the excel file as opposed to ‘opening in Google Sheets’).

How to Use the Rent Versus Buy Calculator

If you are not an expert at excel, don’t worry! I’ve tried to layout the spreadsheet so that you only need to look at one ‘tab’, and that once you enter a few of your own assumptions, the rest will automatically update for you.

• The only tab that you need to use in this spreadsheet is the “Dashboard” tab. All of the other tabs are for your information only, and don’t need to be looked at.
• On the dashboard tab, the only cells that you need to change are those highlighted in yellow. These cells contain the assumptions that the model will use to calculate the renting and buying scenarios. I’ve noted which assumptions are ‘major’, and which assumptions are ‘less important’. See screenshot below, showing the assumptions that you need to enter highlighted in yellow. In this example, I’ve used these major assumptions:
  • For the buying scenario: you are considering buying a $250,000 home with a 30% down payment, the home will increase in value by 2.50% per year, and your mortgage interest rate will be 4.00%.
  • For the renting scenario: a comparable home rents for $1,000 per month, and your investment portfolio will increase in value by 5.5% per year.

• Once you’ve entered your assumptions, please click the button “Recalculate Model“. This will ensure that all the calculations and outputs are taking into account the latest assumptions that you’ve entered.

• By using the drop down menu under the “Model Output” section of the tab, you can switch between looking at the various outputs (more discussion below on what these outputs are).

• By clicking the “Generate PDF Report” button, the model will generate a PDF report with full set of charts / outputs based on the assumptions you’ve made. This makes for easier reading, can be printed, and is an easy way to save your results (highly suggested!).

• If the model is running slowly or is generally not working, please try the following: (1) close any other excel spreadsheets that you have running, and (2) make sure you are in the “automatic except for data tables” calculation mode (in the excel toolbar: go to file > options > formulas > check the button “automatic except for data tables” in the “calculation options” section)

What Answers Will This Rent Versus Buy Calculator Give?

The rent versus buy calculator generates several charts / outputs based on your assumptions.

These outputs will help you to understand whether renting or buying is better over a specific time period, the total costs for you to either rent or buy your home, and how the answers change based on different assumptions.

Chart #1: Liquid Net Worth Over Time

Shows how your net worth changes over time in both the renting and buying scenario.

In this example, renting is better than buying at the start, however, buying becomes better after approximately 7.3 years.

To be honest, it’s not necessary to look at any of the other charts.

From this chart you can see whether it is better to rent or buy after a given number of years.

The following charts will give you more detail on both the renting and buying options, and walk you through some “what if?” scenarios.

Chart #2: Annual Housing Expense

Shows the total costs of either renting or buying your home, in a given year.

The costs are further broken down in the following charts 3 and 4.

Chart #3: Annual Housing Expense (Renting)

Shows the costs to rent your home in a given year.

This is broken down by rent payment, utilities, insurance, and other expenses.

Chart #4: Annual Housing Expense (Buying)

Shows the costs of owning your home in a given year.

This is broken down by mortgage payments (principal and interest), mortgage loan insurance, property tax, maintenance, utilities, insurance, condo fees, and other expenses.

Chart #5: Sensitivity to Key Assumptions

Shows how the difference in net worth between the renting and buying scenario changes based on different assumptions.

In the current example, net worth in the renting scenario is higher by $4,222 relative to the buying scenario in year 5.

If you are able to buy your home for $225,000 instead of the current assumption of $250,000, the buying scenario would be better than the renting scenario by $1,253 in year 5.

Chart #6: Breakeven Points

Calculates breakeven points between the renting and buying scenarios by changing one assumption at a time.

In the current example, the scenarios breakeven in 7.3 years. If you’d like to breakeven in 5 years instead, the following would have to change:

• The purchase price of your home would have to decrease from $250,000 to $230,722, or
• monthly rent payment would have to increase from $1,000 to $1,060, or
• annual investment return would have to decrease from 5.5% to 4.7%, or
• home value appreciation rate would have to increase from 2.50% to 2.82% per year instead of 2.50%, or
• mortgage interest rate would have to decrease from 4.00% to 3.52%

Chart #7: In-Year Increase in Liquid Net Worth

Shows how your net worth increases in each year, in percentage terms.

Note that the year 1 return for the buying scenario tends to be negative given that the one-time costs of buying / selling a home are typically larger than the increase in housing prices plus the mortgage principal paid down over 1 year.

If you sell your home further down the road, the one-time transaction costs are spread over a longer time period.

Chart #8: Cumulative Annual Increase in Liquid Net Worth

Shows the average annual increase in your net worth over a given time period (i.e., a Compounded Annual Growth Rate, or CAGR).

In the current example, the renting scenario has an average annual increase in net worth of 9.6% over the first 5 years, while the buying scenario will only have an average annual increase of 8.9%.

Chart #9: Buy Scenario – Liquid Net Worth Breakdown

Shows the breakdown of your net worth in the buying scenario into two parts: (i) home equity, and (ii) stocks / bonds.

The buying scenario is assumed to accumulate a portfolio of stocks / bonds once the annual costs for buying are lower than the costs to rent.

Try playing around with the model assumptions to make the cost of buying lower (smaller home purchase price, lower mortgage rate, etc.) or the cost of renting higher (higher rent payment, etc.), and you’ll see that the buying scenario begins to accumulate a portfolio of stocks / bonds.

Chart #10: Buy Scenario – Mortgage Principal Balance

Shows how much you owe on your mortgage at the end of any given year.

What’s Next?

Once you’ve acquainted yourself with how the rent versus buy calculator works, and what answers it can give, you can trying playing around with different scenarios and assumptions to see whether renting or buying is a better financial decision for you.

A few things to keep in mind:

• Compare similar homes in the renting and buying scenarios. Try to make sure that you are comparing homes of similar overall quality (location, square footage, age, etc.). You don’t need an excel model to tell you that it would be financially favourable to rent a studio apartment in the suburbs compared to buying a 3-bedroom detached home in a posh neighbourhood.
• This model only accounts for the financial aspects of your decision. There are many non-financial factors that might influence the decision to rent or buy your home. More often than not, there are significant ‘lifestyle’ differences between renting and buying that are not taken into account if we just look at the numbers.
• Test out a range of assumptions before making your decision. The answers that you’ll get from this model will change significantly even with small changes to certain assumptions. In particular, the assumptions that you make for annual investment return and annual home value appreciation will cause the answers to swing quite a bit. With that in mind, I’d suggest trying out a range of assumptions in the model before making your mind up.

And that’s a wrap!

Thank you for taking the time to check out my rent versus buy calculator. I hope that this comes in handy for when you make the decision to either rent or buy your home.

Please let me know if you have any feedback on how to improve this rent versus buy calculator (either through the comments below or by email at themeasureofaplan@gmail.com). My goal is to make updates to this model as time goes on to make sure that it is as easy to use and is as accurate as possible.

—

Header image photo credit: Gary Smith