|
Valoración de DCF de Constellium SE (CSTM)
FR | Basic Materials | Aluminum | 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
Constellium SE (CSTM) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (CSTM)! Utilizando datos reales de Constellium SE y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar (CSTM) como un inversor experimentado.
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 | 6,155.7 | 5,088.6 | 6,411.0 | 8,461.9 | 7,543.8 | 8,105.6 | 8,709.4 | 9,358.0 | 10,055.0 | 10,804.0 |
| Revenue Growth, % | 0 | -17.34 | 25.99 | 31.99 | -10.85 | 7.45 | 7.45 | 7.45 | 7.45 | 7.45 |
| EBITDA | 513.8 | 473.1 | 796.2 | 626.3 | 630.5 | 742.8 | 798.1 | 857.6 | 921.5 | 990.1 |
| EBITDA, % | 8.35 | 9.3 | 12.42 | 7.4 | 8.36 | 9.16 | 9.16 | 9.16 | 9.16 | 9.16 |
| Depreciation | 266.0 | 251.5 | 289.3 | 293.7 | 306.4 | 345.4 | 371.2 | 398.8 | 428.5 | 460.4 |
| Depreciation, % | 4.32 | 4.94 | 4.51 | 3.47 | 4.06 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
| EBIT | 247.8 | 221.6 | 506.8 | 332.6 | 324.1 | 397.4 | 427.0 | 458.8 | 493.0 | 529.7 |
| EBIT, % | 4.02 | 4.36 | 7.91 | 3.93 | 4.3 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 |
| Total Cash | 214.7 | 498.1 | 213.6 | 205.3 | 218.8 | 355.6 | 382.1 | 410.6 | 441.1 | 474.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 411.6 | 357.4 | 630.5 | 486.7 | 404.3 | 561.8 | 603.7 | 648.6 | 696.9 | 748.9 |
| Account Receivables, % | 6.69 | 7.02 | 9.83 | 5.75 | 5.36 | 6.93 | 6.93 | 6.93 | 6.93 | 6.93 |
| Inventories | 698.2 | 606.5 | 1,094.2 | 1,375.6 | 1,144.2 | 1,163.2 | 1,249.8 | 1,342.9 | 1,443.0 | 1,550.4 |
| Inventories, % | 11.34 | 11.92 | 17.07 | 16.26 | 15.17 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 |
| Accounts Payable | 740.9 | 652.4 | 1,109.8 | 1,203.6 | 970.2 | 1,122.7 | 1,206.3 | 1,296.1 | 1,392.7 | 1,496.4 |
| Accounts Payable, % | 12.04 | 12.82 | 17.31 | 14.22 | 12.86 | 13.85 | 13.85 | 13.85 | 13.85 | 13.85 |
| Capital Expenditure | -282.4 | -189.7 | -241.8 | -284.5 | -351.2 | -325.9 | -350.2 | -376.3 | -404.3 | -434.4 |
| Capital Expenditure, % | -4.59 | -3.73 | -3.77 | -3.36 | -4.66 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 |
| Tax Rate, % | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 |
| EBITAT | 178.3 | 110.8 | 410.9 | 493.2 | 206.7 | 291.5 | 313.2 | 336.6 | 361.6 | 388.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -207.0 | 229.9 | 155.2 | 458.6 | 242.1 | 287.1 | 289.4 | 310.9 | 334.1 | 358.9 |
| WACC, % | 8.52 | 7.77 | 8.84 | 9.49 | 8.24 | 8.57 | 8.57 | 8.57 | 8.57 | 8.57 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,231.1 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 370 | |||||||||
| Terminal Value | 6,633 | |||||||||
| Present Terminal Value | 4,397 | |||||||||
| Enterprise Value | 5,628 | |||||||||
| Net Debt | 1,759 | |||||||||
| Equity Value | 3,869 | |||||||||
| Diluted Shares Outstanding, MM | 149 | |||||||||
| Equity Value Per Share | 25.92 |
What You Will Get
- Real CSTM Financials: Access to historical and forecasted data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Constellium's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Constellium SE (CSTM).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Constellium SE (CSTM).
- Interactive Dashboard and Charts: Visual representations highlight key valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based CSTM DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Constellium’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose Constellium SE (CSTM)?
- Innovative Solutions: Benefit from cutting-edge technology and advanced materials tailored to your needs.
- Commitment to Sustainability: Our practices prioritize environmental responsibility and resource efficiency.
- Global Expertise: Leverage our extensive experience and knowledge across various industries.
- Customer-Centric Approach: We focus on understanding and meeting the unique requirements of our clients.
- Proven Track Record: Trusted by industry leaders for delivering high-quality products and services.
Who Should Use This Product?
- Finance Students: Understand advanced valuation methods and apply them to real-time data.
- Academics: Utilize industry-standard models for teaching or scholarly research.
- Investors: Validate your investment hypotheses and evaluate valuation results for Constellium SE (CSTM).
- Analysts: Enhance your efficiency with a ready-to-use, customizable DCF model.
- Small Business Owners: Learn how major corporations like Constellium SE (CSTM) are assessed in the market.
What the Template Contains
- Preloaded CSTM Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.