RevPAR Calculator: ADR and Occupancy for Small Hotels (Free + Excel)

Three numbers tell a hotel owner most of what they need to know about the rooms business: occupancy (how full you were), ADR (the average rate you got) and RevPAR (revenue per available room, which combines the two). They sound simple, but small hotels often calculate them in slightly different ways from month to month. Out-of-order rooms get dropped from the count, comp rooms get counted as sold, or two monthly percentages get averaged. When that happens, the numbers stop being comparable with last year, with the budget or with the hotel down the street.

This page gives you a free RevPAR calculator that works the way STR/CoStar and the USALI define the metrics. Enter your rooms, days, rooms sold and room revenue, and it returns occupancy, ADR, RevPAR and TRevPAR, shows each calculation step, and tells you what ADR or occupancy you need to hit a target RevPAR. Add a few competitors and it also calculates your MPI, ARI and RGI index scores. There’s a matching Excel template too.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Three tabs: a calculator with a target-RevPAR what-if, a competitive set benchmark for up to 8 hotels, and a step-by-step guide.

Free online RevPAR calculator

Fill in your hotel’s figures for any period: a single night, a week, a month or a year. The competitive set table is optional. Click Load example to see a 42-room inn benchmarked against three competitors. You can print the results, save them as a PDF, download them as Excel, Word or CSV, or email a link to your owner, GM or bookkeeper.

1. Your hotel and period

2. Competitive set (optional)

CompetitorRoomsDaysOOO room-nightsRooms soldRoom revenue ($)

Add competitors to get MPI, ARI and RGI (100 = fair share). Use the same period for every hotel. Room revenue is net of lodging taxes and before F&B. Comp rooms are free stays and are not counted as sold. Your data stays in your browser. Nothing is sent to our server unless you choose to save it to your account.

3. Results

Step by step

What it takes to hit your target RevPAR

Competitive set

Index (100 = fair share)

RevPAR by property

Rooms available = rooms × days (out-of-order room-nights are subtracted only if the box is unticked). Occupancy = rooms sold ÷ rooms available. ADR = room revenue ÷ rooms sold. RevPAR = room revenue ÷ rooms available = occupancy × ADR. MPI, ARI and RGI = your occupancy, ADR and RevPAR ÷ the comp set’s × 100, where comp set figures are totals divided, not averages of percentages.

Made with the free RevPAR calculator at bookkeepingsheets.com

What is RevPAR?

RevPAR (revenue per available room) is room revenue divided by the number of rooms you had available to sell. It’s the standard measure of how well a hotel turns its inventory into room revenue, because it captures both how full you were and the price you got. A hotel that sells every room at a deep discount and a hotel that sells half its rooms at a premium can end up with the same RevPAR, and RevPAR is what shows you that.

Two related metrics sit underneath it:

  • Occupancy = rooms sold ÷ rooms available. Complimentary rooms are not counted as sold.
  • ADR (average daily rate) = room revenue ÷ rooms sold. It’s the average price of a paid room-night.

Multiply occupancy by ADR and you get RevPAR. If the two ways of calculating RevPAR don’t match, one of your inputs is wrong. The calculator shows this check as its own row.

For context, CoStar reported that U.S. hotels averaged 66.4% occupancy, a $161.78 ADR and $107.43 RevPAR in August 2026, with RevPAR up 2.0% on August 2025 (CoStar, September 2026). National averages mix luxury city hotels with roadside motels, though. Your own market and competitive set are a far better yardstick, and that’s what the index section of the calculator is for.

RevPAR, ADR and occupancy formulas

MetricFormulaWhat it tells you
Rooms availableRooms × days in the periodYour inventory of room-nights
OccupancyRooms sold ÷ rooms availableHow full you were
ADRRoom revenue ÷ rooms soldAverage price per paid room-night
RevPARRoom revenue ÷ rooms available, or occupancy × ADRRoom revenue earned per room you could have sold
TRevPARTotal revenue ÷ rooms availableIncludes F&B, parking, spa and other revenue
MPIYour occupancy ÷ comp set occupancy × 100Occupancy index (100 = fair share)
ARIYour ADR ÷ comp set ADR × 100Rate index
RGIYour RevPAR ÷ comp set RevPAR × 100RevPAR index, the headline benchmark

Which rooms count as “available”?

Under the Uniform System of Accounts for the Lodging Industry (USALI) and in STR/CoStar benchmarking, rooms that are out of order for repairs still count as available. Only rooms taken out of inventory for a long time, such as during a seasonal closure or a renovation, are removed. Some owners also like to see occupancy on sellable rooms only. The calculator has a tick box for this, and the Excel file has a Yes/No switch. Use the same setting every month, and use the standard setting when you compare with a competitive set.

Worked example: a 42-room inn in October

Harborview Inn has 42 rooms. October has 31 days, so it had 42 × 31 = 1,302 room-nights available. Two rooms were out of order for four nights each (8 room-nights), but they still count as available. The inn sold 968 paid room-nights, gave away 6 comp nights and booked $138,750 in room revenue. Total revenue, including breakfast and parking, was $164,200.

MetricCalculationResult
Occupancy968 ÷ 1,30274.3%
ADR$138,750 ÷ 968$143.34
RevPAR$138,750 ÷ 1,302$106.57
RevPAR check74.3% × $143.34$106.57
Occupancy incl. comps(968 + 6) ÷ 1,30274.8%
TRevPAR$164,200 ÷ 1,302$126.11

Reaching a target RevPAR

The owner’s target for October was $110 RevPAR, so the inn fell short by $3.43. Over 1,302 room-nights, that’s $4,470 of room revenue. There are two ways to close the gap:

  • Raise the rate: at the same 968 rooms sold, ADR would need to be $147.95 ($110 × 1,302 ÷ 968).
  • Sell more rooms: at the same $143.34 ADR, occupancy would need to be 76.7%, which means 32 more room-nights.

Thirty-two more room-nights over a month works out to about one extra room a night, which is usually easier than a $4.61 rate increase across every booking. But it depends on demand. If the target needs more than 100% occupancy at your current ADR, the calculator tells you that the only way to get there is a higher rate.

Benchmarking against the competitive set

The inn compared itself with three nearby hotels for the same month:

PropertyRoomsOccupancyADRRevPAR
Harborview Inn (you)4274.3%$143.34$106.57
Seaside Suites6070.0%$138.00$96.60
Bayfront Lodge3568.6%$134.00$91.89
Pier Point Hotel5074.0%$150.00$111.00
Comp set total14571.0%$141.38$100.43

The index scores come out at MPI 104.7, ARI 101.4 and RGI 106.1. The inn ran fuller than its competitors and at a slightly higher rate, so it took more than its fair share of room revenue. With 22.5% of the market’s room-nights, its fair share was $132,552, and it actually earned $138,750, which is $6,198 above fair share. Pier Point Hotel still leads on RevPAR because of its higher ADR, so the inn’s next step is rate, not volume.

What’s inside the Excel template

  • Start Here: instructions, every formula in plain English, and notes on definitions.
  • Calculator: rooms, days, out-of-order room-nights (with the available Yes/No switch), rooms sold, comp rooms, room revenue, total revenue and target RevPAR. It returns occupancy, occupancy including comps, ADR, RevPAR, a RevPAR check, TRevPAR, a target-RevPAR what-if and a check cell that flags impossible inputs.
  • Comp Set: your hotel fills in automatically, and you can add up to 8 competitors. It calculates occupancy, ADR, RevPAR and rank for each property, comp set and market totals, MPI, ARI, RGI and fair share, plus a RevPAR bar chart.

How to use it

  1. Pick a period and use it everywhere: one night, a week, a month or a year.
  2. Take rooms sold and room revenue from your PMS manager’s report or the hotel daily revenue report template. Use room revenue net of lodging taxes and before F&B.
  3. Enter out-of-order room-nights and leave them counted as available unless you have a reason not to.
  4. Add a target RevPAR to see the rate or occupancy you’d need to reach it.
  5. For the comp set, use the same period and definitions for every hotel. If you subscribe to an STR/CoStar report, it already gives you comp set totals. If not, published rates and local knowledge give you a rough estimate.

Common mistakes

  • Averaging percentages. Monthly occupancy is total rooms sold ÷ total rooms available, not the average of the 31 daily occupancy figures. The same goes for comp set figures: total the rooms and revenue first, then divide.
  • Counting comp rooms as sold. This inflates occupancy and pulls ADR down. Track comp rooms separately.
  • Including taxes or F&B in room revenue. Lodging taxes aren’t revenue (see the sales tax calculator for how to back taxes out of a total). Breakfast packages should be split between rooms and F&B.
  • Removing out-of-order rooms. This makes occupancy look better, and it stops the numbers matching your comp set report.
  • Chasing occupancy at any price. A higher RevPAR from deep discounts can still lower profit once housekeeping, laundry and booking commissions are paid on each room. Check the per-room cost with the break-even calculator.

FAQ

What is a good RevPAR for a small hotel?

It depends on your market, season and class of hotel. A useful benchmark is your own competitive set: an RGI above 100 means you’re beating it. For broad context, the U.S. average was $107.43 in August 2026, according to CoStar.

Is RevPAR the same as ADR?

No. ADR divides room revenue by rooms sold, and RevPAR divides it by rooms available. RevPAR is always equal to or lower than ADR, and it equals ADR only at 100% occupancy.

What’s the difference between RevPAR and TRevPAR?

RevPAR uses room revenue only. TRevPAR (total revenue per available room) adds F&B, parking, spa, meeting space and other revenue. It’s useful for hotels with restaurants or event space, where rooms are only part of the business.

What do MPI, ARI and RGI mean?

They’re index scores from comp set benchmarking. MPI compares occupancy, ARI compares ADR and RGI compares RevPAR. A score of 100 is a fair share, 110 means 10% better than the comp set and 90 means 10% worse.

Can I use this for a vacation rental or B&B?

Yes. Enter the number of units as rooms. For a single Airbnb unit, use rooms = 1. For profit after platform fees and cleaning, the Airbnb host profit calculator goes further.

This calculator and template are for general information. They aren’t accounting, tax or investment advice. The example hotels and figures are fictional. USALI and STR/CoStar definitions can be applied differently by owners, brands and lenders, so for decisions about your own property, talk to a qualified accountant or revenue manager.