STR Break-Even Occupancy from ADR, Platform Fee, and Fixed Costs
Short-term rental income depends on how many nights actually book. RevPAN is ADR multiplied by occupancy. Break-even occupancy is the booked share of available nights that covers monthly principal and interest, taxes, insurance, utilities, software, and reserves after the platform fee and after cleaning is spread across the average stay. Every figure on this page is an illustrative user input, including the workbench price, the $1,800 long-term rent field, and the nightly rate.
Break-Even Occupancy from Example Inputs
Every number here is an illustrative user input. Edit a field and the lines recompute. RevPAN equals ADR times occupancy. Break-even occupancy equals monthly fixed costs divided by available nights times the contribution per occupied night. Contribution is ADR after the platform fee, minus cleaning divided by average stay length. Utilities are entered as a fixed monthly amount.
This sheet does not read the workbench. The workbench shows ADR and occupancy, and this page preset also stores the example platform fee and cleaning amount, but it does not show stay length, utilities, software, or reserves as fields.
Worked result
Break-even occupancy 60.00%. RevPAN $120.00.
- Monthly fixed costs: $1,450.00 + $200.00 + $140.00 + $180.00 + $40.00 + $150.00 = $2,160.00
- ADR net of platform fee: $200.00 x (1 - 15 / 100) = $170.00
- Cleaning per occupied night: $150.00 / 3 = $50.00
- Contribution per occupied night: $170.00 - $50.00 = $120.00
- Break-even occupancy: $2,160.00 / (30 x $120.00) = $2,160.00 / $3,600.00 = 60.00%
- RevPAN at that occupancy: $200.00 x ($2,160.00 / $3,600.00) = $120.00
Currency results are rounded to the cent. Occupancy percent is that fraction rounded to two decimals.
Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.
The shared workbench below uses the Short-Term strategy with this page's example ADR, occupancy, platform fee, and cleaning amount. Its cash-flow figure also applies percent-of-income expenses and the amortizing loan. Read break-even occupancy from the sheet above.
Deal Assumptions
7x7 Interest Rate vs Vacancy Stress Matrix
0/49 cells pass DSCR >= 1.25xClick any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.
| Rate \ Vac | 0% | 3% | 5% | 8% | 10% | 15% | 20% |
|---|---|---|---|---|---|---|---|
| 5.25% | |||||||
| 5.75% | |||||||
| 6.25% | |||||||
| 6.75% | |||||||
| 7.25% | |||||||
| 7.75% | |||||||
| 8.25% |
Annual Operating Statement & Debt Service
- Gross Scheduled Income
- $73,000
- Effective Gross Income
- $43,800
- Operating Expenses
- -$29,484
- Net Operating Income
- $14,316
- Monthly Debt (P&I)
- $1,362.06
- Total Cash Required
- $78,400
Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.
Reference Scenario Benchmarks
| Scenario | Inputs | Result | Underwriting Note |
|---|---|---|---|
| Base example inputs | ADR $200; fee 15%; stay 3 nights; cleaning $150; 30 nights; fixed $1,450 + $200 + $140 + $180 + $40 + $150 | 60.00% occupancy; RevPAN $120.00 | Illustrative user inputs. Fixed = $2,160. ADR net = 200 x (1 - 0.15) = $170. Cleaning per occupied night = 150 / 3 = $50. Contribution = 170 - 50 = $120. Occupancy = 2160 / (30 x 120) = 2160 / 3600 = 60.00%. RevPAN = 200 x (2160 / 3600) = $120.00. |
| Same fixed costs, ADR $250 | ADR $250; fee 15%; stay 3 nights; cleaning $150; 30 nights; fixed $2,160 | 44.31% occupancy; RevPAN $110.77 | Illustrative user inputs. ADR net = 250 x 0.85 = $212.50. Contribution = 212.50 - 50 = $162.50. Occupancy = 2160 / (30 x 162.50) = 2160 / 4875 = 44.31%. RevPAN = 250 x (2160 / 4875) = $110.77. Percent and RevPAN are rounded to the cent. |
| Same fixed costs, ADR $120 | ADR $120; fee 15%; stay 3 nights; cleaning $150; 30 nights; fixed $2,160 | 138.46% occupancy; RevPAN $166.15 | Illustrative user inputs. ADR net = 120 x 0.85 = $102. Contribution = 102 - 50 = $52. Occupancy = 2160 / (30 x 52) = 2160 / 1560 = 138.46%. That share is above 100%, so booking all 30 nights still leaves fixed costs uncovered. RevPAN = 120 x (2160 / 1560) = $166.15, rounded to the cent. |
Field Verification Checklist
- 1 List the fixed costs you will actually pay each month: principal and interest, taxes, insurance, utilities, software, and reserves. The sheet starts from example amounts you can replace.
- 2 Divide cleaning by the average stay you enter. A $150 clean over 3 nights is $50 per occupied night. The same $150 clean over 2 nights is $75 per occupied night.
- 3 When the result is above 100%, these inputs leave fixed costs uncovered even if every available night is booked. The workbench Short-Term model is a separate worksheet and does not show utilities, software, or reserves as fields.