Rental Property Analyzer Spreadsheet: Cash Flow, Cap Rate, Cash-on-Cash, DSCR & 10-Year ROI
Know whether a rental is worth buying before you make an offer. Type in a property's price, financing, rent and expenses, and this spreadsheet instantly tells you if the numbers work.
What's inside:
- Deal Analyzer: mortgage payment, net operating income, monthly and per-unit cash flow, cap rate, cash-on-cash return, DSCR (debt coverage), the 1% rule, gross rent multiplier and break-even occupancy.
- Instant verdict: every deal is scored against your own investing targets (cash flow per unit, cash-on-cash, cap rate and DSCR) and labelled Strong Deal, Good Deal, Borderline or Pass.
- 10-Year Projection: rent and expense growth, cash flow, loan paydown, property value, equity, total profit and ROI year by year, with a chart.
- Amortization Schedule: your full month-by-month mortgage breakdown and total interest paid.
- Compare Deals: analyze up to five properties side by side and see which one wins.
Works for single-family homes, condos, duplexes and small multifamily. Built-in rules of thumb for vacancy, maintenance, capital reserves and management, all fully adjustable.
You get two files: a blank analyzer ready for your deals, and a filled example with four sample properties so you can see exactly how it works.
Works in Microsoft Excel, Google Sheets and Apple Numbers. Yellow cells are for typing; everything else calculates itself. No formulas to write.
Important: this is a planning and educational tool, not financial, tax, legal or lending advice. Results depend on the numbers you enter; always verify with qualified professionals.
Digital download (.xlsx files in one .zip). For personal use.
