OTC: COCSF - Coca-Cola FEMSA, S.A.B. de C.V.

Yield per half year: -7.56%
Sector: Consumer Staples

Summary of Company Analysis Coca-Cola FEMSA, S.A.B. de C.V.

Capitalization = 17.48, Grade = 6/10
Revenue = 245.088, Grade = 8/10
EBITDA margin, % = 19.15, Grade = 6/10
Net margin, % = 7.97, Grade = 3/10
ROA, % = 7.14, Grade = 2/10
ROE, % = 15.38, Grade = 5/10
P/E = 15.55, Grade = 7/10
P/S = 1.24, Grade = 9/10
P/BV = 2.27, Grade = 6/10
Debt/EBITDA = 1.41, Grade = 8/10
Summary:
EBITDA margin average, judging by the multipliers it is estimated fair and interesting to buy.
Earnings per share (1517.41%) and EBITDA yield (71.3%) are located on high level, and it’s worth taking a closer look at the purchase.
Efficiency (ROE=15.38%) are located on low level, the company is not efficient enough.

5.78/10

All company characteristics ⇨

Pay for your subscription

More functionality and data for company and portfolio analysis is available by subscription

Subscribe

Dividend payment stability index

DSI - (Dividend Stability Index, DSI7), Dividend payment stability index
DSI = (Yc + Gc) / 14
Yc – number of consecutive years out of the last seven years in which dividends were paid;
Gc - number of consecutive years out of the last seven years in which the dividend amount was not lower than the previous year.
Yc = 6
Gc = 2
DSI = 0.57

5.7/10

Stability index share price increase

SSI - (Stock Stability Index, SSI7) Stability index share price increase
SSI = Yc / 7
Yc – number of consecutive years out of the last seven years in which the stock price was higher than the previous year.
Yc = 4
SSI = 0.57

5.7/10

Warren Buffett Valuation

Analysis and valuation of the company Coca-Cola FEMSA, S.A.B. de C.V. according to Buffett


1. Stable profit, Value = 79.65% > 0
If growth over 5 years / growth over last 12 months > 0
2. Good debt coverage, Value = 0 < 3
When will the company be able to pay off the debt within 3 years
3. High return on capital, Value = 12.5% > 15
If the average ROE > 15% over the last 5 years
4. High return on investment capital, Value = 172% > 12
If average ROIC > 12% over the last 5 years
5. Positive free cash flow, Value = 367.38 > 0
Positive FCF in the last 12 months
6. Are there any share buybacks?, Value = yes
If the number of shares today < number of shares 5 years ago

8.33/10

Benjamin Graham score

Analysis and valuation of {$company} by Benjamin Graham


1. Adequate company size, Grade = 8/10 (245.088, LTM)
2. Stable financial position (current assets/current liabilities), Grade = 10/10 ( LTM)
Current assets must be at least twice the current liabilities
3. Stable profit, Grade = 9/10
The company must not have incurred losses over the past 10 years
4. Dividend history, Grade = 8.6/10
The company must pay dividends for at least 20 years
5. Earnings growth (earnings per share), Value = 1517.41%
The company's earnings per share must have increased by at least 1/3 over the last 10 years.
5.5. Share price growth, Value = 13.29%
The share price, as an indicator of the company's profit growth, should increase by at least 1/3 over the last 10 years
5.6. Dividend growth, Value = 84.74%
Dividend payments, as an indicator of company profit growth, should increase by at least 1/3 over the last 10 years
6. Optimal price/earnings ratio, Grade = 7/10 ( LTM)
The current share price should not exceed the average earnings for the last three years by more than 15 times
7. The optimal value of the price/book value ratio, Grade = 6/10 ( LTM)
The current share price should not exceed its book value by more than 1.5 times

7.92/10

Score by Peter Lynch

Analysis and evaluation of {$company} according to Lynch


1. Current assets exceed last year's = 79.21 > 79.21
Comparison of assets for the last 2 years. If the last year exceeds the previous one, this is a good sign
2. Debt reduction = 65.97 < 67.74
Reducing debt over recent years is a good sign
3. Excess cash debt = 31.06 > 65.97
If cash exceeds debt load, this is a good sign, which means the company is not at risk of bankruptcy.
4. Are there any share buybacks? = yes
If the number of shares today < number of shares 5 years ago
5. Increased earnings per share = 9.3 > 93
Increased earnings per share compared to the previous year. This means efficiency is increasing, and this is a good sign.
6. Valuation of P/E and EPS versus price = 184.38 < 8.85
If the P/E and earnings per share are less than the share price, then the share is undervalued (see “The Peter Lynch Method,” page 182)

3.33/10

Dividend strategy

1. Current dividend = 0 $.
1.5. Dividend yield = 0% , Grade = 0/10
2. Number of years of dividend growth = 0 , Grade = 0/10
2.5. Number of recent years when the dividend percentage increased = 0
3. DSI = 0.57 , Grade = 5.71/10
4. Average dividend growth = -864.03% , Grade = 0/10
5. Average percentage for 5 years = 11.06% , Grade = 10/10
6. Average percentage for payments = 70.89% , Grade = 10/10
7. Difference with sector = 9.07, Industry average = -9.07% , Grade = 0/10

3.67/10

Beta coefficient

β > 1 – the profitability (as well as volatility) of such securities is very sensitive to market changes. Such assets are more exposed to risk, but potentially more profitable. In general, such securities can be called aggressive;
β = 1 – the profitability of such a security will change equally with the profitability of the market (stock index);
0 < β < 1 – with such a beta, assets are less exposed to market risk and, as a result, less volatile. Such securities have less risk, but are also less profitable in the future;
β = 0 – there is no connection between the security and the market (index) as a whole;
β < 0 – the yield of securities with a negative beta goes in the opposite direction to the market.

β = -1.66 - in 90 days
β = -0.14 - in 1 year
β = -281.68 - in 3 years

Altman index

In 1968, Professor Edward Altman proposed his now classic five-factor model for predicting the likelihood of enterprise bankruptcy. The formula for calculating the integral indicator is as follows:
Z = 1.2*X1 + 1.4*X2 + 3.3*X3 + 0.6*X4 + X5
X1 = Working capital/Assets, X2 = Retained earnings/Assets, X3 = Operating profit/Assets, X4 = Market value of shares/Liabilities, X5 = Revenue/Assets
If Z > 2.9 – zone of financial stability (“green” zone).
If 1.8 < Z <= 2.9 – zone of uncertainty (“gray” zone).
If Z <= 1.8 – financial risk zone (“red” zone).
Altman index, Z = 1.2 * 0.06 + 1.4 * 0.07 + 3.3 * 0.09 + 0.6 * 2.16 + 0.9 = 2.6772

PEG ratio

PEG = 1 - the company's shares have a fair valuation.
PEG < 1 – shares are undervalued.
PEG > 1 - shares may be “overheated”.
PEG < 0 - the company is doing worse.
PEG = P/E / (Growth + Div %)

PEG = 19.83 / (89.27 + 0) = 0.2221

Graham index

NCAV = -34.31 per share (ncav/market cap = -412%)
Net Current Asset Value, NCAV = Total Current Assets – Total Liabilities
   Price = 8.85
   undervalued = -25.79%
   purchase at 50-70% (price range: -17.16 - -24.02), more than 100% overpriced
Data

NNWC = -40.62 per share (nnwc/market cap = -488%)
Net-net Working Capital (NNWC) = Cash and short-term investments + (Receivables * 75%) + (Inventory * 50%) - Total liabilities
   Price = 8.85
   undervalued = -21.79%
   purchase at 50-70% (price range: -20.31 - -28.43), more than 100% overpriced
Data

Total Liabilities/P = 7.9986
Total Liabilities/P = 139.815 / 17.48
The Total Liabilities/P coefficient must be less than 0.1

P/S = 1.23
P/S = Capitalization / Revenue
The P/S ratio should be between 0.3 - 0.5. The closer the multiplier value is to 0.3, the better. Describes the company's sales.

3.26/10