Hotel Pro Forma Builder
Industry Standard FormatA ten-year operating cash flow in the format lenders read, seeded from market benchmarks for your flag and location.
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 brand and flag, enter the room count, and resolve the address. The builder pulls market occupancy, average daily rate (ADR), and revenue per available room (RevPAR) for that location, drawing on industry data sources including HVS and Kalibri Labs, and a departmental cost structure for the flag. Market figures are indexed to the flag's national performance before they seed the model.
- Tune the statement. The full ten-year operating cash flow is editable in place — occupancy and ADR ramp, departmental revenue and expense lines (rooms, food and beverage, other operated departments, undistributed expenses, and fixed charges), and the per-line growth and adjustment column the workbook carries.
- Export a lender-ready model. The statement ends at net operating income in USALI format, one landscape page, ten years across. Download it as an Excel workbook with live formulas or a one-page PDF for construction, PIP, acquisition, or refinance underwriting.
Common questions
Frequently asked questions
What is a hotel pro forma?
A hotel pro forma is a forward-looking operating projection 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. This builder produces the ten-year, USALI-format statement lenders read.
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 seeds your projection from market-level occupancy and ADR for the hotel's location and a cost structure for its flag, drawing on industry data sources including HVS and Kalibri Labs. Market figures are indexed to the flag's national performance before they seed the model, and every assumption stays editable.
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.
Can I check a pro forma I already have?
Yes. Upload your existing Excel model on the check page and it is scored line by line against comparable hotels, along with the consistency problems a credit officer looks for.