SPREADSHEET
Rental Property Investment Analyzer
IN ONE PARAGRAPHThe Rental Property Analyzer is a spreadsheet that underwrites a long-term rental before you buy it, calculating cap rate, cash-on-cash return, net operating income and DSCR from the standard definitions. The Rental Property Analyzer compares up to three properties side by side and costs $9 once.
Thinking about a rental? Before you make an offer, know your real numbers. The Rental Property Investment Analyzer turns a deal's basics — price, financing, rent, and expenses — into every number that actually decides whether it's worth buying. No guesswork, no broken formulas, no $39/month subscription.
What it calculates (the moment you type your numbers)
- Cap rate — the unlevered yield, so you can compare any two properties fairly
- Cash-on-cash return — your actual return on the cash you put in
- Monthly & annual cash flow — after the mortgage, taxes, insurance, vacancy and reserves
- DSCR — the debt-coverage ratio lenders check (they usually want 1.20+)
- NOI, GRM, operating-expense ratio, and the 1% rule — the full screening picture
- Mortgage payment — computed with the standard amortization formula from your rate and term
Compare up to 3 deals side by side
Put three properties in one view and see instantly which one cash-flows and which one only looks good.
Why this one
Most rental spreadsheets are pretty but opaque — and some quietly use the wrong formula. Every calculation here uses the standard industry definition (cap rate = NOI ÷ price, cash-on-cash = annual cash flow ÷ cash invested, DSCR = NOI ÷ debt service) and is machine-verified for arithmetic correctness. A plain-English "Start Here" sheet explains what each metric means.
What you get
- 1 × .xlsx workbook — Analyzer + Compare + Start Here sheets
- Works in Excel 2010+, Google Sheets, and LibreOffice — no macros, no add-ins
- Yellow cells are yours; everything else calculates itself. A worked $200k example shows the format.
- Yours forever, free updates.
Verification
Every metric uses the standard industry definition and the formulas are machine-tested for arithmetic correctness before release. The spreadsheet ships with a worked example and a plain-English “Start Here” sheet.
Important: this is a calculation tool, not investment, tax, or financial advice. It does the math on the numbers you enter — it can't know if your rent, vacancy, or expense assumptions are realistic for your market. Always do your own due diligence; real estate carries risk, including loss of capital.
