Delta Air Lines Financial Model
Transportation Company Financials Example (Free Excel Download)
Delta Air Lines is one of the world's largest global network airlines, providing scheduled air transportation for passengers and cargo.
professionals from Deloitte
Used by professionals from
About this model
This model projects Delta Air Lines' future cash flows and earnings to determine its intrinsic equity valuation and assess its credit profile for debt repayment capacity.
Delta Air Lines is one of the world's largest global network airlines, providing scheduled air transportation for passengers and cargo. The company operates a hub-and-spoke system with a significant presence in key domestic and international markets.
The business is divided into two reporting segments: the Airline segment (which generates the vast majority of revenue through passenger tickets, cargo, and loyalty programmes) and the Refinery segment (the Monroe Energy refinery in Trainer, Pennsylvania, which primarily produces jet fuel for the airline and sells non-jet fuel products to third parties). The Airline segment's passenger revenue is further split by geography into Domestic, Atlantic, Latin America, and Pacific. Delta operates an asset-heavy business model requiring significant capital investment in aircraft, though it has increasingly diversified its revenue streams through its highly profitable SkyMiles loyalty programme and American Express co-brand credit card partnership. The company holds a premium competitive position in the US market, consistently commanding a revenue premium over peers due to its operational reliability and corporate travel market share. Recently, Delta has focused heavily on debt reduction, regaining its investment-grade credit rating in 2024, and navigating supply chain constraints while modernising its fleet.
The downloadable Delta Air Lines 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 & AssumptionsDelta Air Lines financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $29.90B | $50.58B | $58.05B | $61.64B | $63.36B |
| Income Before Income Taxes | $398.0M | $1.91B | $5.61B | $4.66B | $6.18B |
| Operating income | $1.89B | $3.66B | $5.52B | $6.00B | $5.82B |
| Net income | $280.0M | $1.32B | $4.61B | $3.46B | $5.00B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Delta Air Lines
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Passenger Revenue
- Segment name: Passenger Revenue (reported by region: Domestic, Atlantic, Latin America, Pacific)
- Revenue driver formula: Available Seat Miles (ASM) x Passenger Revenue per ASM (PRASM); alternatively, Revenue Passenger Miles (RPM) x Yield.
- Historical growth rate: 3-6% CAGR (normalised post-pandemic recovery).
- Key growth levers and headwinds: Corporate travel recovery, premium seating expansion (Delta One, Premium Select), international capacity growth, and macroeconomic impacts on consumer leisure spending.
- Pricing dynamics: Highly dynamic, algorithmically driven pricing based on booking curves, competitor capacity, and seasonal demand.
- Revenue recognition notes: Recognised when the transportation is provided. Unused tickets are held as an air traffic liability and recognised based on historical breakage patterns.
- Seasonality: The June and September quarters are the strongest due to summer leisure travel, while the March quarter is typically the weakest.
Cargo Revenue
- Segment name: Cargo
- Revenue driver formula: Cargo Ton Miles x Freight Yield.
- Historical growth rate: Highly volatile; surged during the pandemic but has normalised to low-single-digit growth (grew 9% in FY2025).
- Key growth levers and headwinds: Global supply chain dynamics, dedicated freighter competition, and belly-space capacity on international widebody flights.
- Pricing dynamics: Spot market pricing and long-term freight forwarder contracts.
- Revenue recognition notes: Recognised when the cargo transportation is provided.
- Seasonality: Peaks in the fourth quarter ahead of the holiday retail season.
Other Revenue (Including Loyalty and Refinery)
- Segment name: Other Revenue (Loyalty program, Refinery, Ancillary businesses, Miscellaneous)
- Revenue driver formula: American Express remuneration + Third-party refinery sales + MRO (Maintenance, Repair, and Overhaul) volume.
- Historical growth rate: 6-10% CAGR, driven heavily by the Amex partnership.
- Key growth levers and headwinds: Credit card spend volumes, new card acquisitions, and refinery crack spreads.
- Pricing dynamics: Contractual remuneration rates with American Express; spot market pricing for third-party refinery sales.
- Revenue recognition notes: Loyalty revenue has multiple components. The travel component is deferred and recognised when miles are redeemed. The marketing/brand component is recognised as miles are delivered.
- Seasonality: Less seasonal than passenger revenue, providing a stable cash flow buffer.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Aircraft fuel and related taxes, regional carrier expense, passenger commissions, and landing fees.
- Gross margin range: Airlines typically look at operating margin rather than gross margin, but fuel typically consumes 20-25% of total revenue.
- Key input costs and commodity exposures: Jet fuel is the single largest variable cost. Delta's Monroe Energy refinery provides a partial natural hedge, typically yielding a few cents per gallon benefit.
- How COGS scales with revenue: Fuel scales directly with capacity (ASMs) and fleet efficiency, not directly with revenue.
Operating Expenses
- Salaries and related costs: The largest operating expense. Driven by headcount, union contracts (e.g., the 2023 pilot contract), and annual wage increases.
- Profit Sharing: Delta has an industry-leading profit-sharing programme. It typically pays 10% of pre-tax income up to $2.5 billion, and 20% of pre-tax income above that threshold.
- Aircraft maintenance materials and outside repairs: Scales with flight hours and fleet age.
- Depreciation & Amortisation: Typically 5-7% of revenue, driven by the capital-intensive nature of aircraft ownership.
- Restructuring / one-time charges: Infrequent in normal environments, but fleet retirement charges occur during major transitions.
Margin Profile
- Operating margin: 9-13% (FY2025 operating margin was 9.2%).
- Pre-tax margin: 9-12% (FY2025 pre-tax margin was 9.8%).
- Margin trend: Expanding slightly as premium revenue outpaces capacity growth and the company leverages its fixed cost base, though offset by structural labour cost increases.
Balance Sheet Structure
- Total assets: Approximately $70-75 billion.
- Key asset categories: Property and Equipment (primarily aircraft) makes up over 45% of total assets. Operating lease right-of-use assets are also material.
- Goodwill & intangibles: Approximately $10 billion, stemming from the Northwest Airlines merger and international joint venture slots/routes.
- Working capital profile:
- Air Traffic Liability: A massive current liability representing tickets sold for future travel.
- Loyalty Program Deferred Revenue: A significant liability representing unredeemed SkyMiles.
- Net working capital: Structurally negative. Delta collects cash for tickets and SkyMiles well before the service is provided, creating a negative working capital advantage that funds operations.
- PP&E: Owned aircraft, ground equipment, and terminal improvements. Aircraft are typically depreciated over 25-30 years to a 10-20% residual value.
- Right-of-use assets: Material, representing leased aircraft and airport terminal space.
Capital Expenditure & Investment
- Capex as % of revenue: Typically 8-10% (approximately $5.5 billion expected in 2026).
- Maintenance capex vs. growth capex: Roughly 40% maintenance (engine overhauls, IT, ground equipment) and 60% growth/replacement (new aircraft deliveries).
- Major capex programmes underway: Fleet renewal focusing on Airbus A321neos, A350s, and A330-900neos to improve fuel efficiency (gallons per 1,000 ASMs).
- Capitalised software: Material but small relative to aircraft capex; focused on customer-facing digital tools.
- M&A pattern: Delta historically took minority equity stakes in foreign partners (Virgin Atlantic, Aeromexico, LATAM, Air France-KLM) rather than outright acquisitions.
Debt & Capital Structure
- Total debt: Approximately $14.1 billion in total debt and finance lease obligations at the end of FY2025.
- Debt/EBITDA ratio: Adjusted debt to EBITDAR is approximately 2.4x, with a long-term target of 2.0x or lower.
- Credit rating: Investment grade (BBB- equivalent) across all three major rating agencies as of 2024.
- Key debt instruments: Unsecured bonds, enhanced equipment trust certificates (EETCs) secured by aircraft, and term loans.
- Maturity profile: Well-laddered, with the company actively paying down high-cost debt incurred during the pandemic.
- Interest rate profile: Predominantly fixed-rate debt due to the nature of aircraft financing.
- Share repurchase programme: The company historically returned significant capital via buybacks but paused this to focus on debt reduction; buybacks are a potential upside lever as leverage targets are met.
- Dividend policy: Reinstated post-pandemic, currently offering a modest yield with room for growth as free cash flow expands.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong. FY2025 operating cash flow was $8.3 billion on $5.0 billion of net income.
- Free cash flow margin: 5-7% (FY2025 FCF was $4.6 billion on $63.4 billion of revenue).
- Major non-cash items: Depreciation and amortisation (over $3 billion annually) and deferred income taxes.
- Working capital cash flow impact: Highly seasonal. Cash flow is strongest in the March and June quarters as customers book summer travel, building the air traffic liability.
- Capex intensity: High. The business requires constant reinvestment in the fleet to maintain competitive product offerings and fuel efficiency.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic factors, fuel prices, capacity growth, and cost inflation.
- Operating Stats: Calculation of ASMs, RPMs, Load Factor, Yield, PRASM, TRASM, and CASM (Total and Non-Fuel).
- Revenue: Passenger revenue split by Domestic, Atlantic, Latin America, and Pacific. Separate lines for Cargo and Other Revenue (Loyalty, Refinery, Ancillary).
- Operating Expenses: Line items for Salaries, Fuel, Regional Carriers, Maintenance, Passenger Commissions, D&A, and Profit Sharing.
- Income Statement: Consolidated view from Operating Revenue down to Net Income and EPS.
- Balance Sheet: Assets (Cash, Receivables, PP&E, ROU Assets, Goodwill) and Liabilities (Air Traffic Liability, Loyalty Deferred Revenue, Debt, Leases).
- Cash Flow Statement: OCF (starting from Net Income, adding back D&A, adjusting for Air Traffic Liability and Loyalty changes), CFI (Capex), and CFF (Debt paydown, dividends).
- Debt & Leases: Waterfall schedule for existing debt maturities, new aircraft financing, and finance lease obligations.
- DCF Valuation: Unlevered free cash flow calculation, WACC build-up, terminal value, and implied share price.
Key Financial Relationships
- "Passenger Revenue = Available Seat Miles (ASM) x Passenger Revenue per ASM (PRASM)"
- "Total Revenue = Passenger Revenue + Cargo Revenue + Other Revenue"
- "Fuel Expense = (ASM / Fuel Efficiency [Gallons per 1,000 ASMs]) x Average Fuel Price per Gallon"
- "Non-Fuel Operating Expense = Total Operating Expense - Fuel Expense - Profit Sharing"
- "Non-Fuel CASM = Non-Fuel Operating Expense / ASM"
- "Profit Sharing Expense = IF(Pre-Tax Income < 2500, Pre-Tax Income * 0.10, (2500 * 0.10) + ((Pre-Tax Income - 2500) * 0.20))"
- "Operating Margin = Operating Income / Total Revenue"
- "Adjusted Debt = Total Debt + Finance Leases + Operating Lease Liabilities"
- "EBITDAR = Operating Income + Depreciation & Amortisation + Aircraft Rent"
- "Free Cash Flow = Operating Cash Flow - Capital Expenditures"
- "Air Traffic Liability Ending Balance = Beginning Balance + New Tickets Sold - Revenue Recognised for Travel Flown"
- "Loyalty Revenue = Travel Miles Redeemed + Non-Travel Miles Redeemed + American Express Remuneration"
Cross-Sheet Dependencies
- The Assumptions sheet feeds capacity (ASM) and pricing (Yield/PRASM) into the Operating Stats sheet.
- The Operating Stats sheet calculates total ASMs and fuel efficiency, which feed directly into the Revenue and Operating Expenses sheets.
- The Operating Expenses sheet calculates Profit Sharing, which requires a circular reference or an iterative calculation because Profit Sharing depends on Pre-Tax Income (from the Income Statement), but Pre-Tax Income is after Operating Expenses.
- The Income Statement feeds Net Income to the Cash Flow Statement.
- The Cash Flow Statement calculates ending cash and debt paydowns, which feed the Balance Sheet and Debt & Leases sheets.
- The Debt & Leases sheet calculates Interest Expense, which flows back to the Income Statement.
Sign Convention
- Revenue and income items are entered as positive numbers.
- Expenses and cash outflows are entered as positive numbers in their respective build-up schedules, but subtracted in the Income Statement and Cash Flow Statement totals.
- Contra-revenue items (if any) are entered as negative numbers.
- In the Cash Flow Statement, an increase in an asset is a negative number (cash outflow), and an increase in a liability is a positive number (cash inflow).
Things Most Likely to Go Wrong
- Profit sharing circularity: The profit-sharing formula relies on pre-tax income, which itself is reduced by the profit-sharing expense. The model must calculate a "Pre-Tax Income before Profit Sharing" subtotal to avoid an Excel circularity error.
- Refinery gross-up: The Monroe Energy refinery sells products to third parties, which inflates both "Other Revenue" and "Operating Expenses". Analysts often look at "Adjusted Revenue" and "Adjusted CASM" excluding refinery sales to compare Delta to peers. The model must clearly separate refinery impacts.
- Fuel hedging mark-to-market: Delta occasionally records mark-to-market adjustments on fuel hedges. These should be excluded from core operating profit projections.
- Loyalty deferred revenue timing: The balance of deferred revenue grows when miles are issued and shrinks when redeemed. Projecting this requires careful assumptions about redemption rates; getting it wrong will break the cash flow from working capital.
- Air Traffic Liability seasonality: If building a quarterly model, failing to account for the massive cash inflow in Q1/Q2 and outflow in Q3/Q4 will result in inaccurate cash balances and interest income projections.
- CASM vs CASM-Ex: The industry standard metric is CASM-Ex (excluding fuel and profit sharing). If the model divides total operating expenses by ASMs to benchmark cost control, it will incorrectly penalise the company when fuel prices rise.
- Operating vs Finance Leases: Ensure the principal portion of finance leases is captured in CFF, while operating lease payments are captured in OCF, to match the company's reported cash flow metrics.
- Share count dilution: Ensure the model accounts for the dilution of equity awards when calculating EPS, as Delta's share count has crept up slightly due to compensation plans.
Validation Checks
- "Load factor should remain between 82% and 88%; flag if the model projects >90% as this is operationally impossible across a global network."
- "Fuel efficiency (Gallons per 1,000 ASMs) should show a slight downward trend (improvement) from the current 14.3 baseline as new aircraft are delivered."
- "Adjusted Debt to EBITDAR should remain below 3.0x; flag if leverage spikes, indicating a breach of rating agency targets."
- "Free Cash Flow should be positive and in the $3.0 billion to $4.5 billion range based on management's long-term framework."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every projected year."
- "Non-fuel CASM growth should not exceed 2-3% annually; flag if higher, as this violates management's long-term cost control targets."
- "Profit sharing expense should equal roughly 10-15% of pre-tax income; flag if the effective rate falls outside this band."
- "Operating margin should remain in the 9-14% historical band; flag if the model projects margins expanding beyond peak historical levels."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| ASM Growth (Capacity) | 3.0 | % | Aligns with management's FY2026 guidance and long-term GDP+ framework. |
| Load Factor | 85.0 | % | Consistent with recent historical averages and post-pandemic normalisation. |
| Passenger Yield Growth | 1.0 | % | Assumes modest pricing power offset by capacity additions. |
| Fuel Price per Gallon | 2.30 | $ | Based on FY2025 adjusted fuel price; adjust based on current forward curve. |
| Fuel Efficiency | 14.3 | Gal/1k ASM | FY2025 actual; expected to improve slightly as older fleet retires. |
| Non-Fuel CASM Growth | 2.0 | % | Aligns with management's target of low-single-digit non-fuel unit cost growth. |
| Cargo Revenue Growth | 2.0 | % | Normalised growth following the FY2025 9% surge. |
| Loyalty Revenue Growth | 6.0 | % | Driven by American Express partnership growth and premium card acquisitions. |
| Profit Sharing Rate (Tier 1) | 10.0 | % | Contractual rate on first $2.5B of pre-tax income. |
| Profit Sharing Rate (Tier 2) | 20.0 | % | Contractual rate on pre-tax income above $2.5B. |
| Effective Tax Rate | 23.0 | % | Standard US corporate rate plus state taxes, consistent with recent filings. |
| Capex | 5.5 | $ Billions | Management guidance for FY2026 reinvestment. |
| WACC | 8.5 | % | Typical cost of capital for a legacy US network airline. |
| Terminal Growth Rate | 2.0 | % | Long-term macroeconomic growth proxy. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Delta Air Lines Investor Relations website (ir.delta.com) for quarterly earnings presentations and monthly traffic statistics.
- Peers for benchmarking: United Airlines (UAL), American Airlines (AAL), Southwest Airlines (LUV).
- Industry data sources: Bureau of Transportation Statistics (BTS) for domestic market share and yield data; Airlines for America (A4A) for industry-wide cost and traffic trends; IATA for global cargo and passenger demand forecasts.
- Consensus estimates: Bloomberg or FactSet for forward-looking EPS, TRASM, and CASM-Ex consensus to validate model outputs against street expectations.
Sources
Do more with the Delta Air Lines model
Frequently asked
What is Delta Air Lines' primary business?+
Delta Air Lines is one of the world's largest global network airlines, providing scheduled air transportation for passengers and cargo. The company operates a hub-and-spoke system with a significant presence in key domestic and international markets.
How does Delta Air Lines generate its revenue?+
The vast majority of Delta's revenue comes from its Airline segment, primarily through passenger tickets, cargo, and loyalty programs. The company has also diversified its revenue streams through its highly profitable SkyMiles loyalty program and American Express co-brand credit card partnership.
What is Delta Air Lines' typical capital expenditure as a percentage of revenue?+
Delta Air Lines typically allocates 8-10% of its revenue to capital expenditures, with approximately $5.5 billion expected in 2026. These investments are roughly 40% for maintenance and 60% for growth or replacement, focusing on fleet renewal to improve fuel efficiency.
How is Delta Air Lines' net working capital structured?+
Delta Air Lines has a structurally negative net working capital profile, driven by large current liabilities like Air Traffic Liability and Loyalty Program Deferred Revenue. This negative working capital provides a funding advantage, as the company collects cash for services well before they are provided.
What is the main purpose of the Delta Air Lines financial model?+
The financial model projects Delta Air Lines' future cash flows and earnings. Its primary purpose is to determine the company's intrinsic equity valuation and assess its credit profile for debt repayment capacity.
Is an Excel financial model available for Delta Air Lines?+
Yes, a downloadable Excel financial model is available for Delta Air Lines. This model provides projections from FY2026 to FY2030 and includes key assumptions for revenue growth, cost structures, and capital expenditures.
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.
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.
Old Dominion
Old Dominion Freight Line (ODFL) is one of the largest North American less-than-truckload (LTL) motor carriers, providing regional, inter-regional, and national LTL services through a single integrated, union-free organisation.
Explore more Manufacturing financial model templates.
