Back to Case Studies
Community BankJune 21, 2023

Ingenious CECL solutions with CECL Express – Community Bank up to 1 billion

The Client

Institution type
Community Bank
Balance sheet size
$750m – $1b
Active loan pools
42
Pool designation
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

  1. Economic data – Federal Reserve Economic Data (https://fred.stlouisfed.org/)
  2. Call report – FFIEC Call Report
  3. Yield curves – US Treasury
  4. Macro-economics — forecasted using 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.

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. 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