Hotel Pro Forma Underwriting: RevPAR, ADR, and Hospitality Metrics

An OM Lands for a 120-Key Hotel, and Your Multifamily Tab Doesn't Fit

The broker's package shows a limited-service hotel: 120 keys, trailing occupancy, an average daily rate, and a one-line "NOI" that doesn't show its work. Your firm's standard template has a rent roll, a unit mix, and a vacancy assumption. None of that maps cleanly onto a business that sells the same room at a different price every night of the week.

Hotel underwriting isn't multifamily underwriting with a different label. It runs on occupancy times rate rather than units times rent, and its expense structure is departmental rather than a flat operating-expense ratio. Get those two things wrong and your NOI — and the debt sizing, equity returns, and investor memo built on top of it — are wrong too.

This article walks through the mechanics of hotel pro forma underwriting: how RevPAR, ADR, and occupancy combine to build the top line, how departmental expenses convert that top line into NOI, and how to stress-test the result before you commit capital. By the end, you'll be able to take a broker's OM — ADR and occupancy only — and rebuild a defensible NOI from the ground up.

Why a Hotel Deal Breaks Your Multifamily Template

A multifamily or office pro forma starts from a static rent roll: so many units, at so much rent, with a vacancy factor applied against gross potential rent. The lease term is typically 12 months, the rent rarely moves intra-year, and the operating expense line is often modeled as a percentage of revenue or a per-unit dollar figure.

A hotel has no leases in that sense. Every room is re-priced, in principle, every night. Revenue is a function of how many rooms you sell (occupancy) and at what price (rate), and both numbers move with day of week, season, local demand generators, and competitive set pricing. That volatility is the reason hospitality underwriting uses its own vocabulary — RevPAR, ADR, and occupancy — instead of the vacancy-and-rent-roll approach used elsewhere in commercial real estate.

The expense side diverges just as sharply. A hotel's cost structure is organized by operating department — rooms, food and beverage, other operated departments — plus a separate layer of undistributed operating expenses (administrative, sales and marketing, property operations and maintenance, utilities) and fixed charges (insurance, property tax, management fee, and an FF&E reserve for furniture, fixtures, and equipment replacement). A flat expense ratio borrowed from an apartment model will misstate a hotel's NOI by a wide margin, because departmental costs scale with occupancy in ways a single "opex %" line can't capture.

If your firm also underwrites other specialty asset classes with their own unit-mix logic — storage facilities with multiple unit sizes and rate tiers, for instance — the same principle applies: match the model structure to how the asset actually generates revenue. A self-storage financial model and a hotel pro forma look nothing alike for exactly this reason.

RevPAR: The Metric That Replaces NOI-per-Unit Thinking

RevPAR — revenue per available room — is the single most important top-line metric in hotel underwriting. It compresses occupancy and rate into one number that lets you compare a hotel's performance across periods, or against a competitive set, independent of how that performance was achieved.

RevPAR = ADR × Occupancy Rate, and is mathematically identical to Total Room Revenue ÷ Total Available Room-Nights.

Both formulas yield the same number, which is why operators and lenders move between them freely. A property can grow RevPAR by raising rate, by filling more rooms, or by some combination of both — and the mix matters, because a rate-driven RevPAR gain tends to be stickier than an occupancy-driven one, which can evaporate the moment a competitor undercuts price.

RevPAR is a top-line metric only. It says nothing about departmental costs, management fee structure, or capital reserves. Treat it the way you'd treat gross potential rent in a multifamily deal: the starting point for the revenue build, not a stand-in for NOI.

ADR and Occupancy: Building the Top Line

Average daily rate (ADR) is total room revenue divided by rooms sold — not rooms available. It measures the price actually realized per occupied room, net of any rate variance across room types, channels, and dates. Occupancy is rooms sold divided by rooms available, expressed as a percentage, over the same period.

Both figures move independently and both deserve separate underwriting scrutiny. A broker's trailing-twelve-month occupancy number tells you about historical demand, but it may hide a renovation closure, a brand-flag transition, or a one-time group booking that won't recur. A trailing ADR tells you about historical pricing power, but it won't reflect a planned renovation, a brand upgrade, or a shift in market positioning that the deal's business plan is counting on.

Worked example (illustrative inputs only). Assume a 120-key hotel with a modeled stabilized occupancy of 68% and an ADR of $150 — both example figures chosen for this walkthrough, not market data. Available room-nights per year: 120 rooms × 365 = 43,800. Rooms sold: 43,800 × 68% = 29,784. Room revenue: 29,784 × $150 = $4,467,600. RevPAR, as a check: $150 × 0.68 = $102.00, and $102.00 × 43,800 = $4,467,600 — the two formulas reconcile.

That room revenue figure is the starting line of the pro forma, not the ending one. Add other operated department revenue — food and beverage, parking, meeting space, ancillary fees — before moving to the expense side. For a quick gut-check on how occupancy and rate combine before you build the full tab, an ADR and occupancy calculator is a faster first pass than opening the full model.

Departmental Expenses: Undistributed vs. Distributed Costs

Hotel expenses are typically organized using the industry's standard uniform system of accounts logic, which splits costs into two tiers.

Departmental (distributed) expenses scale directly with the department generating the revenue. Rooms department expenses — housekeeping labor, guest supplies, reservation system fees, linen — move with occupancy. Food and beverage department expenses — cost of goods sold, kitchen and service labor — move with covers served. These are modeled as a percentage of their own department's revenue, not of total hotel revenue.

Undistributed operating expenses support the whole property regardless of which department produced the revenue: administrative and general, sales and marketing, property operations and maintenance, and utilities. These lines are more stable period to period and are often modeled as a percentage of total revenue or as a per-available-room dollar figure.

Below that sit fixed charges — property insurance, property tax, and management fee (commonly a base fee as a percentage of total revenue, plus an incentive fee tied to NOI or GOP) — and the FF&E reserve, typically reserved as a percentage of total revenue to fund the periodic case-good and soft-good replacement a hotel requires to maintain brand standards.

Worked example continued (illustrative inputs only). Using the $4,467,600 room revenue above, assume total hotel revenue (rooms plus other operated departments) of $5,200,000 — again an example figure. Departmental expenses across rooms and F&B: $1,560,000 (a 30% blended departmental cost ratio, example only). Undistributed operating expenses: $936,000 (18% of total revenue, example only). That leaves gross operating profit of $2,704,000. Subtract a 3% management fee ($156,000), insurance and property tax (example: $260,000 combined), and a 4% FF&E reserve ($208,000), and stabilized NOI lands at roughly $2,080,000.

Every percentage in that walkthrough is a placeholder chosen to demonstrate the mechanism — your actual departmental ratios should come from the specific property's trailing financials, STR comp-set data, and the brand's operating standards, not from this example.

From RevPAR to NOI: The Full Hotel Pro Forma Build

Put together, the build runs in a fixed sequence: available room-nights → occupancy and ADR → RevPAR and room revenue → other department revenue → total revenue → departmental expenses (by department, as a percentage of that department's own revenue) → undistributed operating expenses → gross operating profit → management fee and fixed charges → FF&E reserve → stabilized NOI.

That NOI then flows into the same downstream mechanics used across commercial real estate: a cap rate for valuation, a DSCR test for debt sizing, and a discounted cash flow for return projections. The inputs are hospitality-specific; the outputs plug into the same underwriting framework you'd use for any other asset class. A general NOI calculator is useful for sanity-checking the final number once you've built the departmental detail, and a broader commercial real estate financial model overview is a good reference if you're underwriting a mixed-use deal with a hotel component alongside retail or multifamily.

Stress-Testing a Hotel Model: Seasonality and Rate Compression

Hotels carry more revenue volatility than most other property types, which makes stress-testing non-negotiable rather than optional. Build the model with monthly, not just annual, granularity so seasonality shows up in the cash flow rather than getting smoothed away in an annual average.

Run a sensitivity grid across both occupancy and ADR independently — a 5×5 table flexing occupancy by a few points in either direction against ADR flexed by a similar percentage — because a RevPAR shortfall driven by rate compression behaves differently in the pro forma than the same shortfall driven by occupancy softness. Rate compression tends to hit margin harder, since departmental costs don't fall proportionally when you're filling the same number of rooms at a lower price.

Also model a downside scenario where the management fee and FF&E reserve stay fixed as a percentage of revenue even as GOP tightens — that's exactly how most management and franchise agreements are structured, and it means fixed-charge coverage erodes faster than revenue alone would suggest. Confirm the specific fee structure and FF&E reserve requirement in the actual management or franchise agreement before finalizing debt sizing; don't assume the industry-typical percentages carry over to every brand and operator.

Choosing or Building a Hotel Pro Forma Template

A hotel deal is the wrong place to force a repurposed multifamily or office template. The departmental expense structure, the RevPAR-driven top line, and the management/franchise fee mechanics are specific enough that a mismatched model will misstate NOI in ways that compound through debt sizing and equity returns.

YieldSheets' Hotel Pro Forma is built around this exact structure: ADR and occupancy inputs flow into RevPAR and room revenue, departmental and undistributed expenses are modeled separately, and the output feeds a standard DSCR, cap rate, and discounted cash flow build. The file ships fully unlocked, with every formula visible and documented, so you can see precisely how RevPAR becomes NOI and adjust any assumption to match the specific property, brand, and market you're underwriting.

If you're evaluating a hotel acquisition or refinance and need a model built on hospitality-specific mechanics rather than an adapted multifamily tab, the Hotel Pro Forma is available as a one-time purchase with immediate download.