
What it does
A listing's "cap rate" rarely includes vacancy, management, a reserve for the roof, or the mortgage. This analyzer builds the numbers properly: 1. Effective income: rent plus other income, minus vacancy. 2. Operating expenses: tax, insurance, maintenance, management, utilities, fees and other costs. 3. Net operating income (NOI): income minus operating expenses. NOI never includes mortgage principal or interest. 4. Cash flow: NOI minus debt service, shown before and after a separate capital reserve for big replacements.
- Purchase price, closing costs (8 lines) and initial repairs (8 lines)
- Mortgage or all cash; down payment, rate, amortization and an explicit convention (Canadian semi-annual or monthly)
- Rent, other income and vacancy & credit loss
- Property tax, insurance, maintenance, management, utilities, condo/HOA fees and other costs
- Capital reserve kept separate from operating expenses
- NOI, debt service, and cash flow before and after the reserve
- Cap rate, cash-on-cash and DSCR, each with a definition
- Break-even occupancy and cash needed at purchase
- Three scenarios with your own adjustments
- Sensitivity to price, rent, vacancy and rate, plus a rent × rate grid
- 10-year projection with IRR, profit and equity multiple (illustrative)
- Your five thresholds, checked in every scenario
What's inside
Workbook tabs: Start Here · Dashboard · Property · Purchase Costs · Analysis · Sensitivity · Projection. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- First-time and small rental investors in Canada or the U.S. weighing a specific property before making an offer.
Free calculator: Rental property cash flow calculator
Frequently asked questions
Does NOI include the mortgage?
No. NOI excludes principal and interest. Debt service is subtracted afterwards to get cash flow.
Where does the roof replacement go?
In the capital reserve, which is shown separately. Every metric says whether it includes the reserve.
Does it work for all-cash purchases?
Yes. Choose All cash; DSCR then shows "No debt".
Will it tell me to buy?
No. It checks the property against the thresholds you set.
Does it work in Google Sheets or Apple Numbers?
It's built for Microsoft Excel and hasn't been tested in Google Sheets or Apple Numbers yet.
You might also like

Rental Portfolio Cash-Flow & Reserve Planner
Forecast 12 months of cash for up to 10 rental properties, schedule roofs, HVAC and appliances, and see the monthly reserve transfer that keeps each property above your minimum. Excel template with a worked example.
Rental Property Tracker (T776)
Rent, expenses and your T776 for up to 5 properties.

Mortgage Offer & Renewal Comparison Kit
Put up to 4 mortgage offers side by side over the same horizon and rank them by net cost: interest, fees and penalties minus cashback, counting the balance you still owe. Canadian and U.S. editions, with worked examples.