Collateral Risk Summaries
Overview
Produce comprehensive collateral risk assessments for secured lending transactions. This skill evaluates collateral type, valuation methodology, marketability, environmental risk, lien position, and expected liquidation recovery to generate structured risk summaries suitable for credit memoranda, loan committee presentations, and ongoing portfolio monitoring. Assessments incorporate advance rate frameworks, collateral-specific depreciation models, and stress-tested recovery scenarios.
When to Use
- Evaluating collateral adequacy for new loan originations or renewals
- Preparing the collateral section of credit memoranda for loan committee
- Reviewing appraisal reports for completeness and reasonableness
- Monitoring collateral value changes during the loan life (annual reviews, impairment triggers)
- Assessing liquidation scenarios for distressed or workout situations
- Determining appropriate advance rates for asset-based lending facilities
Required Inputs
| Input |
Description |
Format |
| Collateral description |
Type, location, condition, specifications |
Structured data |
| Valuation report |
Appraisal, BPO, desktop valuation, or internal assessment |
Appraisal document |
| Loan terms |
Amount, LTV, advance rate, lien position |
Loan structure |
| Market data |
Comparable sales, market trends, vacancy rates |
Market analysis |
| Environmental reports |
Phase I/II ESA results, known contamination |
Environmental docs |
| Insurance coverage |
Hazard, flood, liability coverage amounts |
Insurance certs |
| Legal review |
Title, lien search, UCC filing status |
Legal documents |
Methodology
Step 1 — Collateral Classification and Eligibility
Classify the collateral and determine eligibility under the lending program:
- Real estate: Commercial (office, retail, industrial, multifamily, special purpose), residential (1–4 family, condo, manufactured)
- Equipment: General purpose vs. special purpose, mobile vs. fixed, age and remaining useful life
- Inventory: Raw materials, work-in-process, finished goods — eligible vs. ineligible categories
- Receivables: Eligible A/R (age < 90 days, no concentration > 25%, no intercompany, no government without assignment)
- Securities: Marketable vs. restricted, margin requirements, custodial arrangements
- Other: Intellectual property, business enterprise value, personal guarantees, life insurance CSV
Determine ineligible collateral components: environmentally contaminated, contested title, uninsurable, cross-collateralized with senior liens exceeding value.
Step 2 — Valuation Assessment and Reconciliation
Evaluate the collateral valuation for completeness and reasonableness:
- Appraisal methodology review: Confirm appropriate approach used
- Income approach: Cap rate supported by market data, NOI calculated correctly, vacancy and expense assumptions reasonable
- Sales comparison: Comparables are truly comparable (location, size, age, condition, timing)
- Cost approach: Replacement cost accurate, depreciation reasonable, land value supported
- Reconciliation: If multiple approaches used, verify reconciliation logic and final value
- Red flag identification:
- Value significantly above recent purchase price without justification
- Cap rates below market norms for the property type and submarket
- Unsupported adjustments to comparables exceeding 25%
- Appraisal ordered by borrower rather than lender
- Appraiser unfamiliar with the local market or property type
- Mark-to-market adjustments: Apply index-based adjustments for existing collateral (HPI for residential, NCREIF/CoStar for commercial)
Step 3 — Advance Rate Determination
Apply appropriate advance rates based on collateral type and quality:
| Collateral Type |
Standard Advance Rate |
Stressed Advance Rate |
Notes |
| 1–4 Family Residential |
75%–80% |
60%–65% |
Higher for owner-occupied |
| Commercial RE (stabilized) |
70%–75% |
55%–65% |
Varies by property type |
| Commercial RE (construction) |
60%–65% |
45%–55% |
Based on costs-to-date |
| Equipment (general purpose) |
70%–80% |
50%–60% |
Orderly liquidation value |
| Equipment (special purpose) |
40%–60% |
25%–40% |
Forced liquidation value |
| Eligible A/R |
80%–85% |
65%–75% |
Net of dilution and disputes |
| Eligible Inventory |
50%–65% |
30%–45% |
Depends on marketability |
| Marketable Securities |
50%–70% |
35%–50% |
Margin loan requirements |
Adjust advance rates downward for: illiquid markets, deferred maintenance, environmental concerns, declining market trends, or special-purpose properties.
Step 4 — Risk Factor Analysis
Assess specific risk factors affecting collateral value stability:
- Market risk: Local market supply/demand dynamics, absorption rates, development pipeline
- Obsolescence risk: Functional obsolescence (floor plan, ceiling height), economic obsolescence (market shifts)
- Environmental risk: Phase I findings requiring Phase II, known contamination, proximity to industrial sites
- Regulatory risk: Zoning changes, rent control, building code compliance, ADA requirements
- Concentration risk: Over-reliance on single tenant, geographic area, or property type
- Physical condition: Deferred maintenance, remaining useful life of major systems (roof, HVAC, elevator)
- Insurance adequacy: Coverage amount vs. replacement cost, flood zone determination, earthquake exposure
Step 5 — Liquidation Recovery Scenario Analysis
Model recovery under multiple liquidation scenarios:
- Orderly liquidation (12–18 months): Market-rate disposition with reasonable marketing period
- Apply 10%–15% discount to current appraised value
- Deduct: broker commissions (5%–6%), closing costs (2%–3%), carrying costs (interest, taxes, insurance, maintenance during marketing period)
- Forced liquidation (3–6 months): Accelerated sale under distressed conditions
- Apply 25%–40% discount to current appraised value
- Deduct: Same cost categories plus potential auction/receiver fees
- Net recovery calculation:
Net Recovery = Liquidation Value
- Senior liens (if any)
- Selling costs
- Carrying costs during liquidation
- Environmental remediation costs (if applicable)
- Legal/foreclosure costs
Step 6 — Lien Position and Legal Perfection Review
Verify collateral security and perfection:
- Title search: Confirm clear title with no unexpected liens, judgments, or encumbrances
- Lien position: Verify the institution holds the intended priority position
- UCC filings: Confirm UCC-1 filed in correct jurisdiction with accurate debtor/collateral description
- Insurance: Named as loss payee/additional insured on all required policies
- Flood determination: FEMA flood zone check; flood insurance if in SFHA
- Property taxes: Current status — delinquent taxes create superior liens
- Guarantees: Personal guarantee and guarantor financial capacity assessment
Step 7 — Generate Collateral Risk Summary
Compile all analysis into a structured summary for credit documentation:
Output Specification
## Collateral Risk Summary
### Collateral Overview
- Type: [Classification]
- Description: [Property/asset description]
- Location: [Address/jurisdiction]
- Appraised/assessed value: $[X]
- Valuation date: [Date]
- Valuation method: [Income/Sales/Cost/Combination]
### Valuation Assessment
- Methodology: [Appropriate/Concerns noted]
- Red flags: [None/Identified — description]
- Mark-to-market adjustment: [X]% → Adjusted value: $[X]
### Advance Rate Analysis
| Metric | Value |
|--------|-------|
| Loan amount | $[X] |
| Appraised value | $[X] |
| Standard advance rate | XX% |
| Proposed LTV | XX% |
| LTV vs. advance rate | [Within / Exceeds — by X%] |
### Risk Factors
| Factor | Rating | Commentary |
|--------|--------|-----------|
| Market conditions | [Low/Med/High] | [Detail] |
| Environmental | [Low/Med/High] | [Detail] |
| Physical condition | [Low/Med/High] | [Detail] |
| Obsolescence | [Low/Med/High] | [Detail] |
| Insurance adequacy | [Adequate/Deficient] | [Detail] |
### Liquidation Recovery Analysis
| Scenario | Gross Value | Costs | Net Recovery | Recovery % |
|----------|------------|-------|-------------|-----------|
| Orderly (12–18 mo) | $[X] | $[X] | $[X] | XX% |
| Forced (3–6 mo) | $[X] | $[X] | $[X] | XX% |
### Legal Perfection
- Title: [Clear/Exceptions noted]
- Lien position: [1st/2nd — confirmed/unconfirmed]
- UCC status: [Filed/Pending]
- Insurance: [Adequate/Deficient]
### Overall Collateral Risk Rating: [Low / Moderate / Elevated / High]
### Recommendation: [Accept / Accept with conditions / Decline]
Analysis Framework
Apply the VALUE framework:
- Valuation — Assess the quality and reasonableness of the collateral valuation
- Advance rate — Determine the appropriate advance rate for the collateral type and quality
- Liquidation — Model recovery scenarios under orderly and forced disposition
- Underlying risks — Identify environmental, market, physical, and legal risk factors
- Enforceability — Verify lien perfection, insurance, and legal access to collateral
Examples
Example 1 — Multifamily Property
72-unit apartment complex, Class B, built 1998. Appraised at $9.8M using 5.8% cap rate on $568K NOI. Comparables support cap rate. Occupancy 94% (market 96%). Deferred maintenance: $180K (roof, parking lot). Phase I: No RECs. Flood zone: X (no flood insurance required). Proposed loan: $6.86M (70% LTV). Orderly liquidation recovery: $7.9M net of costs. Forced liquidation: $5.7M. Risk rating: Moderate — manageable deferred maintenance, stable market fundamentals. Recommendation: Accept with condition that deferred maintenance be addressed within 12 months, escrowed from loan proceeds.
Example 2 — Special-Purpose Equipment
CNC machining center, 2019 vintage, original cost $1.2M. Orderly liquidation value (OLV) per equipment appraiser: $720K (60% of cost). Forced liquidation value: $420K (35% of cost). Equipment is bolted to foundation — removal cost estimated at $45K. Proposed advance: $500K (69% of OLV). Market for used CNC equipment is active with multiple dealer channels. Risk rating: Moderate — active secondary market but high removal/transport costs. Recommendation: Accept at 65% of OLV ($468K) to provide cushion for removal and transport costs.
Guidelines
- Require independent appraisals for all real estate collateral above de minimis thresholds ($500K)
- Use OLV (orderly liquidation value) rather than FMV for equipment advance rate calculations
- Apply haircuts to inventory advance rates for perishable, fashion-sensitive, or technology items
- Update collateral valuations at minimum annually for criticized assets, every 3 years for pass
- Require Phase I ESA for all commercial real estate; Phase II if Phase I identifies RECs
- Verify insurance annually and immediately upon any casualty loss notification
- Cross-reference property tax records to confirm no delinquencies creating senior liens
- Document all appraisal review findings per FIRREA and interagency appraisal guidelines
Validation Checklist
1---2name: collateral-risk-summaries3description: Assess and summarize collateral risk for secured lending decisions including real estate, equipment, inventory, and receivables. Use when evaluating collateral adequacy, preparing collateral risk sections for credit memos, monitoring collateral value deterioration, reviewing appraisals, or assessing liquidation recovery scenarios.45metadata:6 display_name: "Collateral Risk Summaries"7 short_description: "Assess collateral risk and recovery for secured lending"8 default_prompt: "Summarize my collateral risk with key findings and next steps"9 version: "1.0.0"10 tags:11 - financial-services12 icon_path: "assets/icon.png"13---1415# Collateral Risk Summaries1617## Overview1819Produce comprehensive collateral risk assessments for secured lending transactions. This skill evaluates collateral type, valuation methodology, marketability, environmental risk, lien position, and expected liquidation recovery to generate structured risk summaries suitable for credit memoranda, loan committee presentations, and ongoing portfolio monitoring. Assessments incorporate advance rate frameworks, collateral-specific depreciation models, and stress-tested recovery scenarios.2021## When to Use2223- Evaluating collateral adequacy for new loan originations or renewals24- Preparing the collateral section of credit memoranda for loan committee25- Reviewing appraisal reports for completeness and reasonableness26- Monitoring collateral value changes during the loan life (annual reviews, impairment triggers)27- Assessing liquidation scenarios for distressed or workout situations28- Determining appropriate advance rates for asset-based lending facilities2930## Required Inputs3132| Input | Description | Format |33|-------|-------------|--------|34| Collateral description | Type, location, condition, specifications | Structured data |35| Valuation report | Appraisal, BPO, desktop valuation, or internal assessment | Appraisal document |36| Loan terms | Amount, LTV, advance rate, lien position | Loan structure |37| Market data | Comparable sales, market trends, vacancy rates | Market analysis |38| Environmental reports | Phase I/II ESA results, known contamination | Environmental docs |39| Insurance coverage | Hazard, flood, liability coverage amounts | Insurance certs |40| Legal review | Title, lien search, UCC filing status | Legal documents |4142## Methodology4344### Step 1 — Collateral Classification and Eligibility4546Classify the collateral and determine eligibility under the lending program:4748- **Real estate**: Commercial (office, retail, industrial, multifamily, special purpose), residential (1–4 family, condo, manufactured)49- **Equipment**: General purpose vs. special purpose, mobile vs. fixed, age and remaining useful life50- **Inventory**: Raw materials, work-in-process, finished goods — eligible vs. ineligible categories51- **Receivables**: Eligible A/R (age < 90 days, no concentration > 25%, no intercompany, no government without assignment)52- **Securities**: Marketable vs. restricted, margin requirements, custodial arrangements53- **Other**: Intellectual property, business enterprise value, personal guarantees, life insurance CSV5455Determine ineligible collateral components: environmentally contaminated, contested title, uninsurable, cross-collateralized with senior liens exceeding value.5657### Step 2 — Valuation Assessment and Reconciliation5859Evaluate the collateral valuation for completeness and reasonableness:6061- **Appraisal methodology review**: Confirm appropriate approach used62 - Income approach: Cap rate supported by market data, NOI calculated correctly, vacancy and expense assumptions reasonable63 - Sales comparison: Comparables are truly comparable (location, size, age, condition, timing)64 - Cost approach: Replacement cost accurate, depreciation reasonable, land value supported65- **Reconciliation**: If multiple approaches used, verify reconciliation logic and final value66- **Red flag identification**:67 - Value significantly above recent purchase price without justification68 - Cap rates below market norms for the property type and submarket69 - Unsupported adjustments to comparables exceeding 25%70 - Appraisal ordered by borrower rather than lender71 - Appraiser unfamiliar with the local market or property type72- **Mark-to-market adjustments**: Apply index-based adjustments for existing collateral (HPI for residential, NCREIF/CoStar for commercial)7374### Step 3 — Advance Rate Determination7576Apply appropriate advance rates based on collateral type and quality:7778| Collateral Type | Standard Advance Rate | Stressed Advance Rate | Notes |79|----------------|----------------------|----------------------|-------|80| 1–4 Family Residential | 75%–80% | 60%–65% | Higher for owner-occupied |81| Commercial RE (stabilized) | 70%–75% | 55%–65% | Varies by property type |82| Commercial RE (construction) | 60%–65% | 45%–55% | Based on costs-to-date |83| Equipment (general purpose) | 70%–80% | 50%–60% | Orderly liquidation value |84| Equipment (special purpose) | 40%–60% | 25%–40% | Forced liquidation value |85| Eligible A/R | 80%–85% | 65%–75% | Net of dilution and disputes |86| Eligible Inventory | 50%–65% | 30%–45% | Depends on marketability |87| Marketable Securities | 50%–70% | 35%–50% | Margin loan requirements |8889Adjust advance rates downward for: illiquid markets, deferred maintenance, environmental concerns, declining market trends, or special-purpose properties.9091### Step 4 — Risk Factor Analysis9293Assess specific risk factors affecting collateral value stability:9495- **Market risk**: Local market supply/demand dynamics, absorption rates, development pipeline96- **Obsolescence risk**: Functional obsolescence (floor plan, ceiling height), economic obsolescence (market shifts)97- **Environmental risk**: Phase I findings requiring Phase II, known contamination, proximity to industrial sites98- **Regulatory risk**: Zoning changes, rent control, building code compliance, ADA requirements99- **Concentration risk**: Over-reliance on single tenant, geographic area, or property type100- **Physical condition**: Deferred maintenance, remaining useful life of major systems (roof, HVAC, elevator)101- **Insurance adequacy**: Coverage amount vs. replacement cost, flood zone determination, earthquake exposure102103### Step 5 — Liquidation Recovery Scenario Analysis104105Model recovery under multiple liquidation scenarios:106107- **Orderly liquidation (12–18 months)**: Market-rate disposition with reasonable marketing period108 - Apply 10%–15% discount to current appraised value109 - Deduct: broker commissions (5%–6%), closing costs (2%–3%), carrying costs (interest, taxes, insurance, maintenance during marketing period)110- **Forced liquidation (3–6 months)**: Accelerated sale under distressed conditions111 - Apply 25%–40% discount to current appraised value112 - Deduct: Same cost categories plus potential auction/receiver fees113- **Net recovery calculation**:114115```116Net Recovery = Liquidation Value117 - Senior liens (if any)118 - Selling costs119 - Carrying costs during liquidation120 - Environmental remediation costs (if applicable)121 - Legal/foreclosure costs122```123124### Step 6 — Lien Position and Legal Perfection Review125126Verify collateral security and perfection:127128- **Title search**: Confirm clear title with no unexpected liens, judgments, or encumbrances129- **Lien position**: Verify the institution holds the intended priority position130- **UCC filings**: Confirm UCC-1 filed in correct jurisdiction with accurate debtor/collateral description131- **Insurance**: Named as loss payee/additional insured on all required policies132- **Flood determination**: FEMA flood zone check; flood insurance if in SFHA133- **Property taxes**: Current status — delinquent taxes create superior liens134- **Guarantees**: Personal guarantee and guarantor financial capacity assessment135136### Step 7 — Generate Collateral Risk Summary137138Compile all analysis into a structured summary for credit documentation:139140## Output Specification141142```143## Collateral Risk Summary144145### Collateral Overview146- Type: [Classification]147- Description: [Property/asset description]148- Location: [Address/jurisdiction]149- Appraised/assessed value: $[X]150- Valuation date: [Date]151- Valuation method: [Income/Sales/Cost/Combination]152153### Valuation Assessment154- Methodology: [Appropriate/Concerns noted]155- Red flags: [None/Identified — description]156- Mark-to-market adjustment: [X]% → Adjusted value: $[X]157158### Advance Rate Analysis159| Metric | Value |160|--------|-------|161| Loan amount | $[X] |162| Appraised value | $[X] |163| Standard advance rate | XX% |164| Proposed LTV | XX% |165| LTV vs. advance rate | [Within / Exceeds — by X%] |166167### Risk Factors168| Factor | Rating | Commentary |169|--------|--------|-----------|170| Market conditions | [Low/Med/High] | [Detail] |171| Environmental | [Low/Med/High] | [Detail] |172| Physical condition | [Low/Med/High] | [Detail] |173| Obsolescence | [Low/Med/High] | [Detail] |174| Insurance adequacy | [Adequate/Deficient] | [Detail] |175176### Liquidation Recovery Analysis177| Scenario | Gross Value | Costs | Net Recovery | Recovery % |178|----------|------------|-------|-------------|-----------|179| Orderly (12–18 mo) | $[X] | $[X] | $[X] | XX% |180| Forced (3–6 mo) | $[X] | $[X] | $[X] | XX% |181182### Legal Perfection183- Title: [Clear/Exceptions noted]184- Lien position: [1st/2nd — confirmed/unconfirmed]185- UCC status: [Filed/Pending]186- Insurance: [Adequate/Deficient]187188### Overall Collateral Risk Rating: [Low / Moderate / Elevated / High]189### Recommendation: [Accept / Accept with conditions / Decline]190```191192## Analysis Framework193194Apply the **VALUE** framework:195196- **V**aluation — Assess the quality and reasonableness of the collateral valuation197- **A**dvance rate — Determine the appropriate advance rate for the collateral type and quality198- **L**iquidation — Model recovery scenarios under orderly and forced disposition199- **U**nderlying risks — Identify environmental, market, physical, and legal risk factors200- **E**nforceability — Verify lien perfection, insurance, and legal access to collateral201202## Examples203204**Example 1 — Multifamily Property**20520672-unit apartment complex, Class B, built 1998. Appraised at $9.8M using 5.8% cap rate on $568K NOI. Comparables support cap rate. Occupancy 94% (market 96%). Deferred maintenance: $180K (roof, parking lot). Phase I: No RECs. Flood zone: X (no flood insurance required). Proposed loan: $6.86M (70% LTV). Orderly liquidation recovery: $7.9M net of costs. Forced liquidation: $5.7M. Risk rating: Moderate — manageable deferred maintenance, stable market fundamentals. Recommendation: Accept with condition that deferred maintenance be addressed within 12 months, escrowed from loan proceeds.207208**Example 2 — Special-Purpose Equipment**209210CNC machining center, 2019 vintage, original cost $1.2M. Orderly liquidation value (OLV) per equipment appraiser: $720K (60% of cost). Forced liquidation value: $420K (35% of cost). Equipment is bolted to foundation — removal cost estimated at $45K. Proposed advance: $500K (69% of OLV). Market for used CNC equipment is active with multiple dealer channels. Risk rating: Moderate — active secondary market but high removal/transport costs. Recommendation: Accept at 65% of OLV ($468K) to provide cushion for removal and transport costs.211212## Guidelines213214- Require independent appraisals for all real estate collateral above de minimis thresholds ($500K)215- Use OLV (orderly liquidation value) rather than FMV for equipment advance rate calculations216- Apply haircuts to inventory advance rates for perishable, fashion-sensitive, or technology items217- Update collateral valuations at minimum annually for criticized assets, every 3 years for pass218- Require Phase I ESA for all commercial real estate; Phase II if Phase I identifies RECs219- Verify insurance annually and immediately upon any casualty loss notification220- Cross-reference property tax records to confirm no delinquencies creating senior liens221- Document all appraisal review findings per FIRREA and interagency appraisal guidelines222223## Validation Checklist224225- [ ] Collateral correctly classified and eligible under the lending program226- [ ] Valuation methodology is appropriate for the collateral type227- [ ] Appraisal red flags identified and addressed or escalated228- [ ] Advance rate is consistent with policy for the collateral type and quality229- [ ] All material risk factors documented with ratings and commentary230- [ ] Liquidation recovery modeled under both orderly and forced scenarios231- [ ] Liquidation costs are realistic (commissions, carrying costs, legal fees)232- [ ] Lien position confirmed through title search or UCC search233- [ ] Insurance coverage adequate and institution named as loss payee234- [ ] Environmental risk appropriately assessed (Phase I at minimum for CRE)