Airbnb occupancy rate equals booked nights divided by available nights, multiplied by 100. Count booked nights and open unsold nights in available inventory; record owner stays and maintenance closures separately. The free calculator also calculates calendar utilization, average nightly rate, and revenue per available night for one property and one consistent period.
Review Your Property Assumptions
STR Search offers free live property analysis for short-term rental investors.
Airbnb Occupancy Rate Calculator
Calculate actual performance, compare it with a target, and see how many additional booked nights the target requires.
Occupancy formula: 18 booked nights ÷ 25 available nights × 100 = 72.0%
The default inputs are hypothetical. Results translate your inputs into performance metrics and targets. Demand forecasts require separate property and market assumptions.
Occupancy Formula and Night Definitions
Occupancy rate = booked nights ÷ available nights × 100. Available nights = booked nights + open unsold nights. Equivalently, available nights = calendar nights − genuinely blocked nights for the selected period.
Airbnb defines occupancy as nights booked divided by total nights available to be booked across the relevant listings. Its occupancy and rates definitions also define average nightly rate as nightly revenue divided by booked listing nights. A sold night stays in the availability denominator even though a new guest can no longer reserve it.
Keep one night-level record with the property, stay date, reservation status, closure reason, and allocated lodging revenue. Count a three-night stay as three nights. For a stay spanning two months, assign each night to its stay month and allocate the nightly lodging charge to that same month. Count a checkout date only when a separate stay occupies that night.
| Night status | Occupancy numerator | Available-night denominator |
|---|---|---|
| Completed paid guest night | Include in historical paid occupancy | Include |
| Active future guest booking | Include in forward booked occupancy | Include |
| Open unsold night | Exclude | Include |
| Owner stay or personal guest | Exclude from paid occupancy | Exclude when held out of guest inventory |
| Maintenance or renovation closure | Exclude | Exclude while unavailable |
For this operating worksheet, “open unsold nights” means available inventory that remains unsold. Airbnb's dashboard label “unbooked nights” includes blocked calendar nights, so that dashboard total needs reconciliation before it can serve as the calculator's unbooked available-night count. Keep nightly status mutually exclusive to prevent double counting.
For the default month, Airbnb's inclusive unbooked total would be 12 nights: five blocked plus seven open unsold. Reconcile it as open unsold = dashboard unbooked − blocked = 12 − 5 = 7. Available inventory then equals 18 booked + 7 open unsold = 25. Dividing 18 by the seven nights still open would produce 257.14%; sold inventory belongs in the denominator throughout the reporting period.
Available Nights and Calendar Utilization
In the hypothetical default month, 30 calendar nights contain three owner-use nights, two maintenance nights, 18 paid guest nights, and seven open unsold nights. Available inventory is 30 − 5 = 25 nights. Occupancy is 18 ÷ 25 × 100 = 72%. Calendar utilization is 18 ÷ 30 × 100 = 60%.
Calendar utilization retains every calendar night in its denominator. Report both ratios with blocked-night counts when reviewing Airbnb income projections. A 72% occupancy assumption applied to 25 available nights produces 18 booked nights; applying it to 30 calendar nights implies 21.6 nights before whole-night rounding.
Closing five additional unsold nights in that example reduces available inventory to 20. The same 18 booked nights then produce 90% occupancy, while calendar utilization stays at 60%. Revenue and guest-night sales remain unchanged. Record closure reasons so a denominator change stays visible in pre-renovation and post-renovation comparisons.
Inventory scope also needs a stable unit. A whole-home listing contributes one property-night per date, regardless of guest count or bedrooms. Two independently rentable units contribute two unit-nights. Duplicate listings for the same physical inventory require deduplication before combining channel records.
Apply the same closure policy to revenue comparisons. At $3,600 lodging revenue and 25 available nights, RevPAN is $144. Closing five unsold nights raises RevPAN to $180 because $3,600 ÷ 20 = $180; revenue per calendar night remains $120. A higher RevPAN following closures can therefore arise entirely from reduced inventory. Report calendar-based revenue alongside available-night revenue when closure counts change.
Cancellations and Paid Occupied Nights
Separate historical paid occupied nights from forward booked nights. Historical paid occupancy uses completed paid guest-night records. Forward booked occupancy uses active reservations for future stay dates at a recorded snapshot time. Future reservations can change, so the two measures describe different stages of the booking cycle.
For the completed-stay worksheet, remove canceled, unoccupied nights from the paid occupied-night numerator. Reopened dates remain available; dates subsequently closed for owner use or repairs enter the documented blocked category. A replacement stay contributes each occupied night once. Record no-shows and retained cancellation receipts separately from completed-stay lodging revenue so the paid occupied-night ADR retains a consistent basis.
Hypothetically, a 30-night fully available month has 20 reserved nights at its booking snapshot. A four-night booking cancels and two of those dates later sell and are occupied. Completed paid nights total 20 − 4 + 2 = 18, yielding 60% historical occupancy. Any retained cancellation payment belongs in a separate revenue reconciliation for this worksheet. A report that treats paid no-shows or cancellation revenue differently needs an explicit alternative definition before comparison.
Preserve both the original snapshot and final stay ledger. Compare next month's forward booked occupancy with the same month at the same lead time in the comparison year. Comparing a future snapshot with a completed month's occupancy mixes booking stages.
ADR and Revenue Denominator Consistency
Use lodging revenue allocated to the same nights as the booked-night numerator. In this worksheet, exclude cleaning fees, taxes, separate cancellation receipts, and pass-through charges; use lodging charges after refunds and discounts and before host service fees. Maintain the same gross or net convention in every period and identify any difference from a platform payout total.
| Metric | Formula | Hypothetical default result |
|---|---|---|
| Available-night occupancy | 18 booked nights ÷ 25 available nights × 100 | 72% |
| Calendar utilization | 18 booked nights ÷ 30 calendar nights × 100 | 60% |
| Average nightly rate or ADR | $3,600 lodging revenue ÷ 18 booked nights | $200 |
| Revenue per available night or RevPAN | $3,600 lodging revenue ÷ 25 available nights | $144 |
| Revenue per calendar night | $3,600 lodging revenue ÷ 30 calendar nights | $120 |
The identity is RevPAN = ADR × available-night occupancy expressed as a decimal: $200 × 0.72 = $144. Revenue per calendar night instead equals ADR × calendar utilization: $200 × 0.60 = $120. Both identities require the same revenue, booked-night count, period, and property inventory.
Hilton's financial reporting defines revenue per available room, or RevPAR, as room revenue divided by available room-nights. For an entire rental home, label the calculator output revenue per available property-night. When comparing a report labeled RevPAR, establish its inventory unit, excluded nights, and revenue basis before comparing its dollar amount with RevPAN.
With zero booked nights, ADR is undefined. With positive availability and zero lodging revenue, revenue per available night is zero. A fully closed period has zero available nights and undefined available-night occupancy; calendar utilization can still be zero. The calculator requires at least one available night, so record a fully closed month separately.
Monthly Seasonality and Weighted Totals
Use monthly booked nights, closures, lodging revenue, and ADR to build a seasonal operating model. The following hypothetical months illustrate different demand and closure assumptions; they represent no specific market or forecast.
| Period | Night counts | Occupancy and utilization | Revenue and ADR |
|---|---|---|---|
| January | 31 calendar; 11 blocked; 20 available; 10 booked | 50% occupancy; 32.26% utilization | $1,500 lodging; $150 ADR; $75 RevPAN |
| July | 31 calendar; 0 blocked; 31 available; 28 booked | 90.32% occupancy; 90.32% utilization | $7,000 lodging; $250 ADR; $225.81 RevPAN |
| Two selected months combined | 62 calendar; 11 blocked; 51 available; 38 booked | 74.51% occupancy; 61.29% utilization | $8,500 lodging; $223.68 ADR; $166.67 RevPAN |
The combined occupancy is 38 ÷ 51 × 100 = 74.51%. The arithmetic average of the displayed monthly occupancies is about 70.16%, which gives the two months equal weight despite their different available inventory. Sum booked nights and available nights before dividing. Use the same method across all 12 months or across properties.
Combined ADR is $8,500 ÷ 38 = $223.68, weighted by booked nights. Combined RevPAN is $8,500 ÷ 51 = $166.67, weighted by available nights. Calculate from unrounded totals and round only displayed results. The two selected months illustrate aggregation; a full-year estimate requires the remaining ten months.
Target Nights and Renovation Comparisons
Target booked nights equal available nights × target occupancy as a decimal, rounded up when the goal is to meet or exceed the rate. With 25 available nights, an 80% target requires 20 booked nights. From 18 booked nights, the additional requirement is two. At a hypothetical $210 target ADR, total target lodging revenue is 20 × $210 = $4,200.
A fractional target requires whole-night capacity. With 25 available nights and a 75% goal, 25 × 0.75 = 18.75, so the minimum is 19 booked nights and the achieved occupancy is 76%. From 18 booked nights, one more night meets the goal. The target-revenue output values those 19 nights at the entered target ADR; it is a scenario total before operating expenses.
The calculator prices all target nights at the target ADR. If the existing 18 nights remain at $3,600 and only the two additional nights sell at $210, the resulting revenue is $4,020 and ADR is $201. Existing reservation rates determine which scenario describes the property.
For a planned bedroom renovation, keep the closure schedule beside the monthly model. Compare pre-work and post-work paid nights, available nights, calendar utilization, ADR, and revenue using matching seasons and booking lead times. Different pricing, availability, and market conditions prevent an occupancy change alone from establishing a renovation's revenue effect.
- Choose the property inventory, stay dates, and historical or forward booking basis.
- Reconcile every calendar night to paid bookings, open unsold inventory, or a documented closure.
- Allocate lodging revenue to the same stay dates and reconcile refunds and cancellation receipts separately.
- Calculate both occupancy denominators, ADR, and revenue per available night.
- Aggregate monthly totals before dividing and retain comparable snapshot dates.
Bottom line
Available-night occupancy measures the share of offered inventory booked; calendar utilization measures paid use across the full calendar. Record both alongside closure reasons and same-basis ADR and RevPAN. Set the next booking target from monthly available inventory, preserve the rates on existing reservations, and use the resulting lodging revenue in an expense-based operating model before committing to a purchase or renovation.
Calculator results are general informational estimates based on the inputs supplied. Property performance and investment outcomes depend on operating costs and market conditions.
