Switch to:
GuruFocus has detected 7 Warning Signs with Agilent Technologies Inc $A.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Agilent Technologies Inc (NYSE:A)
Beneish M-Score
-2.51 (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.

Agilent Technologies Inc has a M-score of -2.51 suggests that the company is not a manipulator.

A' s Beneish M-Score Range Over the Past 10 Years
Min: -4.33   Max: -0.47
Current: -2.51

-4.33
-0.47

During the past 13 years, the highest Beneish M-Score of Agilent Technologies Inc was -0.47. The lowest was -4.33. And the median was -2.62.


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 Agilent Technologies Inc 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.0653+0.528 * 0.9724+0.404 * 0.9528+0.892 * 1.0557+0.115 * 1.1694
-0.172 * SGAI+4.679 * TATA-0.327 * LVGI
-0.172 * 0.9614+4.679 * -0.0272-0.327 * 1.0222
=-2.51

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

This Year (Apr17) TTM:Last Year (Apr16) TTM:
Accounts Receivable was $677 Mil.
Revenue was 1102 + 1067 + 1111 + 1044 = $4,324 Mil.
Gross Profit was 592 + 574 + 588 + 542 = $2,296 Mil.
Total Current Assets was $3,800 Mil.
Total Assets was $8,016 Mil.
Property, Plant and Equipment(Net PPE) was $675 Mil.
Depreciation, Depletion and Amortization(DDA) was $225 Mil.
Selling, General & Admin. Expense(SGA) was $1,227 Mil.
Total Current Liabilities was $1,187 Mil.
Long-Term Debt was $1,802 Mil.
Net Income was 164 + 168 + 126 + 124 = $582 Mil.
Non Operating Income was 5 + 3 + -16 + 2 = $-6 Mil.
Cash Flow from Operations was 257 + 116 + 234 + 199 = $806 Mil.
Accounts Receivable was $602 Mil.
Revenue was 1019 + 1028 + 1035 + 1014 = $4,096 Mil.
Gross Profit was 530 + 537 + 535 + 513 = $2,115 Mil.
Total Current Assets was $3,488 Mil.
Total Assets was $7,640 Mil.
Property, Plant and Equipment(Net PPE) was $610 Mil.
Depreciation, Depletion and Amortization(DDA) was $252 Mil.
Selling, General & Admin. Expense(SGA) was $1,209 Mil.
Total Current Liabilities was $1,133 Mil.
Long-Term Debt was $1,654 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)
=(677 / 4324) / (602 / 4096)
=0.15656799 / 0.14697266
=1.0653

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)
=(2115 / 4096) / (2296 / 4324)
=0.51635742 / 0.53098982
=0.9724

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 - (3800 + 675) / 8016) / (1 - (3488 + 610) / 7640)
=0.44174152 / 0.46361257
=0.9528

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
=4324 / 4096
=1.0557

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))
=(252 / (252 + 610)) / (225 / (225 + 675))
=0.29234339 / 0.25
=1.1694

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)
=(1227 / 4324) / (1209 / 4096)
=0.28376503 / 0.29516602
=0.9614

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)
=((1802 + 1187) / 8016) / ((1654 + 1133) / 7640)
=0.37287924 / 0.36479058
=1.0222

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
=(582 - -6 - 806) / 8016
=-0.0272

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.

Agilent Technologies Inc has a M-score of -2.51 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 local exchange's currency.

Agilent Technologies Inc Annual Data

Oct07Oct08Oct09Oct10Oct11Oct12Oct13Oct14Oct15Oct16
DSRI 0.97450.98340.99571.20220.81451.03521.71540.66980.97041.0006
GMI 0.97570.98961.08220.95041.00891.01521.07311.00320.96580.9667
AQI 1.14061.04970.86070.71261.04321.64270.94981.0110.98641.0605
SGI 1.08991.06530.77611.21491.21511.03670.56781.03950.99751.0406
DEPI 0.93430.98191.2190.94140.85040.97810.83180.65291.28151.0621
SGAI 0.93960.9371.21720.89960.84980.96881.14760.97410.99411.0127
LVGI 1.20410.99331.07291.0280.76520.91351.05880.77071.1341.0409
TATA -0.0445-0.0133-0.0602-0.0243-0.031-0.0086-0.0398-0.0086-0.0171-0.0411
M-score -2.65-2.47-3.01-2.36-2.50-2.16-2.44-2.74-2.62-2.64

Agilent Technologies Inc Quarterly Data

Jan15Apr15Jul15Oct15Jan16Apr16Jul16Oct16Jan17Apr17
DSRI 0.5740.39120.29730.97041.00971.03110.99071.00061.00821.0653
GMI 0.98010.93430.86310.96580.95220.9460.94410.96670.97030.9724
AQI 1.03811.05521.03560.98641.04681.07421.05381.06051.00470.9528
SGI 1.26191.63082.20490.99750.99361.01361.01981.04061.04981.0557
DEPI 0.67520.70950.77111.28151.24071.20381.1441.06211.12241.1694
SGAI 0.96150.91330.85190.99410.98320.99481.0011.01270.99690.9614
LVGI 0.86210.87190.95491.1341.03531.04561.04781.04091.03141.0222
TATA -0.00310.0089-0.0097-0.0171-0.0263-0.0329-0.0429-0.0411-0.0354-0.0272
M-score -2.63-2.42-2.14-2.62-2.59-2.58-2.68-2.64-2.60-2.51
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