[schema type=”product” name=”17C FORMULA” description=”diminished value formula 17c” ]
DV-17C-FORMULA-CALCULATOR-EXCEL
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
