ADR Calculator
Calculate average daily rate from room revenue and occupied room nights.
Average room revenue per occupied room night, excluding non-room revenue.
Continue in the full model.
Move from this screening result to the complete Hotel Acquisition Model.
Get the model · €69 incl. VATHow the ADR calculation works
ADR = room revenue ÷ rooms sold.
Example calculation
€4.6m of room revenue across 25,550 occupied room nights equals about €180 ADR.
How professionals use the result
Use ADR to track achieved room pricing. Keep taxes, resort fees and complimentary rooms consistent.
Common mistakes
- Dividing by available rather than sold rooms
- Including non-room revenue
- Mixing net and gross rates
- Ignoring complimentary rooms
ADR Calculator FAQs
What does the ADR calculator measure?
Calculate average daily rate from room revenue and occupied room nights.
What formula does the ADR calculator use?
ADR = room revenue ÷ rooms sold.
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 ADR to track achieved room pricing. Keep taxes, resort fees and complimentary rooms consistent.
Which mistakes are most common?
Dividing by available rather than sold rooms; Including non-room revenue; Mixing net and gross rates; Ignoring complimentary rooms.