Airbnb Unit Economics: Contribution Margin per Stay, Night, and Property

TL;DR

Unit economics for a short-term rental starts with one choice: which unit to measure. A stay, a booked night, and a property-period are three distinct units. Each one gets its own revenue total and its own variable-cost total before any division happens.

The unit-economics worksheet computes dollar contribution per unit, not a percentage margin. Dollar contribution equals declared revenue minus declared variable costs for that unit. A percentage contribution margin divides that dollar result by the matching revenue figure. Both formulas appear below. The operator can choose which one to track.

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.

Hypothetical opening example: For one completed stay in January 2026, with amounts in US dollars, an operator enters $500 of declared revenue and $180 of declared variable costs. Dollar contribution is $500 - $180 = $320 for that stay.

Key Facts

Step 1: Choose One Unit Before Calculating

Mixing units inside a single formula produces a meaningless result. Pick one of the three units below. Then stay with it for the entire calculation.

• Stay (reservation): one completed guest reservation, regardless of length.
• Booked night: one calendar night covered by a paid reservation.
• Property-period: one property across a defined calendar period, such as a month or quarter.

A stay count and a nights-booked count are not interchangeable. A five-night reservation is one stay. It covers five booked nights. Deriving a stay count from a nights-booked field requires a separately supplied reservation count; the worksheet does not infer one from the other.

Step 2: Define Per-Stay Revenue and Variable Cost

Revenue included for one stay

Declare every revenue item the operator counts for a single reservation. Common operator-entered items include the nightly rate total for that stay, any cleaning fee the operator receives, and any other per-reservation fee the operator collects. Items the operator excludes must be listed as excluded so the boundary is visible.

Variable costs included for one stay

In general business terms, variable costs change as production or service levels change. SBA break-even guidance on fixed and variable costs.

The Airbnb examples below are operator-entered, not SBA examples. They may include cleaning labor, supplies used per turnover, and platform fees for that stay. The operator must declare which costs are included and which are excluded. This worksheet does not classify any cost as variable for tax or accounting purposes.

Dollar contribution for one stay

Individual-stay dollar contribution =
  (Revenue declared for the stay) minus (Variable costs declared for the stay)

The individual-stay formula applies to one completed stay record. If the property-period stay count is zero, an average contribution per stay is undefined. Retain the aggregate property-period contribution without dividing. Never substitute a fabricated ratio.

A negative result means declared variable costs exceeded declared revenue for that stay. A zero result means they were equal. Both are valid outputs; the worksheet does not suppress them.

Percentage contribution margin per stay (optional)

Individual-stay percentage contribution margin =
  (Individual-stay dollar contribution) divided by (Revenue declared for that stay),
  multiplied by 100

Compute only when the matching revenue is resolved and greater than zero.
Zero revenue: undefined. Negative revenue: not applicable for this percentage worksheet.
Unknown revenue: infeasible until the matching revenue is resolved.

The numerator and denominator must describe the same stay. A negative contribution over positive matching revenue remains a valid negative percentage. The operator may track the dollar figure, the percentage, or both. The worksheet does not assert which is more useful across all operating models.

Step 3: Define Per-Booked-Night Contribution

Revenue and variable cost per booked night

Some variable costs attach to a reservation regardless of length. Others scale with each night. The operator must decide which costs belong in a per-night calculation and declare them explicitly. A cleaning fee paid once per stay, for example, may be more meaningful at the stay level than spread across nights.

Average dollar contribution per booked night

Average dollar contribution per booked night for a property-period =
  (Property-period contribution) divided by (Booked nights in that period)

Compute only when booked nights is known and greater than zero.
Zero booked nights: undefined. Negative booked nights: infeasible input.
Unknown booked nights: infeasible until the count is resolved.

When booked nights equal zero, the aggregate contribution amount remains valid. The per-night ratio is undefined. It must not be reported as zero or any other fabricated figure. A negative count is infeasible. An unknown count prevents the average calculation.

Step 4: Define Property-Period Contribution

Aggregating to a property-period

A property-period unit covers one property across a stated calendar span. The operator sums all declared revenue and all declared variable costs for that property and period before subtracting.

Property-period contribution =
  (Total declared revenue for the property and period)
  minus (Total declared variable costs for the property and period)

Zero and negative property-period results are valid when the math supports them. If a required revenue or variable-cost input is unknown, the formula is infeasible until that input is resolved. Do not enter zero in its place.

The property-period result is an aggregate, not a per-unit figure. To turn it into a per-night or per-stay figure, divide by the matching unit count. The count must be greater than zero.

Step 5: Separate Fixed Costs and Internal Period Surplus

Fixed costs do not change with reservation volume within the period. Rent is one operator-entered example. A base internet plan and a fixed monthly software subscription are others. The SBA distinguishes fixed and variable costs in a general business context. The operator applies that structure to their own records. SBA: Plan Your Business, Break-Even Point

Internal period surplus =
  Property-period contribution
  minus (Fixed costs declared for the property and period)
  minus (Overhead allocated to the property for the period, if any)

Zero and negative internal period surplus results are valid when the math supports them. If a required contribution or fixed-cost input is unknown, the formula is infeasible until that input is resolved. If overhead is explicitly excluded, the overhead row is not applicable rather than unknown. Do not subtract an overhead value.

Internal period surplus is a planning label. It is not a profit, net income, or investment-return figure. Overhead allocation rows are user-selected labels, not universal accounting classifications.

Step 6: Reconcile Airbnb Inputs for 2026

Airbnb earnings reports can expose listing-level earnings, nights booked, fees, and optional cleaning-fee fields. Airbnb Help: Earnings Summary These fields may supply some declared revenue inputs to the worksheet.

Before using any Airbnb field, the operator must classify its relationship to the selected total. The field is either embedded in another field, separate and addable, excluded from the worksheet scope, or unknown until the operator checks their own record. Airbnb does not validate off-platform variable costs, fixed costs, overhead allocations, or a final contribution result.

Nights booked is a platform field. A stay count is a separate reservation count. The worksheet does not derive one from the other without a separately supplied figure.

Step 7: Worked Hypothetical Across All Three Units

The following example is entirely hypothetical. It uses made-up inputs to show arithmetic only. It is not a forecast or investment-return result. It does not represent any actual property or operator.

Period: one calendar month. Property: one hypothetical unit.

Property-period contribution: $2,400 minus $720 equals $1,680.

Average dollar contribution per stay for this property-period: $1,680 divided by 6 equals $280.00 per stay.

Property-period percentage states: Zero total revenue makes the percentage undefined. Negative total revenue makes it not applicable. Unresolved total revenue makes the calculation infeasible until that input is resolved.

Property-period percentage contribution margin: $1,680 divided by $2,400 equals 70.0 percent. The equivalent average-scope calculation is $280 divided by $400 average revenue per stay, also 70.0 percent. The denominator is positive and resolved. Rounding: none needed here.

Average dollar contribution per booked night for this property-period: $1,680 divided by 18 equals $93.33 per booked night (rounded to the nearest cent).

Internal period surplus: $1,680 minus $1,100 equals $580 for the month.

If stays had been zero, the average per-stay contribution would be undefined and the aggregate $1,680 would remain valid. A negative stay count is infeasible. An unknown count prevents the average calculation. The same zero, negative, and unknown dispositions apply to booked nights.

Step 8: Sensitivity and Allocation Choices

Changing one input changes every downstream figure. The table below shows how a single variable-cost shift moves the result in this hypothetical.

Overhead allocation is a user-selected label. No universal allocation method is supported by this worksheet. An operator running multiple properties may allocate shared costs by property count, by revenue share, or by another method they choose and document. Each choice produces a different internal period surplus for each property. The worksheet does not assert which method is correct.

Step 9: Common Denominator Errors

Four errors appear often in short-term rental unit calculations.

1. Mixing unit types mid-formula. Dividing a stay-level contribution by a nights-booked count produces a figure with no clear meaning. Keep the numerator and denominator in the same unit.
2. Dividing by zero. A month with no completed stays makes per-stay contribution undefined. Report the aggregate and note the zero denominator.
3. Including fixed costs in variable cost rows. Fixed costs belong below the contribution line. Placing them above it understates contribution. It also makes the per-unit figure incomparable across periods with different volumes.
4. Using nights booked as a stay count. A ten-night booking is one stay. Treating it as ten stays overstates stay count. It also understates per-stay contribution.

Frequently Asked Questions

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