StaxIQ
Hotel financial modelling

Hotel pro forma: how to build one owners and lenders trust

Every hotel deal rests on two documents. The feasibility study says whether the market can support the hotel. The pro forma says what the hotel will earn if it does. Get either one wrong and everything built on top of them, the financing, the purchase price, the operator negotiation, is wrong too.

The short version: a hotel pro forma is a multi-year projection of the P&L, from occupancy and rate down to the owner's return, built on the USALI standard so a reviewer can read it without translation. A feasibility study is the market evidence behind it: supply, demand, the competitive set and the rates the market will bear. The conventions that make both credible are a three-year ramp to stabilisation, fees and reserves on the correct lines, a full capital budget, and a downside case that answers the lender's tests before they are asked. What a commissioned study costs is covered separately; the model itself you can and should own.

This guide covers what each document does, what goes into them, and the handful of conventions that separate a bankable set of numbers from an optimistic spreadsheet. It is written for the owner or investor who has to commission, read or build these documents, not the consultant selling them.

1. Two documents, one question

The question is always the same: will this hotel pay for the money it consumes? The feasibility study answers the market half. It establishes who would stay in the hotel, what they would pay, what already competes for them and what new supply is coming. The pro forma answers the financial half. It converts that market evidence into a year-by-year projection of revenue, cost and return. They are often bound in one report, but they fail differently: a feasibility error means the demand is not there; a pro forma error means the demand is there and the owner still loses money, usually because the fees, reserves or capital were understated.

2. The market evidence underneath it

A pro forma is only as good as the market evidence it rests on, and that evidence comes from a feasibility study: a defined competitive set whose occupancy, average daily rate and RevPAR history anchor every projection, plus the supply and demand analysis around it. Lenders often require an independent one, and owners should test its assumptions rather than inherit them.

That is a subject in its own right, including what a study costs and where they are usually weakest, and it is covered in full in the hotel feasibility study guide. The rest of this page is about the projection you build on top of it.

3. The revenue build-up: keys, occupancy, rate

The pro forma's top line is disciplined arithmetic: rooms multiplied by occupancy multiplied by average daily rate gives rooms revenue, and everything else, food and beverage, spa, parking, other operated departments, builds on assumptions per occupied room or per available room. The two inputs that decide the model's fate are occupancy and rate, and both should be anchored to the competitive set, not to ambition. A projection whose stabilised occupancy or ADR sits above the comp set needs a named, defensible reason: a better product, a stronger brand engine, a gap in the market the study evidences.

4. The ramp: no hotel opens stabilised

Standard practice is a three-year ramp with stabilisation from the fourth full year. Smaller and select-service hotels near strong demand generators often get there in two to three years; big full-service boxes take longer. During the ramp, occupancy typically runs 10 to 20 percent below stabilised levels and rate 5 to 15 percent below market, because a new hotel buys its early business. Model the ramp explicitly, year by year, and if the opening is mid-year, pro-rate the first year properly. A pro forma that opens at stabilised occupancy in month one is the single fastest way to lose a reviewer's trust.

5. From revenue to the owner's return

Between the top line and what you keep sits the whole architecture of hotel accounting: departmental costs, undistributed expenses, gross operating profit, then the layer that most generic templates miss entirely, the operating agreement. Management base and incentive fees, or the franchise stack, or rent, each on the correct USALI line, followed by the FF&E reserve, typically 4 to 5 percent of total revenue. The structure you choose moves the bottom line more than most operating assumptions, which is why the same hotel needs to be modelled under each candidate structure, not just once. The line-by-line format is in the operating statement guide, the gap between GOP and your money in GOP, EBITDA and the owner's bottom line, and the structural comparison in management contract vs lease vs franchise.

6. The capital side of the pro forma

Feasibility is not only operating numbers. On a new build, US development costs in 2025 ran from median levels around 167,000 dollars a key for limited-service to roughly 409,000 for full-service and beyond a million a key for luxury, with FF&E commonly absorbing 8 to 12 percent of the total. On an acquisition or conversion, the entry capital is the purchase price plus the property improvement plan and any repositioning works. And across the hold, brand standards keep the capital meter running well past the contractual reserve. The capital budget belongs inside the pro forma, not in a side spreadsheet, because the return is calculated on all the money in, not just the operating result. The capital mechanics are covered in what brand standards really cost.

7. The tests a lender will apply

A financing case has to clear specific hurdles, so build them into the model. Debt service cover, the ratio of cash flow to debt payments, is commonly required around 1.3 to 1.4 times for hotels. Debt yield, net operating income over the loan amount, often binds first, with many hotel lenders looking for 10 to 12 percent or better. Reviewers also stress the case: interest rates 100 to 150 basis points higher, income haircut, occupancy capped below your stabilised assumption. Run those stresses yourself and show the break-even. A model that arrives with its downside already tested reads as an experienced sponsor; the full checklist is in a projection that survives due diligence.

8. From feasibility to decision

The output that matters is not a single number but a defensible range: the owner's return across the hold, under each realistic structure, with the ramp, fees, reserve, capital and downside all in. That is the basis on which you negotiate the operator terms, size the debt and decide whether to proceed at all. Start with the free fee stack calculator to size the operator and brand charges against your GOP, then build the full multi-year model before any commitment is signed.

Build the pro forma on the standard, not in a spreadsheet

Everything on this page, the revenue build-up, the ramp, the fee stack on the correct lines, the capital budget and the lender tests, is what Stax IQ does from one set of inputs. Change an assumption once and every structure recalculates, so the comparison stays honest and the output survives review.

See what Stax IQ Pro does

Want the fee assumptions first? The free Fee Stack Decoder maps the operator and brand charges most pro formas understate. Get it free.

If you want the deep version, choosing the structure and negotiating the economics of the operating agreement clause by clause, that is what The Hotel Operating Agreements Series is for.

Frequently asked questions

What is a hotel pro forma?

A hotel pro forma is a multi-year projection of the hotel's profit and loss, from occupancy and rate at the top to the owner's return at the bottom. A credible one is built on the USALI standard, ramps the early years realistically, carries the management or franchise fees on the correct lines, and funds the FF&E reserve. It is the document a lender, investor or buyer will test line by line.

What should a hotel pro forma include?

A ten-year projection of the profit and loss on USALI lines, a revenue build-up from keys, occupancy and average daily rate rather than a growth percentage, an explicit ramp to stabilisation, the management or franchise fee stack and the FF&E reserve on the correct lines, the full capital budget including any property improvement plan, and a downside case that answers the lender's tests before they are asked.

How long does a new hotel take to stabilise?

Standard practice is a three-year ramp with stabilisation from the fourth full year. Smaller and select-service hotels near strong demand generators often stabilise in two to three years; larger full-service hotels tend to take the full three to four. During the ramp, occupancy typically runs 10 to 20 percent below stabilised levels and rate 5 to 15 percent below market, which is why a pro forma that assumes day-one stabilisation is the first thing a reviewer rejects.