Web Analytics Made Easy -
Skip to main content
New Excel Models

New Excel Model: Accounting Quality Analysis

By June 19, 2016No Comments

Check out our newest Excel model analyzing the accounting quality of any commercial and industrial company in the TagniFi database. Simply enter a ticker symbol and the model calculates the Beneish M-Score and and Piotroski F-Score for the selected company. Here is some background on each of these accounting quality measures:

Download the Accounting Quality Analysis Model

What is the Beneish M-Score?
“The Beneish model is a mathematical model that uses financial ratios and eight variables to identify whether a company has manipulated its earnings. The variables are constructed from the data in the company’s financial statements and, once calculated, create an M-Score to describe the degree to which the earnings have been manipulated.¬†Once calculated, the eight variables are combined together to achieve an M-Score for the company. 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.” source: Investopedia

What is the Piotroski F-Score?
“The Piotroski score is a discrete score between 0-9 which reflects nine criteria used to determine the strength of a firm’s financial position. The Piotroski score is used to determine the best value stocks, nine being the best. The score was named after Chicago Accounting Professor, Joseph Piotroski who devised the scale according to specific criteria found in the financial statements. For every criteria (below) that is met the company is given one point, if it is not met, then no points are awarded. The points are then added up to determine the best value stocks.” source: Investopedia