Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

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

Written by  Shubham Shah on 
Sat Feb 06 2021
 about Guru functionsValuation Models
Beneish M-Score- A Tool To Find The Manipulation Of The Earnings. - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
Beneish M-Score- A Tool To Find The Manipulation Of The Earnings. - MarketXLS

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.

Ad slot not ready
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

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

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord