Hotel Occupancy Calculator
Calculate occupied rooms as a percentage of available room nights.
Calculated directly from the assumptions shown.
Continue in the full model.
Move from this screening result to the complete Hotel Acquisition Model.
Get the model · €69 incl. VATHow the Hotel Occupancy calculation works
Occupancy = occupied room nights ÷ available room nights.
Example calculation
25,550 rooms sold out of 36,500 available room nights equals 70% occupancy.
How professionals use the result
Use occupancy with ADR and RevPAR. Adjust available rooms for rooms genuinely out of service.
Common mistakes
- Using total keys rather than room nights
- Ignoring closure periods
- Counting complimentary rooms inconsistently
- Comparing different availability definitions
Hotel Occupancy Calculator FAQs
What does the Hotel Occupancy calculator measure?
Calculate occupied rooms as a percentage of available room nights.
What formula does the Hotel Occupancy calculator use?
Occupancy = occupied room nights ÷ available room nights.
Is the result suitable for a final investment decision?
Use it as a transparent screening calculation. Validate deal-specific tax, timing, financing and legal assumptions in a complete underwriting model before making a decision.
Do I need an account?
No. The calculator is free and runs in your browser. FormulaPlanet does not store your projects, inputs or results.
Is any input sent publicly?
No calculation is public by default. A shareable link is only created when you explicitly choose to copy one; that link contains the assumptions shown in its URL.
Why might my spreadsheet give a different answer?
Differences usually come from timing, compounding, sign conventions, fees or a different definition of the numerator or denominator. Match every period and definition before comparing.
What should I review alongside this result?
Use occupancy with ADR and RevPAR. Adjust available rooms for rooms genuinely out of service.
Which mistakes are most common?
Using total keys rather than room nights; Ignoring closure periods; Counting complimentary rooms inconsistently; Comparing different availability definitions.