managing-loan-portfolio-monitoring

# Managing Loan Portfolio Monitoring

Structures loan portfolio review with credit quality trends, watch list management, and concentration analysis.

## When To Use

- Preparing periodic (monthly/quarterly) loan portfolio review reports for credit committees or board
- Tracking migration of loans across risk rating categories over time
- Building or updating a credit watch list with downgrade/upgrade triggers
- Analyzing portfolio concentrations by industry, geography, borrower, collateral type, or product
- Responding to regulatory exam findings on portfolio management or concentration risk
- Evaluating the adequacy of the allowance for credit losses (ACL) relative to portfolio trends

## Inputs To Gather

- **Loan trial balance** — outstanding balances, commitment amounts, risk ratings, maturity dates, accrual status
- **Risk rating history** — prior-period ratings for migration analysis (minimum two quarters, preferably four)
- **Watch list** — current watch list with entry dates, action plans, and last-review dates
- **Delinquency and past-due reports** — 30/60/90+ day buckets, nonaccrual loans, TDRs/loan modifications
- **Concentration policy limits** — board-approved limits by sector, geography, single-borrower, CRE/C&I split, and product type [VERIFY against current board policy]
- **Charge-off and recovery data** — net charge-offs by segment for the reporting period and trailing 12 months
- **Collateral valuations** — most recent appraisals or evaluations, LTV calculations for secured credits
- **Economic/market data** — relevant benchmarks (unemployment, CRE vacancy rates, commodity prices) affecting key portfolio segments

## Workflow

1. **Validate data integrity**
   - Reconcile loan trial balance totals to the general ledger
   - Confirm risk ratings are current (no stale ratings beyond review cycle)
   - Flag any loans missing required fields (rating, NAICS code, collateral type) with [VERIFY]

2. **Compile portfolio snapshot**
   - Summarize total commitments, outstanding balances, and unfunded commitments
   - Break down by loan type (C&I, CRE owner-occupied, CRE non-owner-occupied, construction, consumer, trade finance)
   - Show period-over-period changes in dollar and percentage terms

3. **Analyze credit quality trends**
   - Build a risk rating migration matrix (beginning-of-period vs. end-of-period ratings)
   - Calculate weighted-average risk rating for the portfolio and major segments
   - Track criticized and classified asset ratios (special mention, substandard, doubtful) against policy thresholds [VERIFY thresholds per internal policy]
   - Summarize delinquency trends and nonaccrual balances with root-cause commentary

4. **Manage watch list**
   - Add new entries with: borrower name, outstanding exposure, risk rating, reason for watch, and recommended action plan
   - Update existing entries with progress notes and revised timelines
   - Remove entries only when the credit has been upgraded, paid off, or charged off — document the basis for removal
   - Assign clear ownership (relationship manager or workout officer) and next-review dates

5. **Assess concentration risk**
   - Compare actual concentrations against board-approved limits for each category
   - Flag any limit breaches or approaching-threshold conditions (e.g., >80% of limit)
   - For CRE concentrations, calculate CRE-to-capital and construction-to-capital ratios [VERIFY against interagency CRE guidance thresholds: 300% and 100%]
   - Identify single-borrower or related-entity exposures approaching legal lending limits

6. **Evaluate loss coverage**
   - Compare ACL-to-total-loans ratio against peer benchmarks and historical range
   - Assess ACL coverage of nonperforming loans
   - Note any qualitative adjustment factors (Q-factors) that warrant revision based on observed trends

7. **Prepare management report**
   - Executive summary with key metrics and trend arrows (improving/stable/deteriorating)
   - Portfolio composition tables and charts
   - Credit quality migration matrix
   - Watch list detail with action items
   - Concentration dashboard with policy limits and current utilization
   - Recommended actions and escalation items for committee decision

## Output

A structured loan portfolio monitoring report containing:

- **Executive summary** — headline metrics (total portfolio size, weighted-average risk rating, criticized asset ratio, net charge-off rate, top 3 concentrations) with period-over-period trend indicators
- **Portfolio composition tables** — by product, industry, geography, and maturity band
- **Risk rating migration matrix** — visual grid showing upgrades, downgrades, and stable credits
- **Watch list** — sortable table with borrower, exposure, rating, watch reason, action plan, owner, and next review date
- **Concentration analysis** — dashboard comparing actual exposures to policy limits with traffic-light indicators (green/yellow/red)
- **Action items** — numbered list of recommended committee decisions, escalations, and follow-up deadlines

## Quality Checks

- All portfolio totals tie back to the general ledger — no unexplained variances
- Risk rating migration matrix rows and columns balance (beginning population ± new/paid/charged = ending population)
- Every watch list entry has a named owner, a concrete action plan, and a next-review date
- Concentration percentages are calculated on a consistent denominator (Tier 1 capital + ACL for regulatory ratios, total commitments or outstanding for internal limits) [VERIFY denominator convention per institution policy]
- Delinquency and nonaccrual figures reconcile to subsidiary reports
- Report clearly distinguishes between committed and outstanding exposure where relevant
- All externally referenced thresholds (regulatory guidance, peer data) cite the source and date
- Items requiring committee decision are explicitly called out, not buried in narrative