Skip to content

REI Analyzer · Canada and USA edition · Version 1.2.6

Underwrite any income property in one workbook.

A complete, formula-driven real estate investment analyzer for Excel that also works in Google Sheets. Built by a working investor to replace a discontinued professional analysis package, for apartment buildings, commercial property, self-storage, hotels and value-add deals.

CA$174.00

One-time purchase. Instant digital download. No subscription.

REI Analyzer dashboard overview

The whole picture

Enter a property once. Read every number a lender or partner will ask for.

Twenty years, every year.

A 20-year before-tax cash flow with a hypothetical sale in every year: IRR (annual and calendar-timed), MIRR, NPV, equity multiple, cash-on-cash, debt coverage, break-even ratio, yield on cost and loan-to-value.

19 live charts.

Executive summary, business plan and investor "at a glance" pages, plus nine 20-year projection charts. Every chart updates the moment you change an input.

Print-ready, under your name.

Report pages you can hand to a lender or a partner, with your own logo on the cover.

Screens

See it before you buy.

What is inside

32 tabs, pure formulas.

  • General settings: Canada or USA, base, optimistic and pessimistic scenarios, and a mortgage compounding override
  • Financing Rules: CMHC insured limits, premiums and qualifying rate for Canada; debt coverage, debt yield and loan-to-value sizing for the USA
  • Quick Analysis: a two-minute screener with cap rate, DSCR, cash-on-cash, IRR and three price solvers
  • Short-Term Analysis: flip or bridge-hold screener up to 36 months
  • Residential rent roll up to 40 units with renovation windows, or a simple income entry
  • Commercial income lease by lease (escalations, recoveries, rollover, TI and leasing commissions) or in aggregate
  • Self-storage, hotel and seniors-housing income modules for mixed-use deals
  • Up to three mortgages plus a refinance, with interest-only periods, points, rate steps and monthly amortization schedules
  • Operating Cash Flows, Analysis of Resale and a one-page Summary
  • Executive Summary, Property Narrative, Photo Page, Resale Notes and a Business Plan
  • Partnership waterfall: preferred return with arrearage, IRR-hurdle tiers, fees, manager co-investment and per-$100,000 distributions
  • Sensitivity tables for price, exit cap, vacancy and interest rate, an IRR grid and a price-for-target-IRR solver
  • A ground-up development pro forma for projects up to 72 months

Canada or USA: you choose.

One workbook for both countries. The country sets the mortgage math (Canadian fixed-rate mortgages compound semi-annually, US mortgages monthly), the loan rules and some wording.

For Canada, choose a CMHC product or a conventional loan and the Financing Rules tab shows the maximum loan-to-value and amortization, prices the insurance premium and flags anything outside the limits. For the USA, the loan is sized on debt coverage, debt yield and loan-to-value.

Excel and Google Sheets.

One .xlsx file. Open it in Microsoft Excel 2016 or later (Windows or Mac), or upload it to Google Drive and open it in Google Sheets. The guide explains the few differences in Google Sheets.

Tested every release.

Each release is rebuilt from source, recalculated in Excel, swept for error cells, checked chart by chart and checked against independent models of the engine. Versions 1.1 to 1.2.6 respond to thirteen rounds of independent outside review.

No macros, nothing hidden from you.

Pure formulas, no add-ins, nothing that collects or sends information. Before-tax analysis: hand the cash flows to your accountant for depreciation and tax.

Licence

Please read before you buy.

  • One named user. The licence is for one individual. Each additional user needs their own licence. It covers both Excel and Google Sheets.
  • Your deals, your reports. Use it on as many of your own deals as you like, and share the printed or PDF reports you produce freely.
  • AI is welcome for your own work. Giving the file to an AI tool to analyse your own deals is not sharing it.
  • No copies for others. Do not share, resell or redistribute the workbook, or reproduce it by any method, including AI, to make a product for others. Each copy carries licence identifiers.
  • No support or updates are included with the purchase price. Full terms are in the Quick Start Guide and Licence included with the download.

This is a digital product delivered instantly, so it cannot be returned; this does not affect any right you have under consumer-protection law that cannot be waived. Projections are estimates based on your assumptions and are not a guarantee of future performance. Testing reduces risk; it does not guarantee that any result suits a particular transaction.

More editions

UK and Australia/New Zealand editions are coming.

This edition covers Canada and the USA. A UK edition is in progress, and an Australia and New Zealand edition will follow, each with its own mortgage conventions and lending rules. Leave your details and we will email you when yours is ready.

How it works

Download, choose your country, type your deal.

You receive the workbook and the Quick Start Guide and Licence (PDF). Choose Canada or USA on the General tab, type your deal into the off-white input cells, and everything else calculates.

CA$174.00

Buy on Etsy · CA$174.00