Coca-Cola Consolidated, Inc. (COKE) DCF Valuation

Coca-Cola Consolidated, Inc. (COKE) 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

Coca-Cola Consolidated, Inc. (COKE) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 10.97 9.79 9.83 9.78 9.91
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.