APERTUREHOSPITALITY Talk to Aperture
Aperture Hospitality · Revenue Tools

RevPAR Scenario Calculator

Compare your hotel's baseline against two pricing or demand scenarios. RevPAR = ADR × Occupancy, which equals room revenue ÷ available room nights. The figures loaded below are an example; replace them with your own.

How to use this calculator

Five minutes from blank to a side-by-side comparison

Build a comparison

  1. Set up the property. Enter the hotel's name, then choose the revenue period (night, month, quarter or year) and the currency. The period only changes the revenue totals; RevPAR is always per available room night.
  2. Enter the baseline. In the first card, enter the room count, the current ADR and the current occupancy. Trailing twelve months of actuals make the most defensible baseline; budget figures make a softer one.
  3. Model two alternatives. Scenario A and Scenario B are your what-ifs, for example a rate increase that costs some occupancy, or a lower rate that fills more rooms. Click a card's title to rename it after the move it models.
  4. Adjust inputs. Type exact values in the boxes, or drag the sliders to explore. Every figure on the page updates as you go.
  5. Stress-test the result. Use the sensitivity grid to see how much RevPAR moves if ADR or occupancy lands off plan.
  6. Share it. Click Copy summary for a plain-text recap of all three scenarios, ready to paste into an email or a deck. Reset to example clears your inputs and restores the sample hotel.

Read the results

RevPAR and the change chip
Each scenario shows its RevPAR and its change against the baseline, in money and percent. Green beats the baseline; red falls short.
Room revenue
Total room revenue for the selected period, and the gap to the baseline for each scenario.
Breakeven occupancy
Under the comparison bars, each scenario shows the occupancy it needs at its ADR to match baseline RevPAR, and how many points of cushion or shortfall the modeled occupancy leaves.
Sensitivity grid
Rows move occupancy up or down by 5 and 10 points; columns move ADR by 5, 10 and 15 percent. The outlined cell is the scenario itself. Use the menu above the grid to center it on any scenario.

Before you decide

  • Count available rooms only. Take out-of-order rooms off the room count, and use paid occupancy.
  • RevPAR is rooms revenue only. It leaves out F&B, ancillary spend and distribution costs. A rate push that shifts mix toward OTAs can win on RevPAR and lose on net revenue.
  • Your inputs stay in this browser. Nothing is sent to Aperture, and anyone else who opens the link sees the example figures. Use Copy summary to share your numbers.

RevPAR comparison

    Sensitivity grid

    RevPAR as ADR and occupancy move around the selected scenario. Green cells beat its RevPAR, red cells fall short. The outlined cell is the scenario itself.

    Rows: occupancy (points)Columns: ADR change
    Beyond the Model

    The math says one thing. The market says another?

    RevPAR shows which lever moves revenue. It doesn't show why demand, mix or distribution is holding you back. A Commercial Diagnostic finds where growth is stuck and builds the 90-day plan to fix it.

    Start a conversation