Image Source: Unsplash
 

As part of a new series, each week we typically conduct a DCF on one of the companies in our screens. This week we thought we’d take a look at one of the stocks that is not currently in our screens, Coca-Cola (KO).
 

Profile

Founded in 1886, Atlanta-headquartered Coca-Cola is the world’s largest nonalcoholic beverage company, with a strong portfolio of 200 brands covering key categories including carbonated soft drinks, water, sports, energy, juice, and coffee. Together with bottlers and distribution partners, the company sells finished beverage products bearing Coca-Cola and licensed brands through retailers and food-service locations in more than 200 countries and regions globally. Coca-Cola generates around two thirds of its total revenues overseas, with a significant portion from emerging economies in Latin America and Asia-Pacific.
 

Recent Performance

Over the past twelve months, the share price is down 0.22%.

KO data by YCharts

Inputs

• Discount Rate: 6.5%
• Terminal Growth Rate: 2%
• WACC: 6.5%

Forecasted Free Cash Flows (FCFs)

Terminal Value

Terminal Value = FCF * (1 + g) / (r – g) = 243.44 billion

Present Value of Terminal Value

PV of Terminal Value = Terminal Value / (1 + WACC)^5 = 177.68 billion

Present Value of Free Cash Flows

Present Value of FCFs = ∑ (FCF / (1 + r)^n) = 45.29 billion

Enterprise Value

Enterprise Value = Present Value of FCFs + Present Value of Terminal Value = 222.97 billion

Net Debt

Net Debt = Total Debt – Total Cash = -32.69 billion

Equity Value

Equity Value = Enterprise Value – Net Debt = 190.27 billion

Per-Share DCF Value

Per-Share DCF Value = Enterprise Value / Number of Shares Outstanding = $44.25
 

Conclusion

Based on the DCF valuation, the stock is overvalued. The DCF value of $44.25 per share is lower than the current market price of $60.46. The Margin of Safety is -36.63%

More By This Author: