The CocaCola Company (NYSE:KO) is one of the most popular companies in the world. The beverage giant offers a wide selection of drinks, ranging from carbonated energy drinks to flavored waters. The company has several wellknown brands in its portfolio, such as Diet Coke, Fanta, Sprite, and the world famous CocaCola brand.
The Atlantaheadquartered CocaCola has a history of more than 125 years. Initially, the company was formed as a pharmaceutical enterprise. With the growth of commercial bottling industry and soda fountains, CocaCola has established itself as a global beverage company. Thanks to strong partnerships with local producers, CocaCola has presence in almost every country in the world. It has posted an annualized earnings growth of 11.3% in the last 5 years, and the stock returned near 100% since its dip in 2009.
As of the time of writing, CocaCola stock was trading at $73 with a 52week range of $63  $78. It has a market cap of $165.7 billion. Trailing twelve month [ttm] P/E ratio is 19.5, and forward P/E ratio is 16.4. P/B, P/S, and P/CF ratios stand at 5.1, 3.6, and 17.9, respectively. Operating margin is 22%, and net profit margin is 18.5%. The company has some debt issues. Debt/equity ratio is 0.5. CocaCola is a nifty dividend payer. Based on the latest dividend of $0.51, the projected yield is 2.8%.
CocaCola has a 3star rating from Morningstar. Out of 4 analysts covering the company, 2 have buy, and 2 have hold ratings. Wall Street has diverse opinions on CocaCola's future. For this year, topline growth estimate is 27.9%, whereas the bottomline growth estimate is 6%. Average fiveyear annualized growth forecast estimate is 8.4%. This seems like a reasonable estimate, given the company's past 5year growth record of 11.3%.
What is the fair value of CocaCola given the forecast estimates? We can estimate CocaCola's fair value using our discounted earnings plus equity model as follows:
Discounted Earnings Plus Equity Model
This model is primarily used for estimating the returns from longterm projects. It is also frequently used to price fairvalued IPOs. The methodology is based on discounting the present value of the future earnings to the current period:
V = E_{0} + E_{1} /(1+r) + E_{2} /(1+r)^{2} + E_{3}/(1+r)^{3} + E_{4}/(1+r)^{4} + E_{5}/(1+r)^{5} + Disposal Value
V = E_{0} + E_{0} (1+g)/(1+r) + E_{0}(1+g)^{2}/(1+r)^{2} + â€¦ + E_{0}(1+g)^{5}/(1+r)^{5} + E_{0}(1+g)^{5}/[r(1+r)^{5}]
The earnings after the last period act as a perpetuity that creates regular earnings:
Disposal Value = D = E_{0}(1+g)^{5}/[r(1+r)^{5}] = E_{5} / r
While this formula might look scary for many of us, it easily calculates the fair value of a stock. All we need is the currentperiod earnings, earnings growth estimate, and the discount rate. To be as objective as possible, I use Morningstar data for my growth estimates. You can set these parameters as you wish, according to your own diligence.
Valuation
Historically, the average return of the DJI has been around 11% (including dividends). Therefore, I will use 11% as my discount rate. In order to smooth the results, I will also take the average of ttm EPS along with the mean EPS estimate for the next year.
E_{0} = EPS = ($3.77 + $4.46) / 2 = $4.12
Wall Street holds diversified opinions on the company's future. While analysts tend to impose subjective opinions on their estimates, the average analyst estimate is a good starting point. Average fiveyear growth forecast is 8.4%. Book value per share is $14.54. The rest is as follows:
Fair Value Estimator  
V (t=0) 
E_{0} 
$4.12 
V (t=1) 
E_{0} (1+g)/(1+r) 
$4.02 
V (t=2) 
E_{0}((1+g)/(1+r))^{2} 
$3.92 
V (t=3) 
E_{0}((1+g)/(1+r))^{3} 
$3.83 
V (t=4) 
E_{0}((1+g)/(1+r))^{4} 
$3.74 
V (t=5) 
E_{0}((1+g)/(1+r))^{5} 
$3.66 
Disposal Value 
E_{0}(1+g)^{5}/[r(1+r)^{5}] 
$33.23 
Book Value 
BV 
$14.54 
Fair Value Range 
Lower Boundary 
$56.52 
Upper Boundary 
$71.06 

Minimum Potential 
23% 

Maximum Potential 
3.5% 
(You can download FED+ Fair Value Estimator, here.)
I decided to add the book value per share so that we can distinguish between a lowdebt and debtloaded company. The lower boundary does not include the book value. According to my 5year discountedearningsplusbookvalue model, the fairvalue range for CocaCola is between $56.5 and $71 per share. At the current valuation, CocaCola is overvalued.
Click to enlarge
Summary
Looking at the graph above, one can see that the CocaCola stock is forming something like a headandshoulder formation. The stock made it to alltime high of $78, but could not stay there long, and retreated back to below $75. Recently, New York City Mayor, Michael Bloomberg, expressed his intention to ban largesized sugary drinks. While the proposed move would not have much direct effect on the sodaproducers profits, it could trigger actions from other states, which might propose similar or even more restrictive legislation.
CocaCola is a great company, but its stock is obviously overpriced at the current valuation. The company has to grow by at least 16% annually to justify its current price. McDonald's (NYSE:MCD), which has been a longtime flier, is trading at a trailing P/E ratio of 16. Compared CocaCola, even McDonald's (which I believe is expensive) looks cheaper.
CocaCola has a great moat in the retail beverage business. It is one of the best companies in the consumeroriented service industries. There is also an aggressive growth factor. However, it is trading at significantly higher ratios than the industry average. Its closest competitor, Pepsi (NYSE:PEP), has relatively more attractive ratios. Pepsi's P/E ratio of 16.7, P/B ratio of 4.7, and P/S ratio of 1.6 are all lower than that of CocaCola's valuation ratios. At the current prices, Pepsi also offers a slightly higher yield of 3.1%. Another competitor, Dr. Pepper Snapple (NYSE:DPS), offers a yield of 3.2%, and is priced with a low P/E ratio of 15.
I think CocaCola has one of the top management teams in the business world. As the company reported doubledigit earnings growth, shareholders enjoyed doubledigit returns. However, after returning more than 16% in the last year alone, the stock is primed for a correction. This year will probably be a mediocre one for the shareholders. The stock needs a rest to regain its momentum. The recent selloff is a strong warning signal to bulls. I think the correction has just begun, and there are volatile days ahead for the shareholders. Therefore, I recommend investors to avoid CocaCola until the stock falls within a fair valuation range. A price below $70 could offer a better entry point.
Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.