Switch to:
Coca-Cola Enterprises Inc (NYSE:CCE)
Shiller P/E Ratio
19.64 (As of Today)

As of today, Coca-Cola Enterprises Inc's current share price is $44.00. Coca-Cola Enterprises Inc's E10 for the quarter that ended in Dec. 2014 was $2.24. Coca-Cola Enterprises Inc's Shiller P/E Ratio for today is 19.64.

CCE' s 10-Year Shiller P/E Ratio Range
Min: 18.68   Max: 906.5
Current: 19.9

18.68
906.5

During the past 13 years, Coca-Cola Enterprises Inc's highest Shiller P/E Ratio was 906.50. The lowest was 18.68. And the median was 34.36.

CCE's Shiller P/E Ratiois ranked higher than
93% of the 162 Companies
in the Global Beverages - Soft Drinks industry.

( Industry Median: 46.41 vs. CCE: 19.90 )

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 Enterprises Inc's adjusted earnings per share data for the three months ended in Dec. 2014 was $0.453. Since most companies do not have as long as 10 years history, here we use 6 years to calculate. Add all the adjusted EPS for the past 6 years together and divide 6 will get our E10, which is $2.24 for the trailing six years ended in Dec. 2014.


Definition

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 Enterprises Inc's Shiller P/E Ratio for today is calculated as

Shiller P/E Ratio=Share Price/E10
=44.00/2.24
=19.64

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

Coca-Cola Enterprises Inc's E10 for the fiscal year that ended in Dec14 is calculated as:

For example, Coca-Cola Enterprises Inc's adjusted earnings per share data for the three months ended in Dec. 2014 was:

Adj_EPS=Earnigns per Share/CPI of Dec. 2014*CPI of Current
=0.455/234.812*233.808
=0.453

Since most companies do not have as long as 10 years history, GuruFocus uses 6 years to do the calculation.

Current CPI = 233.808.

Coca-Cola Enterprises Inc Quarterly Data

201209201212201303201306201309201312201403201406201409201412
per share eps 0.8900.3420.2100.6601.0700.5170.4400.7800.9600.455
CPI 231.407229.601232.773233.504234.149233.049236.293238.343238.031234.812
Adj_EPS 0.8990.3480.2110.6611.0680.5190.4350.7650.9430.453
201003201006201009201012201103201106201109201112201203201206
per share eps 0.3500.5900.6100.2830.3100.7400.8800.3590.3500.670
CPI 217.631217.965218.439219.179223.467225.722226.889225.672229.392229.478
Adj_EPS 0.3760.6330.6530.3020.3240.7670.9070.3720.3570.683
200903200906200909200912
per share eps 0.1300.6400.5900.268
CPI 212.709215.693215.969215.949
Adj_EPS 0.1430.6940.6390.290

Add all the adjusted EPS together and divide 6 will get our E10.


Explanation

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.


Be Aware

The Shiller P/E assumes that over the long term, businesses and profitability revert to their means. If a company’s business model does not work in the future compared with the past, the Shiller P/E and P/S ratio will give false valuations.


Related Terms

P/E Ratio, P/B Ratio, P/S Ratio, Price-to-Free-Cash-Flow ratio, E10


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

Coca-Cola Enterprises Inc Annual Data

Dec05Dec06Dec07Dec08Dec09Dec10Dec11Dec12Dec13Dec14
ShillerPE 23.7163.3435.25-12.94-21.28-26.12-31.93759.05244.6119.74

Coca-Cola Enterprises Inc Quarterly Data

Sep12Dec12Mar13Jun13Sep13Dec13Mar14Jun14Sep14Dec14
ShillerPE -43.25759.05513.22454.23262.69244.61189.6330.5626.9919.74
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)
Free 7-day Trial
FEEDBACK