Switch to:

Warning: Division by zero in /home/gurufocu/public_html/term.php on line 1299

Warning: Division by zero in /home/gurufocu/public_html/term.php on line 1304

Warning: Division by zero in /home/gurufocu/public_html/term.php on line 1299

Warning: Division by zero in /home/gurufocu/public_html/term.php on line 1304

Warning: Division by zero in /home/gurufocu/public_html/term.php on line 1299

Warning: Division by zero in /home/gurufocu/public_html/term.php on line 1304
Coca-Cola Femsa, S.A.B. de C.V. (NYSE:KOF)
Beneish M-Score
-2.86 (As of Today)

The zones of discrimination for M-Score is as such:

An M-Score of less than -2.22 suggests that the company is not an accounting manipulator.
An M-Score of greater than -2.22 signals that the company is likely an accounting manipulator.

Coca-Cola Femsa, S.A.B. de C.V. has a M-score of -2.60 suggests that the company is not a manipulator.

KOF' s 10-Year Beneish M-Score Range
Min: -3.27   Max: 2.53
Current: -2.86

-3.27
2.53

During the past 13 years, the highest Beneish M-Score of Coca-Cola Femsa, S.A.B. de C.V. was 2.53. The lowest was -3.27. And the median was -2.66.


Definition

The M-score was created by Professor Messod Beneish. Instead of measuring the bankruptcy risk (Z-Score) or business trend (F-Score), M-score can be used to detect the risk of earnings manipulation. This is the original research paper on M-score.

The M-Score Variables:

The M-score of Coca-Cola Femsa, S.A.B. de C.V. for today is based on a combination of the following eight different indices:

M=-4.84+0.92 * DSRI+0.528 * GMI+0.404 * AQI+0.892 * SGI+0.115 * DEPI
=-4.84+0.92 * 1.0614+0.528 * 0.9942+0.404 * 1.2004+0.892 * 1.0611+0.115 * 0.9408
-0.172 * SGAI+4.679 * TATA-0.327 * LVGI
-0.172 * 1.0465+4.679 * -0.0456-0.327 * 1.2598
=-2.60

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

This Year (Dec13) TTM:Last Year (Dec12) TTM:
Accounts Receivable was $1,065 Mil.
Revenue was 3499.77310543 + 2885.92980296 + 2922.03416392 + 2749.54940193 = $12,057 Mil.
Gross Profit was 1620.25412192 + 1352.75554187 + 1387.08666353 + 1273.7997706 = $5,634 Mil.
Total Current Assets was $3,270 Mil.
Total Assets was $16,387 Mil.
Property, Plant and Equipment(Net PPE) was $3,917 Mil.
Depreciation, Depletion and Amortization(DDA) was $548 Mil.
Selling, General & Admin. Expense(SGA) was $3,962 Mil.
Total Current Liabilities was $2,450 Mil.
Long-Term Debt was $4,302 Mil.
Net Income was 245.878081985 + 227.370689655 + 223.005798464 + 199.410126167 = $896 Mil.
Non Operating Income was -64.1355316896 + -4.38731527094 + 4.23131170663 + 10.0770113059 = $-54 Mil.
Cash Flow from Operations was 972.923914688 + 0 + 723.475944209 + 0 = $1,696 Mil.
Accounts Receivable was $945 Mil.
Revenue was 3271.66036547 + 2806.09396806 + 2715.8784795 + 2569.0870098 = $11,363 Mil.
Gross Profit was 1547.4952741 + 1316.94836409 + 1249.77551631 + 1164.52205882 = $5,279 Mil.
Total Current Assets was $3,615 Mil.
Total Assets was $13,083 Mil.
Property, Plant and Equipment(Net PPE) was $3,349 Mil.
Depreciation, Depletion and Amortization(DDA) was $437 Mil.
Selling, General & Admin. Expense(SGA) was $3,568 Mil.
Total Current Liabilities was $2,328 Mil.
Long-Term Debt was $1,951 Mil.



1. DSRI = Days Sales in Receivables Index

Measured as the ratio of days’ sales in receivables in year t to year t-1.

A large increase in DSR could be indicative of revenue inflation.

DSRI=(Receivables_t / Revenue_t) / (Receivables_t-1 / Revenue_t-1)
=(1064.74058388 / 12057.2864742) / (945.337114052 / 11362.7198228)
=0.08830682 / 0.08319638
=1.0614

2. GMI = Gross Margin Index

Measured as the ratio of gross margin in year t-1 to gross margin in year t.

Gross margin has deteriorated when this index is above 1. A firm with poorer prospects is more likely to manipulate earnings.

GMI=GrossMargin_t-1 / GrossMargin_t
=(GrossProfit_t-1 / Revenue_t-1) / (GrossProfit_t / Revenue_t)
=(1352.75554187 / 11362.7198228) / (1620.25412192 / 12057.2864742)
=0.4645667 / 0.4672607
=0.9942

3. AQI = Asset Quality Index

AQI is the ratio of asset quality in year t to year t-1.

Asset quality is measured as the ratio of non-current assets other than plant, property and equipment to total assets.

AQI=(1 - (CurrentAssets_t + PPE_t) / TotalAssets_t) / (1 - (CurrentAssets_t-1 + PPE_t-1) / TotalAssets_t-1)
=(1 - (3269.62638028 + 3916.57842989) / 16386.7039782) / (1 - (3615.07561437 + 3348.85003151) / 13083.0970384)
=0.56146124 / 0.46771581
=1.2004

4. SGI = Sales Growth Index

Ratio of sales in year t to sales in year t-1.

Sales growth is not itself a measure of manipulation. However, growth companies are likely to find themselves under pressure to manipulate in order to keep up appearances.

SGI=Sales_t / Sales_t-1
=Revenue_t / Revenue_t-1
=12057.2864742 / 11362.7198228
=1.0611

5. DEPI = Depreciation Index

Measured as the ratio of the rate of depreciation in year t-1 to the corresponding rate in year t.

DEPI greater than 1 indicates that assets are being depreciated at a slower rate. This suggests that the firm might be revising useful asset life assumptions upwards, or adopting a new method that is income friendly.

DEPI=(Depreciation_t-1 / (Depreciaton_t-1 + PPE_t-1)) / (Depreciation_t / (Depreciaton_t + PPE_t))
=(437.377255375 / (437.377255375 + 3348.85003151)) / (548.225686362 / (548.225686362 + 3916.57842989))
=0.11551796 / 0.1227883
=0.9408

6. SGAI = Sales, General and Administrative expenses Index

The ratio of SGA expenses in year t relative to year t-1.

SGA expenses index > 1 means that the company is becoming less efficient in generate sales.

SGAI=(SGA_t / Sales_t) / (SGA_t-1 /Sales_t-1)
=(3962.13608671 / 12057.2864742) / (3567.88834612 / 11362.7198228)
=0.32860927 / 0.3139995
=1.0465

7. LVGI = Leverage Index

The ratio of total debt to total assets in year t relative to yeat t-1.

An LVGI > 1 indicates an increase$sgai= in leverage

LVGI=((LTD_t + CurrentLiabilities_t) / TotalAssets_t) / ((LTD_t-1 + CurrentLiabilities_t-1) / TotalAssets_t-1)
=((4301.54288307 + 2450.31008925) / 16386.7039782) / ((1951.40201638 + 2327.5047259) / 13083.0970384)
=0.4120324 / 0.3270561
=1.2598

8. TATA = Total Accruals to Total Assets

Total accruals calculated as the change in working capital accounts other than cash less depreciation.

TATA=(IncomefromContinuingOperations_t - CashFlowsfromOperations_t) / TotalAssets_t
=(NetIncome_t - NonOperatingIncome_t - CashFlowsfromOperations_t) / TotalAssets_t
=(895.664696271 - -54.214523948 - 1696.3998589) / 16386.7039782
=-0.0456

An M-Score of less than -2.22 suggests that the company will not be a manipulator. An M-Score of greater than -2.22 signals that the company is likely to be a manipulator.

Coca-Cola Femsa, S.A.B. de C.V. has a M-score of -2.60 suggests that the company will not be a manipulator.


Related Terms

Altman Z-Score, Piotroski F-Score, Accounts Receivable, Revenue, Gross Profit, Total Current Assets, Total Assets, Property, Plant and Equipment, Depreciation, Depletion and Amortization, Selling, General & Admin. Expense, Total Current Liabilities, Long-Term Debt, Net Income, Non Operating Income, Cash Flow from Operations


Historical Data

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

Coca-Cola Femsa, S.A.B. de C.V. Annual Data

Dec05Dec06Dec07Dec08Dec09Dec10Dec11Dec12Jun13Dec13
DSRI 1.46350.92431.34021.00071.00660.92511.0276
GMI 0.99631.02790.98971.02331.01230.98760.9813
AQI 1.0320.9540.91530.9990.95450.93491.1222
SGI 1.12541.02751.20550.94121.34241.26381.2815
DEPI 0.65440.85851.16141.19350.95970.84430.8235
SGAI 0.98770.98041.00880.96791.01711.04031.0886
LVGI 0.85290.90880.93150.98870.88931.08831.371
TATA -0.039-0.0459-0.0295-0.0299-0.0615-0.0592-0.0422
M-score -2.10-2.73-2.12-2.63-2.44-2.68-2.52

Coca-Cola Femsa, S.A.B. de C.V. Quarterly Data

Sep11Dec11Mar12Jun12Sep12Dec12Mar13Jun13Sep13Dec13
DSRI 0.72240.70830.78240.8530.99481.01341.37910.8671.0614
GMI 1.01081.01281.00920.99860.98680.98050.97380.97830.9942
AQI 1.06331.03821.09821.11050.93491.0440.99981.01211.2004
SGI 1.62261.60741.53821.58181.17531.15111.13931.08721.0611
DEPI 00000.8630.85021.19111.21840.9408
SGAI 3.05492.81081.47781.02141.04151.03231.01891.02341.0465
LVGI 0.94250.9810.90830.921.08831.13721.24671.29971.2598
TATA -0.0086-0.0069-0.0738-0.0641-0.0564-0.0578-0.0559-0.054-0.0456
M-score -2.64-2.64-2.67-2.44-2.68-2.66-2.34-2.86-2.60
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
Hide