Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Guru functionsValuation Models

Beneish M-Score- A Tool To Find The Manipulation Of The Earnings.

Written by Pooja Tanwani (Individual Contributor)
Sat Feb 06 2021
Beneish M-score
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Beneish M-score
 

The extent to which earnings are manipulated has long been a question of interest to analysts, regulators, researchers, and other investment professionals. To address this issue, Professor Messod Beneish developed the Beneish M-score model and published it in a paper in June 1999 called The Detection of Earnings Manipulation.
Beneish M score is a Mathematical model designed to find out the manipulation in the company’s earnings. Beneish’s M-Score model uses eight variables weighted by coefficients to identify whether a company has manipulated its profits.

How is it calculated?

1.Days’ Sales in Receivables Index (DSRI)-
DSRI is the ratio of days sales in receivables in a year to the previous year. If the value of DSRI > 1, it is an indicator of revenue inflation. An increase in the value of DSRI indicates that the company has followed the lenient credit policy or allowed the higher credit period to increase the sales.
DSRI = (Net Receivablest / Salest) / (Net Receivablest-1 / Salest-1)

2. Gross Margin Index(GMI)-

GMI is the ratio of gross margin of a year to the previous year. When GMI is greater than 1, it indicates that gross margins have deteriorated. A firm with a declining gross profit margin is more likely to manipulate earnings.
GMI = [(Salest-1 – COGSt-1) / Salest-1] / [(Salest – COGSt) / Salest]

3. Asset Quality Index (AQI)-
Asset quality in a given year is the ratio of non-current assets other than property plant and equipment (PPE) to total assets. If AQI > 1, it indicates that the firm has potentially increased its involvement in cost deferral.
AQI = [1 – (Current Assetst + PP&Et + Securitiest) / Total Assetst] / [1 – ((Current Assets t-1+ PP&E t-1 + Securities t-1) / Total Assets t-1)]

4. Sales Growth Index (SGI)-
SGI is the ratio of sales of a year to the previous year. The value of SGI > 1 indicates that the company’s sales have increased compared to last year.
High sales growth does not imply manipulation, but high growth companies are more likely to commit financial fraud because their financial position and capital need pressure managers to achieve earnings targets.
SGI = Salest / Salest-1

5. Depreciation Index (DEPI)-
DEPI is the ratio of the rate of depreciation in the previous year to the current year. The value of DEPI higher than 1 indicates the company has revised the life of its useful asset to provide a better picture of its profits.
DEPI = (Depreciation t-1/ (PP&E t-1 + Depreciation t-1)) / (Depreciation t / (PP&E t + Depreciation t))

6. Sales, General, and Administrative Expenses (SGAI)-
SGAI measures the ratio of Sales, General, and Administrative expenses to the prior year. The value of SGAI > 1 indicates that SGA expenses as a percentage of sales increased in the current year. An increase in the SGA expenses leads to a reduction in the operating profits. Management may try to cover up this through manipulation.
SGAI = (SG&A Expense t / Sales t) / (SG&A Expense t-1/ Sales t-1)

7. Leverage Index (LVGI)-
LVGI is the ratio of total debt to total assets in a year relative to the corresponding ratio with the previous year. An LVGI greater than 1 indicates an increase in leverage. Increased leverage results in an increase in the interest expenditure, Thus affecting the company’s net profits. Increased leverage increases the chances of manipulation of earnings.
LVGI = [(Current Liabilities t + Total Long Term Debt t) / Total Assets t] / [(Current Liabilities t-1 + Total Long Term Debt t-1) / Total Assets t-1]

8. Total Accruals to Total Assets (TATA)-
Accruals measures the difference between the accounting Profit/(loss) and the cash profit/(loss). Larger discrepancies in the accounting profits and cash profits increase the probability of manipulation of the earnings.
TATA = (Income from the Continuing Operations t – Cash Flows from the Operations t) / Total Assets t

Based on the above eight variable M-score can be calculated as follows:
M Score = -4.840 + 0.920 x DSRI + 0.528 x GMI + 0.404 x AQ + 0.892 x SGI + 0.115 x DEPI – 0.172 x SGAI – 0.327 x LVGI + 4.697 x TATA

We can draw two possible conclusions using the M score:

  • Beneish M Score < -2.22: the company is not likely to have manipulated its earnings
  • Beneish M Score > -2.22: the company is likely to have manipulated its earnings.

 

Let us find out the M-score of Apple with the MarketXLS template.

Beneish M-score

Limitations of the model-

  1. Beneish’s M-score model uses to find the manipulation of the overstated profits. We cannot use it to find the understated profits.
  2. The Beneish model does not apply to financial firms like banks and insurance companies.
  3. The Beneish model is a probability theory model and doesn’t guarantee fraud detection in a company.

Successful Application of Beneish Model-
In 1998, a group of Cornell University business students used the Beneish model and correctly identified that the Enron Corporation was manipulating its earnings. At that time, Enron’s stock was trading at $48. Noticeably, Wall Street’s financial analysts didn’t pay heed to this and still recommending a buy for the stock. Eventually, the stock went up to $90. In 2001, when Enron filed for bankruptcy, it was found out that Enron manipulated its earnings, and it results in a $74 billion loss to the shareholders.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Invest with confidence with billions of data points and thousands of pre-built functions and templates.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

NACCO Industries Inc. logo

NACCO Industries Inc.

51.74
 
USD
 
1.76
 
(3.52%)
81
Rank
Optionable: No
Market Cap: 367 M
Industry: Coal
52 week range    
28.32   
   63.19
Cintas Corporation logo

Cintas Corporation

411.94
 
USD
 
0.92
 
(0.22%)
81
Rank
Optionable: Yes
Market Cap: 39,137 M
Industry: Business Services
52 week range    
343.86   
   461.44
Hibbett Sports Inc. logo

Hibbett Sports Inc.

54.84
 
USD
 
2.01
 
(3.80%)
80
Rank
Optionable: Yes
Market Cap: 677 M
Industry: Specialty Retail
52 week range    
39.58   
   101.65
EOG Resources Inc. logo

EOG Resources Inc.

126.08
 
USD
 
0.91
 
(0.73%)
79
Rank
Optionable: Yes
Market Cap: 61,798 M
Industry: Oil & Gas E&P
52 week range    
80.67   
   147.99
Darden Restaurants Inc. logo

Darden Restaurants Inc.

133.10
 
USD
 
0.88
 
(0.67%)
79
Rank
Optionable: Yes
Market Cap: 16,207 M
Industry: Restaurants
52 week range    
110.96   
   157.85
Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

111.67
 
USD
 
1.61
 
(1.46%)
79
Rank
Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
63.45   
   142.78
Waste Connections Inc. logo

Waste Connections Inc.

141.81
 
USD
 
-0.86
 
(-0.60%)
78
Rank
Optionable: Yes
Market Cap: 35,409 M
Industry: Waste Management
52 week range    
113.50   
   148.20
STORE Capital Corporation logo

STORE Capital Corporation

31.48
 
USD
 
0.11
 
(0.35%)
77
Rank
Optionable: Yes
Market Cap: 8,868 M
Industry: REIT - Diversified
52 week range    
24.48   
   36.13
Buckle Inc. (The) logo

Buckle Inc. (The)

34.87
 
USD
 
0.54
 
(1.57%)
77
Rank
Optionable: Yes
Market Cap: 1,720 M
Industry: Apparel Stores
52 week range    
26.50   
   57.10
ICF International Inc. logo

ICF International Inc.

114.55
 
USD
 
0.52
 
(0.46%)
76
Rank
Optionable: Yes
Market Cap: 1,994 M
Industry: Business Services
52 week range    
84.68   
   114.79

More Features