Calculator
Example data table
Sample numbers show how RevPAR changes with occupancy and pricing.
| Period | Rooms Available | Rooms Sold | Room Revenue | Occupancy | ADR | RevPAR |
|---|---|---|---|---|---|---|
| Daily | 120 | 84 | 945,000 | 70.00% | 11,250.00 | 7,875.00 |
| Daily | 120 | 96 | 1,152,000 | 80.00% | 12,000.00 | 9,600.00 |
| Daily | 120 | 72 | 936,000 | 60.00% | 13,000.00 | 7,800.00 |
Formula used
- RevPAR (Direct) = Room Revenue ÷ Rooms Available
- Occupancy Rate = Rooms Sold ÷ Rooms Available
- ADR = Room Revenue ÷ Rooms Sold
- RevPAR (ADR × Occupancy) = ADR × Occupancy Rate
- TRevPAR (Optional) = Total Revenue ÷ Rooms Available
- GOPPAR (Optional) = GOP ÷ Rooms Available
How to use this calculator
- Choose your period label and currency.
- Enter rooms available for the chosen period.
- Enter rooms sold and room revenue for the same period.
- Select a method: direct RevPAR or ADR × occupancy.
- Use overrides only when you trust external values more.
- Press Calculate to view results above this form.
- Download CSV or PDF for sharing and reporting.
FAQs
1) What does RevPAR measure?
RevPAR measures room revenue earned per available room. It blends pricing and occupancy, making it useful for tracking overall room performance across days, weeks, or months.
2) Which RevPAR formula should I use?
Use direct RevPAR when you have room revenue and rooms available. Use ADR × occupancy when ADR and occupancy are sourced reliably, such as from a PMS dashboard.
3) Why is my ADR blank?
ADR requires rooms sold and room revenue. If rooms sold is zero or missing, ADR cannot be computed. Add rooms sold or provide an ADR override.
4) Can rooms sold exceed rooms available?
No. This usually means the inputs are from different dates, include complimentary rooms inconsistently, or rooms available excludes out-of-order inventory. Align period definitions before recalculating.
5) What is TRevPAR and when is it useful?
TRevPAR includes all revenue streams, not only rooms. It helps evaluate broader hotel monetization across restaurants, events, and other services, using the same rooms available base.
6) What is GOPPAR and why add it?
GOPPAR divides gross operating profit by rooms available. It connects revenue quality to operating efficiency and can help compare profitability across periods or between properties.
7) How do overrides affect results?
Overrides replace computed ADR or occupancy. Use them only when you are sure they are correct for the same period and inventory definition, otherwise they can mislead trend analysis.
8) Why do the two RevPAR methods differ?
Differences happen when inputs are inconsistent. For example, revenue might include taxes or fees, or occupancy might be calculated from a different room base. Clean, aligned inputs make both methods match closely.