Switch to:
GuruFocus has detected 4 Warning Signs with Coca-Cola European Partners PLC $CCE.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Coca-Cola European Partners PLC (NYSE:CCE)
Median PS Value
$33.13 (As of Today)

This valuation method assumes that the stock valuation will revert to its historical mean in terms of Price/Sales Ratio. The reason we use P/S Ratio instead of P/E Ratio or P/B Ratio is because Price/Sales Ratio is independent of profit margin, and can be applied to a broader range of situations.

Median P/S Value is calculated as trailing twelve months (TTM) revenue per share times 10-Year median P/S ratio. Coca-Cola European Partners PLC's revenue per share for the trailing twelve months (TTM) ended in Dec. 2016 was $27.838. Coca-Cola European Partners PLC's 10-Year median P/S ratio is 1.19. Therefore, the Median P/S Value for today is $33.13.

As of today, Coca-Cola European Partners PLC's share price is $38.62. Coca-Cola European Partners PLC's median P/S value is $33.13. Therefore, Coca-Cola European Partners PLC's Price to Median P/S Value Ratio for today is 1.17.

CCE' s Price-to-Median-PS-Value Range Over the Past 10 Years
Min: 0.23   Max: 1.39
Current: 1.17

0.23
1.39

During the past 13 years, the highest Price to Median P/S Value Ratio of Coca-Cola European Partners PLC was 1.39. The lowest was 0.23. And the median was 0.52.

CCE's Price-to-Median-PS-Value is ranked lower than
54% of the 84 Companies
in the Global Beverages - Soft Drinks industry.

( Industry Median: 1.13 vs. CCE: 1.17 )

Definition

Coca-Cola European Partners PLC's Median P/S Value for today is calculated as

Median P/S Value=Total Annual Sales / Shares Outstanding*10-Year Median P/S Ratio
=Revenue per Share (TTM)*10-Year Median P/S Ratio
=27.838*1.19
=33.13

10-Year Median P/S Ratio is 1.19.
Coca-Cola European Partners PLC's revenue per share for the trailing twelve months (TTM) ended in Dec. 2016 was 6.413 (Mar. 2016 ) + 7.421 (Jun. 2016 ) + 6.867 (Sep. 2016 ) + 7.137 (Dec. 2016 ) = $27.838.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.


Explanation

This valuation method assumes that the stock valuation will revert to its historical mean in terms of Price/Sales Ratio. The reason we use P/S Ratio instead of P/E Ratio or P/B Ratio is because Price/Sales Ratio is independent of profit margin, and can be applied to a broader range of situations.

It also assumes that over time the profit margin is constant. If a company increases its profit margin to a sustainable level, this value might under-estimate its value. If it has permanent declined profit margins, this may over-estimate the company’s value.

Coca-Cola European Partners PLC's Price to Median P/S Value Ratio for today is calculated as

Price to Median P/S Value=Share Price/Median P/S Value
=38.62/33.13
=1.17

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.


Related Terms

P/E Ratio, P/B Ratio, P/S Ratio, Intrinsic Value (DCF Projected), Intrinsic Value (DCF), Intrinsic Value (DE), Graham Number, GAVA


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Coca-Cola European Partners PLC Annual Data

Dec07Dec08Dec09Dec10Dec11Dec12Dec13Dec14Dec15Dec16
medpsvalue 49.8653.2236.6520.1131.7331.0834.8837.0135.5233.13

Coca-Cola European Partners PLC Quarterly Data

Sep14Dec14Mar15Jun15Sep15Dec15Mar16Jun16Sep16Dec16
medpsvalue 38.0637.0136.2835.1734.4035.5235.2734.3332.8633.13
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)
FEEDBACK