Car cost NPV comps v1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKL
1
2014 04 14: Updated w/ correction to Ody formulas, results.
2
3
Assumptions
4
Discount rate5%
5
Sales tax rate8.75%
6
Miles/yr15,000
7
Miles/kWh3.00
8
9
Model8y NPVSafetyPAXLengthWidthHOVFunCargoAWD equivCarbonImage
10
RAV4 EV '14$22,3244518072YesMed36?UnknownHi
11
Subaru Outback '14$32,1904518972NoLo32Yes5.61Hi
12
Subaru Forester '14$32,5365518171NoLo32Yes4.84Hi
13
Ody Touring Elite '14$37,2354720379NoLo38No5.34Hi
14
BMW 328d '14$39,6034517972NoHi18Yes?Lo
15
Tesla Model S85 '14$42,0835719677YesHi32YesUnknownLo
16
Volvo V60 '14$43,7445518373NoHi16Yes?Hi
17
BMW X3 '13 used$43,9574518374NoHi28Yes4.22Lo
18
MB E350 '11 CPO$50,4265719373NoLo29Yes5.21Lo
19
MB E350 '14$58,2855719373NoLo29Yes5.21Lo
20
21
22
Year
23
Assumed energy prices012345678
24
Elec $/kWh$0.12$0.12$0.13$0.13$0.14$0.14$0.15$0.15
25
Gas $/gallon - Regular$4.00$4.10$4.20$4.30$4.40$4.50$4.60$4.70
26
Gas $/gallon - Premium$4.25$4.35$4.45$4.55$4.65$4.75$4.85$4.95
27
28
Year
29
Tesla Model S85 '14012345678
30
Purchase
31
Purchase price$92,800<--S85
32
Destination, doc, reg$1,170
33
Transport fee$0
34
Subtotal$93,970
35
Taxes$8,222
36
Tax credit-$10,000
37
Ongoing costs
38
Maintenance$1,900$0$1,200$0$600$1,800$600$600
39
Fuel cost$600$600$650$650$700$700$750$750
40
Depreciation
41
Depreciation factor20%28%35%43%50%58%63%68%
42
Depreciation$18,560$25,520$32,480$39,440$46,400$53,360$58,000$62,640
43
Incremental depr$18,560$6,960$6,960$6,960$6,960$6,960$4,640$4,640
44
Resale value$74,240$67,280$60,320$53,360$46,400$39,440$34,800$30,160<--residual
45
Totals
46
Net$9,392$11,060$7,560$8,810$7,610$8,260$9,460$5,990-$24,170
47
PV$9,392$10,533$6,857$7,610$6,261$6,472$7,059$4,257-$16,359
48
NPV$42,083
49
50
Year
51
BMW 328d '14012345678
52
Purchase
53
Purchase price$50,000
54
Destination, doc, reg$1,200
55
Transport fee$0
56
Subtotal$51,200
57
Taxes$4,480
58
Tax credit$0
59
Ongoing costs
60
Maintenance$0$0$0$0$500$2,500$500$500
61
Miles/gallon4040404039393939
62
Fuel cost$1,594$1,631$1,669$1,706$1,788$1,827$1,865$1,904
63
Depreciation
64
Depreciation factor25%33%40%48%55%60%65%70%
65
Depreciation$12,500$16,250$20,000$23,750$27,500$30,000$32,500$35,000
66
Incremental depr$12,500$3,750$3,750$3,750$3,750$2,500$2,500$2,500
67
Resale value$37,500$33,750$30,000$26,250$22,500$20,000$17,500$15,000<--residual
68
Totals
69
Net$5,680$14,094$5,381$5,419$5,456$6,038$6,827$4,865-$10,096
70
PV$5,680$13,423$4,881$4,681$4,489$4,731$5,094$3,458-$6,833
71
NPV$39,603
72
73
Year
74
BMW X3 '13 used012345678
75
Purchase
76
Purchase price$41,000
77
Destination, doc, reg$0
78
Transport fee$0
79
Subtotal$41,000
80
Taxes$3,588
81
Tax credit$0
82
Ongoing costs
83
Maintenanceext warr -->$3,000$0$0$0$500$3,000$500$500
84
Miles/gallon2424242423232323
85
Fuel cost$2,656$2,719$2,781$2,844$3,033$3,098$3,163$3,228
86
Depreciation
87
Depreciation factor10%20%30%40%50%60%65%70%
88
Depreciation$4,100$8,200$12,300$16,400$20,500$24,600$26,650$28,700
89
Incremental depr$4,100$4,100$4,100$4,100$4,100$4,100$2,050$2,050
90
Resale value$36,900$32,800$28,700$24,600$20,500$16,400$14,350$12,300<--residual
91
Totals
92
Net$3,588$9,756$6,819$6,881$6,944$7,633$10,198$5,713-$6,522
93
PV$3,588$9,292$6,185$5,944$5,713$5,980$7,610$4,060-$4,414
94
NPV$43,957
95
96
Year
97
MB E350 '11 CPO012345678
98
Purchase
99
Purchase price$45,000
100
Destination, doc, reg$1,200
Loading...
Main menu