Electric Car vs Gas Car Price Comparison

	B	C	D	E	F	G	I	J
1	If you would like to use this sheet, simply copy/duplicate it and paste into a Google Sheet.
2
3	Model	Tesla Model 3 SR+	Toyota Camry SE				Sources
4	Purchase Price	$38,990	$29,111	$29,111	20000	*Variables You Can Change Have Grey Background	Avg miles/year	http://www.fhwa.dot.gov/ohim/onh00/bar8.htm
5	Sales tax	$2,729	$2,038	$2,038
6	Destination & doc fee	$1,200	$1,100	$1,100
7	5 Year Resale Value (via KBB)	$18,988	$10,538	$27,249
8	Incentives	-$1,875	$0		1.3		Avg price of gas	http://www.eia.gov/petroleum/gasdiesel/
9	Cash Cost after Incentives & Resale Deduction	$22,056	$21,711		0		1 gallon of gasoline = 33.7 kWh	http://www.fueleconomy.gov/feg/evsbs.shtml
10	Interest after 5 years (assuming $5000 down and 4.25% interest rate)	$4,238	$3,046
11	Price of Gas	—	$3.10				Avg ICEV maintenance costs	http://newsroom.aaa.com/2012/04/cost-of-owning-and-operating-vehicle-in-u-s-increased-1-9-percent-according-to-aaa%E2%80%99s-2012-%E2%80%98your-driving-costs%E2%80%99-study/
12	Average Price of Electricity for Car	$0.13	—
13	Average Miles Per Year	15,000	15,000
14	Maintenance Costs (5 Years)	$1,300	$3,286	https://www.edmunds.com/toyota/camry/2019/cost-to-own/#style=401771278
15	Miles/kWh or MPG	4	32	https://www.fueleconomy.gov/feg/PowerSearch.do?action=noform&path=1&year1=2019&year2=2019&make=Toyota&baseModel=Camry&srchtyp=ymm
16	Average Gallons of Gas Per Year (Miles/MPG)	—	468.75
17	Average kWh of Electricity Per Year for Car (Miles/4)	3,750	—
18	Average Cost of Fuel Per Year	$488	$1,453
19	5 Year Total Cost of Ownership	$30,032	$35,308
20
21
22
23	Total Cost Of Car After Year...	Tesla Model 3	Toyota Camry XLE V6	... Savings
24	1			$0
25	2			$0
26	3			$0
27	4			$0
28	5	$30,032	$35,308	$5,276
29	6			$0
30	7			$0
31	8			$0
32	9			$0
33	10			$0
34
35			0
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100