Car cost NPV comps v1


1	2014 04 14: Updated w/ correction to Ody formulas, results.
2
3	Assumptions
4	Discount rate	5%
5	Sales tax rate	8.75%
6	Miles/yr	15,000
7	Miles/kWh	3.00
8
9	Model	8y NPV	Safety	PAX	Length	Width	HOV	Fun	Cargo	AWD equiv	Carbon	Image
10	RAV4 EV '14	$22,324	4	5	180	72	Yes	Med	36	?	Unknown	Hi
11	Subaru Outback '14	$32,190	4	5	189	72	No	Lo	32	Yes	5.61	Hi
12	Subaru Forester '14	$32,536	5	5	181	71	No	Lo	32	Yes	4.84	Hi
13	Ody Touring Elite '14	$37,235	4	7	203	79	No	Lo	38	No	5.34	Hi
14	BMW 328d '14	$39,603	4	5	179	72	No	Hi	18	Yes	?	Lo
15	Tesla Model S85 '14	$42,083	5	7	196	77	Yes	Hi	32	Yes	Unknown	Lo
16	Volvo V60 '14	$43,744	5	5	183	73	No	Hi	16	Yes	?	Hi
17	BMW X3 '13 used	$43,957	4	5	183	74	No	Hi	28	Yes	4.22	Lo
18	MB E350 '11 CPO	$50,426	5	7	193	73	No	Lo	29	Yes	5.21	Lo
19	MB E350 '14	$58,285	5	7	193	73	No	Lo	29	Yes	5.21	Lo
20
21
22		Year
23	Assumed energy prices	0	1	2	3	4	5	6	7	8
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 '14	0	1	2	3	4	5	6	7	8
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 factor		20%	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 '14	0	1	2	3	4	5	6	7	8
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/gallon		40	40	40	40	39	39	39	39
62	Fuel cost		$1,594	$1,631	$1,669	$1,706	$1,788	$1,827	$1,865	$1,904
63	Depreciation
64	Depreciation factor		25%	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 used	0	1	2	3	4	5	6	7	8
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	Maintenance	ext warr -->	$3,000	$0	$0	$0	$500	$3,000	$500	$500
84	Miles/gallon		24	24	24	24	23	23	23	23
85	Fuel cost		$2,656	$2,719	$2,781	$2,844	$3,033	$3,098	$3,163	$3,228
86	Depreciation
87	Depreciation factor		10%	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 CPO	0	1	2	3	4	5	6	7	8
98	Purchase
99	Purchase price	$45,000
100	Destination, doc, reg	$1,200
101	Transport fee	$0
102	Subtotal	$46,200
103	Taxes	$4,043
104	Tax credit		$0
105	Ongoing costs
106	Maintenance		$500	$500	$3,000	$500	$500	$3,000	$500	$500
107	Miles/gallon		22	22	21	21	21	21	20	20
108	Fuel cost		$2,898	$2,966	$3,179	$3,250	$3,321	$3,393	$3,638	$3,713
109	Depreciation
110	Depreciation factor		10%	20%	30%	40%	50%	60%	65%	70%
111	Depreciation		$4,500	$9,000	$13,500	$18,000	$22,500	$27,000	$29,250	$31,500
112	Incremental depr		$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$2,250	$2,250
113	Resale value		$40,500	$36,000	$31,500	$27,000	$22,500	$18,000	$15,750	$13,500	<--residual
114	Totals
115	Net	$5,243	$7,898	$7,966	$10,679	$8,250	$8,321	$10,893	$6,388	-$7,038
116	PV	$5,243	$7,522	$7,225	$9,225	$6,787	$6,520	$8,128	$4,539	-$4,763
117	NPV	$50,426
118
119		Year
120	MB E350 '14	0	1	2	3	4	5	6	7	8
121	Purchase
122	Purchase price	$62,000
123	Destination, doc, reg	$1,200
124	Transport fee	$0
125	Subtotal	$63,200
126	Taxes	$5,530
127	Tax credit		$0
128	Ongoing costs
129	Maintenance		$500	$500	$2,500	$500	$500	$2,500	$500	$500
130	Miles/gallon		22	22	22	22	21	21	21	21
131	Fuel cost		$2,898	$2,966	$3,034	$3,102	$3,321	$3,393	$3,464	$3,536
132	Depreciation
133	Depreciation factor		25%	33%	40%	48%	55%	60%	65%	70%
134	Depreciation		$15,500	$20,150	$24,800	$29,450	$34,100	$37,200	$40,300	$43,400
135	Incremental depr		$15,500	$4,650	$4,650	$4,650	$4,650	$3,100	$3,100	$3,100
136	Resale value		$46,500	$41,850	$37,200	$32,550	$27,900	$24,800	$21,700	$18,600	<--residual
137	Totals
138	Net	$6,730	$18,898	$8,116	$10,184	$8,252	$8,471	$8,993	$7,064	-$11,464
139	PV	$6,730	$17,998	$7,361	$8,797	$6,789	$6,638	$6,711	$5,020	-$7,759
140	NPV	$58,285
141
142		Year
143	Ody Touring Elite '14	0	1	2	3	4	5	6	7	8
144	Purchase
145	Purchase price	$42,000
146	Destination, doc, reg	$0
147	Transport fee	$0
148	Subtotal	$42,000
149	Taxes	$3,675
150	Tax credit		$0
151	Ongoing costs
152	Maintenance		$300	$300	$1,500	$300	$300	$1,500	$300	$300
153	Miles/gallon		22	22	22	22	21	21	21	21
154	Fuel cost		$2,727	$2,795	$2,864	$2,932	$3,143	$3,214	$3,286	$3,357
155	Depreciation
156	Depreciation factor		25%	30%	35%	40%	45%	50%	55%	60%
157	Depreciation		$10,500	$12,600	$14,700	$16,800	$18,900	$21,000	$23,100	$25,200
158	Incremental depr		$10,500	$2,100	$2,100	$2,100	$2,100	$2,100	$2,100	$2,100
159	Resale value		$31,500	$29,400	$27,300	$25,200	$23,100	$21,000	$18,900	$16,800	<--residual
160	Totals
161	Net	$3,675	$13,527	$5,195	$6,464	$5,332	$5,543	$6,814	$5,686	-$11,043
162	PV	$3,675	$12,883	$4,712	$5,584	$4,387	$4,343	$5,085	$4,041	-$7,474
163	NPV	$37,235
164
165		Year
166	RAV4 EV '14	0	1	2	3	4	5	6	7	8
167	Purchase
168	Purchase price	$31,500
169	Destination, doc, reg	$1,200
170	Transport fee	$0
171	Subtotal	$32,700
172	Taxes	$2,861
173	Tax credit		-$2,500
174	Ongoing costs
175	Maintenance		$600	$600	$600	$600	$600	$600	$600	$600
176	Fuel cost		$600	$600	$650	$650	$700	$700	$750	$750
177	Depreciation
178	Depreciation factor		25%	33%	40%	48%	55%	60%	65%	70%
179	Depreciation		$7,875	$10,238	$12,600	$14,963	$17,325	$18,900	$20,475	$22,050
180	Incremental depr		$7,875	$2,363	$2,363	$2,363	$2,363	$1,575	$1,575	$1,575
181	Resale value		$23,625	$21,263	$18,900	$16,538	$14,175	$12,600	$11,025	$9,450	<--residual
182	Totals
183	Net	$4,061	$6,575	$3,563	$3,613	$3,613	$3,663	$2,875	$2,925	-$6,525
184	PV	$4,061	$6,262	$3,231	$3,121	$2,972	$2,870	$2,145	$2,079	-$4,416
185	NPV	$22,324
186
187		Year
188	Subaru Forester '14	0	1	2	3	4	5	6	7	8
189	Purchase
190	Purchase price	$35,000
191	Destination, doc, reg	$0
192	Transport fee	$0
193	Subtotal	$35,000
194	Taxes	$3,063
195	Tax credit		$0
196	Ongoing costs
197	Maintenance		$300	$300	$1,500	$300	$300	$1,500	$300	$300
198	Miles/gallon		25	25	25	25	24	24	24	24
199	Fuel cost		$2,400	$2,460	$2,520	$2,580	$2,750	$2,813	$2,875	$2,938
200	Depreciation
201	Depreciation factor		25%	30%	35%	40%	45%	50%	55%	60%
202	Depreciation		$8,750	$10,500	$12,250	$14,000	$15,750	$17,500	$19,250	$21,000
203	Incremental depr		$8,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750
204	Resale value		$26,250	$24,500	$22,750	$21,000	$19,250	$17,500	$15,750	$14,000	<--residual
205	Totals
206	Net	$3,063	$11,450	$4,510	$5,770	$4,630	$4,800	$6,063	$4,925	-$9,013
207	PV	$3,063	$10,905	$4,091	$4,984	$3,809	$3,761	$4,524	$3,500	-$6,100
208	NPV	$32,536
209
210		Year
211	Subaru Outback '14	0	1	2	3	4	5	6	7	8
212	Purchase
213	Purchase price	$33,951
214	Destination, doc, reg	$0
215	Transport fee	$0
216	Subtotal	$33,951
217	Taxes	$2,971
218	Tax credit		$0
219	Ongoing costs
220	Maintenance		$300	$300	$1,500	$300	$300	$1,500	$300	$300
221	Miles/gallon		25	25	25	25	24	24	24	24
222	Fuel cost		$2,400	$2,460	$2,520	$2,580	$2,750	$2,813	$2,875	$2,938
223	Depreciation
224	Depreciation factor		25%	30%	35%	40%	45%	50%	55%	60%
225	Depreciation		$8,488	$10,185	$11,883	$13,580	$15,278	$16,976	$18,673	$20,371
226	Incremental depr		$8,488	$1,698	$1,698	$1,698	$1,698	$1,698	$1,698	$1,698
227	Resale value		$25,463	$23,766	$22,068	$20,371	$18,673	$16,976	$15,278	$13,580	<--residual
228	Totals
229	Net	$2,971	$11,188	$4,458	$5,718	$4,578	$4,748	$6,010	$4,873	-$8,645
230	PV	$2,971	$10,655	$4,043	$4,939	$3,766	$3,720	$4,485	$3,463	-$5,852
231	NPV	$32,190
232
233		Year
234	Volvo V60 '14	0	1	2	3	4	5	6	7	8
235	Purchase
236	Purchase price	$50,000
237	Destination, doc, reg	$0
238	Transport fee	$0
239	Subtotal	$50,000
240	Taxes	$4,375
241	Tax credit		$0
242	Ongoing costs
243	Maintenance		$0	$0	$0	$0	$300	$2,500	$300	$300
244	Miles/gallon		25	25	25	25	24	24	24	24
245	Fuel cost		$2,400	$2,460	$2,520	$2,580	$2,750	$2,813	$2,875	$2,938
246	Depreciation
247	Depreciation factor		25%	33%	40%	48%	55%	60%	65%	70%
248	Depreciation		$12,500	$16,250	$20,000	$23,750	$27,500	$30,000	$32,500	$35,000
249	Incremental depr		$12,500	$3,750	$3,750	$3,750	$3,750	$2,500	$2,500	$2,500
250	Resale value		$37,500	$33,750	$30,000	$26,250	$22,500	$20,000	$17,500	$15,000	<--residual
251	Totals
252	Net	$4,375	$14,900	$6,210	$6,270	$6,330	$6,800	$7,813	$5,675	-$9,262
253	PV	$4,375	$14,190	$5,633	$5,416	$5,208	$5,328	$5,830	$4,033	-$6,269
254	NPV	$43,744


1	Assumptions
2	Downpayment	$13,774
3	Discount rate	5%
4	Sales tax rate	8.75%
5	Miles/yr	15,000
6	Miles/kWh	3
7	Financing rate	1.74%
8
9	Model	8y NPV
10	Tesla Model S85 '14	$62,874
11	Ody Touring Elite '14	$58,323
12
13
14		Year
15	Assumed energy prices	0	1	2	3	4	5	6	7	8
16	Elec $/kWh		$0.11	$0.11	$0.12	$0.12	$0.13	$0.13	$0.14	$0.14
17	Gas $/gallon - Regular		$4.25	$4.35	$4.45	$4.55	$4.65	$4.75	$4.85	$4.95
18	Gas $/gallon - Premium		$4.50	$4.60	$4.70	$4.80	$4.90	$5.00	$5.10	$5.20
19
20		Year
21	Tesla Model S85 '14	0	1	2	3	4	5	6	7	8
22	Purchase
23	Purchase price	$92,800	<--S85 inv
24	Destination, doc, reg	$1,170
25	Transport fee	$0
26	Subtotal	$93,970
27	Taxes	$8,222
28	Tax credit		-$10,000
29	Downpayment	$13,774
30	Loan payment		$15,530	$15,530	$15,530	$15,530	$15,530	$15,530
31	Ongoing costs
32	Maintenance		$500	$500	$500	$500	$500	$500	$500	$500
33	Fuel cost		$550	$550	$600	$600	$650	$650	$700	$700
34	Safety vs 4-star		-$600	-$600	-$600	-$600	-$600	-$600	-$600	-$600
35	Depreciation
36	Depreciation factor		15%	22.5%	30%	37.5%	45%	52.5%	57.5%	62.5%
37	Depreciation		$13,920	$20,880	$27,840	$34,800	$41,760	$48,720	$53,360	$58,000
38	Incremental depr		$13,920	$6,960	$6,960	$6,960	$6,960	$6,960	$4,640	$4,640
39	Resale value		$78,880	$71,920	$64,960	$58,000	$51,040	$44,080	$39,440	$34,800	<--residual
40	Totals									-$34,800
41	Net	$13,774	$5,980	$15,980	$16,030	$16,030	$16,080	$16,080	$600	-$34,200
42	PV	$13,774	$5,695	$14,494	$13,847	$13,188	$12,599	$11,999	$426	-$23,148
43	NPV	$62,874
44
45		Year
46	Ody Touring Elite '14	0	1	2	3	4	5	6	7	8
47	Purchase
48	Purchase price	$45,000		Touring (non-elite) is $42710	Sienna Limited Premium is $46490 (FWD), $47960 (AWD)
49	Destination, doc, reg	$0
50	Transport fee	$0
51	Subtotal	$45,000
52	Taxes	$3,938
53	Tax credit		$0
54	Downpayment	$13,774
55	Loan payment		$6,176	$6,176	$6,176	$6,176	$6,176	$6,176
56	Ongoing costs
57	Maintenance		$300	$300	$1,500	$300	$300	$1,500	$300	$300
58	Miles/gallon		$22	$22	$22	$22	$21	$21	$21	$21
59	Fuel cost		$2,898	$2,966	$3,034	$3,102	$3,321	$3,393	$3,464	$3,536
60	Depreciation
61	Depreciation factor		$0	$0	$0	$0	$0	$1	$1	$1
62	Depreciation		$6,750	$10,125	$13,500	$16,875	$20,250	$23,625	$25,875	$28,125
63	Incremental depr		$6,750	$3,375	$3,375	$3,375	$3,375	$3,375	$2,250	$2,250
64	Resale value		$38,250	$34,875	$31,500	$28,125	$24,750	$21,375	$19,125	$16,875	<--residual
65	Totals									-$16,875
66	Net	$13,774	$9,396	$9,464	$10,732	$9,600	$9,819	$11,090	$3,785	-$13,018
67	PV	$13,774	$8,948	$8,584	$9,271	$7,898	$7,693	$8,276	$2,690	-$8,811
68	NPV	$58,323


1
2		P85+ SB		P85 Inventory	S85 new		S85 used
3
4	Current price	$120,000	$112,000	$126,092	$96,870	$96,870	$97,000	$97,000
5	Sale price	$86,500	$86,500	$108,092	$96,870	$70,000	$82,000	$70,000
6	Discount	$33,500	$25,500	$18,000	$0	$26,870	$15,000	$27,000
7	% discount	28%	23%	14%	0%	28%	15%	28%
8	Discount after tax credit	$23,500		$28,000	$10,000
9	% discount	20%		22%	10%
10	Final price	$86,500	$86,500	$98,092	$86,870	$70,000	$82,000	$70,000
11
12
13
14
15
16		0	1	2	3	4	5	6	7	8
17	13%	$107,000	$93,090	$80,988	$70,460	$61,300	$53,331	$46,398	$40,366	$35,119
18	11.5%	$107,000	$94,695	$83,805	$74,167	$65,638	$58,090	$51,410	$45,497	$40,265
19
20	13%	$117,000	$101,790	$88,557	$77,045	$67,029	$58,315	$50,734	$44,139	$38,401
21	11.5%	$117,000	$103,545	$91,637	$81,099	$71,773	$63,519	$56,214	$49,750	$44,028
22
23	13%	$95,270	$82,885	$72,110	$62,736	$54,580	$47,485	$41,312	$35,941	$31,269
24	11.5%	$95,270	$84,314	$74,618	$66,037	$58,443	$51,722	$45,774	$40,510	$35,851