Hotel Financial Model Template

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.

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.