The Altman Z Score calculation is based on five financial ratios and can take some time to produce manually. To save time (and frustration), you can use this handy Excel hack!
Before you can pull the Altman Z Score, you will need to follow the following steps:
Now, in just three steps, you will be able to pull the Altman Z Score using the API Explorer and the Excel Add-In.
1. Go to the Altman Z Score data tag page
2. Scroll down to the API Explorer and copy the formula by clicking the notepad icon
3. Paste the function into the excel sheet, change the company ticker to the cell in which the ticker is written, for instance, on the example below, “AAPL” was changed to be A2. This will allow you to update a whole list of tickers without manually changing the ticker on each formula.
The Altman Z Score is based on five financial ratios that are pulled from a company’s annual 10K report.
WCTOA: Working Capital/Total Assets
RETOA: Retained Earnings/Total Assets
EBITTOA: Earnings Before Interest & Tax/Total Assets
MVTL: Market Value of Equity/Total Liabilities
STA: Sales/Total Assets
Check out our Altman Z Score video tutorial to also learn how to: