conducting-collateral-pool-analysis

# Conducting Collateral Pool Analysis

## When To Use

- Evaluating an asset pool backing a new securitization (ABS, RMBS, CMBS, CLO, or bespoke structured notes)
- Performing periodic surveillance on an existing deal's collateral
- Comparing multiple pool cuts during warehouse accumulation or ramp-up
- Assessing eligibility criteria compliance for a proposed asset addition or substitution
- Supporting rating agency presentations, investor due diligence, or regulatory examinations

## Inputs To Gather

- **Pool tape / loan-level data file** — the asset-by-asset schedule with fields such as obligor, balance, rate, maturity, origination date, geography, industry/property type, credit score or rating, LTV/DSCR, delinquency status
- **Eligibility criteria and concentration limits** from the indenture, pooling & servicing agreement, or warehouse facility terms
- **Historical performance data** — static pool loss curves, delinquency rolls, prepayment speeds, recovery rates for comparable vintages
- **Deal structure details** — target pool size, overcollateralization levels, advance rates, and any reinvestment or replenishment provisions
- **Third-party reports** (if available) — appraisals, BPOs, credit reports, servicer commentary

## Workflow

1. **Validate the pool tape**
   - Confirm record count, total balance, and field completeness against summary statistics provided by the originator
   - Identify and flag missing, stale, or inconsistent data (e.g., maturity dates before origination dates, negative balances, duplicate loan IDs)
   - Reconcile the tape to any prior cut date if performing a delta analysis

2. **Stratify the pool across key dimensions**
   - For each asset class, stratify by the material risk drivers:
     - *Consumer ABS*: FICO band, original term, seasoning, geographic state, loan-to-value
     - *RMBS*: LTV, DTI, documentation type, occupancy status, property type, origination channel
     - *CMBS*: property type, DSCR bucket, LTV, geographic MSA, lease rollover year
     - *CLO*: Moody's/S&P industry code, rating bucket, spread, maturity, first-lien vs. second-lien
   - Present stratification tables showing count, aggregate balance, weighted-average coupon/spread, and percentage of pool for each bucket

3. **Assess concentration risk**
   - Calculate single-obligor, top-5, and top-10 obligor concentrations by outstanding balance
   - Evaluate geographic concentration (state, MSA, or country depending on asset class)
   - Check industry or property-type concentration against deal limits
   - Flag any breach or near-breach of indenture concentration limits [VERIFY against deal documents]

4. **Analyze credit quality distribution**
   - Map credit scores, internal ratings, or external ratings to a standardized scale
   - Compute weighted-average credit quality metrics (WA FICO, WA rating factor, WA DSCR)
   - Identify tail-risk exposures — bottom decile by credit quality — and quantify their share of the pool
   - Compare current distribution to the pool as of the closing date to detect migration

5. **Review historical performance benchmarks**
   - Overlay the pool's vintage against static pool loss curves from comparable originator cohorts
   - Analyze delinquency transition matrices (current → 30 → 60 → 90 → charge-off roll rates)
   - Calculate cumulative default rate, cumulative loss rate, and loss severity to date
   - Evaluate prepayment behavior (CPR, CDR, ABS) relative to pricing assumptions
   - Note any performance divergence from base-case or rating-agency stress scenarios

6. **Test eligibility and portfolio quality tests**
   - Re-run each eligibility criterion from the governing documents against every asset in the tape
   - Identify any ineligible assets and quantify their balance
   - Run portfolio-level quality tests (e.g., WA spread test, diversity score, WA recovery rate test for CLOs; WA LTV and WA DSCR for CMBS) [VERIFY specific tests per deal]
   - Document pass/fail status and available cushion for each test

7. **Synthesize findings into a pool quality opinion**
   - Summarize strengths (e.g., high WA FICO, geographic diversification, seasoned performance)
   - Highlight weaknesses and risk concentrations with quantified exposure
   - Compare the pool to prior deal vintages or market benchmarks
   - Recommend any remedial actions (asset substitution, concentration limit waiver requests, structural credit enhancement adjustments)

## Output

Produce a structured collateral pool analysis report containing:

- **Executive summary** — one-paragraph pool quality assessment with key metrics (pool balance, asset count, WA coupon, WA credit metric, WA remaining term, top concentration)
- **Stratification tables** — formatted tables for each key dimension with count, balance, WA stats, and pool share
- **Concentration analysis** — obligor, geographic, and sector/property-type heat maps or ranked tables with limit compliance status
- **Credit quality snapshot** — distribution chart or table with migration commentary
- **Performance benchmarking** — vintage curve comparisons and roll-rate summaries
- **Eligibility and portfolio test results** — pass/fail matrix with cushion amounts
- **Risk flags and recommendations** — itemized list of concerns ranked by materiality

## Quality Checks

- All balances in stratification tables sum to the total pool balance (zero reconciliation difference)
- Weighted-average calculations are balance-weighted, not simple averages
- Concentration percentages sum to 100% within each stratification dimension
- Every eligibility criterion from the deal documents is tested — none omitted [VERIFY completeness against indenture/PSA]
- Historical performance comparisons use matched seasoning periods (not mismatched time windows)
- Any data gaps or assumptions are explicitly noted with [VERIFY] markers
- Currency, day-count, and rate conventions are consistent across all calculations
- Output distinguishes between hard breaches (ineligibility) and soft breaches (portfolio test failures with cure periods)