A hotel pro forma is a forward-looking financial statement that projects occupancy, rates, revenue, expenses, net operating income (NOI) and cash flow for a property over a holding period, usually five to ten years. It is only as good as its assumptions. The pro forma that survives a lender's review starts from a normalized operating base, ties every revenue line to market evidence and is stress-tested before anyone signs. This guide shows how to build it, with a worked example, and where the assumptions most often go wrong.
TL;DR
- A hotel pro forma projects rooms and ancillary revenue, departmental costs, undistributed and fixed expenses, NOI and cash flow after debt service.
- Start from a normalized base year in the industry's standard uniform format, then project each line forward. Do not start from a target return.
- Rooms revenue is available room nights times occupancy times average daily rate (ADR). Small changes in either one move NOI sharply.
- Test downside cases for occupancy, ADR, labor, insurance and exit cap rate. A deal that only works at the top of the range is unproven.
- Occupancy and rate assumptions need market and guest-feedback evidence behind them, which is where we work with owners and investors.
Table of Contents
- What a hotel pro forma is, and what it is not
- The hotel financial projections every pro forma needs
- A worked example: a 120-room select-service hotel
- Building realistic assumptions
- Stress-test before you show it to anyone
- Common mistakes that make a pro forma fail
- Making the occupancy and revenue assumptions hold up
- What we do at LDB Hospitality
- Our perspective
- FAQ
- Sources
What a hotel pro forma is, and what it is not
A pro forma is a projection. A historical profit and loss statement (P&L) reports what already happened. A pro forma estimates what will happen if a set of stated assumptions holds. That distinction matters because the pro forma is the document owners, lenders and investors use to decide whether to buy, build, renovate or refinance.
The standard structure follows the Uniform System of Accounts for the Lodging Industry (USALI). Its stated purpose is to give lodging operators operating statements suited to the industry's unique environment and to make comparisons between properties possible (USALI, 11th revised edition). If your pro forma uses its own categories, a lender or buyer has to translate it before they can compare it with anything else.
A typical layout, as described in a professional breakdown of hotel pro forma basics, runs top to bottom like this:
- A header: rooms, available rooms, occupied rooms, occupancy, ADR, ADR growth and RevPAR.
- Departmental revenues and expenses (rooms, food and beverage, other operated departments), giving departmental profit.
- Undistributed expenses, such as administration, sales and marketing, utilities and property operations.
- Gross operating profit (GOP).
- Management and franchise fees and fixed expenses such as property taxes and insurance.
- NOI, capital expenditures (CapEx) and cash flow from operations.
Below NOI, an investor version adds debt service, cash flow after debt and returns.
The hotel financial projections every pro forma needs
Revenue: start with rooms, then add what the property really sells
Three formulas carry most of the work:
- Rooms revenue = available room nights × occupancy × ADR.
- RevPAR (revenue per available room) = ADR × occupancy, or rooms revenue divided by available rooms.
- Available room nights = rooms × days in the period.
Then add every other revenue stream the property actually has: food and beverage, meetings and events, spa, parking, retail, resort fees and other ancillary income. A 2026 modeling guide lists these streams as the ones a projection should cover where they apply. Be conservative with ancillary income on a new property. Restaurants, event space and spa revenue usually ramp slower than rooms.
Expenses: separate what moves with revenue from what does not
Keep three groups apart:
- Departmental costs rise and fall with the revenue of that department: housekeeping labor, room supplies, food costs.
- Undistributed expenses run the building and the brand regardless of how many rooms sell: administration, sales and marketing, utilities, maintenance.
- Fixed charges include property taxes, insurance, and management and franchise fees.
The split matters for stress testing. When occupancy falls, departmental costs flex a little and fixed charges do not flex at all, so NOI drops faster than revenue. Labor is the largest and most volatile line. Our guide to labor cost control for hotels and restaurants covers how to set staffing levels you can defend in a projection.
Below NOI: reserves, debt and returns
NOI is the operating cash flow measure used to assess debt capacity and value. Cash flow after debt service is NOI minus principal and interest payments. Most lenders and franchisors also expect a reserve for furniture, fixtures and equipment (FF&E) replacement, so build it in rather than leaving it for the lender to add.
A worked example: a 120-room select-service hotel
The numbers below are an illustration, not a benchmark. Swap in your own market data.

Rooms revenue. 120 rooms × 365 days = 43,800 available room nights. At 68% occupancy, 29,784 rooms are sold. At an ADR of $165, rooms revenue is $4,914,360. RevPAR is $165 × 0.68 = $112.20, which matches $4,914,360 divided by 43,800.
Total revenue. Assume rooms are about 70% of revenue, with the rest from food and beverage, parking and other income: total revenue of roughly $7.0 million.
| Line | Assumption | Annual amount |
|---|---|---|
| Total revenue | Rooms plus ancillary | $7,000,000 |
| GOP | 38% of revenue | $2,660,000 |
| Management fee | 3% of revenue | $210,000 |
| Property taxes and insurance | Quoted and estimated | $480,000 |
| FF&E reserve | 4% of revenue | $280,000 |
| NOI | $1,690,000 | |
| Debt service | Principal and interest | $1,100,000 |
| Cash flow after debt | $590,000 |
Now run a downside. If occupancy lands at 63% instead of 68%, sold rooms fall to 27,594 and rooms revenue to about $4,553,010. That is roughly $361,000 less, and because most costs do not shrink with five points of occupancy, a large share of that loss falls straight through to NOI. Against $590,000 of cash flow after debt, the cushion is thinner than the base case suggests. This is the sort of result a pro forma exists to reveal.
Building realistic assumptions
Anchor on a normalized base year
The Counselors of Real Estate recommend normalizing the most recent complete operating year into a stabilized, USALI-format base-year P&L, then projecting each revenue, expense and capital line across the hold period (Counselors of Real Estate, 2026). Normalizing means removing one-time items, such as a closure for renovation or an unusual group booking, so the base reflects a typical year.
Their framework builds occupancy and ADR forecasts from market data and from how the subject hotel is positioned against its competitors, and then tests sensitivities: occupancy, ADR growth, capital expenditure, labor margins and exit cap rates. The exit cap rate is the capitalization rate used to estimate what the hotel sells for at the end of the hold.
Existing hotel or new development
The inputs differ.
Existing hotel. Use historical operating statements, monthly results (hotel income is seasonal, so annual totals hide the swings), the competitive set report, tax bills, insurance quotes, payroll detail and the current property improvement plan if there is a franchise.
New development. There is no history, so the model needs more. Include construction and pre-opening costs, FF&E, a ramp-up period before the hotel reaches stabilized occupancy, working capital, and the funding schedule: loan drawdowns, equity, interest and repayments. A feasibility study comes first for a ground-up project, because it tests whether the market supports the hotel before you model its finances.

Get occupancy and ADR from the market, not the target
The most common error is working backward from the return you need. Occupancy and ADR should come from demand evidence: your competitive set's actual performance, new supply entering the market, demand generators such as corporate accounts, events and airports, and how guests rate comparable properties. Our guide to building a hotel market analysis walks through that evidence, and the rate-setting guide on dynamic pricing shows how ADR actually behaves across seasons and demand.
For a sense of how margins vary by format, CBRE Hotels reported 2015 U.S. GOP margins of 44.6% for limited-service hotels and 36.9% for full-service properties (HotelNewsResource, 2015). These are historical benchmarks, so match any benchmark to your property's service level and period instead of copying it as a forecast.
The same discipline applies to valuation. A property investment has to be judged on a handful of core numbers, not on headline yield alone, and this overview of the key numbers for judging a commercial property investment is a useful companion when you compare your hotel's return with other asset types.
Stress-test before you show it to anyone
A pro forma with one scenario is a sales brochure. Build at least three: base, downside and upside. Then flex these inputs one at a time and in combination:
- Occupancy, down three to ten points.
- ADR growth, flat or below inflation.
- Labor, with wages rising faster than rates.
- Insurance and utilities, which have moved sharply in many U.S. markets.
- CapEx, with a renovation running over budget.
- Exit cap rate, a point higher than today.
Watch two outputs: debt service coverage (NOI divided by debt service) and cash flow after debt. If the deal only works in the upside case, it is not yet proven.
The same rule applies to a pro forma you receive. A seller's or broker's pro forma is a projection, not filed operating evidence, and its assumptions can add up to an optimistic picture. Where possible, check the occupancy and rate it implies against market-reported hotel occupancy tax revenue and against actual operating statements.
Common mistakes that make a pro forma fail
- Stabilizing too fast. New hotels take time to build a guest base and reviews. Model a ramp, not a leap to full occupancy in year one.
- Using flat expense percentages. Expenses that look like a fixed share of revenue in the base year rarely stay that way when occupancy moves.
- Ignoring seasonality. Annual averages hide the months when cash is tight. Model monthly, at least for the first years.
- Skipping the reserve. Leaving FF&E reserves out inflates NOI.
- Overstating ancillary revenue. Spa, events and restaurants often underperform in early years.
- Treating payroll as a percentage. Build staffing from a position-by-position plan.
- Having no marketing line that matches the occupancy target. If the projection assumes 75% occupancy, the sales and marketing budget, the distribution mix and the reputation plan should be able to deliver it.
Making the occupancy and revenue assumptions hold up
The pro forma's revenue line is a promise about demand. Making that promise credible takes market analysis, an honest read of guest feedback and a marketing plan sized to the target. Ideas for the operational side are in our playbook to increase hotel occupancy, and restaurant owners can apply the same logic to covers and check averages with our restaurant revenue management guide.
On the expense side, preventive maintenance spending feeds directly into the CapEx and repairs lines. See how to build a preventive maintenance program so that your projections reflect a plan instead of a guess.
What we do at LDB Hospitality
Our work is built around a data-driven methodology: we use market trends and customer feedback to create customized strategies that optimize both operations and the guest experience. Our approach is designed to deliver measurable improvements in occupancy, retention and profitability. For a pro forma, that means the revenue assumptions come from market analysis and guest feedback, and a marketing strategy and reputation management plan sit behind the occupancy and rate targets.
We offer hospitality marketing strategies and guest reputation management for hotels and restaurants, plus strategic consulting and operational support for owners and investors.

If you are building or reviewing a pro forma and want the demand assumptions pressure-tested, you can book a consultation.
Our perspective
A pro forma is a statement about the future that an owner has to be able to defend in front of a lender, a partner and, eventually, the guests who decide whether the numbers come true.
We see the revenue line as the part that deserves the most work. Spreadsheet mechanics are easy. What is hard is proving that your hotel can hold a given occupancy at a given rate, and that proof comes from market trends, competitive positioning and what guests say about the stay.
That is why our method starts with data and customer feedback, then builds a customized strategy around them. When the marketing plan, the reputation work and the operating model all point at the same occupancy target, the pro forma stops being a hopeful forecast and becomes a plan.
The hotels that earn their projections are the ones where someone owns the assumptions after the loan closes, tracks actual results against them every month and corrects course early.
La’Quentin
FAQ
Is it "pro forma" or "proforma"?
Both appear in practice. "Pro forma" as two words is the traditional spelling and the safer choice in formal documents. Lenders and brokers use either, so be consistent within your own file.
How much profit does a hotel make?
It depends on the market, the service level and the season, so no single figure fits every property. Historical U.S. benchmarks show limited-service hotels converting more revenue to GOP than full-service hotels, as in the 2015 CBRE margins cited above. Measure your own projection with occupancy, ADR, RevPAR, GOP margin and NOI, and compare it with a competitive set of your own.
How many years should a hotel pro forma cover?
Most cover the expected holding period, typically five to ten years. A new development usually needs a pre-opening period plus the years it takes to stabilize. Existing hotels with solid history can use a shorter horizon, as long as the exit assumptions are explicit.
What should a hotel pro forma template include?
Separate sheets for assumptions, revenue, operating expenses, an NOI summary, financing and returns, and sensitivity analysis keep the model readable. Enter property basics, room count, acquisition price or development cost and hold period first. Then add ADR, occupancy and ramp assumptions, and switch off any departments the hotel does not operate.
Can I rely on a broker's or seller's pro forma?
Treat it as a starting point and rebuild it from the operating statements, monthly results and market data. Compare the occupancy and rate it implies with what the market has actually reported. If the deal works only at the top of its range, keep working on the assumptions.
Sources
- USALI, Eleventh Revised Edition (HFTP)
- Hotel Proforma Basics: Hotel Cash Flow Projection
- Demystifying Hotel Investment Analysis (Counselors of Real Estate)
- Select-Service Hotels: Efficient and Profitable (HotelNewsResource)
- Hotel Financial Model: Avoid Costly Forecasting Mistakes
- 5 números para saber si un local comercial es buena inversión
