Hotel Financial Model Template

Start with the Assumptions sheet. Enter your total available rooms, ADR by guest segment (if you have RevPAR data from STR reports, use that to back into an ADR and occupancy split), and projected occupancy rate by month. For existing properties, pull your last 12 months of PMS (property management system) data — ADR and occupancy are the two numbers that drive everything else. If you are modeling an acquisition or new development, use STR competitive set benchmarks for your market and apply a 10–15% discount to comp set ADR for the first year of operations. Once those inputs are in, set your F&B revenue per occupied room based on your outlet mix (a full-service hotel with a restaurant and bar typically generates $25–55 per occupied room in F&B revenue), and your overhead cost assumptions.

With assumptions set, review the Departmental P&L and main P&L sheets. Check your GOP percentage — if you're modeling a full-service property and GOP is below 25%, look at whether your ADR assumption is too conservative or your undistributed expense estimates are too high. Review the Labor Plan sheet and confirm labor as a percentage of total revenue is in a reasonable range for your service level (35–45% for full-service, 25–35% for select-service). The Cash Flow sheet shows your break-even month and DSCR, which are the two numbers any lender or franchisor will ask for first. If DSCR falls below 1.25x in any month, that signals either operating performance needs to improve or the financing structure needs to be reconsidered.

For ongoing use, update your actual ADR, occupancy, and department costs monthly. The KPI Dashboard gives you a running view of how your RevPAR and GOP% are tracking against projection. Hotel performance is highly seasonal, so month-to-month variance is expected — what matters is whether your trailing 12-month RevPAR and GOP% are on track. Ownership groups and management companies that review financial models monthly catch ADR softness or labor cost creep before it compounds into a quarterly shortfall. A RevPAR that drifts 5% below projection for three months is a serious conversation with ownership; catching it in month one is a conversation with your revenue manager.

Hotels are among the most capital-intensive businesses to operate, and the financial complexity matches that intensity. Revenue comes from multiple departments — rooms, food and beverage, meetings and events, parking, spa — each with its own cost structure and margin profile. The rooms department typically generates 60–70% of total hotel revenue and carries the highest margin (70–80% departmental contribution), while F&B generates meaningful revenue but often runs at tighter margins (30–55%) due to labor and food cost intensity. Without a model that separates these revenue streams and their associated costs, it's nearly impossible to understand where the property is making money and where management attention is most needed.

The hotel industry runs on a specific set of KPIs that drive every performance conversation. RevPAR (Revenue per Available Room) is the top-line health indicator — it combines occupancy and ADR into a single number that lets you compare your property against competitors regardless of size. GOP% (Gross Operating Profit percentage) is the operating efficiency indicator — it tells you how much of each revenue dollar flows through to the owner after paying for operations. For full-service hotels, 30–40% GOP is the benchmark; select-service properties targeting 35–50% have a structural advantage because they avoid F&B losses and have simpler staffing models. USALI-format financial reporting is the standard across the industry because it separates departmental income from undistributed expenses, making it easy to see which manager is accountable for which number. This model follows that structure throughout.

For investors and lenders, the hotel financial model serves a different purpose than internal operations tracking. Acquisition underwriting depends on the model to project NOI and implied cap rate. SBA 7(a) and SBA 504 lenders require 3-year projections with debt service coverage analysis. Franchise systems may request financial projections as part of the franchise application process. And for STR (short-term rental) and boutique hotel operators who are approaching investors for the first time, the financial model is often the document that determines whether a conversation happens at all. This template is structured to produce the outputs those audiences expect: USALI-format P&L, a departmental contribution breakdown, DSCR calculation, and a clean KPI dashboard — without requiring a hospitality finance background to build it.