Cleaning fee is modeled as guest pass-through by default (does not inflate host P&L). Deal tiers: WEAK < 10% | GOOD ≥ 10% | EXCELLENT ≥ 15%.
| Host Revenue (nightly + other) | $44,446.00 |
| Guest-paid cleaning (pass-through) | $10,585.00 |
| Turns / month (est.) | 6.08 |
| All-in cost basis | $302,940 |
| Cash needed to close | $62,440 |
| Cash invested | $78,940 |
| NOI | $26,719 |
| Annual cash flow (after debt + capex reserve) | $6,794 |
| Monthly cash flow | $566.15 |
| DSCR | 1.51 |
| Break-even occupancy (after debt) | 58.6% |
| Year | Rev | NOI | Cash Flow | DSCR |
|---|---|---|---|---|
| Y1 | $44,446 | $26,719 | $6,794 | 1.51 |
| Y2 | $45,774 | $27,591 | $7,600 | 1.56 |
| Y3 | $47,143 | $28,492 | $8,431 | 1.61 |
| Y4 | $48,552 | $29,421 | $9,290 | 1.66 |
| Y5 | $50,003 | $30,379 | $10,176 | 1.72 |
| Occ \ ADR | $154.80 | $163.40 | $172.00 | $180.60 | $189.20 |
|---|---|---|---|---|---|
| 60.0% | -$2,146 -2.7% | -$470 -0.6% | $1,206 1.5% | $2,883 3.7% | $4,559 5.8% |
| 65.0% | $368 0.5% | $2,184 2.8% | $4,000 5.1% | $5,816 7.4% | $7,632 9.7% |
| 70.0% | $2,883 3.7% | $4,838 6.1% | $6,794 8.6% | $8,749 11.1% | $10,705 13.6% |
| 75.0% | $5,397 6.8% | $7,492 9.5% | $9,587 12.1% | $11,683 14.8% | $13,778 17.5% |
| 80.0% | $7,911 10.0% | $10,146 12.9% | $12,381 15.7% | $14,616 18.5% | $16,851 21.3% |
| Rate \ DP | 10.0% | 15.0% | 20.0% | 25.0% | 30.0% |
|---|---|---|---|---|---|
| 5.90% | 12.8% | 11.6% | 10.8% | 10.3% | 9.9% |
| 6.40% | 10.9% | 10.2% | 9.7% | 9.4% | 9.2% |
| 6.90% | 8.9% | 8.7% | 8.6% | 8.5% | 8.4% |
| 7.40% | 6.9% | 7.3% | 7.5% | 7.6% | 7.7% |
| 7.90% | 4.9% | 5.7% | 6.3% | 6.7% | 6.9% |