Hilton Worldwide logo
Hilton Worldwide Financial Model

Travel Company Financials Example (Free Excel Download)

Hilton Worldwide Holdings Inc. operates as a leading global hospitality company, franchising and managing hotels and resorts under 25 distinct brands.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model projects Hilton Worldwide's future cash flows and earnings to determine an intrinsic equity valuation and assess the company's capacity for continued share repurchases under its asset-light business model.

Hilton Worldwide Holdings Inc. operates as a leading global hospitality company, franchising and managing hotels and resorts under 25 distinct brands. The business is divided into two primary segments: Management and Franchise (generating the vast majority of core revenue and earnings) and Ownership (a small, legacy portfolio of owned and leased hotels). The company generates revenue globally, with the United States being the largest market, followed by Europe, the Middle East and Africa, and Asia Pacific. Hilton employs a highly capital-efficient, asset-light business model where independent third-party owners fund hotel construction while Hilton collects percentage-based fees on room revenue, resulting in significant free cash flow generation. The company holds a top-tier competitive position alongside Marriott and IHG, commanding a 15% global RevPAR index premium and boasting a record development pipeline of over 520,000 rooms. Recent strategic events include the 2024 acquisitions of the Graduate Hotels and NoMad brands, an exclusive partnership with Small Luxury Hotels of the World, and the 2026 launch of the Apartment Collection by Hilton.

The downloadable Hilton Worldwide financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsHilton Worldwide financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$5.79B$8.77B$10.23B$11.17B$12.04B
Income before income taxes$560.0M$1.73B$1.69B$1.78B$2.07B
Operating income$1.01B$2.09B$2.23B$2.37B$2.69B
Net income$410.0M$1.25B$1.14B$1.53B$1.46B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
2.0%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
5.4%
D&A % of revenue
3.6%
Effective tax rate
27.5%
See 8 more
Capex % of revenue
0.9%
Net working capital % of revenue
-14.0%
Other assets % of revenue
158.7%
Other liabilities % of revenue
88.5%
Annual debt paydown
5.0%
Interest rate on debt
4.5%
Dividend payout ratio
9.8%
Buybacks % of net income
109.5%

How to build a detailed financial model for Hilton Worldwide

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Management and Franchise

  • Segment name: Management and franchise fees and other revenues
  • Revenue driver formula: System-wide Rooms x 365 x RevPAR x Effective Fee Rate
  • Historical growth rate: 8% to 12% CAGR
  • Key growth levers and headwinds: Driven by Net Unit Growth (NUG) running at approximately 6.7%, system-wide RevPAR growth, and a gradual increase in the effective franchise fee rate as older contracts roll over to higher published rates. Macroeconomic slowdowns impacting business and leisure travel serve as the primary headwind.
  • Pricing dynamics: Contractual percentage of gross room revenue. The current in-place fee rate is approximately 5.0%, with a steady-state published rate of 5.6%.
  • Revenue recognition notes: Base fees are recognised monthly as revenue occurs at the hotel level. Incentive management fees are recognised when financial thresholds at the managed properties are met. Contract acquisition costs ("key money") are capitalised and amortised as a reduction to this revenue line over the life of the contract.
  • Seasonality: The second and third quarters are historically the strongest due to peak summer leisure travel, while the first quarter is typically the weakest.

Ownership

  • Segment name: Owned and leased hotels
  • Revenue driver formula: Owned Rooms x 365 x Owned RevPAR + Food and Beverage Revenue
  • Historical growth rate: Flat to negative
  • Key growth levers and headwinds: Revenue in this segment is structurally declining as Hilton continues to sell off its remaining owned real estate to focus entirely on the asset-light fee model.
  • Pricing dynamics: Spot pricing based on daily room rates (ADR) and local market demand.
  • Revenue recognition notes: Recognised daily as guests occupy rooms and utilise hotel services.
  • Seasonality: Mirrors the broader portfolio, peaking in the summer months.

Cost Reimbursements

  • Segment name: Other revenues from managed and franchised properties
  • Revenue driver formula: Equals the corresponding "Other expenses from managed and franchised properties" line item.
  • Historical growth rate: Varies with system size and inflation.
  • Key growth levers and headwinds: Driven entirely by the payroll and operating costs of employees at managed properties.
  • Pricing dynamics: Zero-margin pass-through.
  • Revenue recognition notes: Recognised on a gross basis as Hilton is deemed the principal in managing these employees, even though the costs are fully reimbursed by the hotel owners.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: Owned and leased hotel expenses (direct costs of running the owned portfolio) and Other expenses from managed and franchised properties (reimbursed costs).
  • Gross margin range: Not typically evaluated on a gross margin basis due to the zero-margin reimbursement revenues. The core fee business operates at near 100% gross margin.
  • Key input costs and commodity exposures: Labour costs at owned and managed properties.
  • How COGS scales with revenue: Owned hotel expenses scale linearly with occupancy. Reimbursement expenses scale exactly 1:1 with reimbursement revenue.

Operating Expenses

  • R&D: Hilton does not report R&D. Technology and software development costs are capitalised and amortised.
  • SG&A: Reported as "General and administrative". This covers corporate overhead, marketing, and executive compensation. It is heavily headcount-driven and scales slower than revenue, providing operating leverage.
  • Depreciation & Amortisation: Typically 3% to 4% of total revenue. It includes depreciation on the small owned portfolio and amortisation of capitalised software and contract acquisition costs.
  • Stock-Based Compensation: Typically runs at $150 million to $200 million annually, representing a material non-cash add-back to Adjusted EBITDA.
  • Restructuring / one-time charges: Infrequent, though occasionally present during major brand launches or corporate realignments.

Margin Profile

  • Adjusted EBITDA margin: 70% to 75% when calculated against core revenue (excluding zero-margin reimbursements).
  • Operating margin: 20% to 25% on a consolidated GAAP basis (optically depressed by the gross presentation of cost reimbursements).
  • Margin trend: Expanding slowly as the high-margin franchise fee business outgrows the lower-margin ownership segment and corporate G&A scales.

Balance Sheet Structure

  • Total assets: Approximately $15 billion to $16 billion.
  • Key asset categories: Goodwill and intangible assets (brands, management and franchise contracts) make up the vast majority of assets, a legacy of the Blackstone LBO and subsequent spin-offs.
  • Goodwill & intangibles as % of total assets: Typically 60% to 70%.
  • Working capital profile:
  • Days Sales Outstanding (DSO): 30 to 40 days.
  • Days Payable Outstanding (DPO): 40 to 50 days.
  • Net working capital as % of revenue: Structurally negative.
  • Is working capital positive or negative?: Negative. Hilton collects franchise fees and loyalty programme funds upfront, generating a working capital advantage that funds growth.
  • PP&E: Minimal (less than 5% of assets), consisting of the few remaining owned/leased hotels and corporate headquarters.
  • Right-of-use assets / operating leases: Material, representing operating leases for corporate offices and the leased hotel portfolio.

Capital Expenditure & Investment

  • Capex as % of revenue: Less than 2% of total revenue.
  • Maintenance capex vs. growth capex: The majority is growth capex directed towards corporate IT, reservation systems, and software development.
  • Major capex programmes underway: Investments in the Hilton Honors app, digital key technology, and AI-driven booking platforms.
  • Capitalised software / development costs: Highly material; Hilton capitalises significant internal software development costs which are amortised over 3 to 5 years.
  • M&A pattern: Bolt-on acquirer. Hilton occasionally purchases niche brands (e.g., Graduate Hotels for $210 million) to fill portfolio gaps but relies primarily on organic net unit growth.

Debt & Capital Structure

  • Total debt: Approximately $9.5 billion.
  • Debt/EBITDA ratio: Target leverage is 2.5x to 3.0x Net Debt to Adjusted EBITDA.
  • Credit rating: Investment grade (BBB- / Baa3).
  • Key debt instruments: Senior unsecured notes (e.g., $1.0 billion of 5.500% Notes due 2034), term loans, and a $1.9 billion revolving credit facility.
  • Maturity profile: Well-laddered with average maturities exceeding 5 years.
  • Interest rate profile: Predominantly fixed rate through bond issuances.
  • Covenants: Standard interest coverage and leverage covenants on the revolving credit facility.
  • Share repurchase programme: Highly active. Hilton repurchased 12.5 million shares for $3.3 billion in 2025, representing a mid-single-digit percentage of its market capitalisation.
  • Dividend policy: $0.15 per share quarterly ($0.60 annually), representing a low yield but a consistent return of capital alongside the massive buyback programme.

Cash Flow Characteristics

  • Operating cash flow conversion: OCF is typically 1.2x to 1.5x Net Income due to high non-cash D&A and deferred tax items.
  • Free cash flow margin: Free cash flow is typically around 50% of Adjusted EBITDA.
  • Major non-cash items: Amortisation of contract acquisition costs (which reduces revenue but is non-cash), depreciation, and stock-based compensation.
  • Working capital cash flow impact: Generally a source of cash as the system grows, driven by the Hilton Honors loyalty programme liability and deferred revenues.
  • Capex intensity: Extremely low due to the asset-light model.
  • Cash tax rate vs. GAAP effective tax rate: Cash taxes generally track the GAAP effective tax rate of approximately 20%, though timing differences in intangible amortisation can create deferred tax liabilities.

Sheet Structure

  1. Assumptions: Hardcoded drivers for RevPAR growth, Net Unit Growth, fee rates, margin targets, and capital return parameters.
  2. Operating Stats: System-wide rooms, pipeline rooms, occupancy percentages, ADR, and RevPAR broken down by major geographic region.
  3. Income Statement: GAAP P&L splitting out Management and Franchise revenue, Ownership revenue, and Other revenues from managed properties.
  4. EBITDA Reconciliation: Bridge from GAAP Net Income to Adjusted EBITDA, adding back interest, taxes, D&A, stock-based compensation, and special items.
  5. Balance Sheet: Asset-light structure highlighting goodwill, contract acquisition costs, and loyalty programme liabilities.
  6. Cash Flow Statement: Standard indirect method, highlighting key money investments, capitalised software, and heavy share repurchases.
  7. Debt Schedule: Tranche-by-tranche debt build, interest expense calculation, and leverage ratio tracking against the 2.5x to 3.0x target.
  8. DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value based on EV/EBITDA multiples.

Key Financial Relationships

  1. System-wide Rooms = Prior Period Rooms + (Prior Period Rooms x Net Unit Growth %)
  2. RevPAR = Average Daily Rate x Occupancy %
  3. Management and Franchise Revenue = System-wide Rooms x 365 x RevPAR x Effective Fee Rate
  4. Ownership Revenue = Owned Rooms x 365 x Owned RevPAR
  5. Other Revenues from Managed Properties = Other Expenses from Managed Properties
  6. Adjusted EBITDA = Net Income + Interest Expense + Income Tax Expense + Depreciation and Amortisation + Stock-Based Compensation
  7. Free Cash Flow = Operating Cash Flow - Capital Expenditures - Capitalised Software Costs
  8. Net Debt = Total Debt - Cash and Cash Equivalents (excluding restricted cash)
  9. Interest Expense = Average Debt Balance x Weighted Average Interest Rate
  10. Share Count = Prior Period Shares - (Share Repurchase Spend / Average Share Price)

Cross-Sheet Dependencies

  • The Operating Stats sheet feeds the revenue lines on the Income Statement.
  • The Income Statement generates Net Income, which feeds the top of the Cash Flow Statement and the EBITDA Reconciliation.
  • The Cash Flow Statement determines the ending cash balance, feeding the Balance Sheet.
  • The Debt Schedule calculates interest expense for the Income Statement and ending debt balances for the Balance Sheet.
  • A circularity risk exists because interest expense depends on the debt balance, which depends on the cash flow generated, which is impacted by interest expense. A circuit breaker toggle must be included in the Debt Schedule.

Sign Convention

  • Revenue and assets are entered as positive numbers.
  • Expenses and liabilities are entered as positive numbers.
  • Cash outflows on the Cash Flow Statement (e.g., capex, share repurchases) are entered as negative numbers.
  • Contra-revenue items (such as the amortisation of contract acquisition costs) should be entered as negative numbers but added in the revenue summation.

Things Most Likely to Go Wrong

  • Failing to match "Other revenues from managed and franchised properties" exactly with the corresponding expense line, which will artificially distort operating margins.
  • Miscalculating RevPAR revenue by forgetting to multiply the daily RevPAR metric by 365 days.
  • Ignoring the amortisation of contract acquisition costs, which acts as a contra-revenue item and depresses reported franchise fees.
  • Overestimating capital expenditures; Hilton is asset-light and does not fund hotel construction for its franchisees.
  • Mismodelling the share count reduction; Hilton uses almost all its free cash flow for buybacks, making the share count a dynamic variable that significantly impacts EPS.
  • Confusing GAAP Operating Income with Adjusted EBITDA; the market values Hilton entirely on Adjusted EBITDA, so the reconciliation sheet is mandatory.
  • Forgetting to exclude restricted cash (which is tied to the loyalty programme) from the Net Debt calculation.
  • Applying the effective fee rate to total system revenues rather than just the franchised and managed room revenues.

Validation Checks

  • Adjusted EBITDA margin (excluding reimbursement revenues) should be between 70% and 75%; flag if outside this band.
  • "Other revenues from managed and franchised properties" must exactly equal "Other expenses from managed and franchised properties" in every forecast period.
  • Capex as a percentage of total revenue should not exceed 2%.
  • Net Debt to Adjusted EBITDA should remain between 2.5x and 3.0x; flag if it breaches 3.5x.
  • The balance sheet must balance: Total Assets = Total Liabilities + Equity in every period.
  • Net Unit Growth should remain between 5.5% and 7.0% based on historical pipeline conversion rates.
  • Free Cash Flow conversion (FCF / Adjusted EBITDA) should be approximately 50%.

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Net Unit Growth (NUG)6.7%Matches Hilton's reported 2025 full-year net unit growth.
RevPAR Growth1.5%Midpoint of management's 2026 guidance (1.0% to 2.0%).
Effective Fee Rate5.1%Reflects the current in-place rate moving slowly toward the 5.6% steady-state rate.
Ownership Revenue Growth0.0%Assumes no new owned hotel acquisitions and flat performance on the legacy portfolio.
G&A as % of Core Revenue10.0%Historical average for corporate overhead scaling against fee revenues.
Capex as % of Revenue1.5%Historical average reflecting the asset-light, software-heavy investment profile.
Target Net Leverage2.75xMidpoint of management's stated 2.5x to 3.0x target range.
Effective Tax Rate20.0%Historical GAAP effective tax rate.
Annual Share Repurchases3,000$ MillionsAligns with the $3.3 billion total capital return in 2025 and $3.5 billion projected for 2026.
Dividend per Share0.60$Annualised based on the declared $0.15 quarterly dividend in Q4 2025.
WACC8.5%Standard discount rate for an investment-grade, asset-light hospitality business.
Terminal EV/EBITDA Multiple16.0xLong-term historical trading average for Hilton.

Data Sources & Benchmarks

  • Filings: SEC EDGAR for Hilton's 10-K and 10-Q filings; Hilton Investor Relations website for quarterly earnings supplements and pipeline updates.
  • Peers: Marriott International (MAR), InterContinental Hotels Group (IHG), Hyatt Hotels (H).
  • Industry Data: STR (Smith Travel Research) and CoStar for global RevPAR, occupancy trends, and pipeline benchmarking.
  • Consensus Estimates: FactSet or Bloomberg for validation of projected Adjusted EBITDA and EPS figures.

Sources

Frequently asked

What is Hilton Worldwide's primary business model?+

Hilton Worldwide operates as a leading global hospitality company, primarily franchising and managing hotels and resorts under 25 distinct brands. It employs an asset-light business model where independent third-party owners fund hotel construction, allowing Hilton to collect percentage-based fees on room revenue.

How does Hilton Worldwide generate most of its revenue?+

The vast majority of Hilton Worldwide's core revenue and earnings are generated through its Management and Franchise segments. The company collects percentage-based fees from independent third-party owners based on room revenue, rather than owning most of the physical hotel assets.

Why does Hilton Worldwide typically have negative net working capital?+

Hilton Worldwide structurally maintains negative net working capital due to its operational model. The company collects franchise fees and loyalty program funds upfront, which creates a working capital advantage that helps fund its growth initiatives.

What is Hilton Worldwide's capital expenditure strategy?+

Hilton's capital expenditure is minimal, less than 2% of total revenue, with the majority directed towards growth capex for corporate IT, reservation systems, and software development. The company also capitalizes significant internal software development costs, which are amortized over 3 to 5 years.

What is the main purpose of the Hilton Worldwide financial model?+

The financial model aims to project Hilton Worldwide's future cash flows and earnings to determine an intrinsic equity valuation. It also assesses the company's capacity for continued share repurchases under its asset-light business model.

Can I download an Excel financial model for Hilton Worldwide?+

Yes, a downloadable Excel financial model is available for Hilton Worldwide. This model provides financial projections for the forecast horizon of FY2026–FY2030, allowing for detailed analysis of the company's future performance.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Travel Company Financial Models

Browse another company in the same sector.

ABNB.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Airbnb logo

Airbnb

Airbnb operates a global two-sided marketplace that connects hosts offering accommodations and experiences with guests seeking unique travel stays.

BKNG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Booking Holdings logo

Booking Holdings

Booking Holdings is the world's leading provider of online travel and related services, connecting consumers with travel service providers for accommodation, flights, and rental cars.

CCL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Carnival logo

Carnival

Carnival Corporation & plc is the world's largest leisure travel and cruise company, operating a portfolio of global brands including Carnival Cruise Line, Princess Cruises, Holland America Line, Seabourn, Costa Cruises, AIDA Cruises, Cunard, and P&O Cruises.

EXPE.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Expedia Group logo

Expedia Group

Expedia Group is a leading global online travel agency (OTA) that provides travel products and services to leisure and corporate travellers.

LVS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Las Vegas Sands logo

Las Vegas Sands

Las Vegas Sands (LVS) is a leading global developer and operator of integrated resorts, featuring premium accommodations, world-class gaming, retail malls, conventions, and entertainment.

MAR.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Marriott International logo

Marriott International

Marriott International is the world's largest hotel company, operating, franchising, and licensing over 9,300 properties and 1.7 million rooms across more than 30 brands globally.

MGM.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
MGM Resorts logo

MGM Resorts

MGM Resorts International is a global gaming and entertainment company operating integrated casino, hotel, and entertainment resorts.

NCLH.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Norwegian Cruise Line Holdings logo

Norwegian Cruise Line Holdings

Norwegian Cruise Line Holdings Ltd.

Explore more Consumer financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview