Finance AI Skill
Reserve Analysis Impairment
Analyze and manage financial reserves including loan loss reserves (CECL), warranty reserves, litigation reserves, environmental reserves, and asset impairment testing. Calculate expected credit losses, reserve adequacy, and impairment charges. Use when est...
Reserve Analysis & Impairment
Analyze and manage financial reserves including loan loss reserves (CECL), warranty reserves, litigation reserves, and asset impairment testing.
Workflow
1. CECL (Current Expected Credit Losses) Framework
CECL EXPECTED CREDIT LOSS MODEL
═══════════════════════════════════════
Under ASC 326 (CECL), entities recognize expected credit losses over the
entire life of financial assets, replacing the incurred loss model.
KEY CONCEPTS:
═══════════════════════════════════════
Component Description Formula
──────────────────────────────────────────────────────────────────────
PD Probability of Default Statistical model
LGD Loss Given Default 1 - Recovery Rate
EAD Exposure at Default Outstanding balance
EL Expected Loss PD × LGD × EAD
THREE STAGE APPROACH (similar to IFRS 9):
═══════════════════════════════════════
Stage 1: Performing (12-month PD → lifetime PD for CECL)
→ No significant increase in credit risk since origination
→ Measure CECL over ENTIRE remaining life (not just 12 months)
→ Interest revenue on gross carrying amount
Stage 2: Underperforming
→ Significant increase in credit risk since origination
→ Lifetime PD applied
→ Interest revenue on gross carrying amount
Stage 3: Non-Performing / Impaired
→ Credit-impaired (90+ days past due or probable default)
→ Lifetime PD with higher LGD
→ Interest revenue on NET carrying amount
CECL CALCULATION BY POOL:
═══════════════════════════════════════
Loan Portfolio: Commercial Real Estate ($500M)
Pool Characteristics:
→ Number of loans: 250
→ Weighted avg maturity: 5 years
→ Weighted avg LTV: 65%
→ Geographic diversification: 12 states
Historical Loss Experience:
═══════════════════════════════════════
Vintage Year Roll Rate 1→2 Roll Rate 2→3 Roll Rate 3→Default Recovery Rate
(30-90) (90-120) (120+ to default) (of defaulted)
─────────────────────────────────────────────────────────────────────────────────
2019 8.5% 15.2% 35.0% 55%
2020 10.2% 18.5% 42.0% 48%
2021 9.1% 16.0% 38.0% 52%
2022 11.5% 20.0% 45.0% 45%
2023 12.8% 22.0% 48.0% 42%
─────────────────────────────────────────────────────────────────────────────────
AVG 10.4% 18.3% 41.6% 48%
PD CALCULATION:
═══════════════════════════════════════
For a loan currently in 0-30 days bucket:
Probability of reaching default over remaining life:
Path to default = Roll(0→1) × Roll(1→2) × Roll(2→3) × Roll(3→default)
Year 1: 10.4% × 18.3% × 41.6% = 0.79%
Year 2: (1 - 0.79%) × 10.4% × 18.3% × 41.6% = 0.78%
Year 3: (1 - 0.79% - 0.78%) × 10.4% × 18.3% × 41.6% = 0.77%
Year 4: 0.76%
Year 5: 0.75%
Cumulative PD over 5 years: 4.03%
CECL per loan (average $2M):
PD: 4.03%
LGD: 1 - 0.48 = 52%
EAD: $2,000,000
EL: 4.03% × 52% × $2,000,000 = $41,912
Total CECL reserve for pool:
$41,912 × 250 loans = $10,478,000
ADJUSTMENT FOR FORECAST:
═══════════════════════════════════════
Reasonable and Supportable Forecast Period: 2 years
Reversion to Historical: Linear over 2 years (total 4-year period)
Forecast Economic Scenarios:
═══════════════════════════════════════
Scenario Probability Unemployment GDP Growth Loss Adj
──────────────────────────────────────────────────────────────────────
Baseline 50% 4.5% 2.0% 0%
Recession 30% 7.0% -1.0% +40%
Strong Growth 20% 3.5% 3.0% -20%
Weighted adjustment: (50% × 0%) + (30% × 40%) + (20% × -20%) = 8%
Adjusted CECL reserve: $10,478,000 × 1.08 = $11,316,240
SPECIFIC RESERVES (Large Loans):
═══════════════════════════════════════
Individual evaluation for loans >$5M:
Loan ID Balance Stage PD LGD EAD CECL Method
──────────────────────────────────────────────────────────────────────────────
CRE-001 $15,000K Stage 1 2.5% 45% $15,000K $1,688K Model
CRE-002 $12,000K Stage 2 15.0% 55% $12,000K $990K Model
CRE-003 $8,000K Stage 3 45.0% 70% $8,000K $2,520K Collateral
CRE-004 $20,000K Stage 1 3.0% 50% $20,000K $3,000K Model
──────────────────────────────────────────────────────────────────────
SPECIFIC RESERVES: $8,198K
TOTAL ALLOWANCE FOR CREDIT LOSSES:
═══════════════════════════════════════
Collective model reserve: $11,316K
Specific reserves: $8,198K
Unallocated/general: $2,000K
────────────────────────────────────────────
TOTAL ACL: $21,514K
Allowance as % of loans: $21,514K / $500,000K = 4.30%2. Asset Impairment Testing
ASSET IMPAIRMENT TESTING — Long-Lived Assets (ASC 360)
═══════════════════════════════════════
Two-Step Impairment Test:
STEP 1: Recoverability Test
═══════════════════════════════════════
Compare carrying amount to undiscounted future cash flows.
If: Carrying Amount > Undiscounted Cash Flows → IMPAIRED (proceed to Step 2)
If: Carrying Amount ≤ Undiscounted Cash Flows → NOT impaired (stop)
Example — Manufacturing Plant:
═══════════════════════════════════════
Carrying amount: $50,000,000
Useful life remaining: 10 years
Undiscounted Future Cash Flows:
═══════════════════════════════════════
Year Cash Flow Cumulative
─────────────────────────────────────
1 $6,000,000 $6,000,000
2 $5,500,000 $11,500,000
3 $5,000,000 $16,500,000
4 $4,500,000 $21,000,000
5 $4,000,000 $25,000,000
6 $3,500,000 $28,500,000
7 $3,000,000 $31,500,000
8 $2,500,000 $34,000,000
9 $2,000,000 $36,000,000
10 $1,500,000 $37,500,000
─────────────────────────────────────
TOTAL: $37,500,000
$50,000,000 > $37,500,000 → FAILS recoverability test → PROCEED TO STEP 2
STEP 2: Measure Impairment Loss
═══════════════════════════════════════
Fair Value (using discounted cash flows):
═══════════════════════════════════════
Discount rate (WACC): 12%
Year Cash Flow PV Factor PV
─────────────────────────────────────────────
1 $6,000,000 0.8929 $5,357,000
2 $5,500,000 0.7972 $4,385,000
3 $5,000,000 0.7118 $3,559,000
4 $4,500,000 0.6355 $2,860,000
5 $4,000,000 0.5674 $2,270,000
6 $3,500,000 0.5066 $1,773,000
7 $3,000,000 0.4523 $1,357,000
8 $2,500,000 0.4039 $1,010,000
9 $2,000,000 0.3606 $721,000
10 $1,500,000 0.3220 $483,000
─────────────────────────────────────────────
FAIR VALUE: $23,775,000
IMPAIRMENT LOSS = Carrying Amount - Fair Value
= $50,000,000 - $23,775,000
= $26,225,000
JOURNAL ENTRY:
Dr Impairment Loss — Long-Lived Assets $26,225,000
Cr Accumulated Impairment — Plant $26,225,000
New carrying amount: $23,775,000 (becomes new cost basis)3. Goodwill Impairment Testing
GOODWILL IMPAIRMENT TEST (ASC 350)
═══════════════════════════════════════
Annual test (or interim if triggering event)
Simplified One-Step Test (post-ASU 2017-04):
Compare Fair Value of Reporting Unit to Carrying Amount (including goodwill)
If FV > Carrying Amount: No impairment
If FV < Carrying Amount: Impairment = Carrying - FV (max = total goodwill)
REPORTING UNIT ANALYSIS:
═══════════════════════════════════════
Reporting Unit: Enterprise Software Division
Carrying Amount:
═══════════════════════════════════════
Net Assets (identifiable): $80,000,000
Goodwill: $120,000,000
────────────────────────────────────────────
TOTAL CARRYING AMOUNT: $200,000,000
Fair Value (Market Approach):
═══════════════════════════════════════
Method: Guideline Public Company Method
Comparable Companies:
═══════════════════════════════════════
Company Revenue EBITDA EV EV/Rev EV/EBITDA
──────── ─────── ────── ─────── ───────────
Comp A $150M $30M $750M 5.0x 25x
Comp B $120M $24M $600M 5.0x 25x
Comp C $200M $45M $1,000M 5.0x 22x
Comp D $180M $38M $900M 5.0x 24x
Comp E $160M $35M $800M 5.0x 23x
────────────────────────────────────────────────────────────────────
MEDIAN EV/Revenue: 5.0x
MEDIAN EV/EBITDA: 24x
Target Metrics:
Revenue: $140M
EBITDA: $28M
Fair Value Estimates:
→ Using EV/Revenue: $140M × 5.0x = $700M (too high for our unit)
→ Using EV/EBITDA: $28M × 24x = $672M (also too high)
Wait — these are for the whole company. For this reporting unit:
Unit Revenue: $40M
Unit EBITDA: $8M
→ Using EV/Revenue: $40M × 5.0x = $200M
→ Using EV/EBITDA: $8M × 24x = $192M
Fair Value of Reporting Unit: ~$196M (average)
IMPAIRMENT ASSESSMENT:
═══════════════════════════════════════
Fair Value: $196,000,000
Carrying Amount: $200,000,000
───────────────────────────────────────
IMPAIRMENT INDICATED: YES
Impairment Amount: $200,000,000 - $196,000,000 = $4,000,000
(Not exceeding total goodwill of $120,000,000)
JOURNAL ENTRY:
Dr Impairment Loss — Goodwill $4,000,000
Cr Goodwill — Software Division $4,000,000
REMAINING GOODWILL: $120,000,000 - $4,000,000 = $116,000,0004. Contingent Liability Reserves
CONTINGENT LIABILITY RESERVE ANALYSIS
═══════════════════════════════════════
LITIGATION RESERVES:
═══════════════════════════════════════
Case 1: Product Liability Lawsuit
→ Filed: March 2023
→ Alleged damages: $25,000,000
→ Probability: "Probable" (likely to occur)
→ Estimability: $8M-$12M (reasonable estimate range)
→ Best estimate: $10,000,000
→ Action: RECORD $10,000,000 reserve
Case 2: Patent Infringement
→ Filed: September 2023
→ Alleged damages: $15,000,000
→ Probability: "Reasonably possible" (more than remote, less than likely)
→ Estimability: Cannot estimate
→ Action: DISCLOSE only (no reserve)
Case 3: Employment Discrimination
→ Filed: January 2024
→ Alleged damages: $5,000,000
→ Probability: "Remote" (unlikely to occur)
→ Action: NO disclosure, no reserve
Case 4: Environmental Cleanup
→ Identified: June 2023
→ Estimated cost: $3,000,000-$5,000,000
→ Probability: "Probable"
→ Estimability: Range established
→ Action: RECORD minimum of range = $3,000,000
RECORDING THRESHOLDS (ASC 450):
═══════════════════════════════════════
Probability Level Action
───────────────────────────────────────────────
Probable AND Estimable → Record accrual
Probable, Not Estimable → Disclose only
Reasonably Possible → Disclose only
Remote → No action
TOTAL RESERVES RECORDED:
═══════════════════════════════════════
Case 1 (Product Liability): $10,000,000
Case 4 (Environmental): $3,000,000
──────────────────────────────────────
TOTAL CONTINGENT RESERVES: $13,000,000
WARRANTY RESERVE:
═══════════════════════════════════════
Method: Historical rate × current sales
Historical warranty rate: 2.5% of revenue
Current period revenue: $100,000,000
Warranty reserve: $100,000,000 × 2.5% = $2,500,000
JOURNAL ENTRY:
Dr Warranty Expense $2,500,000
Cr Warranty Reserve $2,500,000
WARRANTY RESERVE ROLLFORWARD:
═══════════════════════════════════════
Beginning balance: $2,000,000
Add: Warranty expense: $2,500,000
Less: Warranty claims paid: ($1,800,000)
Less: Write-offs (expired): ($200,000)
─────────────────────────────────────────────
Ending balance: $2,500,000Edge Cases
- CECL for large banks: Complex models with hundreds of pools; model governance critical
- Collateral-dependent loans: CECL based on collateral value, not cash flows
- Purchased credit-deteriorated (PCD): Day-one ACL required
- Goodwill with negative FV: Maximum impairment = total goodwill balance
- Off-balance-sheet contingencies: Guarantees, letters of credit require separate analysis
Integration Points
- Core banking systems: Loan data, payment history, collateral values
- CECL software: Actimize, Moody's Analytics, Fair Isaac (credit models)
- Legal systems: Case management, litigation tracking
- ERP: GL for reserve entries, warranty tracking
- Risk systems: PD/LGD models, stress testing
- Disclosure systems: SEC filings, regulatory reports
Output
Reserve Summary
RESERVE ANALYSIS SUMMARY — Q1 2024
═══════════════════════════════════════
Allowance for Credit Losses: $21.5M (4.30% of loans)
→ Collective reserve: $11.3M
→ Specific reserves: $8.2M
→ General reserve: $2.0M
Goodwill Impairment: $4.0M (Software Division)
→ Remaining goodwill: $116.0M
Contingent Liability Reserves: $13.0M
→ Product liability: $10.0M
→ Environmental: $3.0M
Warranty Reserve: $2.5M (2.5% of revenue)
Total reserves and allowances: $37.0M