ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
If you would like to use this sheet, simply copy/duplicate it and paste into a Google Sheet.
2
3
ModelTesla Model Y PerformanceLexus RXSources
4
Purchase Price$59,990$44,150$64,18920000*Variables You Can Change Have Grey BackgroundAvg miles/year
http://www.fhwa.dot.gov/ohim/onh00/bar8.htm
5
Sales tax (7%)$4,199$3,091
6
5 Year Resale Value$29,215$18,543$59,189
7
Cash Cost after Expected Resale Deduction$34,974$28,6981.3Avg price of gas
http://www.eia.gov/petroleum/gasdiesel/
8
Interest after 5 years (assuming $5000 down, 4.25% interest rate)$6,616$4,721
https://investinganswers.com/calculators/loan/loan-interest-calculator-how-much-interest-will-i-pay-my-lender
01 gallon of gasoline = 33.7 kWh
http://www.fueleconomy.gov/feg/evsbs.shtml
9
Price of Gas$3.15
10
Average Price of Electricity for Car$0.09Avg 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/
11
Average Miles Per Year13,00013,000
12
Maintenance Costs (5 Years)$2,500$6,900
https://www.edmunds.com/honda/accord/2019/cost-to-own/#style=401779176
13
Miles/kWh or MPG3.5722
https://www.fueleconomy.gov/feg/PowerSearch.do?action=noform&path=1&year1=2019&year2=2019&make=Toyota&baseModel=Camry&srchtyp=ymm
14
Average Gallons of Gas Per Year (Miles/MPG)590.91
15
Average kWh of Electricity Per Year for Car (Miles/4)3,641
16
Average Cost of Fuel Per Year$326.64$1,861.95
17
5 Year Total Cost of Ownership$45,723$49,629
18
19
20
21
22
Total Cost Of Car After Year...Tesla Model 3Toyota Camry XLE V6... Savings
23
1$0
24
2$0
25
3$0
26
4$0
27
5$45,723$49,629$3,906
28
6$0
29
7$0
30
8$0
31
9$0
32
10$0
33
34
0
35
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