Uses your Revenue tab inputs. Update the Revenue tab to see how different occupancy rates affect your profit.
| Occupancy | Booked Nights | Gross Rev | Net Profit / Mo | Annual |
|---|---|---|---|---|
| Enter inputs in the Revenue tab first | ||||
| Metric | Good | Great | Elite |
|---|---|---|---|
| Cash-on-Cash | 6–8% | 8–12% | >12% |
| ROI % | 8–12% | 12–18% | >18% |
| DSCR | 1.25–1.5 | 1.5–2.0 | >2.0 |
| Annual CF | $5k+ | $10k+ | $20k+ |
| Occupancy | 55–65% | 65–75% | >75% |
| Appreciation | 3% | 4% | 5%+ |
Use this tab when you own or are buying a property. Fill in all sections A–D. The Scorecard at the top updates live and grades your deal against investor benchmarks with ✅ / ⚠️ / ❌ signals.
Section A — Enter purchase price, down payment %, and estimated repair/furnishing cost. Closing costs (4%) are estimated automatically.
Section B — Enter your interest rate, loan term, and monthly tax/insurance estimates. The P&I payment is calculated using the PMT formula.
Section C — Enter your nightly rate, occupancy %, and available nights. Gross revenue calculates automatically.
Section D — Enter all operating expenses. Annual cash flow, Cash-on-Cash, ROI, and DSCR appear at the top.
Use this tab to model STR revenue independently — great for rental arbitrage (subleasing) where you don't own the property. Enter your fixed monthly costs, Airbnb settings, and fees.
Results show monthly profit after all costs, annual profit, and cash-on-cash return based on your setup cost.
Uses your Revenue tab inputs to show profit at 8 different occupancy levels (50%–85%). Color coded red/gold/green to instantly show your downside, break-even, and upside.
Also shows your break-even occupancy rate — the minimum occupancy needed to cover all costs.