How closely retail references match sale outcomes, and where estimated margins need attention.
Comparison by segmentLoading eligible appraisal-to-sale comparisons…
Estimated economics. The manager’s appraisal is the cost the car is booked at in the DMS. Recon costs are estimates, and estimated spread leaves out the pack. Front gross from the DMS shows realized profit.
Used sales linked to an appraisal, by sale month, with the reason each other sale is unlinked
The retail reference compared with the eventual transaction price
Estimated spread as a share of each vehicle’s sale price
DMS front gross on every used sale in this selection, against the profit target
Find differences by make, model, model year, and mileage at appraisal.
Select a make and model, or choose “Compare model years” in the table.
Median estimated dollars remaining, by appraisal-to-sale interval
These groups show an association, not the effect of holding a car longer. Vehicle mix and other factors can differ.
An adjustable scenario for estimated contribution
A consistent set of vehicles with recon estimates
Lowest estimated spreads and largest retail-reference gaps in the selected cohort.
Ranking the models and model-year ranges that make the target…
Ranked by the same score, up to 10 per section
Set the store’s pack and profit target once, then check a car before making an offer.
Loading saved assumptions…
Compared with what similar used cars actually sold for here
Used sales by segment, with the highest buy price that still meets the target
Listings from Facebook Marketplace, CarGurus, AutoTrader or elsewhere, imported from a CSV file and ranked by room under the maximum buy price
Explore the dealership’s transactions, trace valuations, and compare them with sale outcomes.
Monthly records within your selection
Follow the vehicle from appraisal to sale.
Use the matched comparison to explore the difference between rBook retail values and actual sale prices.
Charting sales…
Try a shorter search, a different date range, or fewer filters.
Used sales link to the latest eligible earlier appraisal for the same VIN, after any previous sale of that VIN. Exact stock numbers take priority; a blank appraisal stock number can be used when an exact match is unavailable. Conflicting stock numbers are excluded.
The benchmark requires exact VIN and stock, a sale within 180 days, manager assessment and rBook values above $1, nondecreasing mileage, and an appraisal last modified no later than the sale’s calendar date. Same-day ordering cannot be established from these exports.
“Appraisal” is the manager’s assessed value at trade-in or buy, and the cost the DMS books the car at. Recon costs are estimates. Estimated spread = sale price − manager assessment − estimated recon. It is not realized profit: it leaves out the pack, and actual recon can differ. Front gross from the DMS is realized front profit.
rBook gap = rBook − sale price. A positive gap means rBook was above the eventual sale. MAE is the mean absolute gap. rBook is a retail market reference, not an agreed future sale price.
Coverage limits. Results describe vehicles that sold and could be linked. Appraisal records are mutable exports, and later updates can affect historical comparisons. “Purchase?” blank does not mean “No.” Age is a source field provisionally interpreted as inventory days.