Watchlist Manager
Coca-Cola Consolidated Inc
NASDAQ:co*kE
Watchlist
Price:825.07 USD0.28% Market Closed
Updated:Mar 11, 2024
Section:
DCF Value
This DCF valuation model was created byAlpha Spreadand was last updated onMar 11, 2024.
Estimated DCF Value of oneco*kEstock is617.55USD.Compared to the current market price of 825.07 USD, the stock isOvervalued by 25%.
co*kEDCF Value
Base Case
617.55USD
Overvaluation 25%
DCF Value
Price
Worst Case
Base Case
Best Case
617.55
DCF Value
Worst Case
Base Case
Best Case
Hide
DCF Value:617.55USD
Present Value Calculation
This block is the starting point of the DCF valuation process. It calculates the present value of a company's forecasted cash flows based on selected operating model. Adjust key parameters like discount rate and terminal growth, and alter inputs such as revenue growth and margins to see their impact on valuation.
DCF Model
Base Case Scenario
![Coca-Cola Consolidated Inc (NASDAQ:co*kE) (6) Coca-Cola Consolidated Inc (NASDAQ:co*kE) (6)](data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==)
DCF Model
Base Case Scenario
The present value of cash flows over the next 5 years amounts to 1.5B USD.The present value of the terminal value is 4.3B USD.The total present value equals 5.8B USD.
Operating Model
Equity Model: via Net Income
Forecast Period
Years
Discount Rate
%
Show All DCF Settings
Terminal Growth
%
Hide DCF Settings
Revenue
Net Margin
Save
DCF Value Calculation
This stage translates the present value into DCF value per share. For firm valuation models, it adjusts present value for debt and assets to derive equity value (skipped if using equity valuation model). Finally, this equity value is divided by the number of shares to determine the DCF value per share.
Present Value to DCF Value
Capital Structure
![Coca-Cola Consolidated Inc (NASDAQ:co*kE) (7) Coca-Cola Consolidated Inc (NASDAQ:co*kE) (7)](data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==)
Present Value to DCF Value
Capital Structure
Present Value | 5.8B USD |
Equity Value | 5.8BUSD |
/Shares Outstanding | 9.4m |
co*kE DCF Value | 617.55USD |
Overvalued by 25%
You are using the equity valuation model. In this approach, further calculations for converting firm value to equity value are not required. The present value, obtained in the present value calculation block, already represents the equity value.
The DCF value per share is derived by dividing the present value by the number of shares:
Present Value
5.8BUSD
/
Number of Shares
9.4m
=
DCF Value
617.55USD
Valuation Analysis
Sensitivity Analysis
DCF Value Sensitivity Analysis
![Coca-Cola Consolidated Inc (NASDAQ:co*kE) (8) Coca-Cola Consolidated Inc (NASDAQ:co*kE) (8)](data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==)
Sensitivity Analysis
DCF Value Sensitivity Analysis
Sensitivity Analysis assesses how changes in key factors like revenue growth, margin, and discount rate affect a stock's DCF value. By visualizing various scenarios, from significant downturns to optimistic growth, this tool helps you understand potential valuation shifts, aiding in risk assessment and strategic decision-making.
DCF Financials
Financials used in DCF Calculation
![Coca-Cola Consolidated Inc (NASDAQ:co*kE) (9) Coca-Cola Consolidated Inc (NASDAQ:co*kE) (9)](data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==)
DCF Financials
Financials used in DCF Calculation
Revenue
7.2B8.7B
Net Income
317.5m473.5m
See Also
Summary
DCF Valuation
Relative Valuation
Wall Street Estimates
Profitability Analysis
Solvency Analysis
Financials
Discount Rate
Discover More
What is the DCF value of one co*kE stock?
Estimated DCF Value of oneco*kEstock is617.55USD.Compared to the current market price of 825.07 USD, the stock isOvervalued by 25%.
The true DCF Value lies somewhere between the worst-case and best-case scenario values. This is because the future is not predetermined, and the stock's DCF Value is based almost entirely on the future of the company. Knowing the full range of possible stock DCF values gives a complete picture of the investment risks and opportunities.
How was the DCF Value calculated?
1. Present Value Calculation.Utilizing the DCF operating model, Coca-Cola Consolidated Inc's future cash flows are projected and then discounted using a chosen discount rate to determine its Present Value, which is calculated at5.8B USD.
2. DCF Value Calculation.The company's capital structure is employed to derive the total Equity Value from the previously calculated Present Value of the cash flow. This Equity Value, when divided by the total number of outstanding shares, yields the DCF Value of617.55 USDper share.
';return tooltip;}// dcfCalculator.renderValueDecompositionChart = function (){if (this.valueDecompositionChart){this.valueDecompositionChart.destroy();this.valueDecompositionChart = false;}this.valueDecompositionChart = this.createValueDecompositionChart();}dcfCalculator.createValueDecompositionChart = function (){varcObj = this;varcolumns = cObj.createValueDecompositionChartColumns();return Highcharts.chart('dcf-calculator-value-decomposition-chart', {credits: {enabled: false},chart: {type: 'waterfall',spacing: 0},plotOptions: {waterfall: {borderWidth: 0,borderRadius: 3,},series: {dataLabels: {enabled: true,inside: false,crop: false,formatter: function () {vardivider = getDivider(this.y);vardividerText = getDividerShortText(divider);varvalue = accounting.formatNumber(this.y / divider) + dividerText;if (!this.point.isSum)value = ((this.y < 0) ? '' : '+') + value;return value;},style: {fontWeight: 'normal',color: '#7B8794'}}}},title: {text: null},xAxis: {type: 'category',tickColor: 'transparent',lineColor: 'transparent',labels: {step: 1,style: {fontSize: '0.85rem',fontWeight: 300,color: '#3E4C59'}}},yAxis: {title: {text: null},labels: {enabled: false},visible: false},legend: {enabled: false},tooltip: {shared: false,backgroundColor: 'rgba(0, 0, 0, 0)',borderWidth: 0,borderRadius: 0,padding: 0,shadow: false,shape: 'rect',useHTML: true,formatter: function () {return cObj.createValueDecompositionChartTooltip(this);},style: {fontSize: '0.95rem'}},series: [{data: columns}]});}dcfCalculator.createValueDecompositionChartColumns = function (){varcObj = this;varcolumns = new Array;vardates = cObj.model.cashFlowsDates;varnHistoricalCashFlows = cObj.model.nHistoricalCashFlows;for (var i = 0; i < cObj.cashFlowsPv.length; i++){varcf = cObj.cashFlowsPv[i];vardate = dates[nHistoricalCashFlows + i];columns.push({name: date,color: (cf > 0) ? '#079A82' : '#EF5350',y: Math.round(cObj.cashFlowsPv[i])});}columns.push({name: 'Growth Period Value',color: '#627D98',isSum: true});columns.push({name: 'Terminal Value',color: (cObj.tvPv > 0) ? '#079A82' : '#EF5350',y: Math.round(cObj.tvPv),});columns.push({name: 'Total Present Value',color: '#627D98',isSum: true,});return columns;}dcfCalculator.createValueDecompositionChartTooltip = function (obj){varcolor = obj.color;varitem = obj.key;vardivider = getDivider(obj.y);vardividerText = getDividerShortText(divider);varvalue = accounting.formatNumber(obj.y / divider) + dividerText;vartooltip = '';if ((!obj.point.options.isSum) && (obj.y > 0))value = '+' + value;tooltip += '
';tooltip += '
' + item + ': | ';tooltip += `${value} USD | `;tooltip += '
';tooltip += '
';return tooltip;}// dcfCalculator.renderSensitivityResults = function (fieldName, sensitivityResults) {this.sensitivityChart = this.createSensitivityChart(fieldName, sensitivityResults);if (this.sensitivityChart)this.renderSensitivityInfoOnChart(sensitivityResults);}dcfCalculator.destroySensitivityChart = function () {if (this.sensitivityChart){this.sensitivityChart.destroy();this.sensitivityChart = false;}}dcfCalculator.createSensitivityChart = function (fieldName, sensitivityResults) {varcObj = this;return Highcharts.chart('sensitivity-analysis-chart', {credits: {enabled: false},title: {text: null},chart: {type: 'column',backgroundColor: 'transparent',zooming: {mouseWheel: false}},legend: {enabled: false},plotOptions: {column: {crisp: false,borderWidth: 0,borderRadius: 2}},xAxis: {tickColor: 'transparent',lineColor: 'transparent',startOnTick: false,endOnTick: false,labels:{enabled: true,reserveSpace: true,style: {fontSize: '0.85rem',fontWeight: 300,color: '#3E4C59'},formatter: function () {return accounting.formatNumber(this.value) + '%'}},},yAxis: {title: {text : null},gridLineColor: '#E4E7EB',gridLineDashStyle: 'Dash',startOnTick: false,endOnTick: false,opposite: true,labels: {enabled: true,reserveSpace: true,style: {fontSize: '0.85rem',fontWeight: 300,color: '#3E4C59'},formatter: function () {if (this.value == 0)return '';return accounting.formatNumber(this.value) + ' USD'}},min: 0},tooltip: {outside: true,backgroundColor: 'rgba(0, 0, 0, 0)',borderWidth: 0,borderRadius: 0,padding: 0,shadow: false,shared: true,shape: 'rect',hideDelay: 50,useHTML: true,formatter: function () {return cObj.createSensitivityChartTooltip(this, fieldName);},style: {fontSize: '0.95rem'}},rangeSelector: {enabled: false},scrollbar: {enabled: false},navigator: {enabled: false},series: [{name: 'Intrinsic Value',data: sensitivityResults,dataGrouping: {enabled: false,},zones: [{value: 825.07,color: '#EF5350'}, {color: '#26A69A'}]}],responsive: {rules: [{condition: {maxWidth: 991},chartOptions: {yAxis: {labels: {enabled: false}}}}]}});}dcfCalculator.createSensitivityChartTooltip = function (obj, fieldName){vartooltip = '';varintrinsicValue = accounting.formatNumber(obj.y, countDecimals(obj.y)) + ' USD';varunderOverValuation, underOverValuationText;if (825.07 > obj.y){if (obj.y > 0)underOverValuation = (825.07 - obj.y) / 825.07;elseunderOverValuation = 1;underOverValuationText =accounting.formatNumber(underOverValuation * 100) +'% overvalued';}else{underOverValuation = 1 - (825.07 / obj.y);underOverValuationText =accounting.formatNumber(underOverValuation * 100) +'% undervalued';}tooltip += '
';tooltip += '
' + fieldName + ': | ';tooltip += '' + obj.x + '% | ';tooltip += '
Intrinsic value: | ';tooltip += '' + intrinsicValue + ' | ';tooltip += '
';tooltip += '
';if (825.07 > obj.y){tooltip += `
${underOverValuationText}
`;}else{tooltip += `
${underOverValuationText}
`;}tooltip += '
';return tooltip;}dcfCalculator.renderSensitivityInfoOnChart = function (sensitivityResults){this.renderStockPriceOnSensitivityChart();}dcfCalculator.renderStockPriceOnSensitivityChart = function (){this.sensitivityChart.yAxis[0].addPlotLine({dashStyle: 'ShortDot',value: 825.07,width: 1,zIndex: 3,color: '#1F2933',label: {y: -2,x: -10,useHTML: true,text: '
Last Price: 825.07 USD
',align: 'right'}});}dcfCalculator.startExclusiveAnimator = function (selector, callback){varcObj = this;if (cObj.animatorStates[selector] === undefined)cObj.animatorStates[selector] = 'init';if (cObj.animatorStates[selector] === 'init'){cObj.animatorStates[selector] = 'started';new Animator($(`#${selector}`), () => {cObj.animatorStates[selector] = 'init';callback();});}}//