Hotel Occupancy, ADR and RevPAR Calculator

This hotel KPI calculator gives the three numbers every hotel manager watches. Enter rooms available, rooms sold and room revenue to get occupancy, ADR and RevPAR, plus TRevPAR and GOPPAR if you add total revenue and gross operating profit. Paste a month of nightly figures to see each night and the correct period totals. It runs in your browser.

Example: 120 rooms

Rooms soldRoom revenueOccupancyADRRevPAR
9211,96076.7%130.0099.67
789,75065.0%125.0081.25
11617,40096.7%150.00145.00

When to use it

  1. Report daily performance to owners.
  2. Compare months or properties.
  3. Check a revenue manager's pricing results.
  4. Benchmark against competitors.
  5. Teach hospitality revenue management.

How to Use

  1. Enter rooms available and sold.
  2. Enter room revenue.
  3. Add total revenue or GOP if you have them.
  4. Paste nightly data for period totals.

Features

  1. Occupancy, ADR, RevPAR
  2. TRevPAR and GOPPAR
  3. Nightly batch
  4. Correct period totals
  5. CSV export
  6. 100% client-side

FAQs

What is RevPAR?

Revenue per available room: room revenue ÷ rooms available, or ADR × occupancy.

How is ADR calculated?

Room revenue ÷ rooms sold. 92 rooms earning 11,960 is an ADR of 130.

Why not average daily RevPAR for the month?

Days with different room counts would be weighted wrongly; add up revenue and rooms first.

Should complimentary rooms count as sold?

Usually not for ADR; report them separately.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

Occupancy = rooms sold ÷ rooms available; ADR (average daily rate) = room revenue ÷ rooms sold; RevPAR = room revenue ÷ rooms available, which also equals ADR × occupancy. TRevPAR uses total revenue and GOPPAR gross operating profit per available room. For a period, nights are summed first — total room revenue ÷ total rooms available — rather than averaging daily ratios, matching industry reporting.

Business & Legal Tools

Business & Legal Tools

  • Tailor Measurement Sheet
  • Cleaning Job Quote Calculator
  • Event Seating Plan Maker
  • Invoice and Receipt Field Extractor
  • Garment Cost Sheet
  • Fabric Inspection (4-Point System)
  • Resume Keyword Scanner
  • Startup Runway Calculator