Switch to:
Coca-Cola Enterprises Inc (NYSE:CCE)
Intrinsic Value (FCF Projected)
$31.43 (As of Today)

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value (DCF), or Discounted Earnings (DCE) Intrinsic Value (DE) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company. The details of how we calculate the intrinsic value of stocks are described in detail here.

As of today, Coca-Cola Enterprises Inc's FCF projected intrinsic value is $31.43. The stock price of Coca-Cola Enterprises Inc is $44.39. Therefore, Coca-Cola Enterprises Inc's Price to Intrinsic Value (FCF Projected) Ratio of today is 1.4.

CCE' s 10-Year Price to Intrinsic Value (FCF Projected) Range
Min: 0.8   Max: 6.01
Current: 1.4

0.8
6.01

During the past 13 years, the highest Price to Intrinsic Value (FCF Projected) Ratio of Coca-Cola Enterprises Inc was 6.01. The lowest was 0.80. And the median was 1.31.

CCE's Price to Intrinsic Value (FCF Projected) is ranked higher than
63% of the 67 Companies
in the Global Beverages - Soft Drinks industry.

( Industry Median: 1.80 vs. CCE: 1.40 )

Definition

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value (DCF), or Discounted Earnings (DCE) Intrinsic Value (DE) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company.

The details of how we calculate the intrinsic value of stocks are described in detail here.

This method smooths out the free cash flow over the past 6-7 years, multiplies the results by a growth multiple, and adds a portion of total equity.

Value = ((Growth Multiple)*Free Cash Flow(6 year avg) + 0.8*Total Equity(most recent))/Shares Outstanding

In the case of negative total equity, the following formula is used (see the Total Equity section for the reason):

Value = ((Growth Multiple)*Free Cash Flow(6 year avg) + Total Equity(most recent)/0.8)/Shares Outstanding


Here Coca-Cola Enterprises Inc's FCF(6 year avg) is calculate as

Coca-Cola Enterprises Inc Quarterly Data

201212201303201306201309201312201403201406201409201412201503
total_freecashflow 140-7472379143-217829529860
201006201009201012201103201106201109201112201203201206201209
total_freecashflow 7444799-7515032685-201248382
200906200909200912201003
total_freecashflow 20250524-86

Add all the Free Cash Flow together and divide 6 will get Coca-Cola Enterprises Inc's FCF(6 year avg) = $591.67.

Coca-Cola Enterprises Inc's FCF Projected Intrinsic Value for today is calculated as

Intrinsic Value=(Growth Multiple*Free Cash Flow(6 year avg)+Total Equity(Mar15)*0.8)/Shares Outstanding
=(11.3770674159*591.666666667+1016*0.8)/240.000
=31.43

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


Explanation

The growth multiple is capped between 8.35 and 17.74.

Total equity weighting is more art than science and it should always be revisited in more detail when researching a company. Weightings from 0% to 100% to more than 100% are possible. 80% was chosen as a happy medium after taking the above ideas into consideration. Learn more here.

Coca-Cola Enterprises Inc's Price to FCF Projected Intrinsic Value Ratio for today is calculated as

Price to FCF Projected Intrinsic Value=Share Price/FCF Projected Intrinsic Value
=44.39/31.4342981433
=1.41

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


Related Terms

Intrinsic Value (DE), Intrinsic Value (DCF), Free Cash Flow


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
iv_dcf_share 18.8418.4121.5013.4826.3425.3325.7926.5127.1928.83

Coca-Cola Enterprises Inc Quarterly Data

Dec12Mar13Jun13Sep13Dec13Mar14Jun14Sep14Dec14Mar15
iv_dcf_share 26.5127.0726.4027.7127.1928.3028.1227.4628.8331.43
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)

GuruFocus Premium Plus Membership

FEEDBACK