Southwest Airlines Financial Model
Transportation Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and cash flow generation of Southwest Airlines, specifically quantifying the financial impact of its historic 2025/2026 strategic transformation (ending open seating, introducing premium cabins, and adding bag fees) amidst pressure from activist investors.
- 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.
- Business segments: Passenger Revenue (~89%), Other Revenue (Rapid Rewards, EarlyBird, ancillary fees) (~10%), and Freight Revenue (~1%).
- Key geographies: Primarily United States, with limited near-international routes to Mexico, Central America, and the Caribbean.
- Business model type: Asset-heavy transportation network. Historically differentiated by a single aircraft type (Boeing 737), open seating, and a "Bags Fly Free" policy.
- Competitive position: One of the "Big Four" US airlines. It holds a dominant market share in several key domestic airports (e.g., Dallas Love Field, Chicago Midway) but has recently faced margin compression relative to legacy peers (Delta, United) who successfully monetised premium cabins.
- Recent major events: Following an activist campaign by Elliott Investment Management in 2024, Southwest overhauled its board and announced the largest strategic shift in its 53-year history. The airline is ending open seating (effective January 2026), introducing extra-legroom premium seating, launching red-eye flights, and introducing a "Basic" fare with bag fees (effective May 2025).
The downloadable Southwest Airlines 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 & AssumptionsSouthwest Airlines financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $15.79B | $23.81B | $26.09B | $27.48B | $28.06B |
| INCOME BEFORE INCOME TAXES | $1.32B | $728.0M | $633.0M | $598.0M | $563.0M |
| Operating income | $1.72B | $1.02B | $224.0M | $321.0M | $428.0M |
| Net income | $977.0M | $539.0M | $465.0M | $465.0M | $441.0M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Southwest Airlines
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 driver formula: Available Seat Miles (ASMs) × Passenger Revenue per ASM (PRASM) *OR* Revenue Passenger Miles (RPMs) × Yield.
- Historical growth rate: 2-5% historically, heavily dependent on capacity additions and macroeconomic demand.
- Key growth levers and headwinds: The introduction of assigned seating and premium extra-legroom seats (first 5 rows and exit rows) is projected by management to unlock $1.8 billion in additional EBIT by 2026. Headwinds include Boeing 737 MAX delivery delays constraining capacity growth.
- Pricing dynamics: Highly competitive and dynamic (algorithmic revenue management). Fares are spot-priced based on booking curves.
- Revenue recognition notes: Revenue is recognised when the transportation is provided. Tickets sold but not yet flown are recorded as "Air Traffic Liability" (unearned revenue).
- Seasonality: Q2 and Q3 are historically the strongest due to summer leisure travel; Q1 is typically the weakest.
Other Revenue
- Segment name: Other
- Revenue driver formula: Loyalty Program (Rapid Rewards) points sold to partners + Ancillary Fees (EarlyBird Check-In, Upgraded Boarding).
- Historical growth rate: 5-8% CAGR.
- Key growth levers and headwinds: *Critical modelling note:* EarlyBird Check-In revenue will structurally decline to near-zero in 2026 as the airline shifts to assigned seating. This must be offset in the model by the new "Choice Extra" and premium seat upgrade fees.
Freight Revenue
- Segment name: Freight
- Revenue driver formula: Cargo ton miles × Yield per ton mile.
- Historical growth rate: Flat to declining (post-pandemic normalisation).
Cost Structure
Variable Costs / COGS (Airline Operating Expenses)
- Line-by-line breakdown: Salaries, wages, and benefits; Fuel and oil; Maintenance materials and repairs; Landing fees and other rentals.
- Gross margin range: Airlines typically look at Operating Margin rather than Gross Margin. Operating margins have compressed from historical 10-15% down to 1-3% recently.
- Key input costs and commodity exposures: Jet fuel is the largest volatile cost (~25% of revenue). Southwest uses a rolling hedging programme (call options and collars) to mitigate fuel price spikes.
- How COGS scales with revenue: Costs scale primarily with capacity (ASMs) and block hours flown, not directly with revenue.
Operating Expenses
- Salaries, wages, and benefits: The largest expense (~40% of revenue). Highly unionised workforce; recent pilot and flight attendant contract renewals have driven step-function increases in unit costs.
- Depreciation & Amortisation: ~5-6% of revenue, driven by the owned Boeing 737 fleet.
- Other operating expenses: Advertising, IT, and passenger convenience.
- Restructuring / one-time charges: Frequent adjustments for sale-leaseback gains (e.g., $92M gain in Q4 2024) and voluntary separation programmes.
Margin Profile
- Operating margin: 1.5% - 4.0% (recent 3-year range).
- Net margin: 1.0% - 3.0%.
- Margin trend: Compressing due to inflationary wage pressures and air traffic control delays, but expected to expand in 2025/2026 as premium seating revenue drops to the bottom line and CASM-ex fuel growth slows to low-single digits.
Balance Sheet Structure
- Total assets: ~$35.0 - $37.0 billion.
- Key asset categories: Property and Equipment (PP&E) is the largest asset class, representing owned aircraft. Cash and short-term investments are also massive ($8.7 billion at year-end 2024).
- Goodwill & intangibles: Minimal (historical AirTran acquisition).
- Working capital profile:
- Days Sales Outstanding (DSO): Very low (most tickets paid upfront via credit card).
- Air Traffic Liability (ATL): Massive current liability representing tickets sold for future travel.
- Net working capital: Structurally negative. The airline funds operations through upfront ticket sales (negative NWC advantage).
- PP&E: $13.3 billion in unencumbered aircraft value. Useful life of aircraft is typically 25 years.
- Right-of-use assets / operating leases: Material, representing leased aircraft and airport gate leases.
Capital Expenditure & Investment
- Capex as % of revenue: 8-12%.
- Maintenance capex vs. growth capex: Heavily skewed toward fleet modernization (growth/replacement).
- Major capex programmes underway: 2025 capex is estimated at $2.5B to $3.0B. This includes $1.2B for aircraft (assuming 38 Boeing 737-8 deliveries) and $1.6B for non-aircraft, which includes the massive cabin retrofitting programme to install premium seating across ~800 aircraft.
- M&A pattern: Organic grower; no major M&A since AirTran (2011).
Debt & Capital Structure
- Total debt: ~$6.7 billion outstanding.
- Net debt: Negative (Net cash position of $2.0 billion at year-end 2024).
- Debt/EBITDA ratio: Adjusted debt to invested capital ("leverage") is ~43%.
- Credit rating: Investment grade (BBB/Baa2), though Fitch recently issued a negative outlook regarding execution risks of the new seating strategy.
- Key debt instruments: Unsecured notes, convertible notes, and a fully available $1.0 billion revolving credit facility.
- Share repurchase programme: Highly active. Announced a $750 million accelerated share repurchase (ASR) programme for Q1 2025.
- Dividend policy: Reinstated post-COVID. Paid $430 million in dividends in 2024.
Cash Flow Characteristics
- Operating cash flow conversion: Highly seasonal, driven by the build-up of Air Traffic Liability in Q1/Q2 ahead of summer travel, and the drawdown in Q3.
- Free cash flow margin: 2-5%, but can be negative in years with heavy aircraft deliveries.
- Major non-cash items: Depreciation of aircraft, stock-based compensation, and deferred income taxes.
- Capex intensity: Very high. Aircraft deliveries dictate cash burn. Management frequently uses sale-leasebacks (e.g., 35 aircraft in Q4 2024 generating $871M) to smooth cash flows.
- Cash tax rate: ~22-24% effective tax rate guidance for 2025.
Sheet Structure
- Assumptions: Macro drivers (jet fuel price per gallon), operating stats (ASM growth, Load Factor), unit revenue (TRASM growth), and unit cost (CASM-ex fuel growth).
- Operating Statistics: Fleet count (beginning, deliveries, retirements, ending), ASMs, RPMs, Load Factor, Passenger Yield, Block Hours, Fuel Gallons Consumed.
- Revenue: Passenger revenue, Freight revenue, Other revenue. Includes a specific schedule modelling the phase-out of EarlyBird fees and phase-in of Premium Seating/Bag fees in 2025/2026.
- Operating Expenses: Salaries wages and benefits, Fuel and oil, Maintenance, Landing fees, D&A, Other operating expenses.
- Income Statement: GAAP and Non-GAAP (excluding special items like sale-leaseback gains).
- Balance Sheet: Cash, Air Traffic Liability, PP&E schedule (aircraft vs non-aircraft), Debt.
- Cash Flow Statement: Net Income, D&A, Change in ATL, OCF, Capex (split by aircraft and retrofits), Sale-leaseback proceeds, Dividends, Share Repurchases.
- Debt Schedule: Existing notes, revolver drawdowns, interest expense, interest income on cash balances.
- DCF Valuation: Unlevered free cash flow, WACC calculation, terminal multiple (EV/EBITDAR).
Key Financial Relationships
- `Ending Fleet = Beginning Fleet + Aircraft Deliveries - Aircraft Retirements`
- `Available Seat Miles (ASMs) = Average Fleet × Seats per Aircraft × Average Daily Utilization × Days in Period`
- `Revenue Passenger Miles (RPMs) = ASMs × Load Factor`
- `Passenger Revenue = RPMs × Passenger Yield`
- `Total Operating Revenue per ASM (TRASM) = Total Operating Revenue / ASMs`
- `Fuel Expense = Fuel Gallons Consumed × Average Jet Fuel Price per Gallon (net of hedging)`
- `Cost per ASM (CASM) = Total Operating Expenses / ASMs`
- `CASM-ex Fuel = (Total Operating Expenses - Fuel and Oil Expense - Special Items) / ASMs`
- `Air Traffic Liability Change = Cash Received for Future Flights - Revenue Recognised for Flown Flights`
- `Net Capex = Gross Aircraft Capex + Non-Aircraft Capex - Sale-Leaseback Proceeds`
Cross-Sheet Dependencies
- Operating Statistics is the engine of the model. ASMs drive both Revenue (via TRASM) and Operating Expenses (via CASM).
- Fuel Gallons (Operating Stats) feeds directly into Fuel Expense (Operating Expenses).
- Capex (Cash Flow) feeds PP&E (Balance Sheet), which in turn drives Depreciation (Operating Expenses).
- Air Traffic Liability (Balance Sheet) is the primary working capital driver in the Cash Flow Statement.
- Debt Schedule feeds Interest Expense (Income Statement), creating a circularity if revolver borrowing is required to fund cash shortfalls.
Sign Convention
- Income Statement: Revenues are positive. Expenses are negative.
- Cash Flow Statement: Cash inflows (net income, D&A, increase in liabilities, sale-leaseback proceeds) are positive. Cash outflows (capex, dividends, share repurchases, debt paydown) are negative.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive.
Things Most Likely to Go Wrong
- Mismodelling the 2026 Seating Transition: EarlyBird revenue will collapse in 2026 as open seating ends. If the model extrapolates historical "Other Revenue" growth, it will double-count the new premium seating revenue while failing to remove the cannibalised EarlyBird revenue.
- Ignoring Sale-Leaseback Distortions: Southwest frequently uses sale-leasebacks (e.g., $871M in Q4 2024). These artificially depress Net Capex and inflate Operating Income via one-time gains. The model must strip these out for "Adjusted" metrics.
- Fuel Hedging Complexity: Economic fuel cost rarely matches spot jet fuel prices due to Southwest's extensive hedging portfolio. The model must use a blended "Price per Gallon" assumption rather than raw spot prices.
- Air Traffic Liability Seasonality: ATL builds heavily in Q1/Q2 and unwinds in Q3/Q4. Annual models mask this, but quarterly models will break if ATL is held as a flat % of revenue.
- CASM-ex Step Functions: Pilot and flight attendant wage increases cause sudden, permanent upward shifts in CASM-ex. Do not model CASM-ex as a smooth historical average.
- Boeing Delivery Delays: Management guidance for aircraft deliveries (38 in 2025) is highly subject to Boeing's production issues. The model should have a toggle for delayed deliveries, which directly impacts ASM growth.
- Share Count Reduction: The $750M ASR in Q1 2025 will significantly reduce the share count. EPS will grow faster than Net Income.
- Cabin Retrofit Capex: The 2025 capex includes a massive $1.6B non-aircraft component, largely for retrofitting 800 planes with premium seats. This is a one-time bulge that should not be extrapolated into 2027+.
Validation Checks
- "Load Factor should remain between 80% and 85%; flag if it exceeds 88% as this is operationally impossible across a network."
- "CASM-ex fuel growth should be in the 1-3% range for 2025 based on management's 'low-single digits' exit rate guidance."
- "Total Liquidity (Cash + Revolver) must remain above $5.0 billion to satisfy internal risk policies."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Net Capex for 2025 should reconcile to the $2.5B - $3.0B guidance range."
- "Effective tax rate should be 22-24%."
- "Total Revenue = ASMs × TRASM. If these diverge, the revenue build is broken."
- "Adjusted Debt to Invested Capital should remain near the 40-45% historical range."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Annual Capacity (ASM) Growth | 1.5 | % | Management guidance of 1-2% annual growth through 2027. |
| TRASM Growth (2025) | 6.0 | % | Midpoint of Q1 2025 guidance (5-7%), driven by tactical revenue initiatives. |
| CASM-ex Fuel Growth (2025) | 2.0 | % | Management target of low-single digit exit rate for 2025. |
| Average Fuel Price per Gallon | 2.60 | $ | Estimated blended rate including hedging impacts. |
| Load Factor | 82.5 | % | Historical average for Southwest post-pandemic. |
| 2025 Aircraft Deliveries | 38 | Planes | Management planning assumption for Boeing 737-8 deliveries. |
| 2025 Aircraft Retirements | 36 | Planes | Planned retirements of older 737-700s and 737-800s. |
| 2025 Aircraft Capex | 1.2 | $ Billions | Management guidance. |
| 2025 Non-Aircraft Capex | 1.6 | $ Billions | Management guidance (includes cabin retrofits). |
| Effective Tax Rate | 23.0 | % | Midpoint of 2025 guidance (22-24%). |
| Share Repurchases (2025) | 750 | $ Millions | Announced Accelerated Share Repurchase programme. |
| Annual Dividend | 430 | $ Millions | Run-rate based on 2024 actuals. |
| WACC | 8.5 | % | Standard cost of capital for investment-grade US airlines. |
| Terminal EV/EBITDAR Multiple | 5.5 | x | Long-term historical average for US low-cost carriers. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Southwest Airlines Co. 10-K, 10-Q, 8-K), Southwest Investor Relations website.
- Key Peers: Delta Air Lines (DAL), United Airlines (UAL), American Airlines (AAL), Alaska Air Group (ALK).
- Industry Data: Bureau of Transportation Statistics (BTS) for domestic market share and yield data; TSA checkpoint travel numbers for macro demand trends.
- Consensus Estimates: FactSet or Bloomberg for consensus TRASM and CASM-ex estimates.
- Proprietary Data: Cirium or OAG for forward-looking schedule data and capacity (ASM) deployment tracking.
Sources
- Southwest Airlines Q4 and Full Year 2024 Earnings Release (January 30, 2025)
- Southwest Airlines Investor Day Presentation (September 26, 2024)
- SEC Form 10-K for Southwest Airlines Co. (FY 2023 / FY 2024)
- Press releases regarding Elliott Investment Management proxy settlement and board changes (2024)
- Press releases regarding the end of open seating, introduction of red-eye flights, and new fare bundles (July 2024 - January 2026)
Do more with the Southwest Airlines model
Frequently asked
What is Southwest Airlines' core business model?+
Southwest Airlines operates as a major US passenger airline, primarily utilizing a low-cost carrier (LCC) model focused on domestic point-to-point transit. Historically, it was known for a single aircraft type, open seating, and a "Bags Fly Free" policy, but is undergoing a significant strategic transformation.
What are the primary revenue streams for Southwest Airlines?+
Southwest Airlines generates most of its revenue from passenger fares, accounting for approximately 89% of its total. Other significant revenue sources include its Rapid Rewards program, EarlyBird check-in, and various ancillary fees, making up about 10%.
What is Southwest Airlines' capital expenditure strategy?+
Southwest Airlines' capital expenditure typically ranges from 8-12% of its revenue, heavily skewed towards fleet modernization. Significant capex programs are underway, including aircraft deliveries and a massive cabin retrofitting initiative to install premium seating across its fleet.
How does Southwest Airlines' balance sheet structure impact its financial model and valuation?+
Southwest Airlines has a structurally negative net working capital profile, benefiting from upfront ticket sales which fund operations. Its balance sheet is asset-heavy, with Property and Equipment (primarily owned aircraft) being the largest asset class, alongside substantial cash reserves.
What is the assumed revenue growth rate in the Southwest Airlines financial model?+
The financial model for Southwest Airlines assumes a revenue growth rate of approximately 3.85%. This projection helps quantify the financial impact of the company's strategic transformation planned for 2025/2026.
Can I download an Excel financial model for Southwest Airlines?+
Yes, a downloadable Excel financial model for Southwest Airlines is available. This model evaluates the equity valuation and cash flow generation, with a forecast horizon extending from FY2026 to FY2030.
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.
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.
