RevPAN vs RevPAR vs ADR: Define the Denominator Before You Compare

TL;DR

ADR, occupancy, and RevPAR are hotel metrics. The NCHMCT revenue management text defines each one using a specific denominator. RevPAN is an operator-created label. It uses a locally declared revenue numerator and available-night denominator. It matches RevPAR only when both inputs match.

If RevPAN and RevPAR share both inputs, they produce the same number. That is arithmetic identity, not a new metric. Naming your own metric lets you control what counts as "available." Declare that policy before you compare properties or periods.

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.

Why the Denominator Changes the Answer in 2026

Suppose a listing earns $1,400 in one calendar month. The month has 30 nights.

• If you count all 30 nights as available, revenue per available night equals $1,400 divided by 30, which is $46.67.
• If you block 5 nights for owner use and count only 25 available nights, revenue per available night equals $1,400 divided by 25, which is $56.00.

Same revenue. Same listing. Two different denominators produce two different results. Neither answer is wrong on its own. Both answers are wrong if you mix the policies mid-comparison.

Key Facts

ADR: Revenue per Night Sold

ADR stands for average daily rate. On printed page 8, the NCHMCT revenue management text defines it as total room revenue divided by rooms sold. In this article's local mapping, "rooms sold" becomes "nights booked." The formula is:

ADR = Listing revenue / Nights booked

ADR is defined only when nights booked is greater than zero. With nights booked above zero, zero listing revenue makes ADR zero. A negative selected revenue numerator is mathematically defined. Exclude that result from cross-period comparison until the operator declares its source relationship and status. Mark it embedded, separate, excluded, or unknown. Unknown revenue produces no ADR value. Zero booked nights makes ADR undefined, and a negative booked-night count is infeasible. Do not emit ADR in either denominator case.

Occupancy: Nights Sold as a Share of Nights Available

On printed page 7, the NCHMCT revenue management text gives occupancy as rooms sold divided by total rooms available. This article maps that formula to nights booked divided by nights available. The result is a ratio between zero and one. It is often shown as a percentage.

Occupancy = Nights booked / Nights available

With positive available nights, zero booked nights produces zero occupancy. Zero available nights makes occupancy undefined. Negative booked or available nights, or booked nights greater than available nights, are infeasible and produce no occupancy value.

RevPAR: Revenue per Available Night, Hotel Convention

On printed page 8, the NCHMCT revenue management text gives two RevPAR formulas. They are occupancy rate times ADR or total room revenue divided by total rooms available. The direct formula requires more than zero rooms available. Negative room counts are infeasible. Zero rooms available makes RevPAR undefined.

RevPAR = Room revenue / Rooms available
RevPAR = ADR x Occupancy (algebraically equivalent)

With rooms available above zero, zero room revenue makes direct RevPAR zero. A negative selected revenue numerator is mathematically defined. Exclude that result from cross-period comparison until the operator declares its source relationship and status. Mark it embedded, separate, excluded, or unknown. Unknown revenue produces no direct RevPAR value.

The ADR multiplied by occupancy identity requires more than zero rooms sold and rooms available. Otherwise, ADR is undefined. With zero rooms sold and positive rooms available, direct RevPAR remains defined. The product form cannot be used because ADR is undefined. These are hotel room metrics. Mapping them to Airbnb listing-nights is an article-defined adaptation. Neither NCHMCT nor Airbnb mandates this mapping for short-term rentals.

RevPAN: An Operator-Created Listing-Night Metric

No inspected source defines RevPAN as a universal standard. RevPAN is an operator-created label for revenue per available night at the listing level. Its formula mirrors RevPAR exactly:

RevPAN = Listing revenue / Operator-declared available nights

With operator-declared available nights above zero, zero selected listing revenue makes RevPAN zero. A negative selected revenue numerator is mathematically defined. Exclude that result from cross-period comparison until the operator declares its source relationship and status. Mark it embedded, separate, excluded, or unknown. Unknown revenue or an unknown denominator produces no RevPAN value. Zero available nights remains undefined.

Because the formula is identical to RevPAR, RevPAN and RevPAR produce the same number whenever their numerators and denominators match. The label "RevPAN" signals that the operator has defined the denominator locally rather than inheriting a hotel convention.

Map Hotel Room-Night Terms to Airbnb Listing-Nights

What "rooms sold" becomes for a listing

In this article's local mapping, "rooms sold" becomes nights booked for one listing. The Airbnb earnings report guide lists nights booked as a report performance statistic.

What "rooms available" becomes for a listing

For this article's local mapping, the operator declares which listing-nights count as available. The required Airbnb earnings report guide does not provide an available-night formula. Derive the input from the operator's actual calendar evidence and a documented denominator policy.

Choose an Airbnb Revenue Scope and Blocked-Night Policy

Revenue numerator options

The Airbnb earnings report guide lists gross earnings and earnings by listing. Select one source-labeled numerator from the operator's actual record. Classify its relationship to fees and other fields as embedded, separate, excluded, or unknown. Do not calculate while any relationship material to the numerator remains unknown.

Blocked-night denominator options

Do not infer availability from an unexplained calendar gap. Use actual calendar evidence and declare how each owner block or maintenance hold is treated before excluding any night. Two local worksheet policies are:

• All-calendar policy: Count every night in the period as available. Owner blocks reduce your RevPAN because they sit in the denominator without contributing revenue.
• Guest-available policy: Count only nights you opened to guests. Owner blocks are excluded from the denominator. With positive revenue and a smaller positive denominator, RevPAN rises, but the metric no longer reflects the full calendar period.

Neither policy is universally mandated. Pick one, document it, and apply it to every listing and period in the same comparison.

Worked Hypothetical: One Listing, October 2026

Hypothetical. Period: October 2026, 31 calendar nights. Units: US dollars and nights. All figures are illustrative.

Inputs:

• Gross listing revenue: $2,080
• Nights booked: 18
• Owner blocks: 4 nights
• Calendar nights: 31

ADR:

ADR = $2,080 / 18 = $115.56 (rounded to the nearest cent)

Occupancy under all-calendar policy:

Occupancy = 18 / 31 = 0.5806 (rounded to four decimal places)

RevPAN under all-calendar policy (31 available nights):

RevPAN = $2,080 / 31 = $67.10 (rounded to the nearest cent)

RevPAN via ADR x Occupancy (all-calendar):

$115.56 x 0.5806 = $67.094136, which rounds to $67.09

The rounded product is one cent below the $67.10 direct result. ADR and occupancy were each rounded before multiplication. Using unrounded inputs, $2,080 / 18 x 18 / 31 returns exactly $2,080 / 31 = $67.096.... That rounds to $67.10. The discrepancy is a rounding artifact, not an error in either formula.

RevPAN under guest-available policy (27 available nights, excluding 4 owner blocks):

RevPAN = $2,080 / 27 = $77.04 (rounded to the nearest cent)

The two RevPAN figures, $67.10 and $77.04, describe the same listing and month. The denominator policy creates the difference. Do not compare listings that use different policies.

Comparison and Reconciliation: RevPAN, RevPAR, and ADR in One Table

When RevPAN and RevPAR share the same numerator and denominator, their values are arithmetically identical. The label difference signals who defined the denominator, not a difference in the underlying math.

Metric Misuse and Stop Rules

When to stop and recheck your inputs

Stop before comparing two properties if they use different denominator policies. Reconcile to one policy first, then recalculate both figures.

Stop before comparing two periods if the available-night count changed for reasons other than calendar length, such as a policy switch mid-year. A policy change mid-period makes the two figures incomparable without adjustment.

Stop before treating RevPAN as a profitability measure. Its denominator does not measure costs, and whether any fee is embedded in the selected numerator depends on the operator's actual source record and field classification. For a broader planning view, see the Airbnb profit margin guide.

When RevPAN is not the right tool

RevPAN does not capture cost structure, fee splits, or net income. It also does not capture demand signals, pricing quality, or listing visibility. Use it as one input in a wider planning worksheet, not as a standalone performance verdict.

FAQ

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