BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Alexy123
Calcite | Level 5

I would appreciate if anybody can help with SAS base or macro formulas for calculating Basel II Capital Requirement (PD, LGD, EAD).

 

Many thanks

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

Unfortunately there is no such thing as "standard" formulas for PD, LGD, and EAD. PD (Probability of Default) and LGD (Loss Given Default) are usually derived as part of complex modelling exercises on the banks own data. This often involves constructing a suite of logistic regression models for the various portfolios of loans. Each loan type may have its own dedicated model. 

 

EAD (Exposure At Default) for a loan is often simply the maximum of the loan balance compared to the loan limit). For example, if the loan limit is $250K and the loan balance is $200K ($200K still to pay) then the EAD would be $250K. However there are also situations where a scale factor is applied to the EAD based on more accurately estimating the Exposure At Default.

 

Also each country's banking regulator has their own set of rules overlaid on the Basel rules as these must be taken into account.

 

When you want to calculate RWA, CR, and EL then there are standard formulas using PD, LGD and EAD as inputs and SAS macro can be very useful here.

 

SAS is a widely-used tool for Basel II Capital Requirements so you are definitely starting out on the right track. 

View solution in original post

3 REPLIES 3
SASKiwi
PROC Star

Unfortunately there is no such thing as "standard" formulas for PD, LGD, and EAD. PD (Probability of Default) and LGD (Loss Given Default) are usually derived as part of complex modelling exercises on the banks own data. This often involves constructing a suite of logistic regression models for the various portfolios of loans. Each loan type may have its own dedicated model. 

 

EAD (Exposure At Default) for a loan is often simply the maximum of the loan balance compared to the loan limit). For example, if the loan limit is $250K and the loan balance is $200K ($200K still to pay) then the EAD would be $250K. However there are also situations where a scale factor is applied to the EAD based on more accurately estimating the Exposure At Default.

 

Also each country's banking regulator has their own set of rules overlaid on the Basel rules as these must be taken into account.

 

When you want to calculate RWA, CR, and EL then there are standard formulas using PD, LGD and EAD as inputs and SAS macro can be very useful here.

 

SAS is a widely-used tool for Basel II Capital Requirements so you are definitely starting out on the right track. 

Alexy123
Calcite | Level 5

Hi SASKiwi,

 

Thank you for this brilliant and comprehensive response.

SASKiwi
PROC Star

My pleasure. If you need any more detailed advice on this topic I'd be happy to help.