REI Analyzer · Canada and USA edition · Version 1.2.6
Underwrite any income property in one workbook.
The formula-driven underwriting model we use on our own apartment and commercial acquisitions, for Excel and Google Sheets. Built 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, plus applicable taxes. Instant digital download. No subscription.
Not available to customers in Quebec.
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.
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.
Sold by Dwell Logic Investing Inc., GST/HST 771833332 RT0001. Prices are in Canadian dollars, plus applicable taxes; GST or HST is added at checkout based on your billing address. Not available to customers in Quebec. All sales final: if you are charged twice, we refund the duplicate charge, and if your download fails or a file will not open, we fix the problem or send a replacement copy (see our refund policy). 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. These tools are analytical aids, not investment advice.
How it works
Download, choose your country, type your deal.
You receive the workbook and the Quick Start Guide and Licence (PDF) right after checkout. Choose Canada or USA on the General tab, type your deal into the off-white input cells, and everything else calculates.
CA$174.00
One-time purchase, plus applicable taxes. Not available to customers in Quebec.
Buy now · CA$174.00