Depreciation Tracker
Value erosion intelligence for consignment timing — which vehicles need to be auctioned now vs which can wait
Purpose
Depreciation intelligence is the core of smart consignment timing. A consignment rep who knows that a 2021 Chevrolet Bolt is losing $800/month in wholesale value will call a dealer with three Bolts sitting at 75 days on lot differently than a rep with no data — 'every week you hold these is $200 more you'll lose at auction, and the market isn't getting better for them' is a closing statement, not a generic pitch.
Depreciation Tracker calculates make/model depreciation curves over 3-month and 6-month windows, ranks the fastest and slowest depreciators in the market, segments them by body type, and tiers brands by residual strength (Tier 1–4). Each analysis includes an explicit auction timing recommendation — FAST (consign immediately, lower reserves), MODERATE (standard 2-week pipeline), or SLOW (no urgency).
How It Works
Execution flow. MCP tool calls are shown inline on each step.
get_sold_summaryCalls get_sold_summary for the state with ranking by make,model and ranking_measure=average_sale_price for used vehicles, current month.
get_sold_summarySame call with dates shifted back 3 months. For specific make/model queries, also adds 6-month-ago call.
For each model with 50+ sold in both periods: monthly rate = (current - 3mo) / 3mo / 3 × 100. Classification: FAST (> 2%/mo), MODERATE (1–2%), SLOW (< 1%).
get_sold_summaryCalls get_sold_summary by body_type current and 3 months ago to calculate segment-level depreciation rates.
get_sold_summaryFor brand residual ranking queries: calls get_sold_summary by make current and 6 months ago. Calculates 6-month retention %. Tiers: Tier 1 (> 98%), Tier 2 (95–98%), Tier 3 (90–95%), Tier 4 (< 90%).
MCP Tool Calls
| Tool | Calls | Purpose |
|---|---|---|
get_sold_summary | 2–4 | Current and historical pricing by model, segment, or brand |
Example Output
DEPRECIATION TRACKER — Texas | February 2026 ════════════════════════════════════════════ FASTEST DEPRECIATING MODELS (Monthly Rate, 3-Month Window) Rank Make/Model Current Avg 3-Mo Avg Monthly Rate Classification ──── ───────────────────────── ─────────── ───────── ──────────── ────────────────────── 1 Chevrolet Bolt EUV $14,800 $20,100 -8.8%/mo FAST — consign NOW ⚡ 2 Nissan Leaf (2020+) $12,400 $16,700 -8.6%/mo FAST — consign NOW ⚡ 3 Hyundai Ioniq 5 $26,200 $33,400 -7.2%/mo FAST — consign NOW ⚡ 4 Ford Mustang Mach-E $28,900 $35,100 -5.9%/mo FAST — consign NOW ⚡ 5 Chrysler Pacifica $18,200 $20,100 -3.2%/mo FAST ⚡ 6 Jeep Compass $19,800 $21,400 -2.5%/mo FAST ⚡ SLOWEST DEPRECIATING (Strong Residuals) 1 Toyota Tacoma TRD Pro $41,300 $41,800 -0.4%/mo SLOW — can hold 2 Toyota 4Runner TRD $36,800 $37,200 -0.4%/mo SLOW — can hold 3 Ford F-150 Raptor $52,400 $53,000 -0.4%/mo SLOW — can hold 4 Honda CR-V Hybrid $28,100 $28,500 -0.5%/mo SLOW — can hold SEGMENT DEPRECIATION RATES EV: -5.1%/mo FAST — prioritize in consignment sourcing calls Minivan: -1.9%/mo MODERATE Sedan: -1.1%/mo MODERATE SUV: -0.7%/mo SLOW Pickup: -0.5%/mo SLOW BRAND RESIDUAL TIERS (6-Month Retention) Tier 1 (>98%): Toyota, Honda, Subaru Tier 2 (95–98%): BMW, Hyundai Tier 3 (90–95%): Ford, GM Tier 4 (<90%): Stellantis brands
Cost Estimate
30 analyses/month ≈ $0.90–$2.40
Limitations
- US only — no sold data available for UK market.
- Minimum 50 sold units per period required for statistical reliability — low-volume models are excluded.
- 3-month window may not capture sudden value shifts in volatile segments (e.g., EV market events).
- Depreciation classification is based on trailing data — forward-looking value projections are estimates, not guarantees.
More in the Auction House Plugin
Same Capability, Different Plugin
These skills share the same underlying methodology but are tuned for a different audience.