Car Depreciation Project
By: Collin King and Abhishek Mohan - 7th Period
Muscle Cars
Audi S5
- Audi S5
2014- $47,998; 10,727 miles
2013- $41,995; 29,857 miles
2012- $35,998; 35,513 miles
2011- $33,987; 48,914 miles
2010- $30,499; 59,254 miles
Regression Equation: y = 52,600.21 x 0.89^x
Rate of Depreciation: 11%
2015 Model Prediction- $59,101
Actual 2015 Model Cost- $54,500
.
X-Axis: Number of Years Used For
Y-Axis: Cost of Car
Mustang V6
- Mustang V6
2014- $18,981; 10,740 miles
2013- $16,424; 22,104 miles
2012- $15,898; 34,689 miles
2011- $14,543; 49,432 miles
2010- $13,671; 62,450 miles
Regression Equation: y = 19,956.19 x 0.93^x
Rate of Depreciation: 7%
2015 Model Prediction- $21,458
Actual 2015 Model Cost- $25,119
.
X-Axis: Number of Years Used For
Y-Axis: Cost of Car
Chevrolet Corvette Coupe
- Chevrolet Corvette Coupe
2014- $52,979; 10,831 miles
2013- $47,996; 22,786 miles
2012- $42,990; 36,893 miles
2011- $40,800; 45,760 miles
2010- $39,650; 59,567 miles
Regression Equation: y = 55,743.69 x 0.93^x
Rate of Depreciation: 7%
2015 Model Prediction- $59,939
Actual 2015 Model Cost- $55,000
.
X-Axis: Number of Years Used For
Y-Axis: Cost of Car
Dodge Challenger SXT
- Dodge Challenger SXT
2014- $21,995; 14,355 miles
2013- $20,398; 22,968 miles
2012- $17,799; 36,057 miles
2011- $16,462; 47,306 miles
2010- $15,478; 61,848 miles
Regression Equation: y = 24,054.59 x 0.91^x
Rate of Depreciation: 9%
2015 Model Prediction- $26,434
Actual 2015 Model Cost- $26,995
.
X-Axis: Number of Years Used For
Y-Axis: Cost of Car
Comparison of all Cars
- Audi S5 - Blue - 11% depreciation
- Mustang V6 - Purple - 7% depreciation
- Chevrolet Corvette Coupe - Green - 7% depreciation
- Dodge Challenger SXT - Orange - 9% depreciation
WHICH IS THE BEST PURCHASE???
Chevrolet Corvette Coupe
2015 Predicted Cost- $59,939 Actual Cost- $55,000 Act cost is 8.2% lower than predicted
2014 Predicted Cost- $55,744 Actual Cost- $52,979 Act cost is 5.0% lower than predicted
2013 Predicted Cost- $51,842 Actual Cost- $47,996 Act cost is 7.4% lower than predicted
2012 Predicted Cost- $48,213 Actual Cost- $42,990 Act cost is 10.8% lower than predicted
2011 Predicted Cost- $44,838 Actual Cost- $40,800 Act cost is 9.0% lower than predicted
2010 Predicted Cost- $41,699 Actual Cost- $39,650 Act cost is 4.9% lower than predicted