|
Valoración de DCF Selled Air Corporation (ver)
US | Consumer Cyclical | Packaging & Containers | 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
Sealed Air Corporation (SEE) Bundle
¡Mejore sus estrategias de inversión con la calculadora (ver) DCF! Utilice datos financieros de aire sellados auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos ajustes afectan el valor intrínseco de (ver).
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 | 4,791.1 | 4,903.2 | 5,533.8 | 5,641.9 | 5,488.9 | 5,687.1 | 5,892.4 | 6,105.2 | 6,325.6 | 6,554.0 |
| Revenue Growth, % | 0 | 2.34 | 12.86 | 1.95 | -2.71 | 3.61 | 3.61 | 3.61 | 3.61 | 3.61 |
| EBITDA | 723.0 | 991.3 | 1,060.5 | 1,147.0 | 946.3 | 1,046.9 | 1,084.7 | 1,123.9 | 1,164.4 | 1,206.5 |
| EBITDA, % | 15.09 | 20.22 | 19.16 | 20.33 | 17.24 | 18.41 | 18.41 | 18.41 | 18.41 | 18.41 |
| Depreciation | 150.9 | 174.1 | 186.4 | 184.6 | 233.4 | 200.1 | 207.3 | 214.8 | 222.6 | 230.6 |
| Depreciation, % | 3.15 | 3.55 | 3.37 | 3.27 | 4.25 | 3.52 | 3.52 | 3.52 | 3.52 | 3.52 |
| EBIT | 572.1 | 817.2 | 874.1 | 962.4 | 712.9 | 846.8 | 877.4 | 909.1 | 941.9 | 975.9 |
| EBIT, % | 11.94 | 16.67 | 15.8 | 17.06 | 12.99 | 14.89 | 14.89 | 14.89 | 14.89 | 14.89 |
| Total Cash | 262.4 | 548.7 | 561.0 | 456.1 | 346.1 | 468.6 | 485.5 | 503.0 | 521.2 | 540.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 669.6 | 681.7 | 732.8 | 592.9 | 581.7 | 707.8 | 733.3 | 759.8 | 787.3 | 815.7 |
| Account Receivables, % | 13.98 | 13.9 | 13.24 | 10.51 | 10.6 | 12.45 | 12.45 | 12.45 | 12.45 | 12.45 |
| Inventories | 570.3 | 596.7 | 725.7 | 866.3 | 774.3 | 758.1 | 785.4 | 813.8 | 843.2 | 873.6 |
| Inventories, % | 11.9 | 12.17 | 13.11 | 15.35 | 14.11 | 13.33 | 13.33 | 13.33 | 13.33 | 13.33 |
| Accounts Payable | 738.5 | 754.2 | 959.9 | 865.6 | 764.6 | 880.5 | 912.3 | 945.3 | 979.4 | 1,014.7 |
| Accounts Payable, % | 15.41 | 15.38 | 17.35 | 15.34 | 13.93 | 15.48 | 15.48 | 15.48 | 15.48 | 15.48 |
| Capital Expenditure | -189.7 | -181.1 | -213.1 | -237.3 | -244.2 | -229.3 | -237.6 | -246.1 | -255.0 | -264.2 |
| Capital Expenditure, % | -3.96 | -3.69 | -3.85 | -4.21 | -4.45 | -4.03 | -4.03 | -4.03 | -4.03 | -4.03 |
| Tax Rate, % | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 |
| EBITAT | 406.3 | 656.3 | 618.5 | 648.7 | 566.7 | 624.9 | 647.5 | 670.9 | 695.1 | 720.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -133.9 | 626.5 | 617.4 | 501.0 | 558.1 | 601.8 | 596.1 | 617.7 | 640.0 | 663.1 |
| WACC, % | 7.57 | 7.84 | 7.56 | 7.46 | 7.81 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,504.0 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 670 | |||||||||
| Terminal Value | 10,076 | |||||||||
| Present Terminal Value | 6,971 | |||||||||
| Enterprise Value | 9,475 | |||||||||
| Net Debt | 4,440 | |||||||||
| Equity Value | 5,035 | |||||||||
| Diluted Shares Outstanding, MM | 145 | |||||||||
| Equity Value Per Share | 34.75 |
What You Will Get
- Real SEE Financial Data: Pre-filled with Sealed Air Corporation’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 Sealed Air Corporation’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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Sealed Air Corporation (SEE).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to Sealed Air Corporation (SEE).
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates for Sealed Air Corporation (SEE).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Sealed Air Corporation (SEE).
- Interactive Dashboard and Charts: Visual representations summarize key valuation metrics for Sealed Air Corporation (SEE) for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template containing Sealed Air Corporation’s (SEE) data.
- Step 2: Review the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Sealed Air Corporation’s (SEE) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Sealed Air Corporation (SEE)?
- Accurate Data: Access to real Sealed Air financials guarantees trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: An intuitive design and guided instructions make it accessible for all users.
Who Should Use Sealed Air Corporation (SEE) Products?
- Investors: Gain insights and make informed decisions with our advanced packaging solutions.
- Supply Chain Managers: Enhance efficiency and reduce costs through innovative packaging technologies.
- Environmental Advocates: Explore sustainable packaging options that minimize environmental impact.
- Manufacturers: Streamline production processes with customized packaging solutions tailored to your needs.
- Educators and Students: Utilize our resources to learn about packaging science and sustainability in industry.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Sealed Air Corporation (SEE) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Sealed Air Corporation (SEE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.