|
Valoración DCF de la Compañía Boeing (BA)
US | Industrials | Aerospace & Defense | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
The Boeing Company (BA) Bundle
¡Mejore su estrategia de inversión con la calculadora (BA) DCF! Use datos financieros reales de Boeing, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones influyen en el valor intrínseco de (BA).
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 76,559.0 | 58,158.0 | 62,286.0 | 66,608.0 | 77,794.0 | 79,115.6 | 80,459.7 | 81,826.7 | 83,216.8 | 84,630.6 |
Revenue Growth, % | 0 | -24.04 | 7.1 | 6.94 | 16.79 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 |
EBITDA | 734.0 | -10,074.0 | -207.0 | -510.0 | 2,315.0 | -2,292.0 | -2,331.0 | -2,370.6 | -2,410.8 | -2,451.8 |
EBITDA, % | 0.95874 | -17.32 | -0.33234 | -0.76567 | 2.98 | -2.9 | -2.9 | -2.9 | -2.9 | -2.9 |
Depreciation | 2,271.0 | 2,246.0 | 2,144.0 | 1,979.0 | 1,861.0 | 2,473.7 | 2,515.8 | 2,558.5 | 2,602.0 | 2,646.2 |
Depreciation, % | 2.97 | 3.86 | 3.44 | 2.97 | 2.39 | 3.13 | 3.13 | 3.13 | 3.13 | 3.13 |
EBIT | -1,537.0 | -12,320.0 | -2,351.0 | -2,489.0 | 454.0 | -4,765.8 | -4,846.7 | -4,929.1 | -5,012.8 | -5,098.0 |
EBIT, % | -2.01 | -21.18 | -3.77 | -3.74 | 0.58359 | -6.02 | -6.02 | -6.02 | -6.02 | -6.02 |
Total Cash | 10,030.0 | 25,590.0 | 16,244.0 | 17,220.0 | 15,965.0 | 20,499.9 | 20,848.2 | 21,202.3 | 21,562.5 | 21,928.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 12,471.0 | 10,051.0 | 11,378.0 | 11,305.0 | 11,065.0 | 13,138.7 | 13,361.9 | 13,588.9 | 13,819.8 | 14,054.6 |
Account Receivables, % | 16.29 | 17.28 | 18.27 | 16.97 | 14.22 | 16.61 | 16.61 | 16.61 | 16.61 | 16.61 |
Inventories | 76,622.0 | 81,715.0 | 78,823.0 | 78,151.0 | 79,741.0 | 79,115.6 | 80,459.7 | 81,826.7 | 83,216.8 | 84,630.6 |
Inventories, % | 100.08 | 140.51 | 126.55 | 117.33 | 102.5 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | 15,553.0 | 12,928.0 | 9,261.0 | 10,200.0 | 11,964.0 | 13,941.0 | 14,177.8 | 14,418.7 | 14,663.7 | 14,912.8 |
Accounts Payable, % | 20.32 | 22.23 | 14.87 | 15.31 | 15.38 | 17.62 | 17.62 | 17.62 | 17.62 | 17.62 |
Capital Expenditure | -1,961.0 | -1,303.0 | -980.0 | -1,222.0 | -1,527.0 | -1,609.6 | -1,637.0 | -1,664.8 | -1,693.1 | -1,721.9 |
Capital Expenditure, % | -2.56 | -2.24 | -1.57 | -1.83 | -1.96 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 |
Tax Rate, % | -10.82 | -10.82 | -10.82 | -10.82 | -10.82 | -10.82 | -10.82 | -10.82 | -10.82 | -10.82 |
EBITAT | -432.7 | -10,162.6 | -1,962.8 | -2,445.9 | 503.1 | -3,740.2 | -3,803.7 | -3,868.3 | -3,934.0 | -4,000.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -73,662.7 | -14,517.6 | -2,900.8 | -4.9 | 1,251.1 | -2,347.4 | -4,255.4 | -4,327.7 | -4,401.2 | -4,476.0 |
WACC, % | 8.45 | 9.27 | 9.29 | 9.51 | 9.54 | 9.21 | 9.21 | 9.21 | 9.21 | 9.21 |
PV UFCF | ||||||||||
SUM PV UFCF | -15,015.5 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -4,633 | |||||||||
Terminal Value | -81,145 | |||||||||
Present Terminal Value | -52,236 | |||||||||
Enterprise Value | -67,251 | |||||||||
Net Debt | 39,912 | |||||||||
Equity Value | -107,163 | |||||||||
Diluted Shares Outstanding, MM | 606 | |||||||||
Equity Value Per Share | -176.81 |
What You Will Get
- Real BA Financial Data: Pre-filled with Boeing’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Boeing’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Pre-Loaded Data: Boeing's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: Observe Boeing's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the Excel file for The Boeing Company (BA).
- Step 2: Review Boeing’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose Boeing (BA)?
- Innovative Technology: Cutting-edge aerospace solutions that lead the industry.
- Global Reach: Extensive network and partnerships across the globe enhance service delivery.
- Commitment to Safety: Rigorous standards and practices ensure the highest level of safety for all products.
- Sustainable Practices: Focus on environmentally friendly initiatives and reducing carbon footprints.
- Expertise You Can Trust: Decades of experience in aviation and defense, backed by a strong reputation.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Boeing stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Boeing (BA).
- Consultants: Deliver professional valuation insights to clients quickly and accurately, focusing on Boeing (BA).
- Business Owners: Understand how major aerospace companies like Boeing (BA) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Boeing (BA).
What the Template Contains
- Historical Data: Includes The Boeing Company's (BA) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The Boeing Company's (BA) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of The Boeing Company's (BA) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.