Dealer PluginMediumSkillv0.1.0

Depreciation Tracker

Value retention curves and depreciation rates by model, segment, and brand

depreciation ratevalue retentionresidual valuehow fast is it losing valuewhich cars hold valueEV depreciation
Medium
Complexity
6-8
API Calls
$0.006 – $0.030
MC API Cost
$0.03 – $0.10
Total Cost

Purpose

Depreciation Tracker pulls historical sold summary data across multiple time intervals — 60 days, 90 days, 6 months, and 1 year — to build a statistically-grounded depreciation curve. For each interval it calculates retention percentage, monthly depreciation rate, and annualized rate so you can see whether a model is depreciating linearly, accelerating, or stabilizing.

For dealers, this directly informs stocking strategy: models depreciating faster than the market average carry higher floor plan risk and should be avoided at auction or priced aggressively. The MSRP Parity Tracker reveals which new models are selling above or below sticker — a leading indicator of used vehicle depreciation for the same nameplate.

Audience:Used car managersDealer ownersInventory strategistsFinance managers

How It Works

Execution flow. MCP tool calls are shown inline on each step.

01
Current Period Sold Dataget_sold_summary

Get average sale price and sold count for the target make/model for the prior month.

02
Historical Intervalsget_sold_summary

Pull sold summary data at four lookback points: 60 days, 90 days, 6 months, and 1 year ago. Each call extracts average sale price and volume for that period.

03
Active Market Asking Pricesearch_active_cars

Pull current active listing statistics (mean, median, min, max) for the same model as the real-time retail anchor.

04
Depreciation Curve Calculation

Calculate retention %, monthly depreciation rate, and annualized rate at each interval. Describe the curve shape: linear, accelerating, or stabilizing.

MCP Tool Calls

ToolCallsPurpose
get_sold_summary5Average sale price at current period + 4 historical intervals (60d, 90d, 6mo, 1yr)
search_active_cars1Current active listing price statistics as real-time retail anchor

Example Output

DEPRECIATION CURVE — 2022 Toyota RAV4 XLE (Used)
State: Texas | Data: Feb 2025 → Feb 2026
══════════════════════════════════════════════

DEPRECIATION TIMELINE
Period          Avg Sale Price  vs MSRP  Retention  Monthly Rate
Feb 2026 (now)  $29,850         63.2%    —          —
90 days ago     $31,200         66.1%    —          -1.44%/mo
6 months ago    $32,800         69.5%    —          -1.26%/mo
1 year ago      $34,500         73.1%    —          —
Original MSRP   $47,225         100%     —          —

CURVE SHAPE: Moderately accelerating
  Monthly rate has increased from 1.26% to 1.44% — depreciation
  is speeding up as the model ages past the 4-year mark.

ANNUALIZED RATE: 17.3%

ACTIVE MARKET (current asking prices)
  Median: $30,900 | Mean: $31,240 | Range: $26,500$36,800
  Active supply: 142 units statewide

SEGMENT CONTEXT
  SUV segment avg monthly depreciation: 1.18%
  RAV4 is depreciating 22% faster than segment average.

STOCKING IMPLICATION: Price RAV4 acquisitions 3-4% below
  market median to protect against accelerating depreciation.
  Target max hold: 35 days.

Cost Estimate

TierMedium
API Calls6-8
MC API — best$0.006
MC API — worst$0.030
Claude — best$0.02
Claude — worst$0.07
Total range$0.03$0.10

20 model analyses/month ≈ $0.60 – $2/month

Limitations

  • US market only — get_sold_summary is US-only. UK dealers are not supported.
  • Depreciation curve accuracy depends on sold volume at each interval. Low-volume or niche models may have sparse data at older intervals.
  • MSRP baseline may be estimated from the highest recent sold price if direct MSRP data is unavailable for the specific year/trim.
  • Geographic depreciation variance is state-level — city or metro-level depreciation differences are not available.
  • EV depreciation comparison requires separate calls for EV and ICE fuel types, which doubles call count for that workflow.
Dealer Plugin
View all skills & commands