name: lending-risk-brief
description: "Write a portfolio-level lending risk brief: concentration analysis by sector, geography and single name, vintage performance, migration matrix narrative, macro-sensitivity scenarios, top watch names, and actions. Use when asked to write a portfolio risk report, credit risk committee brief, loan book review, or quarterly portfolio quality update. Produces a structured risk brief with concentration tables, migration narrative, scenario read, watch list, and recommended actions."
Lending Risk Brief Skill
A loan book fails in patterns before it fails in names. This skill writes the portfolio-level brief that makes the patterns visible: where the book is concentrated, which vintages are misbehaving, which way the grades are migrating, what the macro could do to it, and which names need decisions now.
What This Skill Produces
- Concentration analysis: sector, geography, single-name — each against limits
- Vintage performance comparison
- A migration-matrix narrative (not just the matrix)
- Macro-sensitivity scenarios (base / adverse / severe) with named transmission channels
- A top-10 watch-names table
- Recommended actions with owners
Required Inputs
Ask for what's available; compute what the data supports and mark the rest [data gap — request from portfolio systems]:
- Portfolio snapshot — exposures by borrower, sector, geography, grade, origination vintage
- Concentration limits from the risk appetite statement, if set
- Grade migrations this period (upgrades/downgrades by exposure)
- Delinquency/NPL and provision figures, current and prior periods
- Watch-list candidates already known to the team
Portfolio Framework
1. Concentration. Three cuts, each vs its limit (or vs a stated reference norm if no limit exists — and flag the missing limit as a finding): top sector and top-3 sector share; geographic share; single-name — top-10 and top-20 obligor share, largest single exposure vs capital. Concentration that grew via passive drift (runoff elsewhere) deserves the same flag as active growth — say which it was. Correlated concentrations count together (e.g. construction lending + commercial-real-estate collateral is one bet, not two).
2. Vintage performance. Compare cohorts at the same age on-book (delinquency/default at month 12, 24…), not calendar snapshots — a young book always looks clean. A vintage underperforming its age-matched predecessors signals an underwriting-standards question for that origination period; name the period and what changed in criteria then, if known.
3. Migration narrative. Report net migration by exposure, not count. The narrative must answer: is movement drift (broad one-notch slippage → macro/sector pressure) or jumps (multi-notch falls → underwriting or monitoring misses)? Which sectors drive the downgrades? Are downgrades arriving before delinquency (grading works) or after (grading lags — a finding in itself)?
4. Macro scenarios. Base / adverse / severe. For each: the named driver (rates, unemployment, property values, sector shock) and its transmission channel into this specific book ("+200bps hits the 34% of book on floating rate at refinance; DSCR<1.2x share rises from X to Y [compute from data]"). Severity framing over precision — label all scenario numbers as estimates.
5. Watch names. Top 10 by exposure-weighted concern: name/ref, exposure, grade and recent movement, the concern in one sentence, the action and its owner and date.
6. Actions. Each tied to a finding: limit proposals, sector pause/tighten, deep-dive reviews, provision considerations, data fixes. An observation without an action is a gap — either act or state why watching is the action.
Output Format
Portfolio risk brief: [portfolio / as-at date]
1. Headline read — 3–4 sentences: direction of book quality and the one thing committee must decide.
2. Concentration — table per cut: segment | exposure | share % | limit | headroom | trend.
3. Vintage performance — cohorts at matched age, worst vintage named.
4. Migration — net migration by exposure + the drift-vs-jumps narrative.
5. Scenarios — base/adverse/severe: driver | transmission channel | estimated impact.
6. Top-10 watch names — ref | exposure | grade Δ | concern | action | owner | date.
7. Actions — numbered, each tied to its finding, with owner.
End with: "This brief is analytical support, not a credit, provisioning, or capital determination. Decisions follow your institution's risk policy and applicable regulation."
Quality Checks
Anti-Patterns
Example Trigger Phrases
- "Write a portfolio risk report."
- "Write the loan book review."
- "Write the quarterly portfolio quality update."
- "Brief the credit risk committee."