The Client
- Institution type: Community Bank
- Balance sheet size: $750m – $1b
- Number of active loan pools: 42
- Pool Designation Class or Call codes: Call Code.
How CECL Express helps
Choices available to calculate Expected Credit Losses (ECL):
The client is using the Roll-rate method out of the 5 options provided in CECL Express.
- Roll-rate method
- Probability of Default/Loss Given Default (PD/LGD) method
- Discounted Cash Flow (DCF) method
- Weighted-Average Remaining Maturity (WARM) method.
- Vintage method
Risk designation:
Pools are split by risks according to the credit scores and their PD% according to the table below, which is customized for the client.
User-controlled PD and LGD percentages:
PD and LGD percentages are set as default and are customizable as per the bank.
Market data sourced by CECL Express:
- Economic data – Federal Reserve Economic Data – https://fred.stlouisfed.org/#
- Call report – FFIEC Call Report
- Yield curves – US Treasury Yield Curves
- Macro-economics
The macro-Eco data curve is forecasted using the FRED data considering the GDP, Housing, and unemployment factor.
Liquidity Stress Scenario
CECL Express offers two stress scenarios- Recession and Severe Recession.
Scenario Impacts are added to the Credit Score PD and Credit Score LGD by the Banks.
E.g.
Time taken to implement CECL
10 days.
Portfolio linkage
Portfolio mapped by the CECL Express team, using ETL tool to speed up and simplify the implementation process.
Obstacles faced during implementation
- Bank portfolio had separate off-balance sheet item, which was not included in the portfolio. The CECL express team mapped the off-balance sheet item in the portfolio to include them in the same calculation.
- Revolving loans like credit cards had days to maturity as 0, due to which they were excluded from the calculation and creating discrepancies. The CECL express team manually mapped the default maturity dates to such loans to resolve the issue.
Final Report Example
