Why Most Airbnb Deal Analyses Fail
Most investors analyze Airbnb deals the wrong way: they take the seller's projected revenue, subtract mortgage and maybe insurance, and call the leftover "profit." This approach misses at least 40% of real operating costs and produces wildly optimistic projections that fall apart in year one.
The correct approach is a bottom-up expense waterfall — you model every cost category from gross revenue down to after-tax cash flow, then calculate ROI on your actual cash invested. This guide walks through the complete framework used by professional STR investors.
Estimate Realistic Annual STR Revenue
Revenue estimation is the hardest part and where most analyses go wrong. You need two numbers: Average Daily Rate (ADR) and Occupancy Rate.
How to find ADR: Search Airbnb for comparable listings — same bedroom count, similar quality, within 1 mile — and note the average nightly rate for a mid-season month. Use the median of 5–10 comps, not the best performer.
How to find occupancy: Tools like AirDNA, Mashvisor, or Rabbu show market-level and listing-level occupancy data. As a baseline: use 55% for a conservative underwrite on a new listing in an established market.
Never use the seller's numbers. Sellers use peak occupancy from their best year. Model the average, not the ceiling.
Build the Operating Expense Waterfall
The STR expense waterfall has more layers than a long-term rental. Work from the top down:
- Airbnb host fee: 3% of gross revenue (standard for hosts using Airbnb payments)
- Cleaning costs: $80–$180 per turn depending on property size. Estimate from local quotes, not guesses. With 12 bookings/month on a 2BR, this is $1,000–$2,000/month.
- Occupancy / lodging tax: 6–15% depending on city/state. Check your local jurisdiction — many STR markets now collect this automatically via Airbnb, but it's still a reduction from your gross.
- Property management fee: 20–25% of gross if outsourcing. If self-managing, cost is zero financially but your time has value.
- Maintenance & repairs: Budget 1–1.5% of property value per year. STRs have higher wear than LTRs.
- Supplies & restocking: Toiletries, linens replacement, kitchen consumables — $50–$150/month for a well-run listing.
Calculate Net Operating Income (NOI) and Cap Rate
NOI is your income after all operating expenses but before mortgage payments. It's the financing-neutral measure of property performance.
If the cap rate is below 5%, no amount of creative financing fixes the deal — the asset simply doesn't earn enough relative to its price. Move on.
Add Financing & Calculate Cash-on-Cash ROI
Now layer in your actual financing to calculate the return on your cash invested.
Stress-Test at Downside Occupancy
Every STR deal should be stress-tested at 40% occupancy — this represents a bad year: new listing ramp-up, regulatory changes, market oversupply, or a slow travel season.
Ask: Can the property cover its mortgage and fixed costs at 40% occupancy? If yes, you have a margin of safety. If no, you're betting on a best-case scenario, and a single slow year could cost you the property.
Run the Five-Point Go/No-Go Checklist
-
Cap Rate ≥ 6% Ensures the asset earns enough relative to purchase price, regardless of financing structure.
-
Cash-on-Cash ROI ≥ 8% Your return on actual cash deployed must beat other investment alternatives.
-
Positive Monthly Cash Flow at Base Case The deal should generate positive cash flow at your modeled (conservative) occupancy — not just at peak.
-
DSCR ≥ 1.2× Debt Service Coverage Ratio = NOI ÷ Annual Mortgage. Must be 1.2× or above to have meaningful payment cushion.
-
Gross Revenue ≥ 13% of Purchase Price Annual gross revenue should be at least 13% of what you paid. Below 10% = deal is overpriced for the market's income potential.
A deal that passes all five is strong. Three or four with clear upside is acceptable. Two or fewer is a pass.
Full Example: The Complete Waterfall
A 2-bedroom cabin, $380,000 purchase price, $175 ADR, 60% occupancy, 10 bookings/month, $120 cleaning fee, 8% occupancy tax, 7% mortgage rate, 20% down.
What Makes a Deal Actually Work Today
In the current interest rate environment (7–8%), Airbnb deals require one or more of these conditions to generate acceptable returns:
- High ADR markets: Beach, ski, or niche luxury destinations where $300–$600/night is achievable on a 3BR.
- Lower purchase prices: Markets where you can buy a quality STR property for $200,000–$300,000.
- High occupancy with low seasonality: Year-round demand markets (some urban, some resort) with 70%+ annual occupancy.
- Value-add deals: Underpriced properties you can improve to command meaningfully higher ADR.
- Lower leverage: Higher down payments (30–40%) reduce mortgage burden and make more deals cash-flow positive.
Run Your Deal Analysis in Under 5 Minutes
Enter your property's numbers and get cap rate, cash-on-cash ROI, DSCR, and the full go/no-go checklist instantly.
Analyze This Deal →