Multifamily Deal Analyzer
A working model for the building — then a CMHC sizer for the loan.
A gated Excel template for 5+ unit Canadian files: income, operating expenses, NOI, a simple loan, and cash-on-cash. It is not a CMHC engine; pair it with the max-loan tool.
Separate the building from the program
Get NOI honest first. Then choose Select, Standard, or conventional.
In-place rents only
The landing tells you not to type the listing pro forma into the sheet.
Reserve line stays
Zeroing replacement reserve inflates cash flow you will not have on a CMHC screen.
-
NOI from rent and operating expenses
-
Loan proceeds and cash in
-
Annual cash flow after debt service
-
Enter in-place rents, not listing asking rent
-
Do not zero replacement reserve on a CMHC screen
-
Compare Select vs Standard on the max-loan calculator after you have NOI
- Does this calculate MLI points?
- No. Use the MLI Select points calculator. This sheet is operations and a simple loan.
- Can I use this on a duplex?
- It is built for 5+ unit thinking. For 1–4 use the property cash-flow or DSCR tools.
Email to download
Name and email. We send the file and can follow up on the matching desk.