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
One of the most useful tools for predicting whether or not a publically-traded company might be headed for bankruptcy is the Altman Z-Score. The main advantage of the Altman Z-score is that it takes information easily found in a company's financial statements and uses a simple formula to compute a numeric value that may be used to assess its degree of financial distress.
Originally developed in 1968, the Z-Score was created by Edward Altman of New York University's Stern School of Business, who updated his original work in 2000. This updated work forms the basis for the tool presented below.
The tool below may be used to compute the Altman Z-Score for a publically-traded company found in Manufacturing or in non-financial Non-Manufacturing industries. The necessary financial data for a company of interest may be found using Yahoo! Finance or Google Finance. The default data is taken from General Motors' financial statements for the 3 months ending March 31, 2006.
The following table indicates the degree to which a company may be in distress according to its industry:
| Z-Score Indication of Financial Distress | ||
|---|---|---|
| Financial Health | Manufacturing | Non-Manufacturing |
| Good | Z-Score > 2.67 | Z-Score > 2.60 |
| Neutral | 1.81 < Z-Score < 2.67 | 1.10 < Z-Score < 2.60 |
| Danger! | Z-Score < 1.81 | Z-Score < 1.10 |
Altman identifies a zone of ignorance for Z-Scores between the Danger threshold cut-off and a Z-Score of 2.99. As a result, a company with a Z-Score greater than 2.99 may be considered "sound." By contrast, a company with a score below the Danger threshold is a likely candidate for bankruptcy or potential default on its outstanding bonds.
For investors, a Z-Score that falls in Altman's "Ignorance Zone" shouldn't necessarily be excluded from consideration, but a score in this range does indicate there may be a need to more closely investigate a particular company's situation. Investors may also find it beneficial to determine a company's Z-Score going back over several investing periods in order to establish if a trend exists.
For manufacturing companies that scored 2.67 or less, the Altman-Z score has a surprising level of accuracy in being able to predict a future bankruptcy or default on the distressed companies' outstanding bonds. Between 1969 and 1999, the Altman Z-score correctly predicted bankruptcy for a distressed company one year or less from the date it actually filed for Chapter 7 between 82% and 94% of the time (82% for 86 companies between 1969 and 1975, 85% for 110 companies between 1976 and 1995, and 94% for 120 companies between 1996 and 1999.)
For the same samples, the Altman Z-score correctly anticipated 68% to 75% of the bankrupcties and defaults some two years before they occurred.
The Altman Z-score is most useful in determining the likelihood of bankruptcy occurring in companies found in the Manufacturing and in many Non-Manufacturing industries. Where it doesn't work well is in analyzing financial companies, such as banks or brokerages, or companies with a large financial component in their business, such as General Electric.
A really good article describing the strengths and weaknesses of the Z-Score is available at Investopedia!
Labels: bankruptcy, forecasting, 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:
The S&P 500 at Your Fingertips
Mapping S&P 500 Performance, Since 1871
Should You Trade In Your Gas Guzzler?
What Are the Chances Your Marriage Will Last?
Reckoning the Odds of Recession
Your 2009 Paycheck
Tipping Around the World
Revisiting the Lottery
Estimating Your Life Expectancy
Connecting the Dots for Personal Income Taxes
First Time Visitor to Political Calculations?
On the Moneyed Midways
A Lot, But Not All, of Our Tools
Political Calculations' Recession Probability Track shows the probability that the U.S. economy will be in recession 12 months from the indicated date (shown in red) while revealing the probability trend over the past four years.
Previously, the probability of recession peaked at 50% on 4 April 2007, which means that March-April 2008 was the most likely period in which the NBER would have found the U.S. to be in recession.
As it happens, they almost did. The NBER instead chose December 2007 as the beginning month of the most recent recession (we had found a 46% probability for a recession beginning in that month!)
Political Calculations is also the online home of On the Moneyed Midways (aka OMM), a review of the best posts contributed to the week's best business and money-related blog carnivals. More than that, we also name one post in each edition as being The Best Post of the Week, Anywhere! and at the end of each year, we name The Best Post of the Year, Anywhere! as well as identifying the best blogs we found during the course of the year!
The link below will take you to the running index containing our most recent back issues (you can easily navigate the index to find older editions.)
This site is primarily powered by:
Visitors since December 6, 2004:
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.
ZunZun - Exceptional regression analysis tool.
Wolfram Integrator - Solve integrals. Do calculus!
Create a Graph - Easy-to-use basic graph-making tool.
Many Eyes - Data visualization extraordinaire!