Display the charts

If unchecked, clicking on the checkbox to the right of “Show Charts” will display the tab’s charts. If checked, clicking on the checkbox to the right of “Show Charts” will hide the tab’s charts.

Charts in the Areas tab

When the checkbox is checked, the tab’s charts will always display above the tab’s content that is visible when the checkbox is unchecked. There are charts in all tabs. In the Areas tab there are two charts displaying:

  1. The top 10 areas in the country/region based on ROI (sheet’s property type only); and
  2. The top 10 areas in the province/country based on ROI (all property types).

Only the areas in the sheet’s province or country will be displayed in the second chart.

Charts in the Flipping tab

The Flipping tab displays two charts:

  1. The top 5 developers in the province/country based on average capital gains; and
  2. The top 5 developers in the province/country based on versus market.

“Versus market” indicates if the developer out- or underperformed the market and essentially thus filters out any area effects on the developer’s average capital gains. Please note that only the area’s capital gains during the same period as the developers’ projects have been considered to also filter out any time effects on the developer’s average capital gains. Please also note that we only include developers that developed at least 1 project in the province and that we use their nationwide projects (of the same property type) to calculate their average capital gains and versus market values.

Charts in the Primary Residence tab

The Primary Residence tab displays three charts:

  1. The top 5 projects in the province/country based on capital gains;
  2. The top 5 good value for money projects in the province/country based on capital gains; and
  3. The top 5 projects based on versus market.

“Versus market” indicates if the project out- or underperformed the market and essentially thus filters out any area effects on the project’s capital gains. Please note that only the area’s capital gains during the same period as the project have been considered to also filter out any time effects on the project’s capital gains.

“Good value for money projects” are projects with a median sale price/sqm that is lower than their area’s (or city’s or province’s if not available) median sale price/sqm.

Charts in the Leasing tab

The Leasing tab displays three charts:

  1. The top 5 projects in the province/country based on median rent price/sqm;
  2. The top 5 good value for money projects in the province/country based on median rent price/sqm; and
  3. The top 5 projects based in the province/country based on lowest rent price.

Unlike the areas, developers, projects and projects’ unit types displayed in the charts in all other tabs, the projects displayed in the charts in this tab have been sorted from low to high, as a lower median rent price/sqm or lowest rent price is considered better for the users of this tab (i.c. tenants).

Charts in the Investment tab

The Investment tab displays five charts:

  1. The top 10 projects in the province/country based on ROI;
  2. The top 10 projects’ unit types in the province/country based on ROI;
  3. The top 10 projects’ unit types that can easily be leased in the province/country based on ROI;
  4. The top 10 projects in the province/country based on versus market (ROI); and
  5. The top 10 projects in the province/country based on ROI after n years.

The ROI of projects’ unit types is calculated by adding the project’s capital gains to the rental yield of the projects’ unit types. “Projects’ unit types that can easily be leased” are projects’ unit types with an average rent price equal to or less than the area’s average enquiry rent price.

“Versus market” indicates if the project out- or underperformed the market and essentially thus filters out any area effects on the project’s capital gains and thus ROI. Please note that only the area’s capital gains during the same period as the project have been considered to also filter out any time effects on the project’s capital gains and thus ROI.

The ROI after n years is being calculated by taking into account the project’s rental growth. The value for n is pre-filled, but can be altered in the light blue cell to the left of “years”.

Charts in the Investing Idea tab

The Investing Idea tab displays only one chart: the top 5 “risk-free” projects’ cheapest units in the province/country based on ROI. “Risk-free” units are easy-to-lease units with a positive ROI (now and in the future) for which the lease income is sufficient to offset the amortization payments. “Risk-free” projects’ cheapest units are highlighted in light orange (based on corrected rent price) and/or light yellow (based on matching rent price) in the (frozen) Project column. Only projects’ cheapest units that are highlighted in the Project column will be displayed in the chart. Please note that both projects’ cheapest units that are highlighted in light orange and projects’ cheapest units that are highlighted in light yellow will be displayed in the chart.

“Risk-free” projects’ cheapest units are projects’ cheapest units for which all of the following five conditions are satisfied:

  1. The project’s cheapest unit’s corrected or matching rent price is equal to or less than the area’s average enquiry rent price;
  2. The project’s cheapest unit’s corrected or matching rent price/sqm is equal to or less than the area’s average enquiry rent price/sqm;
  3. The project’s cheapest unit’s corrected or matching rent price is equal to or more than the project’s cheapest unit’s amortization (i.e. positive cash flows);
  4. The sum of the project’s cheapest unit’s rental yield minus interest and the project’s capital gains – or in other words: the project’s cheapest unit’s ROI (including interest) – is positive; and
  5. The project’s cheapest unit’s ROI is also positive after n years.

Please note that we use the project’s cheapest unit’s rental yield and ROI based on either the corrected or matching rent price for condition 4 and 5.

As long as you can get financing, investment in these units is “risk-free”, as you won’t ever lose money on them, they will (nearly) always be leased and - thus - you will always have positive cash flows. The risk of foreclosure on these units is as minimal as possible.

Filter on budget, location and desired value for money

Follow the steps described on the Filter & Sort premium feature page to find the top projects offering your required unit type. The charts are dynamic meaning they only display the content that is visible in the tab. Or in other words: after applying the filters, the projects, projects’ unit types and “risk-free” project’s cheapest units that are being displayed in the charts will change. Please note that this is only the case in the Primary Residence, Leasing, Investment and Investing Idea tabs, as only these tabs contain filters. Compare for example the projects displayed in the charts in the Primary Residence tab before and after applying the filters:

Projects displayed in the charts in the Primary Residence tab before applying the filters.

Projects displayed in the charts in the Primary Residence tab after applying the filters.

Data analysis made easy

All charts conveniently display complex data about the top areas, developers, projects, projects’ unit types and “risk-free” projects’ cheapest units, so that data analysis will be as easy as possible – for everyone! To understand the value of the charts, let us for example have a look at how the “Top 10 Projects' Unit Types That Can Easily be Leased Based on ROI” chart (3rd chart in the Investment tab) is being composed. This will provide insight in the steps one needs to follow to arrive at the same top 10 if one does not subscribe to our membership plans.

First of all, all projects’ unit types that cannot easily be leased should be filtered out. These are all projects’ unit types with a Versus Average Enquiry Rent Price value greater than 1. Of the remaining ones (i.e. the projects’ unit types that can easily be leased), the ROI should be calculated by adding the project’s capital gains to the rental yield of the projects’ unit types. The results should then be sorted from high to low to arrive at a top 10 of projects’ unit types that can easily be leased based on ROI. Every time the “Max Sale Price” filter value is being changed, all the aforementioned steps need to be repeated, as the projects’ unit types that can easily be leased (first step) will be different and thus will also the top 10 be different.

The above screenshot displays some of the data that needs to be checked to select the projects’ unit types that can easily be leased (data in 5 different columns) and to calculate their ROI (data in 6 different columns). The more rows (some sheets have thousands of rows!), the more cells need to be checked and the more calculations need to be made. Although not impossible, it can (and will) get very complex very easily this way. The convenience of the charts should therefore definitely not be underestimated!

Membership Plan

Buying our sheets gets you access to knowledge to maximize the returns on your property investment(s). To use the sheets’ premium features, you need to subscribe to our membership plans.

Important

Please note that one subscription will get you access to the (plan’s) premium features in all Google Sheets you have purchased. You will therefore only need to subscribe to this membership plan once.

If the Google Sheets got shared with an e-mail address that is not a Google Account, then you will not be able to use the premium features – even after subscribing to this membership plan. Please create a Google Account using the e-mail address the Google Sheets got shared with, so that the premium features can be used.

Premium features

Filter & Sort, Charts, Publish

$150/Yr.
Only $0.41/Day
Buy Now

Our Sheets

See All Sheets
© 2020 Real Estate Data. All Rights Reserved.