Loading...

Coca-Cola Co
NYSE:KO

Watchlist Manager
Coca-Cola Co Logo
Coca-Cola Co
NYSE:KO
Watchlist
Price: 62.64 USD +0.02% Market Closed
Updated: Nov 26, 2022

DCF Value

This DCF valuation model was created by Alpha Spread and was last updated on Nov 25, 2022.

Estimated DCF Value of one KO stock is 34.22 USD. Compared to the current market price of 62.64 USD, the stock is Overvalued by 45%.

KO DCF Value
Base Case
34.22 USD
Overvaluation 45%
DCF Value
Price
Worst Case
Base Case
Best Case
34.22
DCF Value
Worst Case
Base Case
Best Case
Hide
DCF Value: 34.22 USD
Coca-Cola Co Competitors:
DCF Valuation
2587
Suntory Beverage & Food Ltd
NICL
Nichols PLC
CCH
Coca Cola HBC AG
COKE
Coca-Cola Consolidated Inc
PRMW
Primo Water Corp
KOF
Coca-Cola Femsa SAB de CV
2599
Japan Foods Co Ltd
2593
Ito En Ltd

Present Value Calculation

The first step in the DCF calculation process is to estimate the company's future free cash flow. Once free cash flow is forecasted, it is discounted at a risk-appropriate discount rate. The resulting value is the present value of the company's free cash flow. You can change any model inputs below.

Available Valuation Models
1 valuation model available
Alpha Spread
Updated on Nov 25, 2022
Default Valuation
Create My Valuation Model
Other investors haven't shared any valuation models for Coca-Cola Co.
Model Settings
Discount Rate
7.48%
Forecast Period
5 Years
Terminal Growth
0%
Discount Rate
7.48%
Terminal Growth
0%
Growth Period
5 Years
Copy as My Model

DCF Model
Base Case Scenario

Rotate your device to view
DCF Model

To view the process of deriving the DCF Value of one share from the estimated Present Value, see the DCF Value Calculation block.

DCF Value Calculation

Depending on which type of operating model is chosen (equity or whole firm valuation model), the resulting value is either the value of equity or the value of the entire firm. In the case of the latter, to move from the value of the firm to the value of equity, liabilities are subtracted and assets are added.

Capital Structure
From Present Value to DCF Value

Present Value 158B USD
+ Cash & Equivalents 10.1B USD
+ Investments 21.4B USD
Firm Value 189B USD
- Debt 38.9B USD
- Minority Interest 1.6B USD
Equity Value 149B USD
/ Shares Outstanding 4.3B
KO DCF Value 34.22 USD
Overvalued by 45%

To view the process of calculating the Present Value of Coca-Cola Co' future free cash flow, see the Present Value Calculation block.

Valuation Analysis

After the valuation process, in order to gain a deeper understanding of the relationship between risk and opportunity, it is useful to study the dynamic of company's valuation under various inputs to the DCF model in use.

DCF Financials
Financials used in DCF Calculation

Revenue
44.2B 49.3B
Operating Income
12.8B 13.9B
FCFF
11.7B 11.8B

Sensitivity Analysis
DCF Value Sensitivity Analysis

See Also

Similar Stocks
What is the DCF value of one KO stock?

Estimated DCF Value of one KO stock is 34.22 USD. Compared to the current market price of 62.64 USD, the stock is Overvalued by 45%.

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. Using the DCF Operating Model we project Coca-Cola Co's future free cash flow and discount it at a selected discount rate to calculate its Present Value (158B USD).

2. DCF Value Calculation. We use the company's capital structure to calculate the total Equity Value based on the previously computed Present Value of the free cash flow. Dividing the Equity Value by the number of shares outstanding gives us the DCF Value of 34.22 USD per one KO share.