Airbnb Break-Even Occupancy Calculator: Nights Needed to Cover Costs

By Sean Rakidzich.

Published August 15, 2026.

TL;DR

Using the SBA break-even unit formula, break-even occupied nights equal your fixed period costs divided by your contribution per booked night. Contribution per booked night equals net nightly revenue minus all costs that vary with each booked night. The result tells you how many nights must be booked in a given period before revenue covers costs.

This worksheet does not tell you whether that number of nights is achievable. It gives you a planning target so you can compare it against your own expectations before committing to a listing period.

Educational scope: This worksheet uses operator-entered assumptions for internal planning only. It does not determine tax, accounting, legal, valuation, investment-return, or performance outcomes.

Key Facts for This Calculator

Step 1: Define the Listing Unit and the Period

Every input in this worksheet must share the same unit and the same period. The unit is one listing-night: one property, available for one night. The period is the calendar window you are planning for, such as a single calendar month or a full year. Mixing units or periods produces a meaningless result.

Before entering any number, write down two things: the exact start and end dates of your planning period, and the total number of nights the listing will be available during that period. Call that number A. Available nights is not the same as booked nights. A 30-day month with no blocked dates gives A = 30. If you block five nights for personal use, A = 25.

The NCHMCT revenue management text, printed page 8, defines Average Daily Rate as room revenue divided by rooms sold and Revenue per Available Room as room revenue divided by rooms available. This worksheet does not import either revenue metric into the break-even formula. It uses one listing-night as an article-defined unit and the operator-entered available-night count as A.

Step 2: Separate Fixed and Variable Inputs

Fixed costs are period costs that do not change with the number of nights booked. The SBA break-even framework frames fixed costs as an estimate for a declared period. Examples an operator might include are rent or mortgage payments, a fixed monthly internet bill, or a fixed property management software subscription. Whether a specific cost is fixed or variable in your situation depends on your actual contracts and records, not on a universal rule.

Variable costs in this worksheet change with each booked night. Operator-entered examples may include separately deducted platform service fees, consumable supplies, and allocated turnover costs. Per-booking and per-stay amounts require conversion to the same per-night unit before they enter V.

Write down your total fixed costs for the period. Call that number F. Write down your variable cost per booked night. Call that number V. Do not mix period totals with per-night figures.

Step 3: Define Net Revenue Per Booked Night

Net revenue per booked night is the operator-selected revenue base after all components already embedded in that base. Before using it, classify every platform fee, adjustment, pass-through charge, and turnover amount in the actual record as embedded in R, separate from R, excluded, or unknown. R must exclude every separate amount that you plan to add to V. If a component is embedded, do not add it to V again. If its relationship is unknown, stop and resolve it before calculating contribution.

Call your net revenue per booked night R. If your nightly rate varies by season or stay length, use a single representative figure and state that assumption, or run separate scenarios for each rate band. A single scenario cannot represent a mixed-rate period without that caveat.

Step 4: Calculate Contribution Per Booked Night

Educational scope: This worksheet uses operator-entered assumptions for internal planning only. It does not determine tax, accounting, legal, valuation, investment-return, or performance outcomes.

Contribution per booked night is the amount left from one booked night after paying variable costs for that night. The SBA unit formula states that contribution equals price per unit minus variable cost per unit. Applied to listing-nights, that is:

C = R - V

Where C is contribution per booked night, R is net revenue per booked night, and V is variable cost per booked night.

Zero contribution (C = 0): If R equals V exactly, contribution is zero. Dividing fixed costs by zero is undefined. No finite number of booked nights can cover fixed costs. The worksheet cannot produce a break-even result. Stop and revise your inputs.

Negative contribution (C < 0): If variable cost exceeds net revenue, contribution is negative. The formula produces a negative quotient, which is not a feasible break-even solution. Each additional booked night increases the deficit. Stop and revise your inputs before proceeding.

Positive contribution (C > 0): Only a positive C allows the worksheet to continue.

Step 5: Handle Turnover Costs and Stay Length

Turnover costs such as cleaning fees occur once per stay, not once per night. A two-night stay generates one turnover event. A one-night stay also generates one turnover event. If you allocate turnover costs per stay rather than per night, you must convert them to a per-night figure before adding them to V.

To convert, divide the per-stay turnover cost by your assumed average length of stay in nights. Call the result T.

T = turnover cost per stay / assumed average stay length

Unknown stay length: If the average stay length is missing or unknown, T cannot be computed. Stop before allocating the turnover cost.

Zero stay length: If the average stay length equals zero, T is undefined because division by zero is not permitted. Stop the calculation.

Negative stay length: A negative average stay length is invalid. Correct the input before calculating T.

Positive stay length: Only a known value greater than zero permits the division. Add T to your other per-night variable costs to get the full V. State the assumption explicitly because changing it changes V, C, and the break-even result.

Apply the same composition gate to every fee, adjustment, pass-through charge, and turnover cost. Add an amount to V only when the actual record confirms it is separate from and not already embedded in R. Convert any per-booking or per-stay amount to a per-night amount using an explicit stay-length assumption. If the relationship is unknown, stop. Adding an amount already embedded in R would double-count it and understate contribution.

Step 6: Calculate Break-Even Booked Nights

Before division, F must be known and nonnegative. If F is missing or unknown, N remains UNKNOWN / NOT CALCULATED. If F is negative, the input is invalid and the worksheet must stop. Only a known F greater than or equal to zero and a positive C allow the calculation to continue:

N = F / C

Where N is break-even booked nights, F is total fixed costs for the period, and C is contribution per booked night.

Because nights are whole units, round N upward to the next whole number. A fractional result such as 14.2 nights means 14 booked nights leave a small deficit; 15 booked nights are the first whole-night count that covers fixed costs. The fractional value is useful as a diagnostic but the operational target is the ceiling integer.

Zero fixed costs (F = 0): Under the required C > 0 precondition, if fixed costs are zero, N equals zero. Any booked night produces a surplus. This case is mathematically valid.

The SBA describes the result as an estimate. SBA: Plan Your Business frames break-even as the point where total revenue equals total cost, not as a guarantee of profitability beyond that point.

Step 7: Convert Nights to Break-Even Occupancy

Before division, available nights must satisfy A > 0. If A = 0, occupancy is undefined because the denominator is zero; stop the calculation. If A < 0, the availability input is invalid; stop and correct it. Only A > 0 permits the occupancy calculation:

O = N / A

Where O is break-even occupancy as a decimal, N is break-even booked nights (ceiling integer from Step 6), and A is available nights from Step 1.

Multiply O by 100 to express it as a percentage. For example, if N = 15 and A = 30, then O = 0.50, or 50 percent occupancy for that period.

This worksheet deliberately avoids external occupancy benchmarks. The result is a property-specific planning figure based on your entered inputs. O = N / A is the article-defined ratio of required booked listing-nights to operator-entered available listing-nights. For comparison of denominator terms only, the NCHMCT revenue management text, printed page 8, defines ADR with rooms sold and RevPAR with rooms available. This article uses the citation only for those denominator terms, not for an occupancy target.

If N exceeds A, break-even occupancy exceeds 100 percent. That result is infeasible. No number of booked nights within the available period can cover fixed costs at the entered contribution level. Revise F, R, V, or the period before using the result for any planning purpose.

Worked Hypothetical with Exact Arithmetic

The following example is entirely hypothetical. It uses invented figures to demonstrate the arithmetic. It does not represent any real listing, market, or achievable outcome.

Period: One calendar month, 30 available nights (A = 30).
Fixed costs for the period (F): $900 (hypothetical rent allocation for the month).
Net revenue per booked night (R): $120 after other embedded components but before the separately deducted hypothetical platform fee; that fee is not embedded in R.
Separately deducted platform fee per booking: $45, allocated across the assumed 3-night stay as $45 / 3 = $15 per night.
Variable cost per booked night excluding turnover (V base): $15 (the per-night platform fee allocation above).
Turnover cost per stay (hypothetical): $60.
Assumed average length of stay: 3 nights.
Turnover cost per night (T): $60 / 3 = $20.
Full variable cost per booked night (V): $15 + $20 = $35.
Contribution per booked night (C): $120 - $35 = $85.
Break-even booked nights (N, exact): $900 / $85 = 10.588...
N (ceiling integer): 11 nights.
Break-even occupancy (O): 11 / 30 = 0.3667, or approximately 36.7 percent for this hypothetical period.

At 10 booked nights, total contribution is $850, leaving $50 of the $900 fixed cost uncovered. At 11 booked nights, total contribution is $935, covering the fixed cost with $35 remaining. Net revenue at R = $120 totals $1,200 at 10 nights and $1,320 at 11 nights, but the break-even comparison uses contribution after V. The ceiling rule is why 11 is the operational target rather than 10.

Sensitivity Table

All figures below are hypothetical extensions of the worked example above. Period, unit, and base inputs are unchanged. Only the variable shown in each column changes.

Each row changes one input and holds others constant. Real planning scenarios may change multiple inputs at once. Run a separate scenario for each combination you want to evaluate.

Limits and Stop Rules

Stop and revise inputs before using any result if any of the following apply.

• Contribution C is zero or negative. No feasible break-even exists at those inputs.
• Fixed costs F are missing or unknown. N remains unknown and is not calculated.
• Fixed costs F are negative. The input is invalid and must be corrected before division.
• Average stay length is missing or unknown. Turnover cost per night T cannot be computed, so the calculation stops.
• Average stay length equals zero. T is undefined because division by zero is not permitted.
• Average stay length is negative. The input is invalid and must be corrected before division.
• Available nights A equals zero. Occupancy is undefined because division by zero is not permitted.
• Available nights A is negative. The input is invalid and must be corrected before division.
• Break-even nights N exceeds available nights A. The result is infeasible for the declared period.
• You have not confirmed whether every fee, adjustment, pass-through charge, and turnover cost is embedded in R, separate from R, excluded, or unknown. Double-counting changes C and produces a wrong result.
• Your net revenue figure R mixes periods, currencies, or rate bands without a stated assumption.
• Your fixed cost figure F includes costs that actually vary with bookings, or excludes costs that are truly fixed for the period.

The worksheet result is a planning scenario for the inputs you entered. It does not establish that the required occupancy is achievable, that the listing will perform as modeled, or that the cost classification you chose is correct for any accounting, tax, or legal purpose.

For a broader look at how booked nights connect to margin, see the related discussion of Airbnb profit margin. For a fuller cost and revenue structure across a rental arbitrage unit, the Airbnb arbitrage unit economics per-unit profit and loss article walks through the full income statement structure.

FAQ

If you want help applying this worksheet to your operation, Book a strategy session.