DealMemo icon DealMemo

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.

RevPAN and Break-Even Occupancy
RevPAN (revenue per available night) = ADR x Occupancy. Break-even occupancy = Monthly fixed costs / (Available nights x (ADR x (1 - platform fee) - cleaning per stay / average stay length)).

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.

  1. Monthly fixed costs: $1,450.00 + $200.00 + $140.00 + $180.00 + $40.00 + $150.00 = $2,160.00
  2. ADR net of platform fee: $200.00 x (1 - 15 / 100) = $170.00
  3. Cleaning per occupied night: $150.00 / 3 = $50.00
  4. Contribution per occupied night: $170.00 - $50.00 = $120.00
  5. Break-even occupancy: $2,160.00 / (30 x $120.00) = $2,160.00 / $3,600.00 = 60.00%
  6. 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.

Calibration Deals:
DSCR Coverage
0.88x
Below 1.25x
Monthly Cash Flow
-$169
-$2,029/yr
Cap Rate
5.11%
NOI $14,316/yr
70% Flip MAO
$196,000
$84,000 over
Cash-on-Cash
-2.59%
Cash In $78,400
1% Rule / GRM
0.64%
GRM 3.8x

Deal Assumptions

$
$
$
$

7x7 Interest Rate vs Vacancy Stress Matrix

0/49 cells pass DSCR >= 1.25x

Click any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.

Rate \ Vac0%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.

Related Underwriting Guides