Banking Credit Risk Accounting & US GAAP ASC 326
ASC 326 CECL Lifetime Credit Loss & Q-Factor Formula
Calculate US GAAP ASC 326 Current Expected Credit Loss (CECL) Historical Through-the-Cycle Base Loss EAD*PD*LGD, Macro-Adjusted Lifetime PD MIN(1, PD*Macro_Scalar), Ending Allowance for Credit Losses (ACL), and Quarterly Provision Expense.
Book forward-looking lifetime credit losses on Day 1 under ASC 326 CECL!
Following the 2008 financial crisis, FASB ASC 326 replaced delayed "incurred-loss" loan-loss accounting with Current Expected Credit Losses (CECL)—requiring banks and corporate trade-receivable holders to reserve for FULL contractual lifetime expected credit losses at origination! Quantitative PD/LGD vintage models first compute Historical Through-the-Cycle Base ECL = Amortized_Cost_EAD * Historical_Lifetime_PD * Loss_Given_Default_LGD, then apply a Reasonable-and-Supportable Macroeconomic Qualitative Scalar (Q-Factor) to adjust PD = MIN(1, Historical_PD * Macro_Scalar), setting Required Ending Allowance ACL = EAD * Adjusted_PD * LGD and hitting quarterly earnings by Provision_Expense = Ending_ACL - Prior_ACL_Net_Chargeoffs!
Verify in a bank credit-committee CECL workbook—Loan_Pool_EAD = $50,000,000 (B2), Historical_Lifetime_PD = 0.04 (4.00%, B3), Loss_Given_Default LGD = 0.45 (45.0%, B4), Macro_Forecast_Scalar = 1.25 (+25% unemployment deterioration overlay, B5), and Pre_Adjustment_ACL_Balance = $950,000 (B6): Unadjusted Historical Base ECL is $50M * 0.04 * 0.45 = $900,000 (E2); Forecast-Adjusted Lifetime PD is MIN(1, 0.04 * 1.25) = 0.0500 (5.00% in E3); Required Ending CECL Allowance is $50M * 0.05 * 0.45 = $1,125,000 (E4); and Quarterly Provision Expense is $1,125,000 - $950,000 = +$175,000 (E5)!
| ASC 326 CECL Metric ($50M Pool, PD=4.0%, LGD=45%, Macro=1.25x, Prior ACL=$950k) | Formula | Verified Output |
|---|---|---|
| Historical Base Lifetime ECL ($) | EAD * Historical_PD * LGD | $900,000 |
| Macro-Adjusted Lifetime PD | MIN(1, Historical_PD * Macro_Scalar) | 0.0500 (5.00%; 0.0400 @ 1.0x) |
| Required Ending Allowance ACL ($) | EAD * Adjusted_PD * LGD | $1,125,000 ($900,000 @ 1.0x) |
| Quarterly Provision Expense ($) | Ending_ACL - Prior_Net_ACL | +$175,000 (-$50,000 Release @ 1.0x) |
ASC 326 CECL Ending Allowance & Provision Expense Formula
Validate EAD > 0, 0 <= PD <= 1, 0 <= LGD <= 1, Macro_Scalar > 0, and Prior_ACL >= 0!
=LET(ea_d, B2, pd_h, B3, lg_d, B4, mc_s, B5, pr_a, B6, IF(OR(ea_d <= 0, pd_h < 0, pd_h > 1, lg_d < 0, lg_d > 1, mc_s <= 0, pr_a < 0), "Invalid CECL Pool Input", LET(pd_f, MIN(1, pd_h * mc_s), ac_l, ea_d * pd_f * lg_d, ROUND(ac_l - pr_a, 2))))Benign Macro Reserve Release Check (Set Macro_Scalar = 1.00)
Normalize Macro_Scalar B5 to 1.00: Required Ending ACL E4 drops to $900,000 (< $950,000 prior balance), recording a -$50,000 reserve release (negative provision benefit) in E5!
=IF(ISTEXT(E5), E5, ROUND(B2 * E3 * B4, 2))Try the example
Use the original values or change them to test your understanding.