Hotel Occupancy, ADR and RevPAR Calculator
Enter your rooms, the number of nights in the period, room nights sold and room revenue. You get occupancy, ADR and RevPAR, each with its formula, for a hotel, riad or guesthouse.
Enter your numbers to see the result.
How to use this tool
- Enter your number of rooms and the number of nights in the period.
- Enter room nights sold and room revenue for the same period.
- Subtract room nights out of order if some rooms could not be sold.
Understanding the results
Occupancy says how full you were, ADR what each sold room night earned, and RevPAR combines both into revenue per room night you could have sold. Raising prices can raise ADR and lower occupancy; RevPAR shows whether the trade was worth it.
Formulas and method
Worked example
A 20-room riad over 30 nights sells 450 room nights for 40,500.
- Available = 600 room nights; occupancy = 75%.
- ADR = 90; RevPAR = 40,500 ÷ 600 = 67.50.
Limitations
- These are room revenue indicators, not full hotel financial reporting: food, drinks, other services and costs are outside them.
- Some hotels exclude complimentary or owner-use nights from rooms sold; be consistent across periods.
Frequently asked questions
What is a good RevPAR?
Compare it with your own past periods and with hotels like yours in the same area and season. A single number means little without that context.
Should taxes be in room revenue?
No. Use room revenue without tourist taxes or VAT, so ADR and RevPAR reflect what you earn.