Market Trends Reporter
Residual risk intelligence — fastest depreciating models, EV parity gaps, and regional collateral variance with advance rate implications
Purpose
Residual risk is the defining variable in auto lending profitability. A model that depreciates 20% faster than the book used at origination will generate deficiency losses, GAP claims, and portfolio write-downs that compound across hundreds of loans. Detecting that velocity shift at the portfolio level — before it shows up in charge-off rates — is the difference between proactive risk management and reactive loss recognition.
Market Trends Reporter for lenders runs the same depreciation comparison and market intelligence analysis as the appraiser version, but every output is translated into lending action: advance rate adjustments, residual forecast revisions, GAP coverage requirements, and origination policy signals. EV depreciation is framed as portfolio concentration risk. Regional variance is framed as geographic LTV exposure. MSRP discounting is framed as origination-price compression that erodes the residual floor.
How It Works
Execution flow. MCP tool calls are shown inline on each step.
get_sold_summaryCalls get_sold_summary with ranking_dimensions=make,model, inventory_type=Used for the most recent complete month. Extracts average_sale_price and sold_count per model — the baseline for residual risk ranking.
get_sold_summaryRepeat call for same month one year prior. Matching models between periods with minimum 100 sold units yields statistically reliable YoY depreciation rates — the primary residual risk signal.
Depreciation rate = (prior_price - current_price) / prior_price × 100. Top 15 fastest depreciators = HIGHEST RESIDUAL RISK. Bottom 15 = LOWEST RESIDUAL RISK. Each entry includes advance rate guidance: models depreciating >10% YoY trigger tighten-advance-rate recommendations.
↔ Parallel Execution
get_sold_summaryCalls get_sold_summary with fuel_type_category=EV for SUV, Sedan, Pickup body types for current and prior year periods. EV average sale price per segment.
get_sold_summaryParallel calls with fuel_type_category=ICE. EV-to-ICE gap = EV avg - ICE avg. Narrowing gap = rising EV origination volume ahead (lending opportunity). Widening gap in used = higher EV residual risk.
get_sold_summaryCalls get_sold_summary with summary_by=state for the subject make/model. Calculates state price index (state avg / national avg × 100). Flags discount markets (<95) where lenders using national averages are overstating collateral coverage.
get_sold_summaryCalls get_sold_summary with inventory_type=New, ranking_measure=price_over_msrp_percentage. Models transitioning from premium to discount territory signal that origination prices are compressing — reduces the residual floor on new originations, elevating residual risk for current-period loans.
MCP Tool Calls
| Tool | Calls | Purpose |
|---|---|---|
get_sold_summary | 8–14 | Current/prior depreciation ranking, EV vs ICE parity by segment (current + prior), regional state variance, MSRP positioning |
search_active_cars | 3 | Active listings for top 3 highest-risk depreciators |
Example Output
MARKET TRENDS REPORT — Lender Edition | February 2026 ════════════════════════════════════════════════════ HIGHEST RESIDUAL RISK MODELS (Tighten Advance Rates) Rank Make/Model Current Avg Prior Avg Drop $ Rate % Action ───── ────────────────────── ─────────── ────────── ────── ────── ──────────────────── 1 Nissan Leaf $18,200 $24,100 -$5,900 24.5% ⚠ Cap LTV at 85% 2 Chevrolet Bolt EV $19,800 $25,700 -$5,900 22.9% ⚠ Cap LTV at 85% 3 Ford Mustang Mach-E $31,400 $39,200 -$7,800 19.9% ⚠ Require GAP coverage LOWEST RESIDUAL RISK MODELS (Standard Advance Rates) Rank Make/Model Current Avg Prior Avg Drop $ Rate % Action ───── ────────────────────── ─────────── ────────── ────── ────── ──────────────────── 1 Toyota Tacoma TRD $42,100 $42,400 -$300 0.7% Standard rates OK 2 Honda Ridgeline $38,200 $38,600 -$400 1.0% Standard rates OK EV RESIDUAL RISK — SUV SEGMENT EV Avg Sale Price: $46,100 | ICE Avg: $37,200 | Gap: $8,900 (+23.9%) YoY Gap Change: -4.2 pts (EVs depreciating faster than ICE) Lending Signal: EV portfolio concentration ELEVATED — set EV residuals 8% below ICE equivalent MSRP DISCOUNT ALERT (New Vehicle Compression) Models newly below MSRP: Ford Explorer -2.8%, Nissan Pathfinder -3.1% Impact: Origination prices compressed → reduced residual floor → review existing portfolio exposure
Cost Estimate
20 risk reports/month ≈ $3–9
Limitations
- US-only — requires get_sold_summary which is US-only.
- YoY depreciation rates require minimum 100 sold units per model per period for statistical reliability.
- EV parity analysis requires sufficient EV volume per body type; EV pickup data may be thin in earlier periods.
- Regional collateral map is most reliable for mainstream models with 100+ state-level sold units; niche vehicles may show high variance.
More in the Lender Plugin
Single-model residual risk curves with LTV projection and advance rate guidance
View details →Monthly portfolio risk composite with brand, segment, and supply signals
View details →EV lending risk scorecard — adoption, depreciation ratio, and portfolio exposure
View details →Same Capability, Different Plugin
These skills share the same underlying methodology but are tuned for a different audience.
Appraisers use the same depreciation rankings to apply trend adjustments to individual valuations — where lenders see advance rate signals, appraisers see valuation correction factors.
View in Appraiser →Insurers use the same depreciation and replacement cost data for reserve adequacy and premium calibration — the data is identical but the business decision is claims reserves vs advance rates.
View in Insurer →