Boeing Financial Model
Aerospace and Defence Company Financials Example (Free Excel Download)
The Boeing Company is a leading global aerospace firm that designs, manufactures, and services commercial airplanes, defence products, and space systems.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive three-statement forecast and sum-of-the-parts valuation for The Boeing Company to help equity analysts assess the company's free cash flow recovery, debt deleveraging trajectory, and production ramp-up feasibility following recent operational crises and the Spirit AeroSystems acquisition.
The Boeing Company is a leading global aerospace firm that designs, manufactures, and services commercial airplanes, defence products, and space systems. The business operates through three primary segments: Commercial Airplanes (BCA) contributing approximately 45-50% of revenue, Defense, Space & Security (BDS) contributing approximately 30-35%, and Global Services (BGS) contributing approximately 20-25%. The company operates globally, with significant export sales originating from its United States manufacturing base. Boeing employs an asset-heavy manufacturing business model characterised by long-cycle product development, massive backlog visibility, and a high-margin aftermarket services tail. The company holds a duopoly position in commercial aerospace alongside Airbus and ranks as a top-tier prime contractor for the US Department of Defense. Recent major events include the 2024 IAM union strike, a $24 billion capital raise in late 2024 to protect its investment-grade credit rating, the acquisition of Spirit AeroSystems in December 2025, and the sale of Digital Aviation Solutions in 2025.
The downloadable Boeing 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 & AssumptionsBoeing financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $62.29B | $66.61B | $77.79B | $66.52B | $89.46B |
| Gross profit | $3.05B | $3.53B | $7.72B | -$1.99B | $4.29B |
| Operating income | -$2.87B | -$3.52B | -$773.0M | -$10.71B | $4.28B |
| Net income | -$4.20B | -$4.93B | -$2.22B | -$11.82B | $2.23B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Boeing
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Commercial Airplanes (BCA)
- Segment name: Commercial Airplanes
- Revenue driver formula: Commercial Deliveries x Average Selling Price per Aircraft
- Historical growth rate: Highly volatile, declining 31% year-over-year in Q4 2024 before rebounding to drive total company revenue to $89.5 billion in 2025.
- Key growth levers and headwinds: Production rate caps imposed by the FAA, supply chain bottlenecks (engines and fuselages), and the successful certification of the 777X and 737 MAX 10.
- Pricing dynamics: Contractual pricing with heavy discounting from list prices, protected by inflation escalation clauses.
- Revenue recognition notes: Primarily recognised at a point in time upon aircraft delivery, resulting in massive inventory builds prior to revenue realisation.
- Seasonality: Q4 is typically the strongest quarter for deliveries as the company pushes to meet annual targets.
Defense, Space & Security (BDS)
- Segment name: Defense, Space & Security
- Revenue driver formula: Funded Backlog x Contract Burn Rate + New Contract Awards
- Historical growth rate: Flat to low single digits.
- Key growth levers and headwinds: US Department of Defense budget allocations, international military sales, and execution on fixed-price development contracts.
- Pricing dynamics: A mix of cost-plus and fixed-price contracts.
- Revenue recognition notes: Recognised over time using the percentage-of-completion method based on costs incurred relative to total estimated costs.
- Seasonality: Generally stable, though Q4 often sees a slight bump from US government fiscal year-end budget deployment.
Global Services (BGS)
- Segment name: Global Services
- Revenue driver formula: Installed Fleet Base x Service Revenue per Aircraft
- Historical growth rate: Mid single digits.
- Key growth levers and headwinds: Global flight cycles, fleet ageing, and passenger traffic volumes.
- Pricing dynamics: Long-term service agreements and high-margin spot parts sales.
- Revenue recognition notes: Recognised over time as services are rendered or upon delivery for spare parts.
- Seasonality: Higher in summer months aligning with peak global travel seasons.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Direct materials (aerospace grade metals, composites), engines, avionics, direct manufacturing labour, and factory overhead absorption.
- Gross margin range: Highly volatile, ranging from negative 3% in 2024 to approximately 5% in 2025.
- Key input costs and commodity exposures: Titanium, aluminium, carbon fibre, and skilled unionised labour.
- How COGS scales with revenue: Step-function scaling. The company requires massive upfront tooling and labour retention, meaning low delivery volumes severely penalise margins due to unabsorbed overhead.
Operating Expenses
- R&D: Typically 4-5% of revenue. It covers new aircraft development (777X) and defence prototypes. Costs are expensed as incurred unless specific technological feasibility criteria are met.
- SG&A: Typically 5-6% of revenue, comprising corporate overhead, sales, and marketing.
- Depreciation & Amortisation: Typically 3% of revenue, split between heavy manufacturing equipment and amortisation of acquired intangibles.
- Stock-Based Compensation: Approximately 1-2% of revenue, used heavily for executive and engineering retention.
- Restructuring / one-time charges: Frequent and massive. The company regularly records reach-forward losses on fixed-price defence contracts and commercial programmes (e.g., $3.5 billion on the 777X in 2024).
Margin Profile
- Gross margin: -3% to 10% over the last 5 years.
- EBITDA margin: -11% in 2024, recovering to mid-single digits in 2025.
- Operating margin: -16% in 2024, recovering to 4.8% in 2025.
- Margin trend: Highly depressed due to production halts and strike action in 2024, showing early signs of stabilisation in 2025 following the IAM agreement and production resumption.
Balance Sheet Structure
- Total assets: Approximately $130-140 billion.
- Key asset categories: Inventory is the largest asset, representing parked aircraft and work-in-process. Property, Plant & Equipment is also highly material.
- Goodwill & intangibles: Increased significantly following the all-stock acquisition of Spirit AeroSystems in December 2025.
- Working capital profile:
- Days Sales Outstanding (DSO): 40-50 days.
- Days Inventory Outstanding (DIO): 150+ days due to delayed deliveries and parked airframes.
- Days Payable Outstanding (DPO): 60-70 days.
- Net working capital as % of revenue: Historically negative, but recently volatile.
- Working capital funding: The company relies heavily on customer advances and progress billings to fund inventory builds. When orders stall, this negative working capital advantage reverses and burns cash.
- PP&E: Consists of heavy manufacturing facilities in Washington and South Carolina. Useful lives range from 10 to 40 years.
- Right-of-use assets: Material but secondary to owned manufacturing infrastructure.
Capital Expenditure & Investment
- Capex as % of revenue: 2-3% historically.
- Maintenance capex vs. growth capex: Approximately 60% maintenance and 40% growth (tooling for new variants).
- Major capex programmes: Tooling for the 777X production line and expansion of South Carolina 787 operations.
- Capitalised software: Minimal relative to physical tooling.
- M&A pattern: Historically a bolt-on acquirer, but executed a transformational vertical integration by acquiring Spirit AeroSystems in late 2025 to regain control over fuselage quality.
- Typical acquisition multiple paid: Spirit AeroSystems was acquired in an all-stock transaction valued at a premium to its standalone distressed market capitalisation.
Debt & Capital Structure
- Total debt: Approximately $53 billion at the end of 2025.
- Net debt: Approximately $27 billion, offset by roughly $26 billion in cash and marketable securities.
- Credit rating: BBB- (S&P) / Baa3 (Moody's), sitting one notch above high yield.
- Key debt instruments: Unsecured senior notes, term loans, and an undrawn $10 billion revolving credit facility.
- Maturity profile: Heavy near-term maturities managed through active refinancing and the $24 billion capital raise in late 2024.
- Interest rate profile: Predominantly fixed-rate bonds with a weighted average cost of debt around 5.5%.
- Covenants: Minimum liquidity requirements and limitations on additional secured debt.
- Share repurchase programme: Suspended indefinitely to preserve cash.
- Dividend policy: Suspended indefinitely.
Cash Flow Characteristics
- Operating cash flow conversion: Highly negative in 2024 (-$12 billion) and slightly positive in 2025 ($1.3 billion).
- Free cash flow margin: -21% in 2024, recovering to roughly 0.5% in 2025.
- Major non-cash items: Reach-forward loss provisions, depreciation, stock-based compensation, and the $9.6 billion gain on the sale of Digital Aviation Solutions in 2025.
- Working capital cash flow impact: Customer advances are a massive source of cash during order booms and a massive use of cash when deliveries outpace new orders.
- Capex intensity: Relatively low compared to revenue scale, as suppliers historically bore much of the development cost burden.
- Cash tax rate: Near zero currently due to massive accumulated net operating losses.
Sheet Structure
- Assumptions: Hardcoded drivers, macro inputs, and scenario toggles.
- Revenue & Backlog: BCA deliveries, BDS contract burn, BGS growth, and consolidated backlog roll-forward.
- Operating Costs: COGS, R&D, SG&A, and reach-forward loss provisions.
- Income Statement: GAAP and Core (Non-GAAP) P&L down to EPS.
- Working Capital: Inventory, receivables, advances, and progress billings schedules.
- PP&E & Intangibles: Capex, depreciation, and goodwill (including Spirit AeroSystems integration).
- Debt Schedule: Tranche-by-tranche debt, interest expense, and revolver mechanics.
- Cash Flow Statement: Indirect method OCF, investing, and financing cash flows.
- Balance Sheet: Assets, liabilities, and shareholders' equity.
- Valuation: DCF and Sum-of-the-Parts using EV/EBITDA for BGS and EV/Sales for BCA and BDS.
Key Financial Relationships
- BCA Revenue = Commercial Aircraft Deliveries x Average Selling Price per Aircraft
- BDS Revenue = Beginning BDS Backlog x Annual Backlog Burn Rate
- BGS Revenue = Global Commercial Fleet Size x BGS Revenue per Aircraft
- Total Backlog = Beginning Backlog + Net New Orders - Recognized Revenue
- BCA Gross Margin = Base Margin - Reach-Forward Losses on 777X and 767
- Inventory Balance = Beginning Inventory + COGS Incurred - COGS Recognized at Delivery
- Customer Advances = Beginning Advances + New Order Deposits - Advances Applied to Deliveries
- Core Operating Earnings = GAAP Operating Earnings - Pension/OPEB Expense - Unallocated Corporate Costs
- Interest Expense = Average Debt Balance x Weighted Average Interest Rate
- Free Cash Flow = Operating Cash Flow - Property, Plant & Equipment Additions
Cross-Sheet Dependencies
The Assumptions sheet feeds Revenue & Backlog and Operating Costs. The Revenue & Backlog sheet drives the Income Statement top line and Working Capital schedules. The Working Capital and Income Statement sheets feed the Cash Flow Statement to calculate operating cash flow. The Cash Flow Statement determines cash available for debt paydown, feeding the Debt Schedule. The Debt Schedule calculates interest expense, which loops back to the Income Statement. This creates a circularity risk that requires a circuit breaker toggle. Finally, the Balance Sheet pulls ending balances from Working Capital, PP&E, Debt Schedule, and the Cash Flow Statement.
Sign Convention
- Revenue and income items are positive.
- Expenses (COGS, SG&A, R&D, Interest) are positive in their specific build schedules but subtracted in the Income Statement.
- Assets are positive.
- Liabilities and Equity are positive.
- Cash Flow Statement: Cash inflows are positive, and cash outflows (Capex, debt repayment) are negative.
Things Most Likely to Go Wrong
- Boeing has negative shareholders' equity; standard Return on Equity calculations will yield meaningless results and must be flagged.
- Failing to link new aircraft orders to cash inflows via customer advances will severely understate operating cash flow.
- Fixed-price defence contracts frequently incur massive one-time non-cash charges that distort gross margins and must be modelled separately from base margins.
- The late 2025 all-stock acquisition of Spirit AeroSystems changes the share count and adds significant goodwill; historical comparisons require pro-forma adjustments.
- The 2025 $9.6 billion gain from selling Digital Aviation Solutions must be excluded from core operating earnings to avoid overstating recurring margins.
- Aircraft built but not delivered sit in inventory; COGS is only recognised upon delivery, creating a mismatch between cash burn and P&L expenses.
- Non-operating pension income and expense must be stripped out to calculate Core Operating Margin accurately.
- High debt loads mean interest expense significantly impacts cash flow, which impacts debt balances, creating a severe circularity loop if not managed with a toggle.
Validation Checks
- Total Assets must equal Total Liabilities plus Shareholders' Equity in all periods.
- BCA deliveries should not exceed stated production rate capacities (e.g., 38 per month for the 737) without triggering a flag.
- Free Cash Flow must reconcile exactly to Operating Cash Flow minus Capex.
- Debt to EBITDA should be flagged as "Not Meaningful" if EBITDA is negative.
- Ending Backlog must equal Beginning Backlog plus Net Orders minus Recognized Revenue.
- The cash balance must not fall below the minimum operating cash requirement of $10 billion without triggering a revolver draw.
- Core Operating Margin must exclude the $9.6 billion gain on sale recorded in 2025.
- The effective tax rate should be flagged if it deviates significantly from zero in the near term, given Boeing's massive valuation allowances on deferred tax assets.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| BCA Deliveries | 600 | Aircraft | 2025 actual delivery volume |
| BDS Revenue Growth | 2.0 | % | Historical low single-digit growth |
| BGS Revenue Growth | 5.0 | % | Steady aftermarket services growth |
| Consolidated Gross Margin | 4.8 | % | 2025 actual reported operating margin proxy |
| R&D as % of Revenue | 4.5 | % | Historical average for development cycles |
| SG&A as % of Revenue | 5.0 | % | Historical corporate overhead run rate |
| Capex as % of Revenue | 2.5 | % | Maintenance and tooling requirements |
| Effective Tax Rate | 15.0 | % | Estimated rate accounting for valuation allowances |
| Weighted Average Interest Rate | 5.5 | % | Blended rate on recent debt issuances |
| Minimum Cash Balance | 10.0 | $ Billions | Liquidity buffer to maintain operations |
| WACC | 9.5 | % | Reflects elevated equity risk premium and debt cost |
| Terminal Growth Rate | 2.0 | % | Long-term GDP and air traffic growth proxy |
Data Sources & Benchmarks
- Filings: SEC EDGAR for Boeing's 10-K and 10-Q filings, and the Boeing Investor Relations page for delivery reports.
- Peers: Airbus (AIR.PA) for commercial aerospace; Lockheed Martin (LMT), General Dynamics (GD), and Northrop Grumman (NOC) for defence benchmarking.
- Industry data: Ascend by Cirium for global fleet data, and FAA press releases for production rate caps.
- Consensus estimates: Bloomberg or FactSet for validation of model outputs against street expectations.
Sources
Do more with the Boeing model
Frequently asked
What is Boeing's primary business model and how does it generate revenue?+
The Boeing Company operates an asset-heavy manufacturing business model, designing, manufacturing, and servicing commercial airplanes, defense products, and space systems. Revenue is primarily generated through the sale of new aircraft and defense systems, complemented by a high-margin aftermarket services tail.
What are the main revenue segments for The Boeing Company?+
Boeing's revenue is primarily driven by three segments: Commercial Airplanes (BCA), which contributes approximately 45-50% of revenue, Defense, Space & Security (BDS) at 30-35%, and Global Services (BGS) contributing 20-25%. This diversified structure reflects its global aerospace and defense operations.
What is Boeing's typical capital expenditure as a percentage of revenue?+
Historically, Boeing's capital expenditure has been approximately 2-3% of its revenue. This investment is split, with about 60% allocated to maintenance capex and 40% to growth capex, such as tooling for new aircraft variants like the 777X.
What does the downloadable Boeing financial model help equity analysts assess?+
The comprehensive financial model for The Boeing Company helps equity analysts assess the company's free cash flow recovery, its debt deleveraging trajectory, and the feasibility of its production ramp-up. This analysis is crucial for understanding the company's financial health following recent operational challenges and strategic acquisitions.
Is there an Excel financial model available for download for Boeing (BA)?+
Yes, a comprehensive Excel financial model for The Boeing Company (BA) is available for download. This model provides a detailed three-statement forecast and a sum-of-the-parts valuation, covering a forecast horizon from FY2026 to FY2030.
How does Boeing's working capital profile impact its cash flow?+
Boeing's working capital profile, characterized by high Days Inventory Outstanding (150+ days), relies heavily on customer advances and progress billings to fund inventory builds. When new orders slow, this negative working capital advantage can reverse, leading to significant cash burn.
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 Aerospace and Defence Company Financial Models
Browse another company in the same sector.
General Dynamics
General Dynamics is a global aerospace and defence company that provides business aviation, ship construction and repair, land combat vehicles, weapons systems, and technology products.
GE Aerospace
GE Aerospace is a global leader in the design, production, and maintenance of commercial and military aircraft engines and integrated systems.
Huntington Ingalls Industries
Huntington Ingalls Industries (HII) is the largest military shipbuilding company in the United States and a provider of professional services to government and industry partners.
Howmet Aerospace
Howmet Aerospace manufactures engineered metal products for the aerospace and commercial transportation industries.
Leidos
Leidos is a Fortune 500 science, engineering, and information technology company that provides services and solutions to the defense, intelligence, civil, and health markets.
L3Harris
L3Harris Technologies is an aerospace and defence technology innovator that provides mission-critical solutions across space, air, land, sea, and cyber domains.
Lockheed Martin
Lockheed Martin is a global security and aerospace company principally engaged in the research, design, development, manufacture, integration, and sustainment of advanced technology systems.
Northrop Grumman
Northrop Grumman is a top-tier global aerospace and defence technology company that provides advanced systems, products, and solutions to the US Department of Defense (DoD) and allied nations.
Explore more Manufacturing financial model templates.
