Silgan Holdings Inc. (SLGN) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Silgan Holdings Inc. (SLGN) Bundle
Explore Silgan Holdings Inc. (SLGN) financial future with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate the intrinsic value of Silgan Holdings Inc. (SLGN) and enhance your investment strategy.
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,489.9 | 4,921.9 | 5,677.1 | 6,411.5 | 5,988.2 | 6,456.8 | 6,962.0 | 7,506.8 | 8,094.2 | 8,727.5 |
| Revenue Growth, % | 0 | 9.62 | 15.34 | 12.94 | -6.6 | 7.82 | 7.82 | 7.82 | 7.82 | 7.82 |
| EBITDA | 622.3 | 770.0 | 846.4 | 964.0 | 858.7 | 952.9 | 1,027.5 | 1,107.9 | 1,194.5 | 1,288.0 |
| EBITDA, % | 13.86 | 15.64 | 14.91 | 15.04 | 14.34 | 14.76 | 14.76 | 14.76 | 14.76 | 14.76 |
| Depreciation | 206.5 | 219.1 | 250.4 | 262.8 | 263.2 | 283.5 | 305.7 | 329.6 | 355.4 | 383.2 |
| Depreciation, % | 4.6 | 4.45 | 4.41 | 4.1 | 4.4 | 4.39 | 4.39 | 4.39 | 4.39 | 4.39 |
| EBIT | 415.8 | 550.9 | 596.1 | 701.2 | 595.4 | 669.4 | 721.8 | 778.2 | 839.1 | 904.8 |
| EBIT, % | 9.26 | 11.19 | 10.5 | 10.94 | 9.94 | 10.37 | 10.37 | 10.37 | 10.37 | 10.37 |
| Total Cash | 203.8 | 409.5 | 631.4 | 585.6 | 642.9 | 566.3 | 610.6 | 658.4 | 709.9 | 765.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 505.0 | 619.5 | 711.3 | 658.0 | 599.5 | 731.4 | 788.6 | 850.3 | 916.9 | 988.6 |
| Account Receivables, % | 11.25 | 12.59 | 12.53 | 10.26 | 10.01 | 11.33 | 11.33 | 11.33 | 11.33 | 11.33 |
| Inventories | 633.0 | 677.5 | 798.8 | 769.4 | 940.8 | 899.4 | 969.7 | 1,045.6 | 1,127.4 | 1,215.7 |
| Inventories, % | 14.1 | 13.77 | 14.07 | 12 | 15.71 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 |
| Accounts Payable | 727.1 | 802.5 | 1,133.3 | 974.0 | 1,075.9 | 1,105.7 | 1,192.2 | 1,285.5 | 1,386.1 | 1,494.5 |
| Accounts Payable, % | 16.19 | 16.31 | 19.96 | 15.19 | 17.97 | 17.12 | 17.12 | 17.12 | 17.12 | 17.12 |
| Capital Expenditure | -230.9 | -224.2 | -232.3 | -215.8 | -226.8 | -270.4 | -291.6 | -314.4 | -339.0 | -365.6 |
| Capital Expenditure, % | -5.14 | -4.56 | -4.09 | -3.37 | -3.79 | -4.19 | -4.19 | -4.19 | -4.19 | -4.19 |
| Tax Rate, % | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 |
| EBITAT | 319.7 | 417.8 | 459.0 | 504.0 | 459.8 | 507.1 | 546.8 | 589.6 | 635.7 | 685.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -115.7 | 329.1 | 594.8 | 474.5 | 485.1 | 459.5 | 519.8 | 560.5 | 604.4 | 651.6 |
| WACC, % | 6.21 | 6.19 | 6.22 | 6.12 | 6.22 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,319.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 665 | |||||||||
| Terminal Value | 15,851 | |||||||||
| Present Terminal Value | 11,737 | |||||||||
| Enterprise Value | 14,057 | |||||||||
| Net Debt | 2,784 | |||||||||
| Equity Value | 11,273 | |||||||||
| Diluted Shares Outstanding, MM | 109 | |||||||||
| Equity Value Per Share | 103.20 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real SLGN financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Silgan Holdings’ valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future estimates for Silgan Holdings Inc. (SLGN).
- Adjustable Forecast Parameters: Modify highlighted cells for crucial metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Intuitive charts and summaries designed to help you visualize your valuation outcomes.
- Suitable for All Levels: A user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Silgan Holdings Inc. (SLGN) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Silgan Holdings Inc. (SLGN)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Silgan Holdings Inc. (SLGN)?
- Industry Leader: A trusted name in packaging solutions with a proven track record.
- Innovative Solutions: Constantly evolving products that meet the needs of diverse markets.
- Commitment to Sustainability: Focused on eco-friendly practices and reducing environmental impact.
- Strong Financial Performance: Consistent growth and robust financial health in a competitive landscape.
- Expert Team: Led by experienced professionals dedicated to delivering quality and value.
Who Should Use Silgan Holdings Inc. (SLGN)?
- Investors: Make informed choices with a reliable resource for understanding Silgan's market position.
- Financial Analysts: Streamline your analysis with comprehensive data on Silgan's performance and projections.
- Consultants: Easily customize insights for client presentations focused on Silgan Holdings Inc. (SLGN).
- Finance Enthusiasts: Enhance your knowledge of the packaging industry through Silgan's case studies and metrics.
- Educators and Students: Utilize Silgan Holdings Inc. (SLGN) as a case study in finance and business courses.
What the Template Contains
- Pre-Filled DCF Model: Silgan Holdings Inc.’s (SLGN) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Silgan Holdings Inc.’s (SLGN) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.