United Airlines Holdings Financial Model
Transportation Company Financials Example (Free Excel Download)
United Airlines Holdings (UAL) operates a global airline network that transports people and cargo across North America and to destinations in Asia, Europe, Africa, the Pacific, the Middle East, and Latin America.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and free cash flow generation of United Airlines Holdings to help an equity analyst determine the impact of capacity expansion, fuel price volatility, and macroeconomic demand on the company's path to double-digit pre-tax margins.
United Airlines Holdings (UAL) operates a global airline network that transports people and cargo across North America and to destinations in Asia, Europe, Africa, the Pacific, the Middle East, and Latin America. The company operates a hub-and-spoke system with major domestic hubs in Chicago, Denver, Houston, Los Angeles, Newark, San Francisco, and Washington, D.C.
Business segments include:
- Passenger Revenue (approximately 90% of total revenue)
- Other Operating Revenue (approximately 7% of total revenue, primarily driven by the MileagePlus loyalty programme and United Club)
- Cargo (approximately 3% of total revenue)
Key geographies for passenger revenue are Domestic (US and Canada), Atlantic, Pacific, and Latin America. The business model is highly asset-heavy and cyclical, requiring significant capital expenditure for fleet renewal and maintenance. United's competitive position is strong as one of the "Big Three" US legacy carriers, boasting the most comprehensive international route network among North American airlines. Recent major events include the execution of the "United Next" fleet plan, which involves taking delivery of over 100 narrowbody aircraft and approximately 20 Boeing 787 widebody aircraft in 2026 alone, driving record FY2025 total operating revenue of $59.1 billion.
The downloadable United Airlines Holdings 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 & AssumptionsUnited Airlines Holdings financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $24.63B | $44.95B | $53.72B | $57.06B | $59.07B |
| Distribution expenses | $677.0M | $1.53B | $1.98B | $2.23B | $2.11B |
| Operating income | -$1.02B | $2.34B | $4.21B | $5.10B | $4.71B |
| Net income | -$1.96B | $737.0M | $2.62B | $3.15B | $3.35B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for United Airlines Holdings
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Domestic Passenger
- Segment name: Domestic
- Revenue driver formula: Domestic Available Seat Miles (ASMs) x Domestic Passenger Revenue per Available Seat Mile (PRASM)
- Historical growth rate: 4% to 6% annually
- Key growth levers and headwinds: Driven by US macroeconomic strength, corporate travel recovery, and the segmentation of cabins (Basic Economy vs. Premium). Headwinds include domestic capacity oversupply and low-cost carrier competition.
- Pricing dynamics: Highly competitive and dynamic, managed via complex revenue management systems.
- Revenue recognition notes: Recognised when the passenger flight occurs. Unused tickets sit in Advance Ticket Sales (deferred revenue).
- Seasonality: Q2 and Q3 are the strongest quarters due to summer leisure travel.
Atlantic Passenger
- Segment name: Atlantic
- Revenue driver formula: Atlantic ASMs x Atlantic PRASM
- Historical growth rate: 5% to 8% annually
- Key growth levers and headwinds: Strong premium leisure demand and corporate transatlantic travel. Vulnerable to European macroeconomic conditions and geopolitical events.
- Pricing dynamics: Premium cabin pricing drives outsized yield improvements.
- Revenue recognition notes: Recognised upon flight departure.
- Seasonality: Highly seasonal, peaking significantly in Q3 (European summer holidays).
Pacific Passenger
- Segment name: Pacific
- Revenue driver formula: Pacific ASMs x Pacific PRASM
- Historical growth rate: 8% to 12% (recovering from extended pandemic closures)
- Key growth levers and headwinds: Reopening of Asian markets and new route expansions (e.g., Ulaanbaatar, Kaohsiung). Headwinds include restricted Russian airspace increasing flight times and costs.
- Pricing dynamics: Supply-constrained environment has supported high yields historically.
- Revenue recognition notes: Recognised upon flight departure.
- Seasonality: Peaks in Q3 and Q4.
Latin America Passenger
- Segment name: Latin America
- Revenue driver formula: Latin America ASMs x Latin America PRASM
- Historical growth rate: 3% to 5% annually
- Key growth levers and headwinds: Nearshoring trends in Mexico and strong leisure demand to the Caribbean. Headwinds include currency volatility.
- Pricing dynamics: Highly sensitive to leisure demand and resort pricing.
- Revenue recognition notes: Recognised upon flight departure.
- Seasonality: Strongest in Q1 and Q4 (winter escapes).
Cargo
- Segment name: Cargo
- Revenue driver formula: Cargo Ton Miles x Cargo Yield
- Historical growth rate: Normalising downwards after pandemic spikes, currently growing at 3% to 5% annually.
- Key growth levers and headwinds: Global supply chain dynamics and widebody belly capacity.
- Pricing dynamics: Spot market pricing based on global freight demand.
- Revenue recognition notes: Recognised when cargo is transported.
- Seasonality: Peaks in Q4 due to holiday shipping.
Other Operating Revenue
- Segment name: Other operating revenue
- Revenue driver formula: Active Co-brand Credit Cards x Spend per Card x Take Rate (often modelled simply as a historically stable percentage of total revenue)
- Historical growth rate: 8% to 11% annually
- Key growth levers and headwinds: Driven heavily by the JPMorgan Chase MileagePlus co-brand agreement and United Club memberships.
- Pricing dynamics: Contractual with banking partners.
- Revenue recognition notes: Mileage revenue is split into travel components (deferred until miles are flown) and marketing components (recognised as miles are awarded).
- Seasonality: Less seasonal than passenger revenue, tied to general consumer credit card spend.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Aircraft fuel, Landing fees and other rent, Distribution expenses.
- Gross margin range: Airlines typically focus on Operating Margin rather than Gross Margin, but fuel and direct flight costs consume 40% to 50% of revenue.
- Key input costs and commodity exposures: Jet fuel is the largest variable cost. United is highly exposed to crude oil and refining crack spread volatility.
- How COGS scales with revenue: Fuel scales directly with ASMs flown, not necessarily with revenue (empty seats burn almost as much fuel as full ones).
Operating Expenses
- Salaries and related costs: The largest expense line item. Driven by union contracts (pilots, flight attendants, mechanics) and headcount.
- Aircraft maintenance materials and outside repairs: Driven by fleet age, flight hours, and maintenance cycles.
- Depreciation and amortisation: High (typically 5% to 7% of revenue) due to the capital-intensive nature of aircraft ownership.
- Regional capacity purchase: Payments to regional partners (e.g., SkyWest) to operate United Express flights.
- Restructuring / one-time charges: Occasional special charges for fleet retirements or voluntary separation programmes.
Margin Profile
- Pre-tax margin: The primary profitability metric for the industry. United achieved a 7.3% pre-tax margin in FY2025, targeting double digits.
- Operating margin: Typically ranges from 7% to 10%.
- Margin trend: Expanding due to premium cabin strength and cost convergence across the industry, though fuel price spikes can cause sudden compression.
- Segment-level margins: Not explicitly disclosed; the network operates as an integrated system.
Balance Sheet Structure
- Total assets: Approximately $75 billion to $80 billion.
- Key asset categories: Property and equipment (aircraft, engines, flight simulators) and Operating lease right-of-use assets.
- Goodwill & intangibles: Minimal relative to total assets, primarily route authorities and airport slots.
- Working capital profile:
- Days Sales Outstanding (DSO): Very low (10 to 15 days) as most tickets are paid for upfront via credit card.
- Days Inventory Outstanding (DIO): Minimal (spare parts and fuel inventory).
- Days Payable Outstanding (DPO): 30 to 45 days.
- Net working capital as % of revenue: Structurally negative.
- Working capital advantage: The company funds operations through negative working capital. Passengers pay in advance, creating a large "Advance ticket sales" liability that acts as free financing.
- PP&E: Dominated by flight equipment. Aircraft are typically depreciated over 15 to 30 years to a residual value.
- Right-of-use assets: Highly material due to leased aircraft and airport terminal space.
Capital Expenditure & Investment
- Capex as % of revenue: 12% to 16% (historically high due to the United Next fleet renewal programme).
- Maintenance capex vs. growth capex: Approximately 30% maintenance (engine overhauls, IT) and 70% growth/replacement (new aircraft deliveries).
- Major capex programmes: Taking delivery of over 100 narrowbody aircraft and approximately 20 Boeing 787s in 2026.
- Capitalised software: Present but immaterial compared to aircraft capex.
- M&A pattern: Organic grower. Major M&A is rare due to antitrust scrutiny (the last major deal was the Continental merger in 2010).
Debt & Capital Structure
- Total debt: Approximately $25.0 billion (including finance lease obligations) at the end of FY2025.
- Debt/EBITDA ratio: Net leverage sits at approximately 2.2x (trailing twelve months).
- Credit rating: Non-investment grade (high yield), typical for legacy airlines.
- Key debt instruments: Enhanced Equipment Trust Certificates (EETCs) secured by aircraft, term loans, and loyalty programme-backed debt (MileagePlus financing).
- Maturity profile: Lumpy, tied to specific aircraft financing tranches.
- Interest rate profile: A mix of fixed (EETCs) and floating (term loans).
- Covenants: Minimum liquidity requirements and collateral coverage ratios on secured debt.
- Share repurchase programme: Active. Repurchased $640 million of shares in FY2025.
- Dividend policy: The company does not currently pay a dividend, prioritising fleet investment and share repurchases.
Cash Flow Characteristics
- Operating cash flow conversion: High. OCF was $8.4 billion in FY2025 on $3.4 billion of net income (roughly 2.4x conversion).
- Free cash flow margin: 4% to 5% (FCF was $2.7 billion in FY2025).
- Major non-cash items: Depreciation and amortisation, deferred income taxes, and stock-based compensation.
- Working capital cash flow impact: Advance ticket sales provide a massive cash inflow during the spring booking season (Q1/Q2) and a cash outflow when flights are taken in the summer (Q3).
- Capex intensity: Extremely high, consuming the majority of operating cash flow.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are often lower than GAAP taxes due to accelerated depreciation on new aircraft deliveries and historical net operating losses (NOLs).
Sheet Structure
- Assumptions: Macroeconomic drivers (GDP, jet fuel prices), segment capacity (ASMs), yield growth, and cost inflation rates.
- Operating Statistics: Calculation of ASMs, RPMs, Load Factor, Passenger Yield, PRASM, TRASM, CASM, CASM-ex, and fuel efficiency (ASMs per gallon).
- Revenue Schedule: Passenger revenue broken out by Domestic, Atlantic, Pacific, and Latin America, plus Cargo and Other operating revenue.
- Operating Expenses: Line-item build of Salaries and related costs, Aircraft fuel, Landing fees, Regional capacity purchase, Maintenance, and D&A.
- Income Statement: Consolidated view from Total operating revenue down to Net income and EPS.
- Balance Sheet: Assets (Cash, PP&E, ROU assets), Liabilities (Advance ticket sales, Debt, Leases), and Equity.
- Cash Flow Statement: Operating cash flow (bridged from Net Income), Investing cash flow (Capex), and Financing cash flow (Debt issuance/repayment, share repurchases).
- Debt & Interest Schedule: Tracking of EETCs, term loans, finance leases, and calculation of interest expense.
- DCF Valuation: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price.
Key Financial Relationships
- `Total ASMs = Domestic ASMs + Atlantic ASMs + Pacific ASMs + Latin America ASMs`
- `Passenger Revenue (by segment) = Segment ASMs x Segment Load Factor x Segment Yield`
- `Total Operating Revenue = Total Passenger Revenue + Cargo Revenue + Other Operating Revenue`
- `Fuel Gallons Consumed = Total ASMs / Fuel Efficiency (ASMs per Gallon)`
- `Aircraft Fuel Expense = Fuel Gallons Consumed x Average Fuel Price per Gallon`
- `CASM (Cost per Available Seat Mile) = Total Operating Expenses / Total ASMs`
- `CASM-ex = (Total Operating Expenses - Aircraft Fuel - Profit Sharing - Special Charges) / Total ASMs`
- `TRASM (Total Revenue per Available Seat Mile) = Total Operating Revenue / Total ASMs`
- `Advance Ticket Sales Liability = Forward 90 Days Passenger Revenue x (Average Booking Window / 90)`
- `Pre-tax Margin = Income Before Income Taxes / Total Operating Revenue`
- `Net Leverage = (Total Debt + Finance Leases - Cash and Cash Equivalents) / Adjusted EBITDAR`
Cross-Sheet Dependencies
- The Assumptions sheet dictates ASM growth and fuel prices, which feed directly into the Operating Statistics sheet.
- The Operating Statistics sheet drives the Revenue Schedule (via ASMs and Yields) and the Operating Expenses sheet (via ASMs driving fuel gallons and CASM-ex costs).
- The Revenue Schedule and Operating Expenses sheet feed the Income Statement.
- The Income Statement provides Net Income to the Cash Flow Statement and Retained Earnings to the Balance Sheet.
- The Balance Sheet calculates the change in Advance Ticket Sales, which is a critical working capital adjustment on the Cash Flow Statement.
- The Debt & Interest Schedule creates a circularity loop: Debt balances drive Interest Expense on the Income Statement, which impacts Net Income, which impacts Cash Flow, which determines the need for revolver drawdowns or debt paydowns on the Debt Schedule.
Sign Convention
- Revenues and Assets: Modelled as positive numbers.
- Expenses and Liabilities: Modelled as positive numbers in their respective build schedules. They are subtracted in aggregation formulas (e.g., `Operating Income = Total Revenue - Total Operating Expenses`).
- Cash Flow: Inflows are positive, outflows are negative.
- Contra-accounts: Treasury stock and accumulated depreciation are modelled as negative numbers on the balance sheet.
Things Most Likely to Go Wrong
- CASM-ex miscalculation: Failing to exclude fuel, profit sharing, and special charges from total operating expenses will result in an inaccurate CASM-ex metric, which is the primary benchmark for airline cost control.
- Working capital disconnect: Advance ticket sales must grow proportionally with passenger revenue. If revenue grows but advance ticket sales remain flat, operating cash flow will be severely understated.
- Fuel efficiency stagnation: The model must assume a gradual increase in ASMs per gallon. Holding fuel efficiency flat ignores the primary economic benefit of the massive United Next fleet renewal programme.
- Regional capacity double-counting: Regional capacity purchase agreements contain both a revenue component (tickets sold by United) and a cost component (payments to the regional operator). Ensure these are modelled in their respective line items.
- Seasonality smoothing: Using a straight quarterly allocation for cash flow will break the model. Q1 generates massive cash from summer bookings, while Q3 shows strong accounting earnings but weaker cash flow as deferred revenue is recognised.
- Ignoring share count reduction: United is actively repurchasing shares ($640 million in FY2025). Holding the share count flat will understate EPS growth.
- Capex cliff: Assuming capex drops to maintenance levels immediately after the explicit forecast period will artificially inflate the terminal value. Aircraft replacement is a continuous cycle.
- Tax rate normalisation: The cash tax rate is significantly lower than the GAAP effective tax rate due to accelerated depreciation on new aircraft. Failing to separate deferred taxes will understate free cash flow.
Validation Checks
- "Pre-tax margin should be in the 7.0% to 10.0% range; flag if outside this band."
- "CASM-ex year-over-year growth should remain between 0% and 3% to reflect cost control initiatives."
- "Fuel expense as a percentage of total operating revenue should typically sit between 20% and 25%."
- "Net leverage (Net Debt / Adjusted EBITDAR) should remain below 2.5x per management targets."
- "Advance ticket sales should represent approximately 12% to 15% of forward twelve-month passenger revenue."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Operating cash flow conversion (OCF / Net Income) should be greater than 2.0x due to high D&A and deferred revenue dynamics."
- "Total ASMs must exactly equal the sum of Domestic, Atlantic, Pacific, and Latin America ASMs."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Total ASM Growth | 5.0 | % | Blended growth rate reflecting the United Next fleet expansion |
| Domestic Yield | 0.19 | $ | Based on recent historical averages and premium cabin strength |
| System Load Factor | 83.5 | % | Consistent with FY2024/FY2025 operational performance |
| Average Fuel Price | 2.49 | $/gallon | Pegged to FY2025 actuals; adjust based on forward curve |
| Fuel Efficiency Improvement | 1.5 | % YoY | Reflects the introduction of new, fuel-efficient Boeing 787s and MAXs |
| CASM-ex Growth | 1.5 | % YoY | Reflects underlying inflation offset by gauge benefits (larger planes) |
| Other Operating Rev Growth | 9.0 | % YoY | Driven by strong co-brand credit card spend and loyalty growth |
| Capex as % of Revenue | 14.0 | % | High capital intensity due to heavy aircraft delivery schedule |
| Effective Tax Rate | 23.0 | % | Standard corporate rate plus state taxes |
| Share Repurchases | 650 | $ Millions | Aligned with FY2025 actuals ($640M) and management capital return focus |
| Cost of Debt | 6.5 | % | Weighted average interest rate on EETCs and term loans |
| WACC | 9.0 | % | Reflects the high beta and cyclical risk of the airline industry |
| Terminal Growth Rate | 2.0 | % | Long-term GDP growth proxy |
Data Sources & Benchmarks
- Filings: SEC EDGAR (United Airlines Holdings, Inc. 10-K and 10-Q filings), United Investor Relations website.
- Key Peers: Delta Air Lines (DAL), American Airlines (AAL), Southwest Airlines (LUV).
- Industry Data: Bureau of Transportation Statistics (BTS) for domestic traffic and yield data, Airlines for America (A4A) for industry cost indices, and IATA for global cargo and passenger trends.
- Consensus Estimates: Bloomberg or FactSet for forward ASMs, CASM-ex, and EPS estimates.
- Proprietary Data: Credit card transaction data panels (e.g., YipitData) to track direct-to-consumer booking trends and co-brand card spend.
Sources
- United Airlines Holdings, Inc. Form 10-K for the fiscal year ended December 31, 2024 (SEC EDGAR).
- United Airlines Holdings, Inc. Form 10-Q filings for FY2025 (SEC EDGAR).
- United Airlines Q4 and Full-Year 2025 Earnings Press Release (January 20, 2026).
- United Airlines Investor Relations: United Next Presentations and historical Financial and Operational metrics.
Do more with the United Airlines Holdings model
Frequently asked
What is United Airlines Holdings' core business model?+
United Airlines Holdings operates a global airline network, transporting people and cargo across North America and to international destinations in Asia, Europe, Africa, the Pacific, the Middle East, and Latin America. The company utilizes a hub-and-spoke system with major domestic hubs in key US cities.
What are the primary revenue streams for United Airlines Holdings?+
Passenger Revenue accounts for approximately 90% of United Airlines Holdings' total revenue, driven by ticket sales across various geographies. Other significant revenue streams include Other Operating Revenue, primarily from the MileagePlus loyalty program and United Club, and Cargo revenue.
What is United Airlines Holdings' capital expenditure strategy?+
United Airlines Holdings has a historically high capital expenditure, projected at 12% to 16% of revenue, primarily due to its "United Next" fleet renewal program. This program involves taking delivery of over 100 narrowbody aircraft and approximately 20 Boeing 787s in 2026, with about 70% of capex dedicated to growth and replacement.
How does United Airlines Holdings' working capital profile impact its operations?+
United Airlines Holdings benefits from a structurally negative net working capital as a percentage of revenue, creating a working capital advantage. Passengers typically pay for tickets in advance, generating a large "Advance ticket sales" liability that acts as free financing for the company's operations.
What is the main purpose of a financial model for United Airlines Holdings?+
A financial model for United Airlines Holdings aims to evaluate its equity valuation and free cash flow generation. It helps an equity analyst determine the impact of capacity expansion, fuel price volatility, and macroeconomic demand on the company's path to achieving double-digit pre-tax margins.
Can I download an Excel financial model for United Airlines Holdings (UAL)?+
Yes, a downloadable Excel financial model is available for United Airlines Holdings (UAL). This general corporate model provides a forecast horizon from FY2026 to FY2030, allowing users to analyze key financial assumptions and projections for the company.
Have more financial modelling questions? Contact us
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 Transportation Company Financial Models
Browse another company in the same sector.
C.H. Robinson
C.H.
CSX
CSX Corporation is a premier Class I freight railroad operating a 20,000 route-mile network across the eastern United States and parts of Canada.
Delta Air Lines
Delta Air Lines is one of the world's largest global network airlines, providing scheduled air transportation for passengers and cargo.
Expeditors International
Expeditors International of Washington, Inc.
FedEx
FedEx Corporation provides a broad portfolio of transportation, e-commerce, and business services globally.
J.B. Hunt
J.B.
Southwest Airlines
Southwest Airlines (NYSE: LUV) is a major US passenger airline operating a low-cost carrier (LCC) business model primarily focused on domestic point-to-point transit.
Norfolk Southern
Norfolk Southern Corporation is a premier Class I freight railroad operating an extensive network of approximately 19,200 route miles across 22 states and the District of Columbia in the eastern United States.
Explore more Manufacturing financial model templates.
