Rental Deal Analyzer
Compare 3 rentals: cash flow, cap rate, cash-on-cash, DSCR, 10-year IRR and sensitivity tables.
Know whether a rental is a deal before you make an offer.
Compare 3 properties side by side from 25 inputs: price, financing, rent, vacancy, taxes, insurance, repairs, CapEx and management.
Instant results
- monthly cash flow and NOI
- cap rate, cash-on-cash return, DSCR
- GRM, the 1% rule, break-even occupancy, expense ratio
10-year projection with loan paydown, appreciation, sale after selling costs, IRR and equity multiple.
Sensitivity tables: cash-on-cash by rent × price, and monthly cash flow by interest rate × down payment.
Includes a blank workbook, a SAMPLE with 3 example deals, and a PDF guide that explains every metric.
Prefer a browser app? Rental Property Calculator Pro (https://sheetandflow.gumroad.com/l/rental-calculator-pro) is a separate $12 download with the same formulas, a max-offer price finder, saved deals and CSV export. It isn't included with this spreadsheet.
Works in Excel 2010+, Google Sheets and LibreOffice. No macros.
Tested: every result, including IRR, matches an independent calculation.
A calculator, not financial advice.
Built with AI assistance and tested by running it end to end (details in the guide).
Refunds: 30-day refund if it doesn't work as described (refund policy).
Learn the method (free)
- Cap Rate vs. Cash-on-Cash vs. DSCR: A Worked Rental Example
The three numbers that decide whether a rental is a deal, calculated step by step on one real-looking property, with a free calculator.
Related free tools
- Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR
Instant rental deal math in your browser: monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule and break-even occupancy.
Save with a bundle
- Landlord Spreadsheet Bundle
2 products for $27 instead of $34 (save $7).
- Complete Bundle (all 6 core products)
6 products for $69 instead of $109 (save $40).
Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.