Ingenious CECL solutions with CECL Express-Credit Union 450 million – 500 million

The Client

1. Institution type: Credit Union
2. Balance sheet size: $450m – $500m
3. Number of active loan pools: 51
4. Pool Designation Class or Call codes: Class 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 days overdue using the formula below, which is customized for the client.

Days Delinquency Adjustment

0-29:  Pass

30-60:  Special

60-90:  Substandard

90-120:  Doubtful

120+:  Loss

User-controlled Q-factors:

Q-factors have defaulted into the system where the highlighted part is customized by the bank as per their historical experiences.

Market data sourced by CECL Express:

1. Economic data – Federal Reserve Economic Data – https://fred.stlouisfed.org/#
2. Call report – NCUA Call Report
3. Yield curves – US Treasury Yield Curves
4. 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 Annual loss rate and Qualitative Factors 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

1. 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.
2. Bank has a separate bonds portfolio for which they want to use the current market risk ratings to value their loss allowances. The CECL Express team mapped this bonds portfolio as per their current risk ratings to include them in the calculation.
3. 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