Enter the numbers from a listing. The spreadsheet normalizes the expenses, runs three scenarios and every ratio, calculates the ceiling price and gives a verdict. The same tool our brokers use, in your hands.
Four fields, and it's in your inbox within minutes.
Address, units, asking price, unit-by-unit rents, ancillary income, vacancy rate.
Taxes, insurance, heating, maintenance, management, vacancy: what the listing leaves out, the spreadsheet puts back.
Down payment, rate, amortization, mortgage payment calculated under the Canadian rule.
Optimistic, realistic, pessimistic: the same property under three sets of assumptions, to see what holds up.
Ratios (GRM, NIM, cap rate), return on down payment, ceiling price, green, yellow or red light, and why.
The benchmarks we use and the calculation assumptions, written out in black and white, editable.
The spreadsheet is a decision-support tool based on the numbers you enter and simplified assumptions. It does not replace reading a property's documents or the advice of a professional. No return is guaranteed.
By email, in Excel and Google Sheets, within minutes. With a completed 6-unit example.
Rents, declared expenses, asking price, your down payment. Blue cells only.
Ceiling price, ratios, green or red light. And if you want a second read, send us the address: a member of the IPG team gets back to you with theirs, free of charge.
A nine-tab Excel (or Google Sheets) file. You enter the income, the expenses, the price and your financing; it runs the same calculations we do for our clients: normalized expenses, three scenarios, every ratio (GRM, NIM, cap rate), ceiling price, and a clear verdict (green, yellow or red light) with the reasons.
Because it's how we work and we have nothing to hide. A buyer who knows how to read a property buys better, and often with us. We're real estate brokers: we're paid through brokerage when you buy, not by a tool.
No. The spreadsheet quickly weeds out bad properties from the listing's numbers. For the good ones, the real documents still need reading: leases, the last two years of expenses, taxes, insurance, TAL history. That's what we do next, free of charge, if you have a property in mind.
No. You only fill in the blue cells; everything else is calculated and protected. Tab 0 explains every field, with a completed 6-unit example.
We send you the spreadsheet, then three short emails over the following nine days to help you use it. You unsubscribe in one click, and we never sell or share your contact details.
The IPG Spreadsheet, free, in your inbox within minutes.
Free · One-click unsubscribe