Gas vs Electric Vehicle Cost and Savings Calculator v1.0 2022.03.11

	A	B	C	D	E	F	G	H	I	K	L
1		GLOBAL VARIABLES			ELECTRIC COMPANY OPTIONS				LEGEND	AUTHOR
2		Miles driven per year	8000		$ / kWh	$0.24	1		Global Variable	Questions:	@ALBsharah
3		Price / gallon of gas	$6.00		Flat fee /mo	$0.00	1		Calculation	Original Post:	https://al.bsharah.com/gas-vs-electric-vehicle-cost-and-savings-calculator/
4		Years Total	5		$ / kWh	$0.10	2		Input	How-to Video:	https://al.bsharah.com/gas-vs-electric-vehicle-cost-and-savings-calculator/
5		Charging Efficiency	85%		Flat fee /mo	$16.00	2
6
7	VEHICLES		GAS ONLY	ELECTRIC 1	ELECTRIC 2	ELECTRIC 3	ELECTRIC 4	ELECTRIC 5	ELECTRIC 6
8		Vehicle	Grand Cherokee Limited	Tesla Model 3 Long Range	Tesla Model 3 Long Range	Tesla Model 3 Standard	Tesla Model 3 Standard	Jeep 4xe	Jeep 4xe
9		Electric Company Option #	1	1	2	1	2	1	2
10	GAS DATA
11		Miles driven per year	8000	8000	8000	8000	8000	8000	8000
12		Price / gallon of gas	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00
13		Vehicle MPG (gas only)	20					20	20
14		Years Total	5	5	5	5	5	5	5
15		Gallons required	400					400	400
16		Cost /yr	$2,400	$0	$0	$0	$0	$2,400	$2,400
17		Cost (5 years)	$12,000	$0	$0	$0	$0	$12,000	$12,000
18	ELECTRIC DATA
19		Battery size (kWh)		82	82	50	50	17.3	17.3
20		Range		353	353	263	263	22	22
21		$ / kWh	$0.24	$0.24	$0.10	$0.24	$0.10	$0.24	$0.10
22		Flat fee /mo	$0	$0	$16	$0	$16	$0	$16
23		Charging Efficiency	85%	85%	85%	85%	85%	85%	85%
24		Cost to fully charge	$0.00	$16.73	$6.97	$10.20	$4.25	$3.53	$1.47
25		Flat fee /yr	$0	$0	$192	$0	$192	$0	$192
26		Flat fee (5 years)	$0	$0	$960	$0	$960	$0	$960
27	COST
28		Cost per Mile (gas)	$0.3000					$0.3000	$0.3000
29		Cost per Mile (elec)		$0.0474	$0.0197	$0.0388	$0.0162	$0.1604	$0.0668
30	USAGE
31		Percent Gas Usage	100%	0%	0%	0%	0%	15%	15%
32		Percent Elect Usage	0%	100%	100%	100%	100%	85%	85%
33	COST AVERAGED
34		Cost per Mile	$0.3000	$0.0474	$0.0197	$0.0388	$0.0162	$0.1814	$0.1018
35	SAVINGS
36		$ Saved vs Gas Only /yr	$0	$2,021	$2,050	$2,090	$2,079	$949	$1,393
37		$ Saved vs Gas Only (5 years)	$0	$10,104	$10,250	$10,449	$10,394	$4,746	$6,967
38	VEHICLE COST OVER TIME
39		Cost of Vehicle	$49,235	$65,490	$65,490	$58,490	$58,490	$57,120	$57,120
40		Cost minus savings (5 years)	$49,235	$55,386	$55,240	$48,041	$48,096	$52,374	$50,153
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