Real Estate & Airbnb Deal Analyzer — Rental Property Calculator Spreadsheet (Excel & Google Sheets)

Know if a rental or Airbnb deal makes money before you make an offer.

Type in the price, the loan and the rent (or the nightly rate). In under 60 seconds you get a clear verdict: Strong Deal, Decent, or Losing Money. You also see the cash flow, cap rate and cash-on-cash return behind it.

No guesswork, no subscription, no complicated software. Just the numbers that matter.

NEW in v4: built for Airbnb investors

• ✔ Airbnb host fee included, so your profit isn't overstated
• ✔ Furnishing & setup costs added to your total cash needed
• ✔ Guest cleaning fees counted as income, with your cleaning costs as expenses
• ✔ What-If heatmap for Airbnb: see what happens if bookings drop or rates rise

What's inside

• Inputs: the only tab you type in. Green cells only; everything else is locked.
• Dashboard: instant verdict, Total Cash Needed, NOI, Monthly Cash Flow, Cap Rate, Cash-on-Cash Return and the 1% Rule.
• What-If: a color-coded heatmap of your cash flow across 25 income and interest-rate scenarios.
• Compare Deals: rank up to 4 long-term rentals side by side. The best numbers highlight automatically.
• Projections: 30-year loan paydown, property value and equity growth, with a chart.

Long-term rental OR Airbnb: one switch

Pick your strategy from a dropdown and the whole model updates. Long-term uses rent and vacancy. Short-term uses nightly rate, occupancy and real Airbnb costs: cleaning, hot tub, internet, supplies and more.

Advanced deals covered

• Hard money loans (points and interest-only)
• Seller financing
• JV / partner splits, so your returns reflect your share

Perfect for

• First-time investors analyzing their first rental
• Airbnb and short-term rental hosts
• House hackers and BiggerPockets-style buy-and-hold investors
• Agents who want to show clients the numbers

What you get

• Deal Analyzer spreadsheet (.xlsx), works in Excel
• Google Sheets version (1-click "Make a copy" link)
• User Guide (PDF)
• Instant download. Use it for every deal, forever.

FAQ

Do I need Excel? No. It works in Google Sheets for free, and on Mac, Windows and Chromebook.

Is there a subscription? No. Pay once, keep it forever.

I'm a beginner. Will I understand it? Yes. The User Guide explains every number in plain English.

Numbers are estimates for analysis only, not financial advice. Always confirm with your lender and your local short-term rental rules.