Rental Property Investment Analyzer Spreadsheet, Cash Flow & Cap Rate Calculator, Cash on Cash, DSCR, Mortgage Amortization, Excel Sheets

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 Microsoft Excel AND Google Sheets.

★ WHAT YOU GET
• PURCHASE ANALYZER – price, closing costs, renovation, down payment, rate, amortization, rents, vacancy, taxes, insurance, HOA/condo fees, utilities, repairs, capital reserve and management → loan, monthly payment, NOI, cash flow, cap rate, cash-on-cash, DSCR, GRM, expense ratio, break-even occupancy, 1% rule, year-1 total return
• YOUR TARGETS – set a minimum cap rate, cash-on-cash and DSCR; each metric shows ✓ or ✗
• MORTGAGE AMORTIZATION – up to 360 monthly payments with opening balance, interest, principal and closing balance, plus a yearly summary and an interest-vs-principal chart
• US AND CANADIAN MORTGAGES – choose monthly compounding (US standard) or semi-annual compounding (Canadian fixed-rate)
• 10-YEAR PROJECTION – rent and expense growth, appreciation, cash flow, cumulative cash flow, loan balance, equity, CoC and DSCR by year; sale analysis with net proceeds, total profit, equity multiple and IRR for a 1–10 year hold
• COMPARE – 5 properties side by side; the best value in each row is highlighted and properties are ranked by cash-on-cash return, with a chart
• METRICS GUIDE – plain-English explanation of every number

★ HOW IT WORKS
1. Download the .xlsx file instantly after purchase (Etsy › Purchases › Download Files).
2. Open in Excel – or upload to Google Drive and choose File › Save as Google Sheets.
3. Type over the clearly marked SAMPLE numbers – every result updates instantly.

★ DETAILS
• Digital download – nothing will be shipped
• File: 1 × .xlsx (Excel 2010+ / Google Sheets; no macros, no add-ons)
• Mortgage payment checked against the standard PMT formula; tested with sample data

★ AI DISCLOSURE
This template was designed by me with the help of AI tools (for drafting formulas, layout and text), then reviewed and tested before listing.

★ IMPORTANT
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.

Personal-use licence: for your own investing. Please don't resell or share the file. Digital items can't be returned – but if anything doesn't work, message me and I'll fix it.