Real Estate Deal Analyzer — Cap Rate, Cash Flow & Cash-on-Cash Spreadsheet (Excel + Google Sheets)

Calculator tool only — not financial, tax or legal advice. Verify all numbers against local data before making an offer.

Stop guessing whether a rental property is a good deal. Type in the yellow cells — price, rent, taxes, loan terms — and the sheet instantly shows you the numbers serious investors check before making an offer:

- Cap rate & NOI

- Monthly and annual cash flow

- Cash-on-cash return

- Mortgage payment (principal & interest)

- DSCR — the ratio lenders look at

- 1% rule check and gross rent multiplier

- CapEx reserve modeled separately (roof, HVAC, appliances)

Then go deeper:

- Sensitivity grid — annual cash flow across rent × price scenarios

- 5-year projection — rent/expense growth, appreciation, equity build-up and IRR, with a chart and an exit-sale scenario

- BRRRR calculator — rehab budget, holding costs, refinance, cash left in the deal

- Compare up to 3 deals side by side

Bonus: a 15-point Due Diligence Checklist — the exact items to verify before signing (taxes, insurance, HOA assessments, flood zone, title, local rental rules).

Works in Microsoft Excel and Google Sheets (upload the .xlsx — formulas convert automatically). One-time payment, use it on every deal you analyze.

For: beginner and practicing buy-and-hold investors (single-family, small multifamily).

FAQ

Do I need paid Excel? No — works in free Google Sheets: upload the .xlsx, formulas convert automatically.

Is this financial advice? No. It is a calculator. Check figures against local taxes, insurance and rental rules.

Can I change assumptions? Yes: vacancy, maintenance and management are % of rent; taxes and insurance are annual amounts.

Refunds: digital file; if the file does not open or formulas are broken in your Excel/Sheets version, write to support — we fix or refund.

Support: reply to the delivery email; response within 2 business days.