What You Will Learn
- Find Out if a Company Will Go Bankrupt Using Altman Z
- How to Use the Free Altman Z Spreadsheet and Where to Get Technical Help
Altman Z Score Spreadsheet
What is the Altman Z Score Spreadsheet?
Here is a free Altman Z score spreadsheet you can download and run in excel. It is an excel spreadsheet requiring the use of macros but will automatically pull data from the internet and let you calculate the Altman Z Score with this free spreadsheet.
The Altman Z Score
The Altman Z score was formulated by a professor in 1968 to predict bankruptcy. You can also read a somewhat current paper by professor Altman which includes his work on the Z score, if you’re into that stuff.
Otherwise, a good concise summary and explanation can be found at Chroma Investing (he has some great stock picks as well).
The Z-score formula may be used to predict the probability that a firm will go into bankruptcy within two years.
Z-scores are used to predict corporate defaults and an easy-to-calculate control measure for the financial distress status of companies in academic studies. The Z-score uses multiple corporate income and balance sheet values to measure the financial health of a company. - Wikipedia
The main problem with the Altman Z formula is that the formula is not suited for many industries. Industries that operate with high leverage, such as radio and utilities will produce a low Z score which equates to a high risk of bankruptcy.
When I run companies such as Entercom Communications [[ETM]], the Z score comes out to 0.42. Even Time Warner [[TWX]] and Waste Management [[WM]] is expected to fail in the near future.
This is why it is important for investors to not just blindly believe that a low Z score predicts the death of a company. Just have to be smart about it.
Download the Free Altman Z Score Spreadsheet
As you can see, it is very easy to use. Simply enter the ticker, click the “Calculate” button and it will automatically calculate the Z score for you.
To download the spreadsheet, you must go to the main page of Old School Value or at the bottom of any page and sign up with your email to receive the free Altman Z spreadsheet along with other free investment spreadsheets.
The list includes nine free spreadsheets, the add-in required to download data from the internet as well as all the installation help material.
The Altman Z score spreadsheet is completely free. You are free to edit, share, link or do anything you want to it.
Feel free to check out the free version and then when ready, go to the stock valuation software page and review what you will get with the premium.
The premium version includes several valuation models as well as fundamental analysis data, historical data, charts and competitor comparison features. Just by entering one ticker, you can immediately get all that information on your favorite stock which will save you hours in your analysis.
To date, I’ve been spending hours helping people with simple excel issues on a free product rather than anything spreadsheet related.
So for all excel and install problems, place all questions in the comment sections below. That way I won’t have to answer the same question again and again.