Public Group Scorecard
Quintile scorecard for publicly traded dealer groups — rank every group from Q1 (best) to Q5 (worst) across all operational dimensions — NEW v0.12.3
Purpose
Quintile scoring normalizes cross-group comparison by converting raw metrics into relative position rankings. Instead of asking 'is 28 days DOM good or bad?', the scorecard answers 'that DOM puts this group in Q1 for DOM efficiency vs all public peers' — immediately actionable for relative value positioning.
Public Group Scorecard runs a full multi-dimensional analysis across all 8 publicly traded dealer groups and assigns Q1–Q5 quintile rankings for Volume, ASP, DOM, Efficiency Score, and Days Supply. Delivers a composite quintile score and an investment heat map.
How It Works
Execution flow. MCP tool calls are shown inline on each step.
get_sold_summaryRuns get_sold_summary for all dealer groups (current + prior month) to gather all 8 public groups' volume, ASP, and DOM. Parallel with search_active_cars for days supply.
For each metric (Volume, ASP, DOM, Efficiency, Days Supply), ranks all 8 groups and assigns Q1 (top 20%=best 1–2) through Q5 (bottom 20%=worst 7–8).
Averages quintile ranks across all dimensions (with DOM and Efficiency weighted 1.5x for investment relevance). Derives composite Q1–Q5 composite score.
Produces a visual scorecard matrix with quintile heat map, composite ranking, MoM quintile changes (improving/declining), and top/bottom investment picks.
MCP Tool Calls
| Tool | Calls | Purpose |
|---|---|---|
get_sold_summary | 2 | All 8 groups current and prior month full metrics |
search_active_cars | 8–16 | Inventory days supply per group (new + used) |
Example Output
PUBLIC GROUP SCORECARD — Q1 2026 | February 2026 ═════════════════════════════════════════════════ QUINTILE SCORECARD (Q1=Best, Q5=Worst) Group Ticker Volume ASP DOM Efficiency DaysSupply Composite MoM ────────── ────── ────── ─── ─── ────────── ────────── ───────── ──── Lithia LAD Q1 Q3 Q2 Q1 Q2 Q1 ↑+1 Group 1 GPI Q2 Q2 Q1 Q2 Q1 Q1 → Penske PAG Q2 Q1 Q2 Q2 Q2 Q2 → Asbury ABG Q3 Q2 Q3 Q3 Q3 Q3 ↓-1 AutoNation AN Q3 Q3 Q4 Q4 Q3 Q3 ↓-2 Sonic SAH Q4 Q4 Q3 Q3 Q4 Q4 → CarMax KMX Q4 Q4 Q4 Q4 Q4 Q4 → Carvana CVNA Q5 Q5 Q5 Q5 Q5 Q5 → TOP PICKS: LAD (Q1 composite, improving), GPI (Q1 composite, stable) AVOID: CVNA (Q5 composite), AN (declining rapidly, -2 quintiles MoM)
Cost Estimate
8 scorecards/month ≈ $1–3
Limitations
- US market only.
- With only 8 publicly traded groups, quintile buckets are narrow — Q1 covers ranks 1–2, Q5 covers ranks 7–8.
- KMX and CVNA's used-only model makes direct quintile comparison on ASP/segment metrics less valid.
- Quintile scores are relative — a group can be Q1 in a weak peer cohort; always contextualize with absolute metrics.