Altman Credit Scoring Model Update
Altman Credit Scoring Model Update
Altman Credit Scoring Model Update
Problems With Traditional Financial Ratio Analysis 1 Univariate Technique 1-at-a-time 2 No Bottom Line 3 Subjective Weightings 4 Ambiguous 5 Misleading
4
Forecasting Distress With Discriminant Analysis Linear Form Z = a1x1 + a2x2 + a3x3 + + anxn Z = Discriminant Score (Z Score) a1 x1 an = Discriminant Coefficients (Weights) xn = Discriminant Variables (e.g. Ratios)
x x x x x x x x x x x x x x x x x x x x x xx x x x x x x x x x x x x x x x x
Example
EBIT TA
EQUITY/DEBT
Definition
Working Capital Total Assets
Weighting Factor
1.2
X2
1.4
X3
3.3
X4
0.6
X5
1.0
6
X1 = Current Assets - Current Liabilities Total Assets X2 = Retained Earnings Total Assets X3 = Earnings Before Interest and Taxes Total Assets
Z > 2.99 - Safe Zone 1.8 < Z < 2.99 - Grey Zone Z < 1.80 - Distress Zone
Credit scores on new issues to estimate Bond ratings equivalents on new issues and then, Utilize mortality rates to estimate annual and cumulative defaults
10
One can measure the cumulative mortality rate (CMR) over a specific time period (1,2,, T years) by subtracting the product of the surviving populations of each of the previous years from one (1.0), that is,
CMR(t) = 1 - SR(t) ,
t=1
here
CMR (t) = Cumulative Mortality Rate in (t), SR (t) = Survival Rate in (t) , 1 - MMR (t)
11
Issued Amount 50 50 100 100 150 150 200 200 250 250 1,500 1,500
SF 5 -----20 ---25
Year 1
1,325 Year 2
- 340
985
12
AA
BBB
BB
2.05% 2.55% 1.10% 1.65% 0.88% 1.72% 3.70% 9.87% 12.17% 13.14% 14.57% 15.15% 16.61% 19.69%
6.92% 7.48% 8.58% 6.08% 4.18% 3.74% 2.31% 2.00% 0.88% 9.77% 16.52% 23.69% 28.32% 31.32% 33.89% 35.41% 36.70% 37.26%
CCC
8.18% 15.57% 19.15% 12.18% 4.26% 10.25% 5.65% 3.15% 0.00% 4.28% 8.18% 22.48% 37.32% 44.96% 47.30% 52.70% 55.37% 56.78% 56.78% 58.63%
(a) Rated by S&P at Issuance Based on 1,719 issues Source: Standard & Poor's (New York) and Author's Compilation
13
2 0.00% 0.00% 0.00% 0.00% 0.04% 0.04% 2.54% 2.81% 1.51% 2.23%
3 0.00% 0.00% 0.06% 0.06% 0.01% 0.05% 1.15% 3.93% 3.24% 5.40%
7 0.00% 0.00% 0.00% 0.12% 0.02% 0.19% 0.47% 6.24% 0.99% 9.68%
0.00% 0.00% 0.06% 0.12% 0.04% 0.09% 0.94% 4.83% 1.46% 6.78%
AA
BBB
BB
5.05% 5.60% 6.00% 4.56% 2.51% 2.74% 1.64% 1.10% 0.67% 7.07% 12.38% 17.54% 21.30% 23.38% 25.00% 26.23% 27.04% 27.53%
CCC
5.48% 11.68% 15.37% 9.72% 3.20% 8.21% 4.80% 2.52% 0.00% 3.22% 5.48% 16.52% 29.35% 36.22% 38.26% 43.37% 46.05% 47.41% 47.41% 49.10%
(a) Rated by S&P at Issuance Based on 1,535issues Source: Standard & Poor's (New York) and Author's Compilation
14
1976-1995
Predictive Sample (110) 85% (78%) 75% -
1997-1999
Predictive Sample (120) 94% (84%) 74% -
15
1980
1981
1982
1983 Year
1984
1985
1986
Bankrupt July 86
16
Z Score
Grey Zone
Distress Zone
'74 '76 '78 '80 '82 '84 '86 '88 '90 '92 '94 '96 '98 '00 Year
17
'78
'80
'82
'84
'86
'88 Year
'90
'92
'94
'96
'98
Z Score
1980 1982 1984 1986 1988 1990 1992 1994 1996 1998 2000
Year
19
B BB
BBB
A AA AAA
20
S&P Rating
6.00
A-
BBB BBB
AA
BEQ*
5.00
Z" Scores
BBB+
BB B+
0.10
BBB
Z" Score
4.00
EDF
CCC+
BB 1.00 B
3.00
CCC2.00
CC
10.00 CCC D
1.00
D
Q2'00 Q3'00 Q4'00 Q1'01 Q2'01 Q3'01 Q4'01 Q1'02 Q2'02
100.00 Q3'02
Z" UnAdj
Z" Adj:3.85B
Z" Adj:7.2B&50B
EDF
Sources: Compilation by the author (E. Altman, NYU Stern), the KMV (Moody's) Website and Standard & Poor's Corporation.
EDF Score
21
3.46
2.38
1.35
12/99
6/00
Actual Rating (S&P / Moodys): 12/98 A / A2 12/99 A / A2 07/00 A- / A3 12/00 BBB- / Ba1 5/02 BB / B1
23
Z > 2.90 - Safe Zone 1.23 < Z < 2.90 - Grey Zone Z < 1.23 - Distress Zone
Z Score Model for Manufacturers, Non-Manufacturer Industrials, & Emerging Market Credits
Z = 6.56X1 + 3.26X2 + 6.72X3 + 1.05X4 X1 = Current Assets - Current Liabilities Total Assets X2 = Retained Earnings Total Assets X3 = Earnings Before Interest and Taxes Total Assets X4 = Book Value of Equity Total Liabilities Z > 2.60 - Safe Zone 1.1 < Z < 2.60 - Grey Zone Z < 1.1 - Distress Zone
25
27
Step 2 -Adjust (modify) the Bond Rating Equivalent for Forex Revaluation Vulnerability High vulnerability = -1 rating class (3 notches) Neutral vulnerability = -1 notch Low vulnerability = no change
Step 3 -Adjust BRE for Risk of Industry in the Emerging Market vs. Risk of the Industry in the U.S. - 1 or 2 notches
28
Step 6 -Assess the yield in the U.S. market on the modified BRE of the emerging Market credit, then add the sovereign yield spread. Finally, compare the resulting required yield with the yield in the market.
29
Z-Score Models and Bond Rating Equivalent Selected Auto and Telecom Companies
Date GM Ford Fiat Daimler Telefonica Deutsche Telecom Telecom Italia France Telecom 31/12/03 31/12/03 31/12/03 31/12/03 31/12/03 31/12/03 31/12/03 31/12/03
30
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 0.84 0.79 0.75 0.81
31
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 0.43 0.44 0.36 0.53
Revised Rating
32
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 1.07 0.84 0.87 0.92
Equivalent Rating B+ B B B-
33
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 1.38 1.15 1.07 1.46
34
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 1.58 1.02 1.32 1.27
Revised Rating
35
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 0.53 0.29 0.67 1.04
Revised Rating
36
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 1.19 0.71 0.64 0.58
37
Z-Score Dec 2003 Dec 2002 Dec 2001 Dec 2000 0.69 (0.19) 0.42 0.70
Revised Rating
38
39
Industry
Airlines Cement Supermarkets Cement Chemicals Conglomerate Construction Bottling Bottling Paper and Forest Products Construction Food Processing Auto Manufacturing Steel Steel Paper and Forest Products Retail Conglomerate Paper and Forest Products Autoparts Conglomerate Steel Hotel and Tourism Textile/Apparel Steel Pipes Telecommunications Cable and Media Shipping Glass
EM Score
-4.42 8.48 4.78 5.67 4.67 4.23 5.96 6.37 5.4 4.61 4.85 5.56 5.54 5.51 5.45 8.96 9.85 5.28 6.64 2.69 4.68 4.42 5.17 1.59 3.34 9.57 7.29 5.34 5.18
Bond-Rating Equivalent
D AAA BBBBBBBB BBB ABB+ B+ BB BBBBBBBBBBBBAAA AAA BB+ A CCC BBB+ BB+ CCCCCC+ AAA AA BB+ BB+
Modified Rating
D A B+ BBBB+ BB+ BB BBB+ BB+ BB BBBB+ BB+ BBBBAA A+ BB+ BB CCCB BB CCC B AABBB+ BB+ BB
Ratings M/S&P/D&P
NR/NR/NR Ba2/NR/NR NR/NR/NR Ba3/BB/BB NR/NR/NR NR/NR/NR B1/BB-/B+ NR/NR/NR Ba3/NR/NR B1/BB-/NR B3/NR/NR NR/NR/NR NR/NR/B NR/NR/NR NR/NR/NR NR/NR/NR NR/NR/NR NR/NR/NR NR/NR/NR NR/NR/NR NR/NR/CCC NR/NR/CCC NR/NR/CCC NR/NR/NR NR/NR/NR NR/NR/NR Ba2/NR/NR Ba2/BB-/NR Ba2/NR/NR
40
Z''-Score 8.15 7.60 7.30 7.00 6.85 6.65 6.40 6.25 5.85 > 8.15 8.15 7.60 7.30 7.00 6.85 6.65 6.40 6.25
Z''-Score 5.65 5.25 4.95 4.75 4.50 4.15 3.75 3.20 2.50 1.75 < 1.75 5.85 5.65 5.25 4.95 4.75 4.50 4.15 3.75 3.20 2.50 1.75
Grey zone
Safe zone
Distress zone
42
BBBBB+ BB BB+
America Movil SA de CV Apasco SA de CV Cemex SA de CV Coca-Cola Femsa SA de CV Empresas ICA Sociedad Controladora Grupo Televisa SA Kimberly-Clark de Mexico Telefonos de Mexico SA de CV Vitro SA de CV n.a: not available
AAAmerica Movil Kimberly-Clark de Mexico Telefonos de Mexico Apasco Femsa Grupo Televisa
BBB+
Cemex
BB
Vitro
BICA
D
Source: Bloomberg
B-
BB
BBB+
AA-
43
AAA
44
America Movil SA de CV
(provides wireless communications services in Mexico)
Z"-Score Equivalent Rating 1
10.0
8.0
7.86
6.0
B+ 0.4 CCC+
4.0
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
45
Source: Bloomberg
Apasco SA de CV
(production and marketing of cement)
Z"-Score Equivalent Rating 1
10.0
9.97
4.0
0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
46
Source: Bloomberg
47
Cemex SA de CV
(production, distribution, marketing, and sale of cement )
Z"-Score Equivalent Rating 1
10.0
8.0
B+ 0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
48
Source: Bloomberg
Cintra SA de CV
(AeroMxico, Mexicana, Aerocaribe, Aerolitoral,)
Z"-Score
10.0
Equivalent Rating 1
8.0
6.0
B+ 0.4 CCC+
2.64 2.71
4.0
4.41
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
49
Source: Bloomberg
Coca-Cola Femsa SA de CV
(production, distribution, and marketing of certain Coca-Cola trademark beverages)
Z"-Score Equivalent Rating 1
10.0
9.69
8.82
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
50
Source: Bloomberg
51
52
10.0
7.34 7.35
4.0
0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
53
Source: Bloomberg
54
Grupo Carso SA de CV
(holding company in diverse industries (e.g. tobacco; mining, hospitality, retail, music stores,))
Z"-Score Equivalent Rating 1
10.0
6.01
4.0
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
55
Source: Bloomberg
56
57
58
59
8.0
6.0
4.0
2.0
4Q90 4Q91 4Q92 4Q93 4Q94 4Q95 4Q96 4Q97 4Q98 4Q99 4Q00 4Q01 4Q02 4Q03
60
8.0
6.0
4.0
2.0
4Q90 4Q91 4Q92 4Q93 4Q94 4Q95 4Q96 4Q97 4Q98 4Q99 4Q00 4Q01 4Q02 4Q03
61
Grupo Televisa SA
(television broadcasting)
Z"-Score Equivalent Rating 1
4.0
0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
62
Source: Bloomberg
63
8.0
6.0
5.17
B+
4.12 3.42 3.48
4.0
0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
64
Source: Bloomberg
8.0
6.0
4.0
2.0
4Q90 4Q91 4Q92 4Q93 4Q94 4Q95 4Q96 4Q97 4Q98 4Q99 4Q00 4Q01 4Q02 4Q03
65
Kimberly-Clark de Mexico SA de CV
(manufacture and sale of consumer and industrial paper products )
Z"-Score Equivalent Rating 1
4.0
0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
66
Source: Bloomberg
67
8.0
6.0
4.0
2.0
4Q90 4Q91 4Q92 4Q93 4Q94 4Q95 4Q96 4Q97 4Q98 4Q99 4Q00 4Q01 4Q02 4Q03
68
Telefonos de Mexico SA de CV
(provide telecommunications services (TELMEX))
Z"-Score Equivalent Rating 1
6.0
6.03
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
69
Source: Bloomberg
8.0
6.0
4.0
2.0
4Q90 4Q91 4Q92 4Q93 4Q94 4Q95 4Q96 4Q97 4Q98 4Q99 4Q00 4Q01 4Q02 4Q03
70
71
Vitro SA de CV
(manufacture and marketing of glass and plastic containers)
Z"-Score Equivalent Rating 1
10.0
8.0
6.0 5.11
5.11
B+
4.00 3.40
4.0
2.0
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
72
Source: Bloomberg
Wal-Mart de Mexico SA de CV
(retail)
Z"-Score Equivalent Rating 1
7.86
4.0
0.4 CCC+
2.0
0.2
Dec 1998 Dec 1999 Dec 2000 Dec 2001 Dec 2002
D 0
73
Source: Bloomberg
75
76
EDFs are calibrated to measure the probability of a borrower defaulting within one year.
77
STEP 2 -
Then calculates the Distance-to-Default (# of Standard Deviations) Distance-to-Default is a Type of Asset/Liability Coverage Ratio
STEP 3 -
Distance-to-Default of a Firm is Mapped Against a Database of Empirical Frequencies of Similar Distance-to-Default Companies to Obtain Expected Default Frequency (EDF) for a Firm
78
Estimation of Market Value And Volatility of Firms Assets Asset Values are Based on Underlying Value of Firm, Independent of Firms Liabilities. Asset Volatility Calculated as the Annualized Standard Deviation of Percentage Changes in the Market Value of Assets. Equity Market Value and its Volatility, as Well as the Liability Structure, are Used as Proxies for the Assets Value and Volatility. Option Theory of Assets Used to Value Assets Since MV of Debt is Not Known. If Debt MV is Known, then A=E+D (MV). But, MV Assets are Calculated by Knowing Only the MV Equity and PV of Liabilities.
79
KMV Assumes that All Short Term Debt and 50% of Long Term Liabilities Are Used to Calculate the Default Point (Was 25% of LTD). When MV Assets < Payable Liabilities then Firm Defaults. Firm Cannot Sell Off Assets or Raise Additional Capital Because All Existing Assets are Fully Encumbered.
80
KMV Strengths Can be applied to any publicly-traded company Responsive to changing conditions, (EDF updated quarterly) Based on stock market data which is timely and contains a forward looking view Strong theoretical underpinnings (versus ad-hoc models)
81
KMV Weaknesses Difficult to diagnose a theoretical EDF (what is the distribution of asset return outcomes) Problems in applying model to private companies and thinlytraded companies Results sensitive to stock market movements (does the stockmarket over-react to news?) Ad-hoc definition of anticipated liabilities (i.e.. 50% of longterm debt)
82
83
= = = = = =
85
88
25