The Spreadsheet · Method

The comparative analysis method for validating the market value of a plex in Quebec

By Raphaël Hébert-Bilodeau, real estate broker, eXp agence immobilière. Published October 15, 2026.

Discover a structured methodology for evaluating your future real estate purchases by comparing actual market data to avoid costly errors during your acquisition process.

Buying an income property carries risks if you rely solely on your emotions or a seller's statements. As an investor, your success depends on your ability to validate the market value of an asset through cold, objective numerical analysis. At IPG, we use a rigorous comparative method to ensure that the price paid aligns with the current market reality. This process allows you to make an informed decision and limit your financial risks.

Understanding key performance indicators

Before comparing two properties, you must speak the same language. The cap rate, or capitalization rate, is the primary tool for this measurement. It allows you to compare the profitability of buildings of different sizes by isolating the return generated by the net operating income relative to the purchase price. Let's say a duplex is listed at $600,000 with a net operating income of $30,000. Its cap rate is 5%. To compare this building, you must find comparables in the same neighborhood, with similar characteristics and comparable revenues, to see if this rate is consistent with recent transactions. Never forget that the cap rate is a gross indicator that does not take into account the cost of your financing, unlike cash flow.

Collecting reliable data

A comparative analysis is only as good as the quality of the data you compile. It is necessary to use actual sales recorded in the land registry rather than asking prices on public platforms. The price requested by a seller is an intention, whereas the sale price is a reality validated by the market. To build your sample, select properties sold in a nearby radius, ideally within the last six months. If the market is moving quickly, your time horizon must be short so that the figures remain relevant. It is crucial to adjust your comparisons according to the condition of the building, the quality of renovations performed, and the stability of the tenants.

Adjustments and normalization of figures

Once you have collected your data, you will quickly notice that buildings are never identical. This is where your work as an analyst begins with adjustments. If a triplex sold for $900,000 but the roof needed urgent repairs, you must adjust this sale price upward in your analysis to bring it to a market value for a building in good condition. Conversely, if a building is sold with major inclusions or high-end appliances, you must subtract this value to compare the structure alone. This normalization allows you to establish a fair price range, thus avoiding paying for characteristics that do not add intrinsic value in the long term.

The limit of the method and the human aspect

Even with the best mathematical method, real estate involves gray areas. A seller's desire to offload their asset for personal reasons or a financial emergency can cause the final sale price to vary. Furthermore, financial data provided by the seller, such as leases, must always be verified. It is essential to consult an accountant or a tax specialist to validate the impact of your acquisitions on your overall portfolio and your reporting obligations. We are brokers, not tax experts, and we always encourage our clients to validate their projects with legal and financial professionals before finalizing an important transaction. Numerical analysis is a foundation, but it must be supplemented by a thorough due diligence of the building's physical condition.

Taking action with concrete tools

Mastering this method will give you a competitive advantage during your next offers. Instead of following trends, you will build your decisions on solid foundations. If you wish to deepen this analysis and obtain access to more precise data, we have developed tools to help you with your calculations. You can download our IPG Spreadsheet to structure your analyses or simply contact us to discuss your current investment project. We are here to share our expertise and accompany you in the development of your real estate portfolio with a results-based approach. Raphaël Hébert-Bilodeau, real estate broker at eXp agence immobilière.

Want to run the numbers yourself? The IPG Spreadsheet is free. A property in mind? A member of the IPG team can give you a second read, free of charge.