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.

For example 30 for a month, 365 for a year.

Optional: rooms closed for repairs, counted in room nights.

Rooms only, excluding food, drinks, other services and taxes.

Enter your numbers to see the result.

How to use this tool

  1. Enter your number of rooms and the number of nights in the period.
  2. Enter room nights sold and room revenue for the same period.
  3. 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

Available room nights = Rooms × Nights − Out-of-order room nights Occupancy rate = Room nights sold ÷ Available room nights × 100 ADR = Room revenue ÷ Room nights sold RevPAR = Room revenue ÷ Available room nights = ADR × Occupancy

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.