Home › Investment analyzer
US & CanadaRental property investment analyzer
Run the numbers before you buy. Analyze any rental property in minutes – cash flow, cap rate, cash-on-cash return, DSCR, a full mortgage amortization table and a 10-year projection with IRR – then compare up to 5 properties side by side. Works in Excel and Google Sheets.
Instant digital download (.xlsx). No macros, no subscription.
What you get
- A purchase analyzer: enter price, closing costs, renovation, financing, rents, vacancy and operating costs to get loan, monthly payment, NOI, cash flow, cap rate, cash-on-cash, DSCR, GRM, expense ratio, break-even occupancy, the 1% rule and year-1 total return
- Your targets: set a minimum cap rate, cash-on-cash and DSCR, and each metric shows ✓ or ✗
- A mortgage amortization table with up to 360 monthly payments, a yearly summary and an interest-vs-principal chart
- US and Canadian mortgages: monthly compounding (US standard) or semi-annual compounding (Canadian fixed-rate)
- A 10-year projection with rent and expense growth, appreciation, cash flow, loan balance, equity, CoC and DSCR by year, plus a sale analysis with net proceeds, total profit, equity multiple and IRR for a 1–10 year hold
- A compare tab: 5 properties side by side, best value in each row highlighted, ranked by cash-on-cash return, with a chart
- A metrics guide with a plain-English explanation of every number
Details
- Compare up to 5 properties
- Up to 360 monthly payments (30 years)
- Excel 2010+ and Google Sheets
- No macros, no add-ons, no subscription
- Mortgage payment checked against the standard PMT formula; tested with sample data
Screenshots
How it works
- Buy on Etsy and download the .xlsx file.
- Open it in Excel, or upload it to Google Drive and choose File → Save as Google Sheets.
- Type over the clearly marked sample numbers – every result updates instantly.
Just want a quick check first? Try the free rental cash flow and cap rate & cash-on-cash calculators.
This is an estimating tool, not financial, investment, tax or legal advice. Results depend entirely on your assumptions and don't include income tax, depreciation/CCA, refinancing or rate changes at renewal. Please do your own due diligence and talk to a qualified professional before you buy. It was designed with the help of AI tools, then reviewed and tested before release.