KO has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
As of today, Coca-Cola Co's current share price is $43.07. Coca-Cola Co's E10 for the quarter that ended in Dec. 2016 was $1.83. Coca-Cola Co's Shiller P/E Ratio for today is 23.54.
During the past 13 years, Coca-Cola Co's highest Shiller P/E Ratio was 33.95. The lowest was 19.75. And the median was 24.52.
E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller P/E calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years.
Coca-Cola Co's adjusted earnings per share data for the three months ended in Dec. 2016 was $0.120. Add all the adjusted EPS for the past 10 years together and divide 10 will get our E10, which is $1.83 for the trailing ten years ended in Dec. 2016.
For the Shiller P/E, the earnings of the past 10 years are inflation-adjusted and averaged. The result is used for P/E calculation. Since it looks at the average over the last 10 years, the Shiller P/E is also called PE10.
The Shiller P/E was first used by professor Robert Shiller to measure the valuation of the overall market. The same calculation is applied here to individual companies.
Coca-Cola Co's Shiller P/E Ratio for today is calculated as
|Shiller P/E Ratio||=||Share Price||/||E10|
Coca-Cola Co's E10 for the fiscal year that ended in Dec16 is calculated as:
For example, Coca-Cola Co's adjusted earnings per share data for the three months ended in Dec. 2016 was:
|Adj_EPS||=||Earnigns per Share||/||CPI of Dec. 2016 (Change)||*||Current CPI (Dec. 2016)|
Current CPI (Dec. 2016) = 241.432.
Coca-Cola Co Quarterly Data
|per share eps||0.480||0.180||0.350||0.710||0.330||0.280||0.340||0.790||0.240||0.120|
|per share eps||0.450||0.610||0.500||0.410||0.390||0.590||0.540||0.380||0.360||0.580|
|per share eps||0.405||0.330||0.345||0.510||0.440||1.235||0.410||0.600||0.480||0.360|
|per share eps||0.270||0.400||0.355||0.260||0.320||0.305||0.405||0.215||0.290||0.440|
Add all the adjusted EPS together and divide 10 will get our E10.
Compared with the regular P/E ratio, which works poorly for cyclical businesses, the Shiller P/E smoothed out the fluctuations of profit margins during business cycles. Therefore it is more accurate in reflecting the valuation of the company.
If a company has consistent business performance, the Shiller P/E should give similar results to regular P/E.
Compared with the P/S ratio, the Shiller P/E makes the comparison between different industries more meaningful.
The Shiller P/E assumes that over the long term, businesses and profitability revert to their means. If a companys business model does not work in the future compared with the past, the Shiller P/E and P/S ratio will give false valuations.
Coca-Cola Co Annual Data
Coca-Cola Co Quarterly Data