COSTS TO RENT VERSUS OWN IN CANADA: A FUN ANALYSIS USING R

Paying for somewhere to live is an unavoidable expense. Whether you rent or own it is recommended that no more than 30% of your income be spent on shelter costs. Is this 30% figure attainable for Canadians? In this post, we perform an analysis using r to find out, and make predictions for the future.

We collected Census Data from the last National Household Survey, published in 2011 for this analysis. Data from the most recent Census is not available until later this year. Each result is presented as a map of Canada and embedded below are pdfs that can be zoomed in to highlight specific regions. The shelter costs as a % of gross income are white at 0% and become progressively redder as the costs increase up to 60%.

Getting the Data

We used the data available here. This Census data is split into 13 csv files, and covers an enormous amount of data. Here is information from one of the 13 csv files, the file for Ontario:

Getting data

The data is organized by Census division (CD_Name), Topics (such as Citizenship), and Characteristics of each topic. The first thing we want to do is pull out only the information we are interested in from each of the 13 files, and combine it in R. We can write our own function for that.

data organisation 

Steps to Create the Maps

To create the maps shown below, we calculated the data of interest, combined it with our map data frame, then created the maps using ggplot2.

steps to create maps

Rental Cost in 2010

With the data we imported, let’s look at the cost to rent in Canada, based on census division. For this analysis using r, we need to compare the “Average household income” and “Average shelter costs for rented dwellings” for each Census division. The results are shown on the map below.

 Rental Cost 2010

To rent in 2010, generally Canadian families spent less than 30% of their incomes. Unsurprisingly some regions are more expensive to rent than others (Toronto, Muskoka, and Sunshine Coast).

Ownership Cost 2010

Now let’s do the same for “Average household income” and “Average shelter costs for owned dwellings”, again for each Census division. The results are shown on the map below.

 of Yearly Income Cost

Compared to the cost of renting a place to live, owning is more expensive in general. Here we are overall much closer to the 30% ‘accepted’ income cost. Keep in mind though that equity build-up is not taken into account.

Ownership Cost Continued

The ownership cost from the Census is somewhat misleading, as it includes both mortgaged and mortgage free shelter. It obviously is much more expensive to own if a mortgage is being payed monthly. Let’s use the “Average value of dwelling” and “Average household income” for this analysis using r.

Let’s assume the mortgage is 95% of the dwelling value, amortized over 25 years. This next figure demonstrates the cost just to cover the mortgage, as a percentage of household income.

Buy new cost

The costs are much more expensive in regions such as Sunshine Coast, Toronto, Greater Vancouver, and Columbia-Shuswap.

Home Purchase: Predictions 2016

This Census data was collected in 2010, and data from the 2016 Census will be presented later this year. For interest sake, we built a model to predict the cost to buy a home in Canada, based on Census division. Our model uses available housing and wage data from previous years to predict future years. We will revisit this 2016 prediction later this year when the Census data is released.

 Cost Prediction 2016

Has the situation improved at all? Generally, it has gotten worse. We are predicting that in 2016 a lot of regions will require greater than 30% of family income just to cover the mortgage when purchasing shelter. This model predicts that the cost will remain high regions mentioned above (Sunshine Coast, Greater Vancouver, and Toronto). The general rise is predicted to be caused by increasing housing costs and stagnant wages.

Home Purchase: Predictions 2020

There may be a small bit of relief by 2020 as wages catch up slightly in some regions, but compared to 2010 we predict that the cost of buying shelter will remain out of control through 2020.

Cost prediction 2020 

Conclusions

Until wages increase significantly or there is a major housing correction, in many regions in Canada it may be better to rent than to buy or own a home.