| A | B | C | D | |
|---|---|---|---|---|
1 | Created by John DiFini | |||
2 | ||||
3 | ||||
4 | ||||
5 | Description: | This sheet shows an example of how quickly a car can depreciate. | ||
6 | Car: | 2005 Nissan Xterra | Linear Depreciation: | Approximately $1,000 per 10,000 miles or $1,600 per year |
7 | ||||
8 | Date | Miles | Resale Value | Notes |
9 | 1-Apr-2006 | 11,111 | $22,000 | Purchase price of used 2005 model |
10 | 2-Apr-2006 | 11,111 | $19,839 | drive-off-the-lot value |
11 | 1-Aug-2006 | $18,873 | ||
12 | 1-Dec-2006 | $17,694 | ||
13 | 9-Apr-2007 | $15,698 | ||
14 | 1-Aug-2007 | $17,521 | ||
15 | 11-Dec-2007 | 51,200 | $16,293 | |
16 | 6-Apr-2008 | 57,669 | $15,514 | |
17 | 3-Aug-2008 | 64,929 | $13,243 | |
18 | 21-Dec-2008 | 74,263 | $10,482 | |
19 | 12-Apr-2009 | 80,608 | $11,793 | |
20 | 29-Dec-2009 | 97,171 | $10,931 | |
21 | 30-Dec-2011 | $7,636 | ||
22 | 6-May-2012 | 133,305 | $6,419 | |
23 | 15-Sep-2012 | 138,005 | $7,133 | |
24 | 20-Jan-2013 | 140,980 | $6,344 | |
25 | 5-May-2013 | 143,784 | $7,287 | |
26 | 25-Sep-2013 | 147,500 | $6,716 | |
27 | 19-Jun-2016 | 167,662 | $3,833 |