Diminished value worksheet: 17c formula or straight percentage

• 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

• Independent appraisers preparing a diminished value claim after a repair.
• Public adjusters and attorneys who need the pre-loss value built from comparables the carrier cannot wave away.
• Appraisers who consider 17c an undervaluation and would rather argue the loss from the market.

What is a diminished value claim?

A diminished value claim asks for the resale value a vehicle loses because it now has an accident history, a loss that remains after a proper repair and comes on top of the repair bill. Claims usually go to the at-fault driver's insurer, and the rules vary by state. The worksheet measures the loss against a pre-loss value built from comparable vehicles for sale.

How do I file a diminished value claim?

Finish the repair and keep the invoice. Get a written valuation of the pre-loss value and the loss in value, then send it to the at-fault driver's insurer with the repair records and photos and ask for payment under your claim number. Deadlines and rules differ by state, so check yours, and expect a counteroffer. The worksheet supplies the valuation and a branded Excel; enter the appraiser fields when you run it and it carries your certification too.

What is the 17c formula and why do appraisers dispute it?

17c is a diminished value formula many carriers use. It caps the loss at 10% of the pre-loss value and scales that cap by damage and mileage multipliers, so a car past 100,000 miles gets zero. It is simple to apply; appraisers dispute it because its cap and multipliers are fixed in advance, while buyers' discount for an accident history varies by vehicle and market. The worksheet builds pre-loss value from market comparables and offers 17c or a percentage.

Is there a diminished value calculator?

Yes. This worksheet takes a VIN, odometer, ZIP and damage severity, builds the pre-loss value from about three like-for-like comparables verified on the dealer page, and computes the loss with the 17c formula or a percentage. On the page you can re-pick comparables and change the method, cap, damage severity, multipliers and percentage. Changing the VIN, odometer, ZIP or radius is a re-run: on a prepaid account, $0.99 within 30 days of a full-price run, up to 3 times.

How does the 17c formula work here?

A 10% cap on the pre-loss value is scaled by a damage multiplier (none 0, minor 0.25, moderate 0.50, major 0.75, severe 1.00) and a mileage multiplier. All three are editable on the page. Note that 17c yields zero above 100,000 miles by construction; the worksheet says so plainly and lets you override the multiplier or switch methods.

What is the percent method?

A straight percentage of the comparable-derived pre-loss value, 12% by default and editable. Use it when you can support the loss from the market rather than from a carrier formula. You can switch between the two methods on the hosted page after the run.

Where does the pre-loss value come from?

From about three like-for-like active comparables matched through the VIN pattern and banded to the subject odometer, each verified on the dealer page with a timestamped snapshot and mileage-adjusted to the subject. You pick the comparables; the loss is taken off that figure.

How is this different from the Diminished Value Report?

The report anchors pre-loss value on a model prediction you cannot move and returns a comparable-based figure quickly. The worksheet derives pre-loss value from comparables you select and gives you the certification block, the branded Excel and the read-only copy for the file.

What does it cost?

$5.99 per worksheet, with $0.99 re-runs of the same VIN within 30 days, up to three times. Connect the MarketCheck AI Desk to Claude or ChatGPT once and ask in plain English, or run it from this website. You pay per report from a credit balance, with no subscription.

Technical reference (inputs, outputs, the MCP tool name): Diminished Value Worksheet documentation.