Free early accessis open for residential development teams. Start modelling today.

Start modelling
Operating model · Register interest

Hotel performance, RevPAR forward.

ADR, occupancy, RevPAR and GOP across the hold. Operator fee, F&B and capex reserve drive the answer, not a year-one stub.

  • Inputs7 blocks
  • Outputs8 metrics
  • CashflowMonthly
  • ScenariosPlanned

What this model does

Hotel operating operating model, end to end.

Run the hotel across the hold. ADR, occupancy and RevPAR drive room revenue; F&B revenue and operator fee build out GOP and net cashflow.

Calculation flow05 steps
  1. 01

    Asset

    Key count, room mix and brand captured for the operating asset.

  2. 02

    Room revenue

    ADR, occupancy and RevPAR applied; seasonal pattern overlaid.

  3. 03

    F&B and ancillary

    F&B revenue, banquets and other ancillary revenue split out.

  4. 04

    Hold cashflow

    GOP runs across the hold, with operator fee, brand fee and capex reserve modelled.

  5. 05

    Exit

    Exit cap rate applied to forward GOP; hold-period equity IRR returned.

Schema

Every input. Every output. In one view.

The full hotel operating operating model schema. 7 input blocks feeding 8 output metrics, with the calculation engine in between.

Inputs07 blocks
  1. 01

    Asset

    Key countRoom mixBrandAmenities
  2. 02

    Room revenue

    ADROccupancyRevPARSeasonality
  3. 03

    F&B and ancillary

    F&B revenueBanquetsSpaParking
  4. 04

    Operating cost

    Operator feeBrand feeStaffF&B cost
  5. 05

    FF&E and capex

    FF&E reserveSoft refurbHard refurbCapex cycle
  6. 06

    Hold finance

    Existing debtRefinance yearInterestCoupon
  7. 07

    Hold and exit

    Hold yearsExit cap rateSelling costInflation
Outputs08 metrics
Primary outputAt base case
Operating yield7.4%
MetricValue
  • Year-one GOP$15.6M
  • Exit value$214.0M
  • RevPAR$258
  • Stabilised occupancy78%
  • GOP margin38%
  • Hold-period IRR12.4%
  • FF&E reserve4% of revenue

Engine logic

Two engines. Scenarios and cashflow.

The two pieces that separate the hotel operating operating model from a spreadsheet. Scenarios that share one project, and a monthly cashflow wired to every input.

Scenarios01 / 02

Multiple scenarios, one project

Switchable in a click. No copied files.

  1. 01

    ADR, occupancy and F&B revenue as scenario levers.

  2. 02

    Operator fee, brand fee and management per scenario.

  3. 03

    Refurb cycle and FF&E reserve per scenario.

  4. 04

    Each scenario carries its own exit cap rate.

Cashflow02 / 02

Monthly cashflow, fully connected

Every input touches the schedule.

  1. 01

    Monthly RevPAR across the hold, with seasonal overlay.

  2. 02

    F&B revenue runs alongside, with its own cost build-up.

  3. 03

    GOP feeds through operator fee, brand fee and management.

  4. 04

    FF&E reserve drawn against soft and hard refurb cycles.

Excel replacement

Where the workbook quietly fails.

Every row is a recurring failure mode of the hotel operating operating workbook, and how the model handles it once.

SpreadsheetPopurise model
  • 01RevPAR as a single flat lineADR, occupancy and seasonality as live inputs
  • 02F&B hidden in room revenueF&B revenue and cost as their own block
  • 03FF&E reserve ignoredFF&E and refurb cycle reserved against the hold

Use and verify

What it decides. What to check first.

The decisions the hotel operating operating model is built to support, alongside the things to verify before you trust it on a live deal.

What it decidesUse cases
  1. 01

    Forecast GOP

    ADR, occupancy, F&B and operator fee through the hold. GOP follows.

  2. 02

    Plan the refurb cycle

    Soft and hard refurb cycles reserved. Net cashflow reflects the cycle.

  3. 03

    Stress-test occupancy

    Occupancy and ADR stress scenarios. RevPAR follows.

  4. 04

    Pressure-test exit cap rate

    Exit cap rate sensitivity. Hold IRR follows.

Pre-flight checklist05 checks
  • ADR, occupancy and seasonality as separate inputs.

  • F&B revenue and cost as their own block.

  • Operator fee, brand fee and management broken out.

  • FF&E reserve and refurb cycle reserved against the hold.

  • Exit cap rate sensitivity as a scenario.

Worth checking before you stake a live deal on the hotel operating operating model.Register interest
Related models

Hotel feasibility model

Open

BTR operating model

Open

Stabilised value model

Open

Questions

Hotel operating operating model, answered.

How Popurise handles the hotel operating operating model.

How is this different from the hotel feasibility model?

Feasibility answers whether to build. Operating answers how the open hotel runs across the hold.

Does it handle seasonality?

Yes. Occupancy and ADR carry a seasonal overlay across the year.

How is FF&E reserved?

FF&E reserve and refurb cycle live as separate inputs, drawn against soft and hard refurb.

Can I model brand change?

Yes. Operator fee and brand fee sit as scenarios, with re-flagging modelled at the hold horizon.

Shape the hotel operating model in Popurise.

Tell us how your team runs this asset today. We are building the operating model with the owners and operators who will use it.