Hotel Pro Forma Template

Start with the Assumptions sheet. Enter the property basics — room count, property type (full-service, select-service, extended stay), acquisition price or total development cost, and hold period. Then set your ADR and occupancy inputs, including the ramp schedule if you're projecting lease-up or post-renovation stabilization. Most users spend 20–30 minutes here getting the inputs right before looking at any output sheets. The closer these assumptions are to reality, the more useful the rest of the model becomes.

Once assumptions are in, review the Revenue Projections and Operating Expenses sheets to make sure the categories match your property. Toggle off revenue lines that don't apply (a limited-service hotel won't have spa revenue), and adjust the expense percentages under each department to reflect actual operator benchmarks or LOIs you've already negotiated. The NOI Summary sheet will start showing a 10-year picture as soon as the revenue and expense lines are populated.

Use the Investor Returns sheet once the operating model looks right. Enter your debt terms and equity contribution to see levered IRR and cash-on-cash returns for each year of the hold. Then spend time in the Sensitivity Analysis sheet — run it against a few downside ADR and occupancy combinations to see where the deal breaks even and where it blows through your return thresholds. This is typically what equity partners and senior lenders want to see before a credit committee.

Hotels are operationally complex investments, and a pro forma built on generic spreadsheet logic usually falls apart in due diligence. The reason is that hotel revenue isn't just one number — it's the product of ADR, occupancy, and rooms available, each of which behaves differently across market cycles, competitive sets, and property types. A select-service hotel in a suburban market ramps to stabilization in 12–18 months. A full-service urban property with a new F&B concept can take three years to reach underwritten occupancy. Any pro forma that doesn't model the ramp explicitly is hiding the hardest part of the deal.

Lenders and institutional equity partners expect hotel financials to follow the Uniform System of Accounts for the Lodging Industry (USALI). This means departmental P&Ls, undistributed operating expenses broken out line by line, and GOP stated before management fees and franchise royalties. If your model collapses everything into a single expense column, it signals to investors that you're working from a residential or retail template rather than hospitality-specific underwriting. The structure in this template matches what a hotel asset manager or hotel-specialized lender expects to see.

The practical value of a hotel pro forma isn't just presenting to investors — it's testing whether the deal works under realistic assumptions. Most hotel acquisitions are underwritten at 70–75% occupancy and stabilized ADR at the market average, but the actual first-year performance is often 10–15 points below that as you rebuild the reservation base or complete a renovation. Running the Sensitivity Analysis with a conservative occupancy ramp and a lower exit cap rate tells you whether the deal has a real margin of safety or whether it only pencils under a best-case scenario.