Spirit AeroSystems Holdings, Inc. (SPR) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Spirit AeroSystems Holdings, Inc. (SPR) Bundle
Engineered for accuracy, our Spirit AeroSystems Holdings, Inc. (SPR) DCF Calculator empowers you to evaluate the valuation of Spirit AeroSystems using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 7,863.1 | 3,404.8 | 3,953.0 | 5,029.6 | 6,047.9 | 6,152.0 | 6,257.8 | 6,365.5 | 6,475.0 | 6,586.5 |
| Revenue Growth, % | 0 | -56.7 | 16.1 | 27.24 | 20.25 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 |
| EBITDA | 1,006.7 | -613.0 | 15.0 | 41.8 | 41.0 | -40.8 | -41.5 | -42.2 | -42.9 | -43.6 |
| EBITDA, % | 12.8 | -18 | 0.37946 | 0.83108 | 0.67792 | -0.66254 | -0.66254 | -0.66254 | -0.66254 | -0.66254 |
| Depreciation | 251.7 | 277.6 | 327.6 | 337.1 | 315.6 | 388.3 | 395.0 | 401.8 | 408.7 | 415.8 |
| Depreciation, % | 3.2 | 8.15 | 8.29 | 6.7 | 5.22 | 6.31 | 6.31 | 6.31 | 6.31 | 6.31 |
| EBIT | 755.0 | -890.6 | -312.6 | -295.3 | -274.6 | -429.1 | -436.5 | -444.0 | -451.6 | -459.4 |
| EBIT, % | 9.6 | -26.16 | -7.91 | -5.87 | -4.54 | -6.97 | -6.97 | -6.97 | -6.97 | -6.97 |
| Total Cash | 2,350.5 | 1,873.3 | 1,478.6 | 658.6 | 823.5 | 1,833.6 | 1,865.2 | 1,897.3 | 1,929.9 | 1,963.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,148.9 | 1,168.1 | 918.8 | 994.4 | 1,113.7 | 1,357.7 | 1,381.1 | 1,404.8 | 1,429.0 | 1,453.6 |
| Account Receivables, % | 14.61 | 34.31 | 23.24 | 19.77 | 18.41 | 22.07 | 22.07 | 22.07 | 22.07 | 22.07 |
| Inventories | 1,118.8 | 1,422.3 | 1,382.6 | 1,470.7 | 1,767.3 | 1,838.7 | 1,870.3 | 1,902.5 | 1,935.3 | 1,968.6 |
| Inventories, % | 14.23 | 41.77 | 34.98 | 29.24 | 29.22 | 29.89 | 29.89 | 29.89 | 29.89 | 29.89 |
| Accounts Payable | 1,058.3 | 558.9 | 720.3 | 919.8 | 1,106.8 | 1,041.9 | 1,059.9 | 1,078.1 | 1,096.7 | 1,115.5 |
| Accounts Payable, % | 13.46 | 16.42 | 18.22 | 18.29 | 18.3 | 16.94 | 16.94 | 16.94 | 16.94 | 16.94 |
| Capital Expenditure | -232.2 | -118.9 | -150.6 | -121.6 | -148.0 | -186.0 | -189.2 | -192.5 | -195.8 | -199.2 |
| Capital Expenditure, % | -2.95 | -3.49 | -3.81 | -2.42 | -2.45 | -3.02 | -3.02 | -3.02 | -3.02 | -3.02 |
| Tax Rate, % | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 |
| EBITAT | 603.6 | -710.0 | -302.9 | -298.1 | -285.2 | -391.8 | -398.6 | -405.4 | -412.4 | -419.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -586.3 | -1,373.4 | 324.5 | -46.8 | -346.5 | -569.8 | -229.9 | -233.8 | -237.8 | -241.9 |
| WACC, % | 9.39 | 9.38 | 10.08 | 10.21 | 10.21 | 9.85 | 9.85 | 9.85 | 9.85 | 9.85 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,200.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -247 | |||||||||
| Terminal Value | -3,143 | |||||||||
| Present Terminal Value | -1,965 | |||||||||
| Enterprise Value | -3,165 | |||||||||
| Net Debt | 3,353 | |||||||||
| Equity Value | -6,518 | |||||||||
| Diluted Shares Outstanding, MM | 107 | |||||||||
| Equity Value Per Share | -61.15 |
What You Will Get
- Real SPR Financial Data: Pre-filled with Spirit AeroSystems' historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Spirit AeroSystems' 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
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Spirit AeroSystems Holdings, Inc. (SPR).
- Adjustable Forecast Parameters: Modify highlighted cells for variables such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based SPR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model automatically recalculates Spirit AeroSystems' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Spirit AeroSystems Holdings, Inc. (SPR)?
- Accuracy: Utilizes real Spirit AeroSystems financial data to ensure precise calculations.
- Flexibility: Crafted for users to easily experiment and adjust inputs as needed.
- Time-Saving: Eliminate the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Engineered with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Aerospace Engineering Students: Understand design and manufacturing processes using real-world data.
- Researchers: Integrate industry-standard models into academic studies or projects.
- Investors: Evaluate your investment strategies and analyze the financial performance of Spirit AeroSystems Holdings, Inc. (SPR).
- Market Analysts: Enhance your analysis with a customizable financial model tailored for the aerospace sector.
- Entrepreneurs: Learn how major aerospace companies like Spirit AeroSystems are evaluated in the market.
What the Template Contains
- Historical Data: Includes Spirit AeroSystems' past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Spirit AeroSystems' 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 Spirit AeroSystems' financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.