Total Loss Valuation Worksheet

2019 Chevrolet Equinox Premier ยท TOTAL ACV $22,479 (4 comps)

ACV below the carrier offer
TOTAL ACV pre-tax$22,479
ACV (advertised-price basis)$22,479
Carrier offer$25,000
ACV minus offer-$2,521
Comparables selected4 selected by the preparer
01ACV Appraisal Worksheet

Read-only copy. The comparables, prices, and adjustments below are locked to the preparer's certified selections.

Carrier offer $25,000VIN 3GNAXYEX1KS56296525,000 miZIP 90044Mileage rate $0.06/mi
Subject vehicle specs: 2019 Chevrolet Equinox Premier (tap to confirm)
VIN3GNAXYEX1KS562965
Vehicle2019 Chevrolet Equinox Premier
VariantAWD Premier 2.0T
Body typeSUV
Drivetrain4WD
Engine2.0L I4
TransmissionAutomatic
FuelPremium Unleaded
Doors5
Odometer25,000 miles
Original MSRP$35,700
VIN patternAXYEX

4 comparables selected by the preparer from an eligible pool of 25 active listings. Sourced from active listings nationwide (this configuration is scarce; the search widened past 1,000 miles), ranked by match, options match, and mileage proximity.

PhotoVehicleVIN patternMatchOptions matchMilesvs subjectAdvertisedDealer
292019 Chevrolet Equinox PremierAXYEX70%
+
VIN pattern (chars 4-8): 40/40AXYEX matches the subject
Mileage proximity: 0/3042,186 miles more than the subject (169% off)
Drivetrain: 15/154WD matches
Engine: 15/152L matches subject 2L
100%
+
Shared equipment150 items in common
67,186+42,186$19,999Young Chrysler Dodge Jeep Ram FIAT of Burley, Burley, ID
642 mi from subject
View evidence ยท new tab (2026-09-17)
252019 Chevrolet Equinox PremierAXYEX70%
+
VIN pattern (chars 4-8): 40/40AXYEX matches the subject
Mileage proximity: 0/3015,804 miles more than the subject (63% off)
Drivetrain: 15/154WD matches
Engine: 15/152L matches subject 2L
97%
+
Shared equipment150 items in common
Comp has, subject lacksadditional equipment, headlight control, anti collision system, lane departure warning, 360 view camera
40,804+15,804$21,778John Elway Chevrolet, Englewood, CO
833 mi from subject
View evidence ยท new tab (2026-09-17)
322019 Chevrolet Equinox PremierAXYEX70%
+
VIN pattern (chars 4-8): 40/40AXYEX matches the subject
Mileage proximity: 0/3023,061 miles more than the subject (92% off)
Drivetrain: 15/154WD matches
Engine: 15/152L matches subject 2L
97%
+
Shared equipment150 items in common
Comp has, subject lackssunroof, glass roof, upholstery color, additional equipment
48,061+23,061$21,085Scott Volvo Cars Allentown, Allentown, PA
View evidence ยท new tab (2026-09-17)
362019 Chevrolet Equinox PremierAXYEX70%
+
VIN pattern (chars 4-8): 40/40AXYEX matches the subject
Mileage proximity: 0/3024,976 miles more than the subject (100% off)
Drivetrain: 15/154WD matches
Engine: 15/152L matches subject 2L
96%
+
Shared equipment150 items in common
Comp has, subject lackssunroof, glass roof, external color, license plate bracket, upholstery color
49,976+24,976$20,695Camp Chevrolet, Spokane, WA
950 mi from subject
View evidence ยท new tab (2026-09-17)
Average of 4 selected comparables (advertised)$20,889
Mileage adjustment ($0.06/mile x 26,507 average miles vs subject)$1,590
ACV (advertised-price basis)$22,479
TOTAL ACV pre-tax$22,479
Insurance carrier offer$25,000
Market value difference from insurance offer-$2,521
Download Excel worksheet

The carrier's offer is $2,521 above the comp-backed ACV; the market data does not support arguing this offer up.

Active advertised (asking) prices only, per appraiser practice; recently off-market units are excluded from this worksheet. Dealer advertised prices generally exclude add-on and documentation fees, so the comp-derived figure is an ACV-basis value.

ACV: actual cash value on the advertised-price basis (dealer prices generally exclude add-on and documentation fees). TOTAL ACV: the ACV plus the preparer's itemized additions and deductions. Every figure is a listed (asking) price; negotiated transaction prices are not observable. Comparable prices marked verified were read from the dealer's own page by an AI model, and any condition notes were produced the same way: AI output is not always accurate, so the source page and photo are shown beside each one to be checked.

02Recommended ActionsMemo
  1. The carrier's offer is at or above the comp-backed ACV; the market data does not support arguing it up.
  2. To certify a different comparable set, re-run with Select comps (pin VINs) or Exclude vins (reject); on the hosted page, tick comparables to preview the recalculated worksheet and download the matching branded Excel.
Data Downloads (CSV)
ACV Appraisal Worksheet (Excel) ยท 4 rows

The appraisal workbook exactly as prepared, with the selected comparables and evidence links.

Methodology
  1. Decoded the VIN to lock configuration (trim, drivetrain, engine, fuel) and the VIN pattern (chars 4-8).
  2. Comp sourcing, nearest first: searched active same-trim listings within 25 miles of the subject's ZIP, widening stepwise (50 / 100 / 250 / 500 / 1,000 miles, then nationwide) only while fewer than 6 mileage-matched candidates existed. Candidates of a different drivetrain, powertrain, or engine displacement were dropped as non-comparable.
  3. Comp eligibility: excluded listings with fewer than 4 photos, odometer artifacts (near-zero miles on an aged car), and IQR advertised-price outliers. Every exclusion is disclosed with its reason on the Excluded tab, where the preparer can force any back into the pool.
  4. Comp ranking: preferred comparables unrestricted (mileage-matched pool too thin) (5% band first, widened as needed); scored each candidate on Match % (VIN pattern 40 pts, mileage proximity 30, drivetrain 15, engine 15, stale asks penalized) plus installed-options similarity from full decodes (weight 0.6) minus a distance penalty (about 1 point per 15 miles, capped at 15). The best 10 form the pool; the top 4 (the worksheet size chosen on the run form) are selected by default and the preparer's selection governs the worksheet. Comparables below the 70% match threshold stay in the pool but are never selected automatically.
  5. Price verification: read every pool comparable's price on the dealer's own page, semantically resolving the pricing container to the sale price EXCLUSIVE of documentation and dealer fees (checked against the page's own arithmetic); cached a full-page snapshot of each dealer page as timestamped evidence.
  6. Averaged the 4 selected asks, applied the mileage adjustment at $0.06/mile = ACV (advertised-price basis), then the preparer's additions/deductions = TOTAL ACV pre-tax.
  7. Compared the settlement total against the insurance carrier offer.
Inputs Used
Provided
VIN3GNAXYEX1KS562965
Miles25,000
ZIP90044
Insurer offer$25,000
Defaulted
Mileage cost per mile$0.06/mile (common appraisal-template rate)
Radius miles25 miles, widening automatically (50 / 100 / 250 / 500 / 1,000, then nationwide) while the pool is thin; set Radius miles to fix it