Coca-Cola Consolidated, Inc. (COKE) DCF Valuation
- ✓ 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
Coca-Cola Consolidated, Inc. (COKE) Bundle
Evaluate Coca-Cola Consolidated, Inc.'s (COKE) financial prospects with expertise! This (COKE) DCF Calculator provides pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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,826.5 | 5,007.4 | 5,562.7 | 6,201.0 | 6,653.9 | 7,213.0 | 7,819.2 | 8,476.3 | 9,188.6 | 9,960.7 |
Revenue Growth, % | 0 | 3.75 | 11.09 | 11.47 | 7.3 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 |
EBITDA | 260.1 | 456.8 | 469.2 | 771.5 | 898.6 | 705.3 | 764.6 | 828.9 | 898.5 | 974.0 |
EBITDA, % | 5.39 | 9.12 | 8.43 | 12.44 | 13.51 | 9.78 | 9.78 | 9.78 | 9.78 | 9.78 |
Depreciation | 179.9 | 179.0 | 180.6 | 171.6 | 177.0 | 230.5 | 249.8 | 270.8 | 293.6 | 318.3 |
Depreciation, % | 3.73 | 3.58 | 3.25 | 2.77 | 2.66 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 |
EBIT | 80.2 | 277.8 | 288.6 | 599.9 | 721.7 | 474.9 | 514.8 | 558.0 | 604.9 | 655.8 |
EBIT, % | 1.66 | 5.55 | 5.19 | 9.67 | 10.85 | 6.58 | 6.58 | 6.58 | 6.58 | 6.58 |
Total Cash | 9.6 | 54.8 | 142.3 | 197.6 | 635.3 | 239.3 | 259.4 | 281.2 | 304.8 | 330.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 529.6 | 490.1 | 546.5 | 606.3 | 659.3 | 725.3 | 786.2 | 852.3 | 923.9 | 1,001.5 |
Account Receivables, % | 10.97 | 9.79 | 9.83 | 9.78 | 9.91 | 10.05 | 10.05 | 10.05 | 10.05 | 10.05 |
Inventories | 225.9 | 225.8 | 302.9 | 347.5 | 321.9 | 361.8 | 392.2 | 425.1 | 460.8 | 499.6 |
Inventories, % | 4.68 | 4.51 | 5.44 | 5.6 | 4.84 | 5.02 | 5.02 | 5.02 | 5.02 | 5.02 |
Accounts Payable | 187.5 | 217.6 | 319.3 | 351.7 | 383.6 | 366.5 | 397.3 | 430.7 | 466.9 | 506.1 |
Accounts Payable, % | 3.88 | 4.34 | 5.74 | 5.67 | 5.76 | 5.08 | 5.08 | 5.08 | 5.08 | 5.08 |
Capital Expenditure | -171.4 | -202.0 | -155.7 | -329.3 | -282.3 | -287.6 | -311.8 | -338.0 | -366.4 | -397.2 |
Capital Expenditure, % | -3.55 | -4.03 | -2.8 | -5.31 | -4.24 | -3.99 | -3.99 | -3.99 | -3.99 | -3.99 |
Tax Rate, % | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 | 26.75 |
EBITAT | 43.5 | 198.8 | 214.4 | 448.7 | 528.6 | 330.6 | 358.4 | 388.5 | 421.2 | 456.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -516.0 | 245.5 | 207.5 | 219.0 | 427.7 | 150.7 | 235.9 | 255.8 | 277.3 | 300.5 |
WACC, % | 8.07 | 8.11 | 8.12 | 8.12 | 8.12 | 8.11 | 8.11 | 8.11 | 8.11 | 8.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 950.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 302 | |||||||||
Terminal Value | 3,971 | |||||||||
Present Terminal Value | 2,689 | |||||||||
Enterprise Value | 3,640 | |||||||||
Net Debt | 100 | |||||||||
Equity Value | 3,540 | |||||||||
Diluted Shares Outstanding, MM | 9 | |||||||||
Equity Value Per Share | 376.90 |
What You Will Get
- Real COKE Financial Data: Pre-filled with Coca-Cola Consolidated’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 Coca-Cola Consolidated’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 Coca-Cola Consolidated, Inc. (COKE).
- WACC Calculator: Comes with a pre-built Weighted Average Cost of Capital sheet that allows for customizable inputs.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to suit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Coca-Cola Consolidated, Inc. (COKE).
- Interactive Dashboard and Charts: Visual representations provide a summary of key valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Coca-Cola Consolidated, Inc.'s (COKE) financial data.
- 2. Adjust Key Inputs: Modify essential variables such as sales growth, cost of goods sold, and operating expenses.
- 3. Analyze Results Immediately: The DCF model automatically
Why Choose Coca-Cola Consolidated, Inc. (COKE)?
- Rich Heritage: Benefit from a company with a long-standing reputation in the beverage industry.
- Quality Products: Enjoy a diverse range of beverages that meet high standards of taste and quality.
- Innovative Solutions: Experience cutting-edge marketing strategies and product offerings that resonate with consumers.
- Strong Community Engagement: Participate in initiatives that support local communities and sustainability.
- Proven Leadership: Trust in a management team with extensive experience and a commitment to excellence.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Coca-Cola Consolidated, Inc. (COKE) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specifically for Coca-Cola Consolidated, Inc. (COKE).
- Consultants: Deliver professional valuation insights on Coca-Cola Consolidated, Inc. (COKE) to clients quickly and accurately.
- Business Owners: Understand how large beverage companies like Coca-Cola Consolidated, Inc. (COKE) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Coca-Cola Consolidated, Inc. (COKE).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Coca-Cola Consolidated, Inc. (COKE).
- Real-World Data: Coca-Cola Consolidated’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.