How to Build a Hotel Pro Forma That Lenders Actually Approve in 2026

A hotel pro forma is the single document that determines whether your financing request moves forward or stalls in underwriting. It projects revenue, expenses, and cash flow over five years, telling lenders exactly how much Net Operating Income (NOI) will remain after operations to service debt. Get the line items wrong, and underwriters flag your deal before they finish reading page one.

This guide breaks down the eight sections every hotel pro forma must include, explains how to source defensible assumptions, identifies the mistakes that kill deals in underwriting, and shows where hotel pro formas diverge from standard commercial real estate (CRE) models.

What a Hotel Pro Forma Actually Does

A hotel pro forma is your five-year financial forecast. It projects how much revenue your property will generate, what your operating costs will look like, and, most importantly, how much NOI will be left over to service debt. Think of it as the business plan your lender actually reads.

Unlike a pitch deck or executive summary, the pro forma faces direct scrutiny from underwriters who compare every assumption against third-party data. If your RevPAR projection shows $130 in a market where the competitive set averages $110, underwriters will demand documentation supporting your premium positioning: brand strength, superior location, recent renovation, or differentiated amenities.

Every lender type (banks, CMBS conduits, life companies, debt funds) uses the pro forma to size the loan. The numbers you present here determine your leverage, rate, and structure.

The 8 Line Items Every Hotel Pro Forma Must Include

1. RevPAR Projections

Revenue Per Available Room (RevPAR) is the single metric lenders weight most heavily. It combines your occupancy rate and Average Daily Rate (ADR) into one number: RevPAR = Occupancy × ADR.

Your projections must reconcile with comparable properties in your market. The updated STR/Tourism Economics outlook projects 0.6% RevPAR growth for the U.S. hotel market in 2026, so projecting 5% growth without strong market-specific support will raise immediate red flags.

For new construction, build in an 18–36 month stabilization period with graduated occupancy curves. Acquisitions need trailing twelve months (T-12) of actual performance layered with STR benchmarking.

2. ADR Assumptions

ADR reflects your property's pricing power relative to the competitive set. Lenders don't just want a number. They want the logic behind it.

Ground your ADR in STR competitive set data, not in what a seller's broker told you the property "could achieve." Break ADR by segment (transient, group, contract) and by season. A select-service hotel in a business travel market will show different ADR patterns than a resort property driven by leisure demand.

In the current environment, some lenders are underwriting flat to +1% ADR growth in their base cases, reflecting a conservative stance in an uncertain economy.

3. Occupancy Rates by Season

Annual average occupancy tells only part of the story. Lenders need monthly or quarterly occupancy projections that account for seasonality. Historical data reveals up to a 30% variance in occupancy between peak and off-peak seasons. A ski resort might project 90% in winter and 40% in summer.

Your occupancy projections should show:

• Monthly or quarterly breakdowns tied to local demand drivers (conventions, tourism seasons, business travel patterns)

• Segment mix: transient versus group versus contract

• Ramp-up periods for new construction or post-renovation properties

• Market context: how your projected occupancy compares to the competitive set

4. Gross Operating Profit (GOP) Margins

GOP is total revenue minus all operating department expenses and undistributed expenses, before management fees, capital reserves, and debt service. This line item reveals how efficiently your hotel converts revenue into operating profit.

Hotel operating expenses are substantially higher than standard CRE properties. Full-service hotels carry heavier expense loads because of food and beverage operations, banquet services, and larger staffing requirements. Limited-service properties run leaner because they don't carry those departments.

Your pro forma should break out departmental expenses (rooms, F&B, other operated departments) and undistributed expenses (admin, marketing, utilities, property operations, IT) in the Uniform System of Accounts for the Lodging Industry (USALI) format that lenders expect.

5. Net Operating Income (NOI) Calculation

NOI = GOP minus management fees, franchise fees, and capital reserves. This is the number lenders use to calculate loan sizing metrics.

For hotel deals, NOI calculation is more complex than standard CRE because of the layered fee structures. Brand management fees typically run 3–5% of gross revenue plus incentive fees tied to profitability. Franchise fees add another 4–6% of rooms revenue. These fees are non-negotiable line items that must appear in your pro forma. Omitting them is one of the fastest ways to lose credibility with an underwriter.

6. Debt Service Coverage Ratio (DSCR) at 1.25x+

DSCR measures whether your property generates enough NOI to cover annual debt payments, with a cushion. The formula: DSCR = NOI ÷ Annual Debt Service.

Lenders typically require a minimum DSCR of 1.25x or greater, meaning for every $1.00 in debt service, the property must generate $1.25 in NOI. For 2026, bank lenders set DSC floors at 1.25x, while borrowers with strong credit profiles and high liquidity may see more favorable structures.

Your pro forma must calculate DSCR for each projected year. If your DSCR dips below 1.25x in any year of the projection, including during a ramp-up or renovation period, you need to explain how you'll bridge that gap (interest reserves, equity injection, or restructured amortization).

7. Debt Yield

Debt yield = NOI ÷ Loan Amount. It tells lenders what return they'd earn on their loan if they had to take the property back, making it a risk metric independent of interest rates and amortization.

In 2026, CMBS lenders are targeting 13.5%+ debt yield, while life companies prefer 14% to 15%+ for the strongest deals. Minimum debt yields for bridge loans start around 9%.

Include debt yield in your pro forma summary alongside DSCR and LTV. Lenders will calculate it themselves, but presenting it proactively signals that you understand how they evaluate risk.

8. Capital Expenditure (CapEx) Reserves

Hotels require ongoing capital investment for FF&E (furniture, fixtures, and equipment) replacement, brand-mandated Property Improvement Plans (PIPs), and general building maintenance. The industry standard for FF&E reserves is approximately 4% of total revenue, according to HVS, though some hospitality consultants argue the true replacement cost runs higher.

Brands typically require FF&E refreshes approximately every seven years, and a PIP can run into the millions depending on the scope. Your pro forma must include:

• Annual CapEx reserve as a percentage of revenue

• Known PIP obligations with estimated costs and timing

• Roof, HVAC, and structural reserves beyond FF&E

Underwriting that focuses only on operational cash flow and ignores capital expenditures is a common pitfall that sophisticated lenders immediately flag.

How to Source Realistic Assumptions: STR Data vs. Seller Pro Formas

The difference between a funded deal and a dead deal often comes down to where you sourced your numbers.

Start With STR Competitive Set Data

STR (Smith Travel Research, now part of CoStar) provides the benchmark data that lenders trust. An STR report compares your property's performance (occupancy, ADR, and RevPAR) against a competitive set of at least four comparable hotels selected based on location, scale, and quality.

CBRE and PKF HOST reports provide detailed operating statistics by chain scale and property type, letting you benchmark labor costs, departmental expenses, and profit margins against industry norms.

When a lender reviews your pro forma, the first thing they do is compare your revenue projections against STR data for your market. If your numbers diverge materially, in either direction, you need a documented explanation.

Treat Seller Pro Formas as Marketing Documents

A seller's pro forma is designed to make the asset look attractive. It often projects aggressive ADR growth, optimistic occupancy, and expense ratios that assume operating efficiencies the current owner hasn't achieved.

Never adopt a seller's assumptions wholesale. Instead:

• Cross-reference every revenue line against STR competitive set data

• Validate expense ratios against PKF HOST benchmarks for your property type and chain scale

• Stress-test the occupancy ramp: if the seller shows 75% occupancy by month six post-acquisition, ask whether the market supports that pace

• Check for omitted costs: seller pro formas frequently understate or exclude PIP requirements, insurance increases, and brand-mandated technology upgrades

How Hotel Pro Formas Differ From Generic CRE Pro Formas

If you've built pro formas for office, retail, or multifamily properties, hotel pro formas will look unfamiliar. Here's why.

A standard CRE pro forma starts with lease-by-lease rental income, deducts vacancy and credit loss, adds expense reimbursements, and arrives at NOI through a relatively straightforward calculation.

A hotel pro forma is more like the income statement of a real operating company, with revenue split across rooms, food and beverage, and other operated departments, and expenses broken into fixed versus variable categories.

The bottom line: you cannot adapt a multifamily or office pro forma template for a hotel deal. Lenders who specialize in hospitality expect USALI-formatted financials, hospitality-specific line items, and metrics that reflect operating business risk, not just real estate risk.

5 Hotel Pro Forma Mistakes That Kill Deals in Underwriting

1. Projecting RevPAR Above the Competitive Set Without Justification

If your pro forma shows RevPAR 20% above the comp set, underwriters will reject it unless you document exactly why: brand strength, location advantage, recent capital improvements, or differentiated demand generators. Unjustified variances trigger immediate pushback.

2. Ignoring Seasonality in Revenue Projections

Presenting flat monthly revenue across all twelve months signals that you don't understand the hotel business. Every market has seasonal patterns, and lenders know it. Build monthly or quarterly granularity into your projections.

3. Omitting or Understating Capital Expenditure Requirements

A pro forma that shows strong NOI but sets CapEx at 1–2% of revenue, or ignores it entirely, will not survive underwriting. Lenders know hotels require ongoing capital reinvestment, and upcoming PIP obligations can materially change the cash flow picture.

4. Using Seller Assumptions Instead of Market Data

Adopting a seller broker's "best case" projections without independent verification is the fastest way to lose credibility. Underwriters compare your numbers against STR data, and discrepancies erode trust in the entire submission.

5. Failing to Calculate DSCR Across All Projection Years

Some pro formas show DSCR only at stabilization, hiding the fact that coverage falls below 1.0x during ramp-up or renovation periods. Lenders model every year. If year two shows a DSCR of 0.85x, you need to present the solution (interest reserves, guarantor support, or restructured terms), not pretend the gap doesn't exist.

Stress Test Your Pro Forma Before Lenders Do

Lenders will stress-test your assumptions. You should get there first.

According to MMCG Investment Group, some lenders now explicitly model -3% to -5% occupancy versus current levels and only flat to +1% ADR growth in their base cases. Your pro forma should include at least three scenarios:

• Base case: Moderate growth aligned with STR market forecasts and your competitive set trends

• Downside case: Occupancy drops 5–10 percentage points, ADR grows at 0%, and expenses increase 2–3%. Does DSCR still hold above 1.0x?

• Upside case: Your renovation or brand conversion delivers the lift you're projecting. Show the math, but don't rely on it for loan sizing.

The goal isn't to present a worst-case scenario that scares lenders. It's to prove you've thought through variability and that the deal survives stress. If the downside case shows DSCR below 1.0x, your loan is probably oversized for the asset's risk profile.

Additional stress factors to model:

• Interest rate increases of 100–200 basis points on floating-rate debt

• Insurance cost escalation (a growing concern in coastal and wildfire-risk markets)

• Loss of a major demand generator (a convention center closing, a corporate headquarters relocating)

• PIP timing: what happens to cash flow during the renovation period?

Build a Lender-Ready Pro Forma in Minutes

Building a hotel pro forma from scratch in Excel means formatting revenue projections, layering in seasonal occupancy curves, calculating DSCR at multiple debt levels, and ensuring every line item follows the USALI structure that underwriters expect. Most owners spend days on this process, and still submit a document that triggers formatting corrections before the lender even reviews the numbers.

Bridge Marketplace's pro forma builder was designed specifically for hotel deals. The tool lets you input key drivers (ADR, occupancy assumptions, seasonality factors) and automatically generates institutional-grade forecasting for Revenue, NOI, and Operating Expenses. It enforces consistent formatting, incorporates industry-standard expense ratios by property type, and models realistic stabilization curves.

The pro forma builder calculates DSCR, LTV, and Loan-to-Cost (LTC) automatically, and flags deals that fall outside typical approval parameters before you submit to lenders. Combined with Bridge's AI-powered offering memorandum generator, you can go from raw data to a complete, lender-ready package.

Once your pro forma is ready, Bridge's deal room presents your package to a network of 150+ hospitality-specialized lenders, with complete submissions receiving competitive term sheets within 48 hours.

Start building your hotel pro forma →

Frequently Asked Questions

How long should a hotel pro forma cover?

Most lenders require a five-year projection. Construction loans may require projections through the stabilization period, which can extend to seven or more years from ground-breaking. Match the projection period to your loan term plus any extension options.

Can I use a generic CRE pro forma template for a hotel?

No. Hotel pro formas require hospitality-specific line items: RevPAR, ADR, segmented occupancy, departmental revenue (rooms, F&B, other), USALI-formatted expenses, management and franchise fees, and FF&E reserves. A standard CRE template built around lease-by-lease income won't capture the operating business dynamics that hotel lenders evaluate.

What STR data do I need for my pro forma?

At minimum, you need an STR competitive set report showing your property's occupancy, ADR, and RevPAR indexed against comparable hotels. STR requires a minimum of four comparable hotels in your competitive set. For deeper analysis, add STR segmentation data (transient, group, contract) and day-of-week performance breakdowns.

What DSCR do lenders require for hotel loans in 2026?

Most lenders set a floor at 1.25x DSCR. Borrowers with weaker credit profiles or higher-risk assets may face 1.35x–1.40x requirements. SBA lenders evaluate Global DSCR, aggregating all of the borrower's business and personal obligations, not just the subject property.

How do I handle a ramp-up period in my pro forma?

New construction and major renovation projects require graduated occupancy assumptions, typically starting at 40–50% in year one and reaching stabilized occupancy (65–75% for most markets) by year two or three.

Show the math behind your ramp-up assumptions, reference comparable properties that achieved similar curves, and address how debt will be serviced during the below-stabilization period (interest reserves, sponsor guarantees, or structured holdbacks).

Conclusion

A hotel pro forma is more than a spreadsheet exercise. It's the document that determines whether your financing moves forward or dies in an underwriter's inbox. The eight line items covered here (RevPAR, ADR, occupancy, GOP, NOI, DSCR, debt yield, and CapEx reserves) represent the minimum standard that hospitality lenders expect. Miss one, and the entire package loses credibility.

What separates funded deals from rejected ones usually isn't the property itself. It's the quality of the assumptions behind the numbers. Ground every projection in STR competitive set data, not seller optimism. Build in seasonality. Account for management and franchise fees. Stress-test before the lender does it for you.

Hotel underwriting is more complex than standard commercial real estate, and lenders know when a borrower has done the work versus when they've recycled a generic template. The USALI format, hospitality-specific metrics, and layered fee structures all demand a purpose-built approach.

If you're preparing a hotel financing package, Bridge Marketplace's pro forma builder handles the formatting, calculations, and stress testing so you can focus on the deal itself. Once your pro forma is complete, submit it to our network of 150+ hospitality lenders and receive competitive term sheets within 48 hours.