Hotel Pro Forma Builder
Project your hotel's five-year performance with market benchmarks, then download a lender-ready pro forma.
For preliminary planning only. Projections are estimates based on the figures you entered and market benchmark data, so validate assumptions with your lender. Not an offer of credit.
How the pro forma builder works
- Set up the property. Pick the hotel flag, room count, and location. The builder pulls market benchmarks for that flag and market: occupancy, average daily rate (ADR), and revenue per available room (RevPAR), drawing on industry data sources including HVS, Kalibri Labs, and CoStar.
- Tune the assumptions. Adjust base-year occupancy and ADR, growth rates, and departmental revenue and expense lines (rooms, food and beverage, other operated departments, undistributed expenses, and fixed charges). Benchmark cost profiles for your flag pre-fill realistic expense ratios.
- Review the five-year projection. The builder produces yearly occupancy, ADR, RevPAR, departmental P&L, and net operating income, and exports a lender-ready report in Excel or PDF for construction, PIP, acquisition, or refinance underwriting.
Frequently asked questions
What is a hotel pro forma?
A hotel pro forma is a forward-looking financial projection, typically five years, covering occupancy, average daily rate (ADR), revenue per available room (RevPAR), departmental revenues and expenses, and net operating income. Lenders use it to underwrite construction, PIP, acquisition, and refinance loans.
What are occupancy, ADR, and RevPAR?
Occupancy is the share of available room nights sold. ADR (average daily rate) is room revenue divided by rooms sold. RevPAR (revenue per available room) is ADR × occupancy, the headline measure of a hotel's top-line performance.
Where do the benchmark numbers come from?
The builder starts your projection from market benchmarks by hotel flag and location, drawing on industry data sources including HVS, Kalibri Labs, and CoStar, and lets you adjust every assumption.
What do lenders look for in a hotel pro forma?
Lenders check that occupancy and ADR assumptions are in line with the market and the flag, that expense ratios by department are realistic, and that projected NOI supports the requested debt with an adequate debt service coverage ratio and yield on cost.