Rental Property Deal Analyzer — Canada | Excel Investment Calculator
🎉 Launch OfferLaunch price: $29 USD for the first 20 buyers with code LAUNCH29 — regular price $39 USD.Know if a rental property is worth digging into — faster.Cashflow, cap rate, DSCR, cash-on-cash, scenarios, and a property comparator — designed with the Canadian market in mind.Stop guessing whether a rental property is a good deal. Rental Property Deal Analyzer — Canada is a self-contained Excel workbook that takes your numbers and turns them into a clear, structured read on the property — in about the time it takes to enter the purchase price and the rent.It’s designed with the Canadian market in mind — CAD currency, CMHC mortgage default insurance tiers, land transfer tax, municipal/school taxes — rather than being a generic US spreadsheet with the currency symbol swapped. Fees and rules vary by province, city, and lender, so every assumption in the file — vacancy %, maintenance %, closing costs, insurance tiers, and more — is fully adjustable. You plug in what’s accurate for your market instead of relying on hardcoded numbers.Enter a property’s numbers once, and the workbook does the rest: Calculates cashflow, NOI, cap rate, cash-on-cash return, DSCR, GRM, and the 1% rule Produces an automatic verdict: Strong Potential / Worth Digging Into / Fragile Deal / Avoid Scores the deal transparently against 5 criteria — not a black box Surfaces the deal’s specific strengths and watch-outs, generated from your actual numbers Stress-tests the deal across Optimistic, Realistic, and Pessimistic scenarios Shows how the deal holds up if rates rise, vacancy spikes, or assumptions change Compares up to 3 properties side by side with automatic ranking Lets you adjust every assumption and threshold from one central tab — no digging through formulas Everything is color-coded: Blue = your input Green = linked assumption Gray = automatic calculation A plain-language glossary explains every metric in one sentence, so you don’t need a finance background to use it with confidence.This is a decision-support tool, not a promise. It won’t tell you what a property will do — it gives you a fast, consistent, numbers-based read on what you’re looking at, so you can decide where to spend your time and when to call in a professional.Features ✔ Automatic verdict: Strong Potential / Worth Digging Into / Fragile Deal / Avoid ✔ Transparent 0–10 scoring engine based on 5 criteria ✔ Auto-generated deal strengths and watch-outs based on your numbers ✔ Optimistic / Realistic / Pessimistic scenario stress-test ✔ Side-by-side comparator for up to 3 properties, with automatic ranking ✔ Key metrics: cashflow, NOI, cap rate, cash-on-cash, DSCR, GRM, 1% rule, break-even ratio ✔ Designed with the Canadian market in mind: CAD currency, CMHC premium tiers, land transfer tax assumptions ✔ Adjustable assumptions for your province, city, lender, and market ✔ One central Assumptions tab — change a threshold once, the whole file updates ✔ Full loan amortization schedule, month by month ✔ Color-coded cells so you know what to edit and what not to touch ✔ Plain-language glossary — no finance degree required ✔ Clean, professional design — easy to read, easy to discuss with a client, partner, or advisor ✔ 100% Excel formulas, no macros, no add-ins, nothing to enable What’s included 1 Excel workbook .xlsx 7 tabs: Guide — how to use the file, glossary, and disclaimer Dashboard — 30-second deal summary with verdict, score, strengths, and watch-outs Assumptions — every default % and threshold, centralized and editable Calculator — full single-property analysis Scenarios — Optimistic / Realistic / Pessimistic side by side Comparator — compare up to 3 properties with automatic ranking Amortization — full month-by-month loan schedule Also included: Built for Microsoft Excel 2019+ and Excel 365 Excel desktop recommended Google Sheets compatibility not guaranteed No macros No add-ins No subscriptions Works fully offline Instant digital download Who it’s for Canadian real estate investors evaluating rental properties Beginner and intermediate investors who want a clear, structured way to read a deal’s numbers Real estate agents working with investor clients who want a fast, credible way to screen deals together Anyone comparing multiple rental properties and wanting a consistent, side-by-side read instead of a gut feeling Who it’s not for Anyone looking for a guarantee, prediction, or promise of returns — this tool does not provide that, and no spreadsheet can Commercial multi-unit, 5+ units, or commercial-only underwriting — this is built around single-property residential rental analysis Anyone looking for tax filing, legal document prep, or mortgage approval — this is an analysis tool, not a filing or approval tool Anyone unwilling to verify province/city-specific fees before relying on the output FAQQ: Do I need to know Excel well to use this?A: No. You only touch the blue cells. Every other cell calculates automatically. The Guide tab walks you through it in six steps, and a glossary explains every metric in plain language.Q: Does this work in Google Sheets?A: The file is built for Microsoft Excel 2019+ and Excel 365. That’s where it’s tested and where all features are intended to work correctly. It may open in Google Sheets, but some formulas and conditional formatting may not carry over properly, so Google Sheets compatibility is not guaranteed. Excel desktop is recommended.Q: Is this accurate for my specific province or city?A: The core numbers — cashflow, cap rate, DSCR, cash-on-cash, and related metrics — apply anywhere in Canada. Fees like land transfer tax, insurance premiums, and closing costs vary by province, city, and lender. The file is designed with these Canadian mechanics in mind, but you’ll need to adjust the Assumptions tab with the figures that apply to your specific market. It’s a flexible framework, not a plug-and-play database of every local rate.Q: Can I use this for a duplex, triplex, or small multi-unit?A: Yes, as long as you’re analyzing it as a single financed property with one combined rent roll. It’s not built for complex multi-building commercial underwriting.Q: Does it tell me if I should buy the property?A: No. It gives you a structured, numbers-based verdict and shows you exactly why — strengths, watch-outs, and how the deal holds up under stress. The decision, and validation with qualified professionals, is still yours.Q: What happens if I change the default assumptions?A: Everything downstream updates automatically. The Calculator, Scenarios, Comparator, and Dashboard are all linked to the Assumptions tab. Change a threshold once and the whole file adjusts.Q: Is there a mobile version?A: The file may open in the Excel mobile app, but for the best experience — especially the Comparator and Amortization tabs — a laptop or desktop is recommended.Q: Can I get support if I run into an issue?A: Yes. If you run into a technical issue, message me through Gumroad and I’ll do my best to help.Q: Do you offer refunds?A: Because this is an instant digital download, all sales are final. If you run into a technical issue with the file, message me through Gumroad and I’ll do my best to help.DisclaimerThis tool is an educational analysis tool. It is not financial, tax, legal, mortgage, or real estate advice, and it does not guarantee or predict investment returns.The results depend entirely on the assumptions you enter. An optimistic input will produce an optimistic verdict, even if reality turns out differently.Fees — land transfer tax, notary, mortgage insurance, closing costs, and other expenses — vary by province, city, lender, property type, and the buyer’s situation. This tool is designed with Canadian mechanics in mind, but it is your responsibility to confirm the figures that apply to your specific market.Always validate your numbers and your decision with qualified professionals, such as a mortgage broker, notary/lawyer, accountant, and real estate agent.
Get it → digitallabtools.gumroad.com