How to Use This Free Hotel KPI Calculator
This calculator computes up to 13 hotel performance metrics from as few as five inputs. Results update automatically as you type — no button press needed. Here is a step-by-step guide to getting the most accurate results.
Step 1 — Choose Period and Currency
Select Daily to calculate KPIs for a single day (today's numbers, a specific date, or a forecast date). Select Monthly to calculate across a multi-day period — the calculator reveals a Days in Period field so you can specify 28, 30, or 31 days. Choose your currency (INR, USD, EUR, or GBP) — all monetary outputs display in the selected currency.
Step 2 — Enter Room Inventory
Enter your Total Rooms Available — this is your sellable inventory, excluding rooms under renovation or permanently out of service. In monthly mode, this is still your nightly room count, not total room-nights. The calculator multiplies rooms × days to get available room-nights automatically.
Enter Rooms Sold / Occupied. In Daily mode this is simply the number of rooms occupied tonight. In Monthly mode, enter total room-nights occupied for the period. Quick formula: average rooms occupied per night × number of days. For example, if an average of 35 rooms were occupied each night over 30 days, enter 1,050.
Step 3 — Enter Revenue and Costs
Enter Room Revenue — total revenue from room sales only, excluding F&B, spa, and other departments. Enter Total Revenue — the sum of all revenue-generating departments combined. Enter Total Operating Costs — all departmental costs plus undistributed overhead (administration, sales, energy, maintenance) before interest, depreciation, and income tax. This aligns with the standard industry definition of Gross Operating Profit (GOP).
Step 4 — Optional Inputs for More KPIs
Enter your Rack Rate (maximum published room rate per night) to unlock the Yield % metric. Enter your Distribution / OTA Costs (commissions paid to OTAs, GDS, and booking platforms) to unlock NRevPAR — the net revenue per available room after distribution expenses.
Step 5 — Benchmark Against Your Market
Expand the Competitive Benchmarking section and enter your market's average occupancy percentage and average ADR — typically sourced from STR reports, HotStats, or your own comp-set tracking. The calculator computes MPI, ARI, and RGI, showing whether you are outperforming, meeting, or lagging your competitive set. An index above 100 means you are capturing more than your fair market share.
All 12 Hotel KPIs Explained — Formulas, Examples & Benchmarks
Each metric below is calculated by this tool. Understanding what each KPI measures — and its limitations — is as important as knowing the formula.
OCC % = (Rooms Sold ÷ Available Room Nights) × 100
Occupancy rate is the most fundamental hotel metric — what percentage of your available inventory did you actually sell? It answers the demand side of the performance equation. High occupancy alone does not indicate success; you must evaluate it alongside ADR to understand true RevPAR performance.
Example
50 rooms available, 35 sold: OCC = (35 ÷ 50) × 100 = 70%
Luxury Resort: 65–80%
City Hotel: 70–85%
Budget: 75–90%
ADR = Total Room Revenue ÷ Number of Rooms Sold
ADR measures the average rate guests actually paid for occupied rooms, excluding complimentary and house-use rooms. It reflects your pricing power and the quality of your revenue mix. Rising ADR can signal improved market positioning, a shift toward direct bookings, or successful upselling. Falling ADR often indicates over-discounting or an increasing share of low-rate OTA bookings.
Example
₹1,75,000 room revenue ÷ 35 rooms sold: ADR = ₹5,000
RevPAR = Room Revenue ÷ Total Available Rooms [= ADR × OCC%]
RevPAR is the industry's primary performance benchmark because it combines both pricing and occupancy into one number. A hotel with a ₹10,000 ADR at 50% occupancy (RevPAR ₹5,000) underperforms one with ₹7,000 ADR at 80% occupancy (RevPAR ₹5,600). RevPAR growth comes from three levers: raise ADR, raise occupancy, or both. The right lever depends on where you sit in the demand cycle.
Example
₹1,75,000 revenue ÷ 50 rooms: RevPAR = ₹3,500 | Also: ₹5,000 ADR × 70% OCC = ₹3,500 ✓
TRevPAR = Total Revenue (all departments) ÷ Total Available Rooms
TRevPAR expands RevPAR to include every revenue stream: rooms, food & beverage, spa, minibar, laundry, activities, and any other operated department. For full-service resorts where non-room revenue often represents 30–50% of total revenue, TRevPAR is a more complete picture of how well each available room is monetised. If RevPAR grows while TRevPAR stagnates, your ancillary revenue departments may be underperforming or you may be attracting guests who do not use on-site facilities.
Example
₹2,30,000 total revenue ÷ 50 rooms: TRevPAR = ₹4,600 (vs RevPAR of ₹3,500 — ₹1,100 from non-room revenue)
GOP = Total Revenue − Total Operating Costs
GOP is the absolute profit remaining after all operational expenses — departmental costs and undistributed overhead — before fixed charges (rent, management fees, interest, depreciation, and income tax). It is the most commonly tracked profit line in hotel P&Ls and the base for GOPPAR. A negative GOP means the property is cash-flow negative at the operating level, which is a critical warning signal.
Example
₹2,30,000 revenue − ₹1,50,000 costs: GOP = ₹80,000
GOPPAR = Gross Operating Profit ÷ Total Available Room Nights
GOPPAR is the metric that owners and investors care about most. Two hotels can have identical RevPAR but very different profitability if one has significantly higher operating costs. GOPPAR contextualises revenue with costs — it tells you how much profit each room in your inventory is generating, whether occupied or not. A growing RevPAR alongside a declining GOPPAR signals cost control problems that need immediate attention.
Example
₹80,000 GOP ÷ 50 rooms: GOPPAR = ₹1,600
Strong: GOP% > 35%
Average: GOP% 25–35%
GOP % = (GOP ÷ Total Revenue) × 100
GOP % (Gross Operating Margin) shows what percentage of every revenue rupee/dollar is retained as operating profit. It is the most concise measure of operational efficiency. A 34% GOP margin means ₹34 of every ₹100 in revenue becomes profit before fixed charges. Compare this across months and years — a shrinking margin during growing revenue indicates rising costs are outpacing revenue growth.
Example
₹80,000 ÷ ₹2,30,000 × 100: GOP % = 34.8%
CPOR = Total Operating Costs ÷ Rooms Sold
CPOR measures how much it costs to service each occupied room. It encompasses all operating expenses — housekeeping labour, laundry, amenities, room supplies, front desk, utilities, and a share of overhead — divided by the number of rooms sold. A CPOR close to or exceeding your ADR indicates operational distress. Comparing CPOR against ADR gives you the operating cost recovery ratio: what percentage of rate revenue is consumed by costs.
Example
₹1,50,000 costs ÷ 35 rooms: CPOR = ₹4,286 (vs ADR of ₹5,000 — ₹714 operating margin per room)
Yield % = (RevPAR ÷ Rack Rate) × 100
Yield % measures how close you are to theoretically perfect revenue — what percentage of your maximum possible revenue (all rooms sold at full rack rate every night) you actually achieved. A 100% yield is impossible in practice; a yield of 55–70% is considered strong for full-service hotels. Low yield indicates excessive discounting, low occupancy, or both. Enter your rack rate in the optional inputs to unlock this metric.
Example
RevPAR ₹3,500 ÷ Rack ₹8,000 × 100: Yield = 43.8%
NRevPAR = (Room Revenue − Distribution Costs) ÷ Available Rooms
NRevPAR deducts distribution costs (OTA commissions, GDS fees, booking platform charges) from room revenue before dividing by available rooms. It answers: after paying for the channel that brought the guest, how much room revenue do you actually keep per available room? Direct bookings have zero distribution cost, making NRevPAR higher than RevPAR for direct channels. Heavy OTA dependency compresses NRevPAR significantly. Enter your OTA/distribution costs in the optional inputs to unlock this metric.
Example
(₹1,75,000 − ₹14,000) ÷ 50 rooms: NRevPAR = ₹3,220 vs RevPAR of ₹3,500 — ₹280 distribution drag per room
MPI = (Your OCC% ÷ Market OCC%) × 100 | ARI = (Your ADR ÷ Market ADR) × 100 | RGI = (Your RevPAR ÷ Market RevPAR) × 100
These three indices (commonly called the STR indices) compare your property's performance against your competitive set. An index of 100 means you are performing exactly at market average — capturing your fair share. Above 100 means you are outperforming the market; below 100 means you are underperforming. RGI is the most important of the three — it is the RevPAR equivalent of the overall competitive scorecard.
MPI measures occupancy share. A high MPI with a low ARI means you are filling rooms by discounting. ARI measures rate premium. High ARI with low MPI means you are priced above the market but not filling rooms. RGI combines both — a high RGI with balanced MPI and ARI is the ideal outcome. Enter market comp-set data in the Competitive Benchmarking section above to unlock these metrics.
Example
Your OCC 70% vs Market 62%: MPI = 112.9 (above fair share) | Your ADR ₹5,000 vs Market ₹4,200: ARI = 119.0 | Your RevPAR ₹3,500 vs Market ₹2,604: RGI = 134.4