Sedan Depreciation Estimate

SELECT mk.id as makeId, mk.name as makeName, m.id as modelId, m.name as modelName ,md.* FROM vehicleCategoryMapping vcm, makes mk, models m LEFT JOIN modelDepreciation md ON m.id=md.id WHERE vcm.modelId=m.id AND m.makeId=mk.id AND vcm.categoryId=1 AND m.active=1 ORDER BY makeName, modelName

Chevrolet Cruze (no data)
Chevrolet Impala (no data)
Chevrolet Malibu (no data)
Chrysler 200 (no data)
Chrysler 300 (no data)
Dodge Charger (no data)
Dodge Dart (no data)
Ford Focus (no data)
Ford Fusion [remove ]
Honda Accord [remove ]
Hyundai Elantra (no data)
Hyundai Genesis (no data)
Hyundai Sonata (no data)
Mazda Mazda3 (no data)
Mazda Mazda6 (no data)
Mitsubishi Lancer (no data)
Nissan Altima (no data)
Nissan Maxima (no data)
Nissan Sentra (no data)
Subaru Impreza (no data)
Subaru Legacy (no data)
Toyota Avalon (no data)
Toyota Camry [remove ]
Toyota Corolla (no data)

Note: These depreciation rates are third-party estimates calculated by analyzing the used car market in the United States. We offer no guarantee that your vehicle will depreciate at the rate we have estimated. Sale prices and depreciation rates can vary significantly between trim lines, seller location, and time of year. For our figures, we calculate an "average selling price" for each model/year combination. This value is compared to used car listing prices to estimate the depreciation rate for a model. This methodology slightly underestimates depreciation by assuming the asking price for used car listings reflects the amount of money a person selling a used car can expect.