How to calculate RevPAR? Hotel occupancy rate, ADR and RevPAR formulas

How to calculate RevPAR? Occupancy rate, ADR and RevPAR formulas with a small hotel example, which indicator to use for which decision, and common mistakes.

FUFerhat UğurluYazSis TeamPublished: November 17, 20268 min read
In short

RevPAR is calculated by dividing a hotel’s total room revenue in a period by the number of rooms available for sale in the same period; the same result also comes from multiplying occupancy rate by ADR. Occupancy rate is the ratio of rooms sold to rooms available, and ADR is room revenue divided by rooms sold. Read together, the three indicators support more balanced pricing and occupancy decisions.

A hotel owner is comparing two months. In July nearly all the rooms were full but the till did not fill as much as expected; in August fewer rooms were sold but revenue looks better. Which month was more successful? Occupancy alone does not answer, because it ignores the price; average price alone does not answer, because it does not say how many rooms stayed empty. That is why in hospitality three indicators are read together: occupancy rate, ADR and RevPAR.

RevPAR (Revenue Per Available Room) is the revenue per room available for sale, found by dividing a hotel’s total room revenue in a period by the number of rooms available for sale in the same period. In this article we calculate the formulas of the three indicators step by step on a hypothetical hotel, and list which one to look at for which decision and the common mistakes.

How is occupancy rate calculated?

Occupancy rate is found by dividing the number of room nights sold by the number of room nights available for sale and converting the result to a percentage. The room nights available for sale are the number of rooms multiplied by the number of days. For example, in a 40-room hotel, in a 30-day month the room nights available for sale are 40 × 30 = 1,200. If 900 room nights were sold this month, occupancy is 900 ÷ 1,200 = 0.75, that is, 75 percent.

What is ADR and how is it calculated?

ADR (Average Daily Rate) is found by dividing room revenue by the number of room nights sold. The formula is room revenue ÷ room nights sold. What matters is that the denominator is sold rooms; empty rooms do not affect ADR. If the example hotel’s room revenue this month is 1,350,000, ADR is 1,350,000 ÷ 900 = 1,500.

How is RevPAR calculated? Two ways, the same result

You can find RevPAR in two ways: divide total room revenue by the number of room nights available for sale, or multiply the occupancy rate by ADR. For the same hypothetical hotel, the two ways give the same result.

IndicatorFormulaSample calculationResult
Occupancy rateRoom nights sold ÷ room nights available900 ÷ 1,2000.75 (75 percent)
ADRRoom revenue ÷ room nights sold1,350,000 ÷ 9001,500
RevPAR (way 1)Room revenue ÷ room nights available1,350,000 ÷ 1,2001,125
RevPAR (way 2)Occupancy × ADR0.75 × 1,5001,125

Comparing two hotels: why look at RevPAR?

Hypothetical hotel A runs at 80 percent occupancy and an ADR of 1,000; hotel B at 60 percent occupancy and an ADR of 1,500. Someone looking at occupancy finds A successful, someone looking at price finds B successful. RevPAR comes out at 0.80 × 1,000 = 800 for A and 0.60 × 1,500 = 900 for B. For every room available for sale, B produces more revenue. Still, RevPAR does not show cost: if the cleaning, staff and energy cost per occupied room differs, the profitability ranking can change. That is why RevPAR is a compass that shows direction, not a profit statement.

Why should weekdays and weekends be read separately?

A single monthly RevPAR hides the differences within the same month. In a hypothetical hotel, if weekday occupancy is 60 percent and ADR is 1,100, weekday RevPAR is 660; if weekend occupancy is 95 percent and ADR is 1,800, weekend RevPAR is 1,710. The monthly average falls somewhere between the two and does not tell you that the rooms left empty on weekdays are the real problem. The shorter the periods and the narrower the segments for which the indicator is calculated, the more accurate the decision: look by day, weekend, season, room type and sales channel.

Which indicator to look at for which decision?

DecisionIndicator to look at firstWhy
Raising pricesADR and occupancy togetherIf occupancy falls as the price rises, you need to check whether RevPAR is going up.
Running a promotionOccupancy and RevPARRevPAR shows whether the rise in occupancy makes up for the price cut.
Comparing two periodsRevPARIt combines occupancy and price in one figure.
Evaluating channelsADR by channelChannels that bring the same occupancy can have different average prices.
Comparing with last yearRevPAR with the same definitionsIf the definition of available rooms changes from year to year, the comparison breaks.

Common mistakes in the calculation

  • Averaging daily occupancy percentages: period occupancy is found by dividing total room nights sold by total room nights available for sale.
  • Using total revenue instead of room revenue: revenue such as restaurant and spa does not go into ADR and RevPAR.
  • Counting out-of-service rooms one month and not the next: whichever you choose, use it consistently.
  • Not deciding how to count complimentary or comped rooms.
  • Mixing amounts with and without tax: choose a single method for revenue.
  • Posting cancellation and no-show revenue to the wrong period.

What are the limits of these three indicators?

None of them gives the full picture on its own. An ADR calculated before channel commission is deducted shows net earnings higher than they are. In packages such as half board, whether the meal price is included in room revenue directly affects ADR. When the room type mix changes, for example when more suites are sold, ADR goes up, but you cannot see whether this is a price rise or a shift in the product mix. So write the definitions down once, use the same method in every period and note any changes.

Tracking occupancy, ADR and RevPAR in Excel

A daily sheet is enough: the date, rooms available for sale, rooms sold and room revenue columns are inputs, and the occupancy, ADR and RevPAR columns are formulas. At month end, take the column totals and recalculate the percentages from the totals. This setup works well in a small hotel where data is entered regularly from one place. Trouble starts when the number of rooms sold is carried by hand from one source and revenue from another, and when a breakdown by channel is wanted: a day is skipped, a cancellation is not deducted and the figures do not match. At that point it becomes hard to trust the numbers in the sheet.

ColumnWhat is enteredFormula
A: DateThe date of the dayEntered by hand
B: Rooms availableThe number of rooms that can be sold that dayEntered by hand (according to your out-of-service decision)
C: Rooms soldThe number of rooms occupied that nightBy hand or taken from the system
D: Room revenueAccommodation revenue onlyBy hand or taken from the system
E: OccupancyThe share of rooms sold=C÷B
F: ADRRevenue per room sold=D÷C
Month total: RevPARTotal room revenue ÷ total rooms available=total of D ÷ total of B
  1. At month end, take the totals of columns B, C and D; do not average the daily percentages.
  2. Recalculate occupancy, ADR and RevPAR from these totals.
  3. Compare the number of rooms sold in the reservation record with the total in the sheet; if there is a difference, find it day by day.
  4. Do the same calculation for the same month last year and make sure the definitions have stayed the same.

How does YazSis hotel management support these indicators?

In the Reservation & Hotel Management platform, the reservation, room assignment, stay transactions and folio sit in the same record; occupancy, average rate, revenue, channel and operations indicators can be compared. Reports cover payment, balance, revenue and occupancy indicators. RevPAR is a result calculated from these indicators; we do not claim that there is a separate RevPAR screen in the platform, but having the required inputs come reliably from a single source makes the calculation easier. Which indicator to look at for which decision is for you to decide as the management team; the system’s job is to keep the numbers that will support that decision consistent and up to date.

If you want to measure where the reservation is taken, without moving reporting to Excel, you can request a demo on the hotel management page.

Frequently asked questions

Are ADR and average room price the same thing?

ADR is room revenue divided by the number of room nights sold. In some reports “average price” may be defined differently; make sure the denominator is sold rooms.

If RevPAR is high, is the hotel profitable?

Not necessarily. RevPAR is a revenue indicator; it does not include cost. If the cleaning, staff and energy cost per occupied room differs, the profitability ranking can change.

What occupancy percentage counts as good?

There is no universal threshold; it varies with the type of property, the location and the season. We do not give a number; compare with your own past periods and with similar properties using the same definitions.

Are out-of-service rooms included in the rooms available for sale?

This is a matter of definition and varies by business. Whichever you choose, use it consistently; otherwise periods cannot be compared.

Does a hotel management system calculate RevPAR?

The YazSis hotel platform reports occupancy, average rate and revenue indicators; RevPAR is a result calculated from these indicators.

FU
Ferhat Uğurlu · YazSis Team

Builds enterprise software, AI and digital transformation products together with the YazSis team.