Crown Holdings, Inc. (CCK) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Crown Holdings, Inc. (CCK) Bundle
Looking to assess the intrinsic value of Crown Holdings, Inc.? Our (CCK) DCF Calculator merges real-world data with extensive customization features, enabling you to refine your forecasts and make informed investment choices.
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 | 11,665.0 | 11,575.0 | 11,394.0 | 12,943.0 | 12,010.0 | 12,131.6 | 12,254.5 | 12,378.6 | 12,504.0 | 12,630.6 |
| Revenue Growth, % | 0 | -0.77154 | -1.56 | 13.59 | -7.21 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 |
| EBITDA | 1,475.0 | 1,448.0 | 281.0 | 1,746.0 | 1,730.0 | 1,347.0 | 1,360.6 | 1,374.4 | 1,388.3 | 1,402.4 |
| EBITDA, % | 12.64 | 12.51 | 2.47 | 13.49 | 14.4 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 |
| Depreciation | 490.0 | 422.0 | 447.0 | 460.0 | 499.0 | 472.6 | 477.4 | 482.2 | 487.1 | 492.0 |
| Depreciation, % | 4.2 | 3.65 | 3.92 | 3.55 | 4.15 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 |
| EBIT | 985.0 | 1,026.0 | -166.0 | 1,286.0 | 1,231.0 | 874.4 | 883.2 | 892.2 | 901.2 | 910.3 |
| EBIT, % | 8.44 | 8.86 | -1.46 | 9.94 | 10.25 | 7.21 | 7.21 | 7.21 | 7.21 | 7.21 |
| Total Cash | 607.0 | 1,173.0 | 531.0 | 550.0 | 1,310.0 | 853.0 | 861.6 | 870.3 | 879.2 | 888.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,528.0 | 1,332.0 | 1,889.0 | 1,843.0 | 1,727.0 | 1,693.7 | 1,710.8 | 1,728.2 | 1,745.7 | 1,763.3 |
| Account Receivables, % | 13.1 | 11.51 | 16.58 | 14.24 | 14.38 | 13.96 | 13.96 | 13.96 | 13.96 | 13.96 |
| Inventories | 1,626.0 | 1,673.0 | 1,735.0 | 2,014.0 | 1,613.0 | 1,761.8 | 1,779.6 | 1,797.6 | 1,815.9 | 1,834.2 |
| Inventories, % | 13.94 | 14.45 | 15.23 | 15.56 | 13.43 | 14.52 | 14.52 | 14.52 | 14.52 | 14.52 |
| Accounts Payable | 2,646.0 | 2,141.0 | 2,901.0 | 2,773.0 | 2,459.0 | 2,633.5 | 2,660.2 | 2,687.2 | 2,714.4 | 2,741.9 |
| Accounts Payable, % | 22.68 | 18.5 | 25.46 | 21.42 | 20.47 | 21.71 | 21.71 | 21.71 | 21.71 | 21.71 |
| Capital Expenditure | -432.0 | -587.0 | -816.0 | -839.0 | -793.0 | -704.2 | -711.3 | -718.5 | -725.8 | -733.1 |
| Capital Expenditure, % | -3.7 | -5.07 | -7.16 | -6.48 | -6.6 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 |
| Tax Rate, % | 43.4 | 43.4 | 43.4 | 43.4 | 43.4 | 43.4 | 43.4 | 43.4 | 43.4 | 43.4 |
| EBITAT | 639.1 | 641.5 | -143.4 | 885.3 | 696.8 | 593.3 | 599.3 | 605.3 | 611.5 | 617.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 189.1 | 120.5 | -371.4 | 145.3 | 605.8 | 420.8 | 357.1 | 360.7 | 364.3 | 368.0 |
| WACC, % | 6.38 | 6.32 | 6.91 | 6.48 | 6.18 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,562.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 375 | |||||||||
| Terminal Value | 8,426 | |||||||||
| Present Terminal Value | 6,163 | |||||||||
| Enterprise Value | 7,725 | |||||||||
| Net Debt | 6,389 | |||||||||
| Equity Value | 1,336 | |||||||||
| Diluted Shares Outstanding, MM | 120 | |||||||||
| Equity Value Per Share | 11.17 |
What You Will Get
- Real Crown Holdings Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Crown Holdings, Inc. (CCK).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Crown Holdings, Inc. (CCK).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Crown Holdings, Inc.'s (CCK) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Crown Holdings, Inc. (CCK).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Crown Holdings, Inc. (CCK).
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Crown Holdings, Inc. (CCK).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with customizable parameters for precise analysis.
- Adjustable Forecast Assumptions: Easily modify growth projections, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Crown Holdings, Inc. (CCK).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics for streamlined analysis and insights.
How It Works
- Step 1: Download the Excel file for Crown Holdings, Inc. (CCK).
- Step 2: Review the pre-filled financial data and forecasts for Crown Holdings.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Analyze the results and leverage the outputs for informed investment decisions.
Why Choose Crown Holdings, Inc. (CCK)?
- Industry Leader: Crown Holdings, Inc. (CCK) is a top player in packaging solutions, ensuring high-quality products.
- Innovative Solutions: Constantly evolving technology and design keep us ahead of market trends.
- Global Reach: With operations in multiple countries, we serve a diverse range of clients worldwide.
- Sustainability Focused: Committed to environmentally friendly practices in all aspects of our business.
- Expert Team: Our professionals bring extensive experience and knowledge to deliver exceptional service.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Crown Holdings, Inc. (CCK) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Crown Holdings, Inc. (CCK) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Manufacturing Enthusiasts: Gain insights into how companies like Crown Holdings, Inc. (CCK) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Crown Holdings, Inc.'s (CCK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Crown Holdings, Inc.'s (CCK) 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.