The hotel RevPAR, ADR and occupancy calculator gives the available room-nights, the occupancy rate, the average daily rate, the RevPAR, the break-even occupancy and the revenue generation index against the market.
How the calculation works
- Enter the number of rooms, the days in the period and the room-nights sold.
- Enter the room revenue of the period, and the operating cost per available room-night.
- Enter the market RevPAR of your competitive set to get the index.
Example
A hotel with 120 rooms over 30 days has 3,600 available room-nights. With 2520 room-nights and a revenue of 289800 $, the occupancy is 70.0 %, the ADR 115.00 $ and the RevPAR 80.50 $. The break-even occupancy is 47.8 %, and the index against the market RevPAR of 85 $ is 94.7.
Why it matters
The calculator helps hotel owners and managers, revenue analysts, small guesthouse operators and hospitality students who need to monitor the monthly performance, to compare it with competitors and to check whether the pricing and the occupancy cover the cost of operating the rooms.
Good to know
Use the room revenue only, without taxes, breakfast or other departments, and count the rooms that are available for sale, excluding rooms out of order if your market reports do so. Use the same period for the sold nights, the revenue and the days. The break-even occupancy is a simplification, since the costs of a hotel include fixed and variable parts. The market RevPAR should come from a comparable set of hotels and the same period. Seasonality is strong, so compare the same months across the years.
Related tools
The break-even occupancy calculator goes deeper on the cost side, the vacancy rate calculator covers rental properties, the short-term rental calculator estimates the income of a vacation rental and the restaurant revenue per seat calculator offers a similar measure for dining.