Actual cash value worksheet built from verified comparables

• 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
• ACV math: average of selected asks, mileage adjustment with a market-implied rate suggestion, ACV, additions/deductions, TOTAL ACV pre-tax
• Market value difference from the insurance carrier offer
• Branded Excel export and a locked read-only copy to hand the consumer

• Independent auto appraisers preparing an actual cash value file for a client.
• Public adjusters and attorneys arguing a carrier offer up with evidence the other side can check.
• Anyone who needs to certify a value from hand-picked comparables rather than a black-box number.

How are the comparables chosen?

The worksheet pulls like-for-like active listings matched on configuration through the VIN pattern and banded to the subject odometer, each with a match percentage and an installed-options similarity percentage. It selects about three by default; you can tick, untick, hide, sort and re-pick any of them on the page and the math follows. Comparables under a 70% match are never picked automatically.

Are the comparable prices verified?

Yes. Every comparable price is read off the selling dealer’s own page with documentation and dealer fees stripped out, and a full-page snapshot of the listing is saved with the worksheet. When the carrier says the comparable is gone, it is still in your file. A comparable also needs at least four real photos to qualify.

Can I control the search radius?

Yes. Set the radius on the run form, from 25 to 500 miles, and the worksheet stays inside it and says so on the page. Leave it blank and it starts at 25 miles and widens only while the pool is thin.

Can I change the worksheet after the run without paying again?

Comparable picks, the per-mile rate, additions and deductions, price corrections and the carrier offer are free edits on the hosted page, and the Excel and PDF follow. Changing the VIN, odometer, ZIP or radius is a re-run: within 30 days of a full-price run the same worksheet costs $0.99, up to three times.

What do I hand the client or the carrier?

A branded Excel workbook with your name, licence and file number, a PDF of the page, and a locked read-only copy that shows only the comparables you kept. Prices are listed prices throughout; the worksheet says so.

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