Recently, Finbox users have been asking us to add a metric called the Beneish MScore to help them quickly identify companies that are likely manipulating their earnings reports. So I decided to investigate this financial ratio and its statistical foundation. I then translated the concepts described in the paper into a spreadsheet financial model.
Note there is a lot of misinformation on this topic around the web and in some of the top search results on Google. To be sure, I reconciled all the calculations I use in the post with the Beneish MScore calculation posted by Dr. Beneish and the Sunbeam example provided.
You can view and download the model for free using the links below. Note the "Linked" tab will allow you to calculate this score with the latest data for any company using the Finbox Spreadsheet Addon. You just need to have the Finbox Excel or Google Spreadsheets addon installed correctly.
[ View Spreadsheet Calculator ]: To make a copy of the Google Spreadsheet, go to File > Make a Copy
[ Download Excel Spreadsheet Calculator ]
Table Of Contents
What Is The Beneish MScore
I was happy to find that professor Messod D. Beneish at my Alma mater, Indiana University, Kelley School of Business, invented the score. In his now famous paper, Dr. Beneish sets out ambitiously to "profile a sample of earnings manipulators" and identify the characteristics that distinguish them from their public peers. He then develops and outlines a statistical model to detect such manipulation by proposing eight key variables designed to "capture either the effects of manipulation or preconditions that may prompt firms to engage in such activity."
It's important to note, just because a company has been flagged by the model as an earnings manipulator does not necessarily mean that it's true. Like any statistical model, the Beneish MScore is subject to false positives. The inverse is also true — the model does not identify all earnings manipulators. In Dr. Beneish's holdout sample tests, the model identified approximately half of the companies involved in earnings manipulation before the public market realized. Considering the catastrophic consequences of owning stock in a company that's involved in accounting trickery can have on a portfolio, the model's hit rate is very impressive. After all, some bright Cornell students used the Beneish MScore to identify Enron Corporation as an earnings manipulator correctly.
Beneish M Score Formula, Methodology & Calculation Details
So let's get into the methodology and calculation steps. The paper outlines eight financial ratios required to calculate the score:

Days Sales in Receivables Index (DSRI): DSRI is the ratio of days sales in receivables in the first year in which earnings manipulation is uncovered (year t) to the corresponding measure in year t1. This variable gauges whether receivables and revenues are in or outofbalance in two consecutive years. Dr. Beneish explains, "I thus expect a large increase in days sales in receivables to be associated with a higher likelihood that revenues and earnings are overstated."
DSRI = (Net Receivables_{t} / Sales_{t}) / (Net Receivables_{t1} / Sales_{t1})

Gross Margin Index (GMI): GMI is the ratio of the gross margin in year t1 to the gross margin in year t. It appears Dr. Beneish is building on the work of Lev and Thiagarajan (1993) here that suggested gross margin deterioration is a negative signal about firms' prospects.
GMI = [(Sales_{t1}  COGS_{t1}) / Sales_{t1}] / [(Sales_{t}  COGS_{t}) / Sales_{t}]

Asset Quality Index (AQI): Asset quality in a given year is the ratio of noncurrent assets other than property plant and equipment (PPE) to total assets and measures the proportion of total assets for which future benefits are potentially less certain.
AQI = [(Total Assets  Current Assets_{t}  PP&E_{t}) / Total Assets_{t}] / [(Total Assets  Current Assets_{t1}  PP&E_{t1}) / Total Assets_{t1}]

Sales Growth Index (SGI): SGI is the ratio of sales in year t to sales in year t1. I was surprised to find this variable included since investors typically love growth. Dr. Beneish notes, that while growth does not imply manipulation, management at growth companies are more likely to face investor pressure to achieve earnings targets.
SGI = Sales_{t} / Sales_{t1}

Depreciation Index (DEPI): DEPI is the ratio of the rate of depreciation in year t1 vs. the corresponding rate in year t. When DEPI is greater than 1, it indicates that the rate at which assets are depreciated has slowed down. This can signal that aggressive accountants may be revising estimates of assets useful lives upwards or adopting a new depreciation method to reduce expenses.
DEPI = (Depreciation_{t1}/ (PP&E_{t1} + Depreciation_{t1})) / (Depreciation_{t} / (PP&E_{t} + Depreciation_{t}))

Sales General and Administrative Expenses Index (SGAI): SGAI is calculated as the ratio of SGA to sales in year t relative to the corresponding measure in year t1. Dr. Beneish again builds on the work of Lev and Thiagarajan (1993) here, assigning a positive relationship between increasing profit margins and the probability of manipulation.
SGAI = (SG&A Expense_{t} / Sales_{t}) / (SG&A Expense_{t1} / Sales_{t1})

Leverage Index (LVGI): LVGI is the ratio of total debt to total assets in year t relative to the corresponding ratio in year t1. An LVGI greater than 1 indicates an increase in leverage. By including this variable, the model captures incentives for earnings manipulation to meet debt covenants.
LVGI = [(Current Liabilities_{t} + Total Long Term Debt_{t}) / Total Assets_{t}] / [(Current Liabilities_{t1} + Total Long Term Debt_{t1}) / Total Assets_{t1}]

Total Accruals to Total Assets (TATA): Finally, Dr. Beneish total accruals to total assets as a proxy for cash earnings underlying the reported earnings. Higher positive accruals (less cash) can logically be associated with a higher likelihood of earnings manipulation.
TATA = (Income from Continuing Operations_{t}  Cash Flows from Operations_{t}) / Total Assets_{t}
The Beneish MScore
After computing the eight variables outlined above, they can be weighted together using the following multivariate model to calculate the score:
MScore =
4.84
(+) 0.92 × DSRI
(+) 0.528 × GMI
(+) 0.404 × AQI
(+) 0.892 × SGI
(+) 0.115 × DEPI
(+) 0.172 × SGAI
(+) 4.679 × TATA
(+) 0.327 × LVGI
Here are the summary stats from the paper:
When an MScore is greater than 1.78 (e.g 1.1), the model flags the company as a likely earnings manipulator. If of interest, you can also use the score to determine the probability of manipulation using this free calculator. Just enter the value of the Beneish MScore in the "Calculate probability Q from z" section.
So in summary:
 When the Beneish MScore is greater than 1.78, the company is likely an earnings manipulator
 When the Beneish MScore is between 1.78 and 2.00, the company is a possible earnings manipulator
 When the Beneish MScore is less than 2, the company is not likely an earnings manipulator
Beneish MScore Stock Screener
We've done the heavy lifting of calculating the Beneish MScore score for every company and keep an updated dataset. You can look up the score for any company using the Data Explorer tool: See Apple's Score
To find stocks that are flagged by the Beneish MScore, you can use the Finbox Stock Screener tool. Add it as a filter in the screener, and you'll get the latest candidates.