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

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Sanderson Farms Inc. logo

Sanderson Farms Inc.

218.61
 
USD
 
-1.29
 
(-0.59%)
81
Rank
Optionable: Yes
Market Cap: 4,908 M
Industry: Packaged Foods
52 week range    
175.42   
   221.63
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

49.95
 
USD
 
0.21
 
(0.42%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Gaming and Leisure Properties Inc. logo

Gaming and Leisure Properties Inc.

46.12
 
USD
 
-0.56
 
(-1.20%)
79
Rank
Optionable: Yes
Market Cap: 11,555 M
Industry: REIT - Diversified
52 week range    
40.57   
   48.57
General Mills Inc. logo

General Mills Inc.

74.72
 
USD
 
4.46
 
(6.35%)
79
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   73.99
National Retail Properties logo

National Retail Properties

44.27
 
USD
 
0.11
 
(0.25%)
78
Rank
Optionable: Yes
Market Cap: 7,768 M
Industry: REIT - Retail
52 week range    
39.12   
   48.19
Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

34.31
 
USD
 
-0.91
 
(-2.58%)
77
Rank
Optionable: Yes
Market Cap: 421 M
Industry: Capital Markets
52 week range    
30.71   
   53.17
Kronos Worldwide Inc logo

Kronos Worldwide Inc

18.47
 
USD
 
-0.70
 
(-3.65%)
77
Rank
Optionable: Yes
Market Cap: 2,213 M
Industry: Specialty Chemicals
52 week range    
11.64   
   19.78
Cowen Inc. logo

Cowen Inc.

25.01
 
USD
 
-0.34
 
(-1.34%)
75
Rank
Optionable: Yes
Market Cap: 704 M
Industry: Capital Markets
52 week range    
21.35   
   41.61
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

62.82
 
USD
 
-0.80
 
(-1.26%)
75
Rank
Optionable: Yes
Market Cap: 8,600 M
Industry: Specialty Retail
52 week range    
45.85   
   74.09
Strategic Education Inc. logo

Strategic Education Inc.

68.03
 
USD
 
-2.49
 
(-3.53%)
74
Rank
Optionable: Yes
Market Cap: 1,760 M
Industry: Education & Training Services
52 week range    
47.09   
   80.29

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!