[schema type=”product” name=”17C FORMULA” description=”diminished value formula 17c” ]

DV-17C-FORMULA-CALCULATOR-EXCEL

17C

Diminished Value Worksheet        Claim Number   Claim Rep / Date   Vehicle Owner   Year/Make/Model   Mileage   NADA Value                   Step 1. Base Loss of Value (10% of NADA value above) $0.00         Step 2. Damage Severity Modifier 0.00  Modifier Extent of Damage     1.00 Severe damage to the structure of the vehicle   0.75 Major damage to the structure and panels   0.50 Moderate damage to the structure and panels   0.25 Minor damage to the structure and panels   0.00 No structure damage   0.00 Previously structurally damage vehicle   0.00 Previous total loss history   (Note: These are guideline ranges and any number from 0 to 1.0 can be used)           Step 3. Mileage Modifier 0.00  Modifier Mileage     1.0 – 0.91 0 – 9,999    0.9 – 0.81 10,000 – 19,999    0.8 – 0.71 20,000 – 29,999    0.7 – 0.61 30,000 – 39,999    0.6 – 0.51 40,000 – 49,999    0.5 – 0.41 50,000 – 59,999    0.4 – 0.31 60,000 – 69,999    0.3 – 0.21 70,000 – 79,999    0.2 – 0.11 80,000 – 89,999    0.1 – 0.01 90,000 – 99,999    0.00 100,000 plus    (Note: This is based on a 100,000 miles but this should be modified for vehicles with a longer expected lifespan.)           Step 4. Calculations      Base Loss Value  $0.00    Damage Modifier (X) 0.00$0.00    Mileage Modifier (X) 0.00$0.00    Diminished Value  $0.00