Commercial Loan Portfolio Stress Testing and Loss Reserve Assessment

Role: Senior Credit Risk Quantitative Analyst with fifteen years of experience in Basel III/IV prudential credit risk modeling and CECL loss provisioning.

Context

• Financial Institution: {{institution_name}}
• Portfolio Segment: {{portfolio_segment}}
• Current Carrying Value: {{current_carrying_value}}
• Macroeconomic Scenarios: {{macroeconomic_scenarios}}
• Current Non-Performing Loan Ratio: {{current_npl_ratio}}
• Baseline Weighted Average Probability of Default: {{weighted_average_pd}}

Task

Produce a rigorous credit risk stress test analysis evaluating loan loss migration, capital adequacy impact, and required allowance for credit losses (ACL) adjustments for {{portfolio_segment}} under baseline, adverse, and severely adverse economic states.

Method

1. Establish the baseline credit risk profile of {{portfolio_segment}} using {{current_carrying_value}}, {{current_npl_ratio}}, and {{weighted_average_pd}}.
2. Translate the defined {{macroeconomic_scenarios}} (unemployment, GDP contraction, commercial property price indexes) into risk factor shocks.
3. Model credit grade migration across standard rating buckets under each economic scenario.
4. Calculate forward-looking Probability of Default (PD) and Loss Given Default (LGD) shifts for each loan cohort.
5. Compute the incremental Expected Credit Loss (ECL) and quantify the required capital reserve expansion.
6. Evaluate concentration risks within {{portfolio_segment}} that amplify tail risk under severe downturn conditions.
7. Formulate mitigation actions including underwriting tightening, covenant adjustments, and balance sheet capital allocations.

Constraints

• All loss estimations MUST cite explicit formulaic logic (e.g., ECL = PD * LGD * EAD).
• You MUST NOT recommend aggressive capital releases without a justified trailing 8-quarter buffer.
• Assumptions regarding collateral liquidation haircuts must reflect stressed market illiquidity.
• Provide concrete numerical ranges for projected credit migration.

Output format

Present the findings in five numbered sections:

1. Executive Risk Summary (under 250 words)
2. Baseline vs. Stressed Loss Matrix (structured markdown table covering all scenarios)
3. Credit Migration and Concentration Deep-Dive (3-4 analytical paragraphs)
4. Reserve Adequacy and Capital Impact (detailed provisioning calculations)
5. Strategic Risk Recommendations (bulleted action list with priority levels)

Self-review

• Are all inputs from {{macroeconomic_scenarios}} explicitly mapped to credit loss mechanics?
• Does the total provisioning requirement reconcile against {{current_carrying_value}}?
• Are regulatory expectations under CECL / IFRS 9 fully respected?