The three versions of the Altman Z-score worked on one private borrower, with the cut-offs that go with each and the ratio that quietly carries the score.
The Altman Z-score is a weighted sum of five ratios: working capital, retained earnings, EBIT, equity and sales, each over total assets or liabilities. There are three versions with different weights and cut-offs, and choosing the wrong one moves a borrower between zones. On one illustrative private manufacturer the scores are 2.18 on the original Z, 1.67 on the private-company Z' and 2.44 on Z'': grey on all three, but Z' read against the original 1.81 cut-off would call it distressed.
Worked in full in Credit Analysis by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
A privately owned packaging manufacturer, last audited year, figures in millions. All figures are illustrative. A market value of equity is shown only so the original model can be run; a private company does not have one, which is the point of the second version.
| Input | Value |
|---|---|
| Total assets | 250.0 |
| Current assets | 95.0 |
| Current liabilities | 60.0 |
| Working capital | 35.0 |
| Retained earnings | 40.0 |
| EBIT | 22.0 |
| EBITDA (not used by the model) | 34.0 |
| Revenue | 250.0 |
| Book equity | 70.0 |
| Total liabilities | 180.0 |
| Market value of equity, if it were listed | 150.0 |
X1 = working capital / total assets = 35.0 / 250.0 = 0.1400
X2 = retained earnings / total assets = 40.0 / 250.0 = 0.1600
X3 = EBIT / total assets = 22.0 / 250.0 = 0.0880
X4 = equity / total liabilities = 150.0 / 180.0 = 0.8333 on market value, 70.0 / 180.0 = 0.3889 on book value
X5 = revenue / total assets = 250.0 / 250.0 = 1.0000
Excel, with the inputs in B2:B11: =(B4-B5)/B2 for X1, and so on down the column.
The ratios are the same in every version, except that X4 changes from market to book equity. What changes between versions is the weights, and with them the cut-offs.
Z (listed manufacturers) = 1.2 X1 + 1.4 X2 + 3.3 X3 + 0.6 X4market + 1.0 X5
Z' (private manufacturers) = 0.717 X1 + 0.847 X2 + 3.107 X3 + 0.420 X4book + 0.998 X5
Z'' (non-manufacturers) = 6.56 X1 + 3.26 X2 + 6.72 X3 + 1.05 X4book
Excel, ratios in C2:C6 and Z' weights in D2:D6: =SUMPRODUCT(C2:C6,D2:D6)
| Term | Z | Z' | Z'' |
|---|---|---|---|
| X1, working capital | 0.1680 | 0.1004 | 0.9184 |
| X2, retained earnings | 0.2240 | 0.1355 | 0.5216 |
| X3, EBIT | 0.2904 | 0.2734 | 0.5914 |
| X4, equity | 0.5000 | 0.1633 | 0.4083 |
| X5, asset turnover | 1.0000 | 0.9980 | |
| Score | 2.18 | 1.67 | 2.44 |
| Distress below | 1.81 | 1.23 | 1.10 |
| Safe above | 2.99 | 2.90 | 2.60 |
All three scores sit in their grey zones. For a private manufacturer the right test is Z', and at 1.67 the borrower is 0.44 above the distress line of 1.23. The original Z needs a market value of equity, and the 150.0 used here is hypothetical. Z'' was built for non-manufacturers and emerging market issuers, and drops asset turnover because it varies too much between industries. Some practitioners add a constant of 3.25 to Z'' for emerging market issuers, which takes it to 5.69 and changes the scale again: one more reason never to quote a Z-score without saying which one.
Look at where the score comes from. Asset turnover carries 0.9980 of the 1.67, or 60 per cent of Z'. EBIT, the ratio a credit analyst would expect to matter most, contributes 0.2734. Set EBIT to zero and Z' falls only to 1.40, still grey. A company that earns nothing and turns its assets once a year is not, on this model, in distress. That is a property of the weights, and it is why the Z-score is a screen rather than a credit decision.
| Case | Z' | Change | Z'' |
|---|---|---|---|
| Base | 1.67 | 0.00 | 2.44 |
| EBIT down 30% to 15.4 | 1.59 | −0.08 | 2.26 |
| Revenue down 10% to 225.0, EBIT down 30% | 1.49 | −0.18 | 2.26 |
| Dividend recap: 30.0 of new debt paid out | 1.49 | −0.18 | 1.84 |
| Working capital drawn to 15.0 | 1.61 | −0.06 | 1.91 |
| EBIT zero | 1.40 | −0.27 | 1.85 |
A 30 per cent fall in EBIT moves Z' by less than a tenth. A dividend recapitalisation, which leaves the operating business untouched, moves it more than twice as far, because it hits retained earnings and book equity at once and adds to liabilities. Holding everything else, revenue would have to fall 44.2 per cent, to 139.6, before Z' reached 1.23. Z'', without the turnover term, is far more sensitive to earnings and leverage: the same recap takes it from 2.44 to 1.84.
The Z-score was estimated on historical samples of failed and surviving companies. It is a quick screen of a balance sheet, not a probability of default, and it knows nothing about the maturity of the debt, the covenants or the cash. A borrower is repaid from cash, which no ratio of this model measures.
The book's own borrower is analysed on four EBITDAs, from the statutory figure to cash, in the free workbook for this case.
On the original model, above 2.99 is the safe zone and below 1.81 the distress zone. The private-company Z' uses 2.90 and 1.23, and the four-ratio Z'' uses 2.60 and 1.10. A score is only good or bad against the cut-offs of its own version: the illustrative borrower here scores 1.67 on Z', comfortably grey, which on the original scale would read as distress.
Yes, but use Z', which replaces the market value of equity with book equity and re-estimates every weight: 0.717, 0.847, 3.107, 0.420 and 0.998. Putting book equity into the original formula instead gives 1.92 on the borrower here, a number that belongs to no model and has no cut-offs.
Because the model was estimated on EBIT over total assets, and its weight of 3.107 in Z' is calibrated to that ratio. Substituting EBITDA of 34.0 for EBIT of 22.0 lifts Z' from 1.67 to 1.82 for the same company, an improvement that comes entirely from the depreciation line.
This article is one calculation from Credit Analysis. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Reading guide: credit, private credit and distressed debt → · All 1340 articles →
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.