Skip to main content
Getly

Command menu

Jump to a page or search the catalog

Spreadsheets & Calculators

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

Evaluate rental deals in seconds: cap rate, NOI, cash flow, cash-on-cash and DSCR, plus a sensitivity stress-test and a 15-point due diligence checklist. Works in Excel and Google Sheets.

$24.00

What you get: 1 file · 18.07 KB · XLSX

See purchase options

Product description

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.

What you get

1 file · 18.07 KB

  • Real-Estate-Deal-Analyzer.xlsxXLSX · 18.07 KB
LicensePersonal use only
Package checkPassed

Getly opened the uploaded files and found nothing that would stop them opening. It is not a virus scan or a quality rating.

PublishedOct 22, 2026
File size18.07 KB
File formatXLSX
Versionv1.0

Tags

real estatespreadsheetcalculatorcap ratecash flowinvestingexceldscrrental
d
dealtools

Frequently asked questions

Do I get access instantly?

Yes. This is a digital product - you can download it right after checkout, straight from your library.

Can I use it for commercial projects?

Personal use only. Use it for yourself - not in work you sell or hand to a client - and do not resell or redistribute the file.

What's your refund policy?

You can request a refund within 30 days. If something isn't right, request it from your order and the Getly team reviews it.

What file formats and sizes will I get?

You'll download 1 file - XLSX - 18.07 KB in total.

Do I get free updates?

Yes - when the seller ships a new version, you can re-download the latest files from your library at no extra cost. Check the changelog for recent updates.

Price

$24.00