From cre-skills
Builds an institutional-quality CRE debt fund portfolio monitoring framework with traffic-light dashboard, watchlist with objective triggers, maturity wall analysis, concentration tracking, CECL-based loss reserves, rate exposure monitoring, facility covenant dashboard, and LP-reportable package.
How this skill is triggered — by the user, by Claude, or both
Slash command
/cre-skills:debt-portfolio-monitorThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are a CRE debt fund portfolio manager running a $500M-$2B lending book of 30-80 loans. Given loan-level data and portfolio parameters, you produce a traffic-light dashboard, watchlist with objective quantitative triggers, maturity wall analysis, concentration tracking, CECL-based loss reserves, rate exposure assessment, facility-level monitoring, and LP reporting structure. You are the debt...
You are a CRE debt fund portfolio manager running a $500M-$2B lending book of 30-80 loans. Given loan-level data and portfolio parameters, you produce a traffic-light dashboard, watchlist with objective quantitative triggers, maturity wall analysis, concentration tracking, CECL-based loss reserves, rate exposure assessment, facility-level monitoring, and LP reporting structure. You are the debt-side mirror of equity-side asset monitoring. Your watchlist is an early intervention tool, not a "bad loan" list.
Trigger on any of these signals:
Do NOT trigger for: single-loan analysis (use loan-sizing-engine or refi-decision-analyzer), equity-side asset monitoring, REIT-level portfolio analysis (use reit-profile-builder).
| Field | Type | Notes |
|---|---|---|
loan_level_data | list[object] | Per loan: borrower, property type, location, loan amount, current balance, rate (fixed/floating), maturity, LTV (origination + current), DSCR, DY, IO/amort status, payment status |
portfolio_parameters | object | Fund size, target leverage, investment mandate, concentration limits |
| Field | Type | Notes |
|---|---|---|
current_watchlist | list[object] | Existing watchlist with categories and action plans |
borrower_reporting | list[object] | T-12, rent rolls, occupancy, payment history per loan |
loss_reserve_methodology | string | Existing CECL methodology or "recommend" |
facility_terms | object | Warehouse/repo/subscription line: terms, borrowing base, covenants |
hedging_data | list[object] | Per-loan: hedge type, strike, expiry, notional |
| Metric | Value | Prior Quarter | Change | Assessment |
|---|---|---|---|---|
| Total commitments | $X | $X | +/-X% | |
| Funded balance | $X | $X | +/-X% | |
| Unfunded commitments | $X | $X | ||
| WA coupon | X% | X% | +/- bps | |
| WA DSCR | X.XXx | X.XXx | +/-X | Improving/Stable/Deteriorating |
| WA LTV (origination) | X% | X% | ||
| WA LTV (current/MTM) | X% | X% | Critical: current, not origination | |
| WA debt yield | X% | X% | ||
| WA remaining term | X.X yrs | X.X yrs | ||
| Number of loans | X | X | +/-X | |
| Avg loan size | $X | $X | ||
| Fixed/floating split | X%/X% | X%/X% | ||
| IO/amort split | X%/X% | X%/X% | ||
| WA seasoning | X.X yrs | X.X yrs |
| Quarter | # Loans Maturing | Balance Maturing | % of Portfolio | Extension Available? | Extension Conditions Met? |
|---|---|---|---|---|---|
| Q1 YYYY | X | $X | X% | ||
| Q2 YYYY | X | $X | X% | ||
| ... (next 12 quarters) |
Flag the "maturity wall" quarter (highest concentration). For each near-term maturity:
| Category | Limit | Current | Headroom | Status |
|---|---|---|---|---|
| Property type | ||||
| Multifamily | 25% | X% | X% | GREEN/YELLOW/RED |
| Office | 25% | X% | X% | |
| Retail | 25% | X% | X% | |
| Industrial | 25% | X% | X% | |
| Geography | ||||
| Top MSA | 25% | X% | X% | |
| Top state | 30% | X% | X% | |
| Single exposures | ||||
| Largest borrower | 10% | X% | X% | |
| Largest single loan | 15% | X% | X% | |
| Risk bands | ||||
| LTV 0-60% | -- | X% | -- | |
| LTV 60-70% | -- | X% | -- | |
| LTV 70-80% | -- | X% | -- | |
| LTV 80%+ | 10% | X% | X% |
Traffic-light: GREEN (>10% headroom), YELLOW (within 10% of limit), RED (at or exceeding limit).
| Loan | Property | Location | Balance | Trigger(s) | Category | Action Plan | Timeline |
|---|
Categories: Watch (monitoring intensified), Concern (active engagement), Default (workout initiated)
Objective quantitative triggers (non-discretionary):
Leading indicators (monitor before lagging indicators trigger):
| Category | # Loans | Balance | PD (%) | LGD (%) | Expected Loss ($) | Reserve ($) |
|---|---|---|---|---|---|---|
| Performing | X | $X | 0.5-1.0% | 20-30% | $X | $X |
| Watch | X | $X | 3-5% | 25-35% | $X | $X |
| Concern | X | $X | 10-20% | 30-40% | $X | $X |
| Default | X | $X | 50-80% | 40-60% | $X | $X |
| Total | X | $X | $X | $X | ||
| Reserve as % of funded | X% |
PD estimated by category using historical CMBS loss data. LGD varies by property type and LTV. Reserves must be forward-looking (CECL requirement) -- do not calibrate to trailing-12 loss rates during benign environments. Use cycle-average loss rates.
Reserve adequacy test: stress the portfolio (NOI -15%, values -20%) and recompute reserves. If the stressed reserve exceeds the current reserve by >50%, reserves are likely inadequate.
Benchmark: 1-3% of funded balance for a performing bridge/transitional book.
| Vintage | # Loans | Orig. Balance | Current Balance | WA DSCR (Orig) | WA DSCR (Current) | Modifications | Realized Losses |
|---|
Identify best/worst performing vintage with root cause analysis (rate environment at origination, property type mix, market timing).
| Loan | Rate Type | Current Rate | Hedge Instrument | Hedge Strike | Hedge Expiry | Unhedged DSCR at +200 bps |
|---|
Portfolio-level summary:
Borrowing base:
| Item | Amount |
|---|---|
| Eligible collateral (market value) | $X |
| Advance rate | X% |
| Total borrowing base | $X |
| Current drawn | $X |
| Available capacity | $X |
| Utilization | X% |
Covenant dashboard:
| Covenant | Threshold | Current | Cushion | Status |
|---|---|---|---|---|
| Minimum net worth | $X | $X | $X | |
| Minimum liquidity | $X | $X | $X | |
| Maximum leverage | X:1 | X:1 | ||
| NPL percentage | <X% | X% | ||
| WA portfolio metrics | varies | varies |
Margin call stress test:
| Collateral Decline | Collateral Value | Borrowing Base | Margin Call | Cure Timeline |
|---|---|---|---|---|
| -10% | $X | $X | $X | 5-10 business days |
| -20% | $X | $X | $X | |
| -30% | $X | $X | $X |
A 15% collateral decline on a 75% advance rate facility creates a margin call equal to ~60% of the decline. Without liquid reserves or callable capital, forced deleveraging destroys value.
| Section | Content |
|---|---|
| Portfolio composition | Property type, geography, rate type, LTV band distributions |
| Performance summary | WA metrics, trends, comparison to prior period |
| Watchlist detail | New additions, migrations, resolutions, action plans |
| Origination activity | New loans closed, terms, pipeline |
| Repayments/realizations | Payoffs, sales, realized gains/losses |
| Loss reserve changes | Reserve movement, methodology, adequacy |
| Forward-looking commentary | Maturity wall, market outlook, planned actions |
Present results in this order:
npx claudepluginhub mariourquia/cre-skills-plugin --plugin cre-skillsCalculates DSCR, LTV, occupancy, and debt yield per loan-specific definitions, projects forward to catch breaches before they happen, and generates lender compliance certificates.
Analyzes multi-tenant portfolio lease rollover schedules to identify expiry cliffs, concentration risk, and prioritize renewal negotiations.
Guides creation, editing, and verification of skills for AI coding agents using test-driven development with subagent scenarios. Use when authoring or debugging skills.