ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
If you would like to use this sheet, simply copy/duplicate it and paste into a Google Sheet.
2
3
ModelTesla Model 3 SR+Toyota Camry SESources
4
Purchase Price$38,990$29,111$29,11120000*Variables You Can Change Have Grey BackgroundAvg 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$01.3Avg price of gas
http://www.eia.gov/petroleum/gasdiesel/
9
Cash Cost after Incentives & Resale Deduction$22,056$21,71101 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—$2.50Avg ICEV maintenance costshttp://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 Year15,00015,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 MPG432
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,172
19
5 Year Total Cost of Ownership$30,032$33,902
20
$0.40$0.45
21
22
23
Total Cost Of Car After Year...Tesla Model 3Toyota Camry XLE V6... Savings
24
1$0
25
2$0
26
3$0
27
4$0
28
5$30,032$33,902$3,870
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