ADR & Hotel KPI Calculator
Performance Metrics
What Is an ADR & Hotel KPI Calculator?
An ADR & Hotel KPI Calculator is a hotel revenue tool that calculates Average Daily Rate, Revenue Per Available Room, and occupancy rate from three inputs: total room revenue, paid rooms sold, and total available rooms. It helps hotel teams understand how much revenue they earned per sold room and per available room.
An ADR calculator answers a simple question: how much room revenue did the hotel earn for each paid room sold? This calculator divides total room revenue by paid rooms sold, then also shows RevPAR and occupancy rate so you can view rate, inventory use, and room revenue performance together.
This tool is most useful for hotel managers, revenue managers, property owners, investors, and hospitality students. The result is an estimate based on the values entered. It does not pull data from a property management system, apply taxes, or separate revenue sources automatically.
How the ADR Calculator Formula Works
The calculator uses three direct hotel KPI formulas. It first calculates Average Daily Rate by dividing total room revenue by the number of paid rooms sold. It then calculates RevPAR by dividing total room revenue by total available rooms. Finally, it calculates occupancy rate by dividing paid rooms sold by total available rooms and multiplying by 100.
- Total Room Revenue is the dollar amount entered for room revenue.
- Rooms Sold is the number of paid rooms sold.
- Total Available Rooms is the room inventory entered for the period.
- ADR shows room revenue per paid room sold.
- RevPAR shows room revenue per available room.
- Occupancy Rate shows rooms sold as a percentage of available rooms.
For example, enter $15,000 in total room revenue, 85 paid rooms sold, and 100 total available rooms. The calculator divides $15,000 by 85 for ADR, which equals $176.47. It divides $15,000 by 100 for RevPAR, which equals $150.00. It divides 85 by 100 and multiplies by 100 for an occupancy rate of 85.00%.
The calculator formats ADR and RevPAR as U.S. dollar amounts with two decimal places and commas for large values. Occupancy rate is shown with two decimal places and a percent sign. If rooms sold is zero, ADR displays as $0.00. If total available rooms is zero, RevPAR and occupancy rate display as zero instead of an error.
How to Use the ADR & Hotel KPI Calculator: Step by Step
- Enter your Total Room Revenue ($). Use room revenue only, not food, beverage, spa, parking, or other extra revenue.
- Enter the Number of Rooms Sold (Paid). This should be the count of paid rooms sold for the period.
- Enter Total Available Rooms (Inventory). This is the room inventory you want to use for the RevPAR and occupancy calculation.
- Select Calculate KPIs. The calculator will show Average Daily Rate, Revenue Per Available Room, and Occupancy Rate.
- Use Reset to clear the three input fields and hide the results.
The main result is Average Daily Rate, or ADR. This shows the average room revenue earned per paid room sold. RevPAR gives a broader room revenue view because it uses total room inventory. Occupancy rate shows how much of the entered inventory was sold.
What Your Hotel KPI Results Mean
The three results work together. ADR shows pricing strength for sold rooms. RevPAR connects revenue to available inventory. Occupancy rate shows how much of the available room supply was sold. Looking at all three can give a clearer view than looking at one number alone.
Average Daily Rate
ADR tells you the average room revenue collected for each paid room sold. A higher ADR means the entered room revenue was spread across fewer or higher-priced sold rooms. A lower ADR means the average paid room rate was lower for the values entered.
Revenue Per Available Room
RevPAR uses total available rooms instead of only sold rooms. This makes it useful when you want to connect room revenue with inventory. Two hotels can have the same ADR but different RevPAR values if one has a higher or lower occupancy rate.
Occupancy Rate
Occupancy rate shows the percentage of total available rooms that were sold. The calculator does not block results above 100%. If you enter more rooms sold than total available rooms, the occupancy rate can exceed 100% based on the numbers provided.
| Metric | What It Uses | What It Shows |
|---|---|---|
| ADR | Total room revenue and paid rooms sold | Average revenue per paid room sold |
| RevPAR | Total room revenue and total available rooms | Room revenue per available room |
| Occupancy Rate | Paid rooms sold and total available rooms | Percentage of inventory sold |
This calculator depends on clean input data. Total room revenue should exclude ancillary revenue, such as restaurant, bar, spa, parking, and resort fees if those are not room revenue. Rooms sold should reflect paid rooms. If complimentary rooms are included, ADR may not reflect paid room performance accurately.
The results are estimates for analysis and planning. Real hotel reporting may vary based on accounting rules, property management system setup, canceled bookings, no-shows, comps, out-of-order rooms, taxes, service fees, and how your business defines room revenue.
Frequently Asked Questions
What is an ADR calculator?
An ADR calculator is a tool that estimates Average Daily Rate by dividing total room revenue by paid rooms sold. This calculator also shows RevPAR and occupancy rate when you enter total available rooms, giving a broader view of hotel room revenue performance.
How do I calculate ADR for a hotel?
To calculate ADR, divide total room revenue by the number of paid rooms sold. For example, if room revenue is $15,000 and paid rooms sold is 85, ADR is $176.47. This calculator performs that division and formats the result as a dollar amount.
What is the difference between ADR and RevPAR?
ADR uses only paid rooms sold, while RevPAR uses total available rooms. ADR shows the average revenue earned per sold room. RevPAR shows revenue spread across all available inventory, so it reflects both room revenue and how much inventory was used.
Why does the calculator ask for total available rooms?
The calculator asks for total available rooms because that value is needed for RevPAR and occupancy rate. ADR only needs room revenue and paid rooms sold. RevPAR divides room revenue by available rooms, while occupancy divides paid rooms sold by available rooms.
Does this ADR calculator include food and beverage revenue?
No, this ADR calculator is designed for room revenue. The input label asks for Total Room Revenue, and the on-page note says to exclude ancillary revenue such as food and beverage, spa, or parking. Including those amounts would change the ADR result.
How accurate is the ADR calculator?
The calculator is accurate based on the numbers you enter and the formulas shown on the page. The result depends on clean data. If revenue includes non-room sales, or rooms sold includes complimentary rooms, the output may not match your official hotel reports.
Can occupancy rate be over 100%?
Yes, this calculator can show occupancy over 100% if rooms sold is greater than total available rooms. It does not block that result. The calculator simply divides rooms sold by total available rooms and multiplies by 100 based on the values entered.