to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
If you're just an average investor, how can you pick up on whether or not a company is cooking its books?
Craig Newmark recently pointed to one of the neater ways in which someone might be able to determine if the numbers they're examining are following a natural pattern as opposed to an artificially-contrived one using Benford's Law, but unless you have access to reams and reams of internal company data, it's pretty unlikely that you as an individual without that kind of access could find out if something shady might be going on.
But for publicly-traded companies, you can get access to a company's publicly-reported financial statements, such as their annual reports or the 10-K statements they file with the United States Securities and Exchange Commission (SEC). And with that information, you can calculate a company's "fraud score" or "F-Score", which can provide a pretty good indication of whether or not the people inside the company might be manipulating their accounting.
Using math originally developed by Patricia M. DeChow, Weili Ge, Chad R. Larson and Richard G. Sloan in 2007 using data from 1982 through 2002, and updated in 2010 to include all years from 1982 through 2005, we've updated our tool for calculating the F-Score for any publicly-traded company for which you can obtain the indicated data below!
For that, you'll need three consecutive years worth of the company's annual data - our tool below provides that using Enron's data for the years 1998 (two years prior), 1999 (one year prior) and 2000 (year of interest).
Here, a result greater than a value of 1 indicates a statistically higher than expected likelihood that the numbers the company in question has published have been misstated, which is "accountingese" for suggesting that the company's books may have been cooked! The following guide, developed by the F-score's creators, may be used to interpret the tool's results ("F-Score 1" corresponds to the specific model used in our tool):
We should note that the math is somewhat sensitive - the formula's creators indicate it will produce a high frequency of false positives, which means that an F-Score greater than one should be taken as an indication that an average investor should be much more diligent in reviewing a company's business before making investing decisions related to it.
The tool above provides different results from our original version of the F-Score formula, which was based upon the original 2007 math.
This update to our original tool is the result of a collaborative project with Pasi Havia, who was seeking to implement a Finnish-language version of the tool. We owe our thanks to Pasi for his detective work in finding that the formula for calculating a company's F-score had changed from 2007 and for developing the new and improved code to calculate the F-Score!
If you compare the results between Pasi's version and ours above, you'll find that the results between the two tools are nearly identical - the difference comes down to how the rounding for the value of the mathematical constant e in the formula was done (Pasi rounded it to 8 decimal places for the sake of matching the authors' results in their paper, while we just let it run!)
How likely is it that a publicly traded company will declare bankruptcy in the next year? Our tool for calculating the company's Altman Z-Score can answer! It predicted General Motors failure years before the company failed!
Does that publicly-traded company have enough money flowing through its veins to keep operating?
Labels: business, investing, tool
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.