# Hotel Model Build a hotel financial model with segmented room revenue, F&B margins, departmental cost tracking, and institutional asset management logic. Designed for developers, investors, and operators. - Canonical: https://finamodel.com/templates/hotel-model - Excel download: https://finamodel.com/templates/hotel.xlsx - Category: Real Estate - Model type: Underwriting - Difficulty: Intermediate - Audiences: Developers & sponsors, Investors & analysts, Hotel owners, Hospitality investors, Asset managers, Hotel operators - Tags: hotel, revpar, adr, occupancy, lodging-operations ## Overview This project finance model values a luxury hotel acquisition by forecasting occupancy, ADR, F&B and ancillary revenue, calculating NOI after all departmental and management fees, sizing senior debt to DSCR, and projecting levered and unlevered IRR over a 7-year hold. Answer: does the 200-key asset sustain 1.25x+ DSCR and achieve 12–16% levered IRR given labour cost inflation and refinancing risk? The workbook projects rooms revenue (occupancy × ADR), F&B revenue per occupied room (£180 Year 1, 3% escalation), spa (15–18% capture rate, 4% growth), and OOD (5% of rooms revenue). USALI cost structure: departmental expenses 25% rooms cost, 75% F&B cost, 35% spa cost. Undistributed opex 22.5%: A&G 8%, S&M 7%, POM 4%, utilities 3.5%. Management fees: 3% base + 4% FF&E reserve + 10% incentive on adjusted GOP. Senior debt £44M (55% LTV on £80M asset) at 6.5% fixed, 25-year amortisation. Annual PMT ~£3.65M. Exit Year 7: forward NOI (Year 8) / 6.5% cap rate. Used by hotel operators, real estate sponsors in hospitality acquisitions, lenders underwriting CRE mortgages, and infrastructure funds deploying capital in lodging assets. The model captures the structural challenge post-2022: labour costs up 20–30% vs. 2019 baseline, squeezing four-wall margins; exit cap rate expansion (50–100 bps wider than entry) reflecting higher refinancing risk. FF&E reserve (4% of revenue accumulated annually) is mandatory to meet brand standard. Benchmarks: luxury RevPAR $200–400; Four Seasons, Mandarin Oriental, Ritz-Carlton flag fees 3–5% base, 10–15% incentive on GOP. ## What's included - Room revenue build by segment (Transient, Group, Contract) - Ancillary revenue streams including F&B, spa, and parking - Departmental expense schedules with labour and variable cost drivers - GOP and NOI tracking with management fee logic - FF&E reserve, capex planning, and exit sensitivity analysis - Room inventory and occupancy rate assumptions by market and season - Average daily rate (ADR) with market segmentation (leisure, business, group) - Food and beverage and ancillary revenue (parking, resort fees, events) - Labor costs (front desk, housekeeping, management, culinary) - Property operations (utilities, maintenance, supplies, insurance) - Debt service and capital expenditure reserve ## Inside the Hotel Financial Model: Full-Service Luxury Acquisition Logic This hotel model is a 21-sheet workbook that answers one question: what levered and unlevered IRR does an equity investor earn acquiring, operating and exiting a full-service luxury hotel over a seven-year hold? It follows USALI departmental accounting, from the revenue build through the P&L to NOI, debt and returns. ### Revenue drivers: rooms, F&B, spa and other departments Revenue is built from the rooms department outward. Available room nights equal total keys times days in the year. - Rooms sold follow from applying an occupancy rate that ramps before stabilising, and rooms revenue is rooms sold times ADR. RevPAR, the headline valuation metric, is simply occupancy times ADR, or rooms revenue divided by available room nights. - Growth comes from ADR pricing, occupancy through loyalty channels and suite mix. - F&B and spa revenue both scale with rooms sold rather than available rooms, each using a per-occupied-room spend figure that grows at its own rate, so occupancy drives ancillary spend while ADR increases do not lift it proportionally. Other operated departments, covering parking, retail and similar, are modelled as a percentage of rooms revenue. Occupancy, ADR strata and seasonality feed the blended ADR, and a checks row confirms the seasonal mix sums to one. ### Cost structure and operating leverage Costs follow USALI sequencing: departmental expenses first, then undistributed overheads, then management fees and fixed charges. Departmental costs vary with their own revenue line, so each department carries its own margin. - Channel costs, covering OTA and brand commissions, are deducted within the rooms cost block based on the booking mix across OTA, brand and direct channels. Rooms costs scale with rooms sold, not available rooms, which matters for housekeeping and guest supplies. - Undistributed opex, covering admin, sales and marketing, property operations and utilities, splits each line into a fixed base escalated by cost inflation plus a variable share of revenue. That split is the source of operating leverage: as revenue outgrows the inflated fixed base, margins expand, and in a downside case where revenue grows slower and inflation runs higher, margins compress. Management fees, a base fee, an FF&E reserve and a two-tier incentive fee sit on GOP, with the incentive tier floored at zero. ### From GOP to NOI, cash flow and liquidity The P&L consolidates the departmental build into GOP, then subtracts base and incentive management fees, property taxes and insurance, and the FF&E reserve to reach NOI. Depreciation is tracked separately, so operating cash flow starts from NOI, which is already pre-depreciation, and no add-back is applied. - This avoids double-counting D&A, which is a known cause of balance sheet errors in hotel models. - The cash flow layer runs a liquidity waterfall. A minimum cash balance, roughly two months of opex, is held every year. In deficit years the revolver draws to that floor before sponsor equity is called; in surplus years the revolver is repaid first, then the lender cash sweep applies, then the remainder above the floor is distributed to the sponsor. Annual FF&E reserve contributions fund refurbishment capex, and a brand-mandated improvement plan splits soft-goods and case-goods spend across specific years with contingency reserves. ### Returns, balance sheet and practical use Exit value is forward NOI divided by an exit cap rate. Sale proceeds repay the senior mortgage and any revolver balance, then credit residual cash and the remaining FF&E reserve back to the owner. - The levered equity stream nets equity called against distributions received and adds exit equity, and that series drives levered IRR and the equity multiple. The multiple divides total cash returned by total equity actually called over the hold, so follow-on capital calls are captured correctly. - The balance sheet rolls PP&E net of depreciation, working capital from receivable, inventory and payable days, debt, and equity as cumulative contributions less distributions. Validation checks confirm the balance sheet balances, occupancy stays within limits, DSCR holds above covenant from the post-ramp years, revenue streams sum to the total, and cash never goes negative. - A sensitivity grid shows implied annualised returns across exit cap and NOI growth combinations. The public download is a values-only preview of the underlying model. This template is designed for developers, investors and operators evaluating a full-service luxury hotel acquisition. ## Built for hotel investment analysis Use this model when RevPAR, departmental margins, and management fee structures drive the property-level financial outcome. ## Designed around hospitality-specific drivers A useful hotel model connects occupancy, ADR, and segment mix to departmental profitability so the operating picture is complete. ## Better for underwriting and asset management This gives you USALI-formatted reporting with proper management fee logic instead of a generic real estate template that misses hotel-specific mechanics. ## Built for hotel investment analysis Use this model when RevPAR, departmental margins, and management fee structures drive the property-level financial outcome. ## Designed around hospitality-specific drivers A useful hotel model connects occupancy, ADR, and segment mix to departmental profitability so the operating picture is complete. ## Better for underwriting and asset management This gives you USALI-formatted reporting with proper management fee logic instead of a generic real estate template that misses hotel-specific mechanics. ## Features - **RevPAR and rate optimization:** Model occupancy vs. ADR trade-offs to identify optimal pricing strategy for revenue maximization. - **Seasonal and market-driven scenarios:** Build occupancy and rate patterns reflecting seasonal demand, competitive set, and market cycles to forecast normalized performance. - **Property-type and conversion analysis:** Compare class A, B, and C property economics and model repositioning or renovation upside. ## Use cases - **Acquisition underwriting and valuation:** Forecast property cash flow, estimate stabilized NOI, and calculate cap rate and debt capacity for acquisition pricing. - **Renovation and repositioning planning:** Model capital spend and revenue uplift from renovation (ADR accretion, occupancy improvement) to support financing and ROI decisions. - **Franchise and management agreement evaluation:** Analyze franchisor fees, management fees, and brand support to determine profitability vs. independent operation. ## Frequently asked questions ### What is a hotel financial model? It is a model that forecasts hotel revenue, departmental costs, and profitability using hospitality-specific drivers such as occupancy, ADR, RevPAR, and segment mix. ### Who uses hotel financial models? Hotel developers, real estate investors, asset managers, hospitality consultants, and lenders use them for acquisition underwriting, development, and operations. ### What should a hotel model include? It should include segmented room revenue, F&B and ancillary income, departmental expenses, GOP and NOI, FF&E reserves, management fees, and exit analysis. ### Does it support different hotel types? Yes. The model is flexible enough to adjust labour intensity, ADR benchmarks, and expense ratios for anything from limited-service budget hotels to full-service luxury resorts. ### Are management fees and FF&E reserves included? Yes. The model calculates base and incentive management fees and includes standard FF&E reserve deductions as a percentage of revenue. ## Related templates - [Theme Park Operating Model](https://finamodel.com/templates/theme-park-model) - [Restaurant Unit Economics and Multi-Unit Model](https://finamodel.com/templates/restaurant-model) - [Gym and Fitness Studio Operating Model](https://finamodel.com/templates/gym-model)