🎉 Black Friday: off every tracker · Or get all 8 for $49.99 → 🎉 Get all 8 spreadsheets for $49.99, save $109.93 vs buying separately →

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.

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

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.

⚠ Important: please readA planning tool for information only. It is not tax, legal, accounting, lending, investment or financial advice, and it doesn't replace a qualified professional. Results depend on the figures you enter; lenders, platforms and tax authorities apply their own rules. Check important decisions with a professional. Images show the real workbook with sample data.

You might also like