Rental Property Deal Analyzer

Know the numbers before you buy. Every deal, three scenarios, one verdict.

The Rental Property Deal Analyzer is a 6-tab deal machine with 46 live formulas — run any rental through Base, Conservative, and Stretch scenarios and see monthly cash flow, cap rate, and cash-on-cash return instantly.

WHAT'S INSIDE

• Deal Analyzer — one input block, three scenario columns: monthly cash flow, cap rate, cash-on-cash, color-coded green/red

• Portfolio — track every property you own: rent, cash flow, best performer auto-flagged

• Comps — comparable sales with average estimated cap rate

• Dashboard — portfolio totals at a glance

• Start Here — 3-step setup guide

• Lists — hidden control tab

PROOF IT WORKS

Built on a real example deal: $1,339.98 monthly P&I → Base case $335.02/mo cash flow, 7.58% cap, 6.64% cash-on-cash. Conservative case goes red (-$87.98/mo, -1.75% CoC) so you see the downside before the seller does. Stretch case: $584.02/mo, 11.58% CoC. Portfolio of 3: $7,450 rent, $965.02 cash flow. Every number computed live by the sheet's own formulas, verified cell by cell.

WHAT YOU GET

• The .xlsx file (works in Excel AND imports into Google Sheets in one click)

• Example data pre-loaded so you see exactly how it works — then overwrite with yours

• Yellow = you type here. Everything else calculates itself.

The best deal is the one you analyzed before you fell in love with it.