Improving PD and LGD models following the changes in the market
Wemke.vanderWeij@SNSREAAL.nl Marcel.denHollander@SNSREAAL.nl Credit Scoring Conference 2009 - Edinburgh
Wemke van der Weij Marcel den Hollander
Improving PD and LGD models following the changes in the market - - PowerPoint PPT Presentation
Improving PD and LGD models following the changes in the market Wemke van der Weij Marcel den Hollander Wemke.vanderWeij@SNSREAAL.nl Marcel.denHollander@SNSREAAL.nl Credit Scoring Conference 2009 - Edinburgh Agenda Introduction Basel
Wemke.vanderWeij@SNSREAAL.nl Marcel.denHollander@SNSREAAL.nl Credit Scoring Conference 2009 - Edinburgh
Wemke van der Weij Marcel den Hollander
– Among the largest banking companies in The Netherlands – Balance sheet total of € 77 billion – 3245 employees (FTEs)
Acceptation Scorecard
IN OUT
Behaviour models
Realisation versus estimate
0% 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% 200611 200612 200701 200702 200703 200704 200705 200706 200707 200708 200709 200710 200711 200712
Month Percentage
Realisation Estimate
Note that the figures in the presentation do not correspond to actual data
General Terminology
SNS Terminology
Default End of default Period t
EAD recovery NPV(Loss)
RLR = NPVd(Loss) EAD
write-off
Defaults
Probability of Default model Exposure at Default estimate PD fixed 100% Loss Given Default model LGD Best Estimate model LGD X PD X EAD EL =
Non- Defaults
Profile Credit risk Client Loan Payment behaviour Product Securities
0,00% 5,00% 10,00% 15,00% 20,00% 25,00% 30,00% 35,00% 1 2 3 4 5 6
10.000 15.000 20.000 25.000 30.000 35.000 Customers (#) RLR LGD
Score for each client based on the characteristics Score are categorized in risk classes (buckets) Each bucket gets an estimated value for the risk Client and loan characteristics
Example PD pools 1 0.01 % 2 0.05 % 3 0.20% 4 1.00% 5 2.00% 6 8.00% 7 15.00% 8 25.00% LGD pools 1 0.02% 2 0.09% 3 0.50% 4 2.10% 5 7.00% 6 13.00% 7 18.00% 8 30.00%
Commonly based on historical data How can we get these values up to date?
Layers
– Client (1) – Risk buckets (2) – Portfolio (3)
Frequency
– monthly – quarterly – yearly
Average Value Estimated
(1) (2) (3)
200909 4.4 200908 5.5 3.4 200907 2.3 2.1 5.4 200906 1.4 2.1 4.2 3.4 200905 1.0 1.1 2.6 1.9 2.3 200904 0.7 0.8 1.2 1.9 3.2 1.7 200903 0.3 0.1 0.4 2.1 1.2 4.2 3.4 200902 0.1 0.2 0.6 1.2 0.9 2.2 4.5 3.2 200901 0.3 0.6 0.2 1.0 3.2 2.1 3.4 3.5 200812 0.0 0.1 2.2 0.8 1.2 2.3 4.3 2.3 200811 0.1 0.1 0.0 0.1 0.1 0.4 1.2 0.7 1.2 1.9 2.3 2.3 200801 0.0 0.2 0.1 0.0 0.6 0.3 0.4 1.1 1.3 1.3 4.2 6.2 200712 0.0 0.1 0.2 0.0 0.0 0.2 0.5 0.9 1.5 1.2 3.2 3.4 200711 >24 24 23 22 … 8 7 6 5 4 3 2 1
Period \ month
PD: clients observed in 200902 and in default in the 3rd month LGD: clients in default in 200902 and recovered / lost in the 3rd month Not observable at the period 200909
200909 4.4 200908 5.5 3.4 200907 2.3 2.1 5.4 200906 1.4 2.1 4.2 3.4 200905 1.0 1.1 2.6 1.9 2.3 200904 0.7 0.8 1.2 1.9 3.2 1.7 200903 0.3 0.1 0.4 2.1 1.2 4.2 3.4 200902 0.1 0.2 0.6 1.2 0.9 2.2 4.5 3.2 200901 0.3 0.6 0.2 1.0 3.2 2.1 3.4 3.5 200812 0.0 0.1 2.2 0.8 1.2 2.3 4.3 2.3 200811 0.1 0.1 0.0 0.1 0.1 0.4 1.2 0.7 1.2 1.9 2.3 2.3 200801 0.0 0.2 0.1 0.0 0.6 0.3 0.4 1.1 1.3 1.3 4.2 6.2 200712 0.0 0.1 0.2 0.0 0.0 0.2 0.5 0.9 1.5 1.2 3.2 3.4 200711 >24 24 23 22 … 8 7 6 5 4 3 2 1
Period \ month
How to deal with a default with a very long default period Estimate the loss
200909 4.4 200908 5.5 3.4 200907 2.3 2.1 5.4 200906 1.4 2.1 4.2 3.4 200905 1.0 1.1 2.6 1.9 2.3 200904 0.7 0.8 1.2 1.9 3.2 1.7 200903 0.3 0.1 0.4 2.1 1.2 4.2 3.4 200902 0.1 0.2 0.6 1.2 0.9 2.2 4.5 3.2 200901 0.3 0.6 0.2 1.0 3.2 2.1 3.4 3.5 200812 0.0 0.1 2.2 0.8 1.2 2.3 4.3 2.3 200811 0.1 0.1 0.0 0.1 0.1 0.4 1.2 0.7 1.2 1.9 2.3 2.3 200801 0.0 0.2 0.1 0.0 0.6 0.3 0.4 1.1 1.3 1.3 4.2 6.2 200712 0.0 0.1 0.2 0.0 0.0 0.2 0.5 0.9 1.5 1.2 3.2 3.4 200711 >24 24 23 22 … 8 7 6 5 4 3 2 1
Period \ month
SUM Xt SUM Xt+1 SUM Xt+1 Historic data used for calibration
– a x + b = y – a = 1 and x +b =y ⇒ linear trend taken
– 1/n Sum (x) =y ⇒ average over the last n observations
– a y(t) = x(t) + (1- a)y(t-1)
=>weighted moving average
200909 4.4 200908 5.5 3.4 200907 2.3 2.1 5.4 200906 1.4 2.1 4.2 3.4 200905 1.0 1.1 2.6 1.9 2.3 200904 0.7 0.8 1.2 1.9 3.2 1.7 200903 0.3 0.1 0.4 2.1 1.2 4.2 3.4 200902 0.1 0.2 0.6 1.2 0.9 2.2 4.5 3.2 200901 0.3 0.6 0.2 1.0 3.2 2.1 3.4 3.5 200812 0.0 0.1 2.2 0.8 1.2 2.3 4.3 2.3 200811 0.1 0.1 0.0 0.1 0.1 0.4 1.2 0.7 1.2 1.9 2.3 2.3 200801 0.0 0.2 0.1 0.0 0.6 0.3 0.4 1.1 1.3 1.3 4.2 6.2 200712 0.0 0.1 0.2 0.0 0.0 0.2 0.5 0.9 1.5 1.2 3.2 3.4 200711 >24 24 23 22 … 8 7 6 5 4 3 2 1
Period \ month
Xt Xt+1 Historic data used for calibration
( )
=
−
n t t t
z y n
1 2
1 Root mean square error
=
−
n t t t
z y n
1
1
Mean square error
=
−
n t t t t
z z y n
1
1
Mean absolute percentage error
– guidelines → credit risk models
– Realisations versus estimates
– Using historical data avoiding the performance period
Remarks