lev-os 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
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
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
- For each asset class, stratify by the material risk drivers:
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]
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
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
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
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)