Airbnb Occupancy Rate Calculator Formula

Understand the math behind the airbnb occupancy rate calculator. Each variable explained with a worked example.

Use the Airbnb Occupancy Rate Calculator

Formulas Used

Current Occupancy Rate

current_occ = occupancy_rate

Current Annual Revenue

current_rev = current_revenue

Revenue at Target Occupancy

target_rev = target_revenue

Revenue Opportunity

rev_gap = revenue_gap

Additional Nights Needed

additional_nights = target_nights - nights_booked

RevPAN (Revenue Per Available Night)

rev_per_available_night = nights_available > 0 ? current_revenue / nights_available : 0

Variables

VariableDescriptionDefault
nights_bookedNights Booked (per year)220
nights_availableNights Available (per year)350
avg_nightly_rateAverage Nightly Rate(USD)165
target_occupancy_pctTarget Occupancy Rate(%)75
occupancy_rateDerived value= nights_available > 0 ? (nights_booked / nights_available) * 100 : 0calculated
current_revenueDerived value= nights_booked * avg_nightly_ratecalculated
target_nightsDerived value= nights_available * target_occupancy_pct / 100calculated
target_revenueDerived value= target_nights * avg_nightly_ratecalculated
revenue_gapDerived value= target_revenue - current_revenuecalculated

How It Works

Occupancy Rate Analysis for Short-Term Rentals

Occupancy rate measures how efficiently your property generates bookings from available nights. It is the most important performance metric for short-term rental operators.

Formula

Occupancy Rate = Nights Booked / Nights Available x 100

Key Metrics

  • Occupancy Rate: Percentage of available nights that are booked
  • ADR (Average Daily Rate): Average revenue per booked night
  • RevPAN (Revenue Per Available Night): Total revenue divided by available nights, combining both occupancy and rate

    • Optimizing Occupancy

  • Lower rates during slow periods to fill gaps
  • Adjust minimum stays based on booking patterns
  • Respond quickly to inquiries (within 1 hour)
  • Maintain Superhost status for better visibility
  • Use professional photography and compelling descriptions

    • Balancing Rate vs. Occupancy

    Higher rates mean fewer bookings but more revenue per night. The goal is to maximize RevPAN, not just occupancy or rate alone.

    Worked Example

    220 nights booked out of 350 available, $165 average nightly rate, with a target of 75% occupancy.

    nights_booked = 220nights_available = 350avg_nightly_rate = 165target_occupancy_pct = 75
    1. 01Current occupancy: 220 / 350 = 62.9%
    2. 02Current revenue: 220 x $165 = $36,300
    3. 03Target nights: 350 x 75% = 262.5
    4. 04Target revenue: 262.5 x $165 = $43,313
    5. 05Revenue opportunity: $43,313 - $36,300 = $7,013
    6. 06Additional nights needed: 262.5 - 220 = 42.5
    7. 07RevPAN: $36,300 / 350 = $103.71

    Ready to run the numbers?

    Open Airbnb Occupancy Rate Calculator