Switch to:
GuruFocus has detected 3 Warning Signs with Coca-Cola Femsa SAB de CV $KOF.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Coca-Cola Femsa SAB de CV (NYSE:KOF)
Intrinsic Value: Projected FCF
$34.79 (As of Today)

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings Intrinsic Value: DCF (Earnings Based) 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 Femsa SAB de CV's projected FCF intrinsic value is $34.79. The stock price of Coca-Cola Femsa SAB de CV is $77.40. Therefore, Coca-Cola Femsa SAB de CV's Price to Intrinsic Value: Projected FCF Ratio of today is 2.2.

KOF' s Price-to-Intrinsic-Value-Projected-FCF Range Over the Past 10 Years
Min: 0.53   Max: 6.14
Current: 2.22

0.53
6.14

During the past 13 years, the highest Price to Intrinsic Value: Projected FCF Ratio of Coca-Cola Femsa SAB de CV was 6.14. The lowest was 0.53. And the median was 1.98.

KOF's Price-to-Intrinsic-Value-Projected-FCF is ranked lower than
56% of the 48 Companies
in the Global Beverages - Soft Drinks industry.

( Industry Median: 2.03 vs. KOF: 2.22 )

Definition

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings Intrinsic Value: DCF (Earnings Based) 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 Femsa SAB de CV's FCF(6 year avg) is calculate as

Coca-Cola Femsa SAB de CV Quarterly Data

201412201503201506201509201512201603201606201609201612201703
total_freecashflow 0000000000
201206201209201212201303201306201309201312201403201406201409
total_freecashflow 304000000000
201106201109201112201203
total_freecashflow 41935881429

Add all the Free Cash Flow together and divide 6 will get Coca-Cola Femsa SAB de CV's FCF(6 year avg) = $265.30.

Coca-Cola Femsa SAB de CV's Intrinsic Value: Projected FCF for today is calculated as

Intrinsic Value=(Growth Multiple*Free Cash Flow(6 year avg)+Total Equity(Mar17)*0.8)/Shares Outstanding
=(9.52035159596*265.295621948+5935.01037344*0.8)/207.290
=35.09

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's 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 Femsa SAB de CV's Price to Intrinsic Value: Projected FCF Ratio for today is calculated as

Price to Intrinsic Value: Projected FCF=Share Price/Intrinsic Value: Projected FCF
=77.40/35.0895648443
=2.21

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


Related Terms

Intrinsic Value: DCF (Earnings Based), Intrinsic Value: DCF (FCF Based), Free Cash Flow


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 Femsa SAB de CV Annual Data

Dec07Dec08Dec09Dec10Dec11Dec12Dec13Dec14Dec15Dec16
Projected FCF 19.6318.0637.6951.0473.7279.1778.1264.1646.5937.19

Coca-Cola Femsa SAB de CV Quarterly Data

Dec14Mar15Jun15Sep15Dec15Mar16Jun16Sep16Dec16Mar17
Projected FCF 64.1654.5052.9747.9446.5943.2641.3939.5537.190.00
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)

GF Chat

FEEDBACK