--- name: reserve-analysis-impairment description: 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 establishing reserves, testing for impairment, analyzing reserve adequacy, performing CECL calculations, or managing contingent liability reserves. Triggers on phrases like "loan loss reserve", "CECL", "expected credit losses", "allowance for credit losses", "reserve adequacy", "impairment test", "warranty reserve", "litigation reserve", "contingent liability", "asset impairment", "goodwill impairment", "long-lived asset impairment", "stage migration", "PD/LGD/EAD", "collectibility assessment". --- # 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,000 ``` ### 4. 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,000 ``` ## Edge 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 ```