Diminished Value Worksheet

Post-repair loss in value, argued from comparables the appraiser picks, by 17c or by percentage.

This is the technical reference. For the price, a rendered sample and answers to common questions, see the Diminished Value Worksheet product page.

Post-repair loss in value, argued from comparables the appraiser picks, by 17c or by percentage.

At a glance

What it does

The appraiser's diminished value worksheet. Pre-loss value is built from ~3 like-for-like ACTIVE comparables (configuration-matched via the VIN pattern, mileage-banded to the subject odometer, each with a match % and an installed-options similarity %, every price read off the dealer's own page with a timestamped evidence snapshot), mileage-adjusted to the subject. The loss in value is then taken off that comp-derived figure. Ships a branded, shareable Excel and a hosted page the preparer drives. TWO METHODS, switchable on the page: "17c" applies the formula carriers and several state courts expect (a 10% cap on pre-loss value, scaled by a damage multiplier and a mileage multiplier, all three editable). "percent" takes a straight percentage of the comp-derived pre-loss value, for appraisers who consider 17c an undervaluation and would rather argue the loss from the comparables. Note that 17c yields ZERO above 100,000 miles by construction; the worksheet says so plainly and the preparer can override the multiplier or switch methods. Use when a repaired vehicle has lost resale value and the preparer is building the file. This supersedes the Diminished Value Report for appraisers: the report anchors pre-loss value on a model prediction the preparer cannot move, whereas this worksheet derives it from comparables they select.

Arguments

What comes back

• Nearest matching comps with match %, options similarity %, and distance per comp
• Every comp price verified on the dealer page (doc and dealer fees excluded), with a full-page evidence snapshot
• Interactive selection plus an excluded-comps tab: the worksheet recalculates live and your changes save
• Pre-loss value built from the comps you selected, mileage-adjusted at an editable per-mile rate
• Two methods you toggle between: the 17c formula (cap, damage multiplier and mileage multiplier, all editable) or a straight percentage of pre-loss value
• Post-repair value and the loss stated as a percentage of pre-loss
• Branded Excel export and a locked read-only copy to hand the consumer

Asking for it in a chat client

Build a diminished value worksheet for VIN 4T3R6RFV7MU015349, 42,800 miles, ZIP 60601, moderate damage, repairs were $6,400.

My car was repaired after a structural hit and is worth less now. VIN 3GNAXUEG2RS216393, 41,058 miles, ZIP 48120. Use a straight 15% rather than 17c.

Running it from a backend

Grant an agent the reports:diminished-value-worksheet scope, then call the tool over MCP:

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "generate_diminished_value_worksheet",
    "arguments": {
      "vin": "3GNAXUEG2RS216393",
      "comp_count": "3"
    }
  }
}

See Server-side access for the token exchange and how to read the response.