COKE DCF Model
| Dec'20 Actual | Dec'21 Actual | Dec'22 Actual | Dec'23 Actual | Dec'24 Actual | Dec'25 Estimate | Dec'26 Estimate | Dec'27 Estimate | Dec'28 Estimate | Dec'29 Estimate | Dec'30 Estimate | Dec'31 Estimate | Dec'32 Estimate | Dec'33 Estimate | Dec'34 Estimate | Dec'35 Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 5,007.4 3.7% | 5,562.7 11.1% | 6,201.0 11.5% | 6,653.9 7.3% | 6,899.7 3.7% | 7,819.2 13.3% | 8,772.6 12.2% | 9,742.9 11.1% | 10,710.2 9.9% | 11,652.2 8.8% | 12,545.1 7.7% | 13,364.4 6.5% | 14,085.8 5.4% | 14,686.5 4.3% | 15,146.6 3.1% | 15,449.5 2.0% |
% margin | 313.4 6.3% | 288.6 5.2% | 641.0 10.3% | 834.5 12.5% | 920.4 13.3% | 514.8 6.6% | 577.5 6.6% | 641.4 6.6% | 705.1 6.6% | 767.1 6.6% | 825.9 6.6% | 879.8 6.6% | 927.3 6.6% | 966.9 6.6% | 997.2 6.6% | 1,017.1 6.6% |
NOPAT % effective tax rate | 236.7 4.7% | 214.4 3.9% | 479.5 7.7% | 611.3 9.2% | 680.2 9.9% | 380.4 4.9% | 426.8 4.9% | 474.0 4.9% | 521.1 4.9% | 566.9 4.9% | 610.4 4.9% | 650.3 4.9% | 685.4 4.9% | 714.6 4.9% | 737.0 4.9% | 751.7 4.9% |
% of revenue | 179.0 3.6% | 180.6 3.2% | 171.6 2.8% | 177.0 2.7% | 193.8 2.8% | 214.6 2.7% | 240.8 2.7% | 267.5 2.7% | 294.0 2.7% | 319.9 2.7% | 344.4 2.7% | 366.9 2.7% | 386.7 2.7% | 403.2 2.7% | 415.8 2.7% | 424.1 2.7% |
% of revenue | (202.0) (4.0%) | (155.7) (2.8%) | (329.3) (5.3%) | (282.3) (4.2%) | (371.0) (5.4%) | (389.1) (5.0%) | (436.6) (5.0%) | (484.9) (5.0%) | (533.0) (5.0%) | (579.9) (5.0%) | (624.3) (5.0%) | (665.1) (5.0%) | (701.0) (5.0%) | (730.9) (5.0%) | (753.8) (5.0%) | (768.9) (5.0%) |
% of revenue | 78.1 1.6% | 22.9 0.4% | (76.4) (1.2%) | (6.0) (0.1%) | 0.0 0.0% | (34.5) (0.4%) | (38.7) (0.4%) | (42.9) (0.4%) | (47.2) (0.4%) | (51.4) (0.4%) | (55.3) (0.4%) | (58.9) (0.4%) | (62.1) (0.4%) | (64.7) (0.4%) | (66.8) (0.4%) | (68.1) (0.4%) |
Free Cash Flow to Firm (FCFF) % of revenue | 291.8 5.8% | 262.2 4.7% | 245.4 4.0% | 500.0 7.5% | 503.0 7.3% | 171.5 2.2% | 192.4 2.2% | 213.7 2.2% | 234.9 2.2% | 255.6 2.2% | 275.2 2.2% | 293.1 2.2% | 309.0 2.2% | 322.1 2.2% | 332.2 2.2% | 338.9 2.2% |
% of FCFF used in calculation | 83.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | ||||||
Discount period | 0.50 | 1.50 | 2.50 | 3.50 | 4.50 | 5.50 | 6.50 | 7.50 | 8.50 | 9.50 | ||||||
Discount factor | 0.97 | 0.90 | 0.85 | 0.79 | 0.74 | 0.69 | 0.65 | 0.60 | 0.56 | 0.53 | ||||||
Discounted FCFF (DFCFF) | 137.7 | 174.0 | 180.6 | 185.6 | 188.8 | 190.1 | 189.3 | 186.6 | 181.9 | 175.4 |
Best stock ideas on the market right now
With Value Sense, you can find undervalued stocks list with intrinsic value. Discover more stock market investment ideas.
Undervalued stocks right now
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Low P/E stocks
Explore the best low P/E stocks to buy in 2025, featuring top companies trading at low P/E ratios.
Undervalued dividend stocks
Discover the top 20 best undervalued high-yield dividend stock that offers both growth potential and attractive dividend returns for Mar 2025.
COKE DCF Value
DCF Value Calculation
Equity Value Bridge
COKE DCF Financials
COKE DCF sensitivity
Explore more intrinsic value tools hub for COKE
FAQ
What is Coca-Cola Consolidated, Inc. DCF (discounted cash flow) valuation?
As of Mar 03, 2025, Coca-Cola Consolidated, Inc.'s Discounted Cash Flow (DCF) valuation estimates its share price at $561.7. This suggests it may be overvalued by (60.1%) compared to its current price of around $1,407.2, using a WACC of 7.0% and growth rates of 2.0%.
What is Coca-Cola Consolidated, Inc. WACC?
As of Mar 03, 2025, Coca-Cola Consolidated, Inc.'s Weighted Average Cost of Capital (WACC) is approximately 7.0%.
What is Coca-Cola Consolidated, Inc. Enterprise Value?
As of Mar 03, 2025, Coca-Cola Consolidated, Inc.'s Enterprise Value (EV) is approximately $5,397.2M. This value reflects the company's total market capitalization plus debt, minus cash and cash equivalents, providing a comprehensive measure of its overall value in the market.