EV vs Gas Cost worksheet

1. Yearly savings with the electric car: $750.29

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{11,000}}{34}$$=323.53\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $323.5294\times \mathrm{\$3.60}$$=\mathrm{\$1,164.71}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{11,000}\times 23}{100}$$=\mathrm{2,530}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{93\%}\times \mathrm{\$0.14}+\mathrm{7\%}\times \mathrm{\$0.48}$$=0.1638$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{2,530}\times 0.1638$$=\mathrm{\$414.41}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,164.71}-\mathrm{\$414.41}$$=\mathrm{\$750.29}$

7. Multiply by the number of years to get the savings over 6 years

   $\mathrm{\$750.29}\times 6$$=\mathrm{\$4,501.75}$

2. Yearly savings with the electric car: $497.81

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{14,000}}{26}$$=538.46\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $538.4615\times \mathrm{\$2.40}$$=\mathrm{\$1,292.31}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{14,000}\times 25}{100}$$=\mathrm{3,500}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{90\%}\times \mathrm{\$0.18}+\mathrm{10\%}\times \mathrm{\$0.65}$$=0.227$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{3,500}\times 0.227$$=\mathrm{\$794.50}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,292.31}-\mathrm{\$794.50}$$=\mathrm{\$497.81}$

7. Multiply by the number of years to get the savings over 6 years

   $\mathrm{\$497.81}\times 6$$=\mathrm{\$2,986.85}$

3. Yearly savings with the electric car: $928.26

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{14,500}}{34}$$=426.47\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $426.4706\times \mathrm{\$3.90}$$=\mathrm{\$1,663.24}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{14,500}\times 24}{100}$$=\mathrm{3,480}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{88\%}\times \mathrm{\$0.18}+\mathrm{12\%}\times \mathrm{\$0.44}$$=0.2112$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{3,480}\times 0.2112$$=\mathrm{\$734.98}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,663.24}-\mathrm{\$734.98}$$=\mathrm{\$928.26}$

7. Multiply by the number of years to get the savings over 5 years

   $\mathrm{\$928.26}\times 5$$=\mathrm{\$4,641.30}$

4. Yearly savings with the electric car: $336.26

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{8,000}}{28}$$=285.71\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $285.7143\times \mathrm{\$3.00}$$=\mathrm{\$857.14}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{8,000}\times 34}{100}$$=\mathrm{2,720}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{91\%}\times \mathrm{\$0.16}+\mathrm{9\%}\times \mathrm{\$0.51}$$=0.1915$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{2,720}\times 0.1915$$=\mathrm{\$520.88}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$857.14}-\mathrm{\$520.88}$$=\mathrm{\$336.26}$

7. Multiply by the number of years to get the savings over 4 years

   $\mathrm{\$336.26}\times 4$$=\mathrm{\$1,345.05}$

5. Yearly savings with the electric car: $391.35

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{15,000}}{30}$$=500\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $500\times \mathrm{\$2.40}$$=\mathrm{\$1,200.00}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{15,000}\times 30}{100}$$=\mathrm{4,500}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{91\%}\times \mathrm{\$0.15}+\mathrm{9\%}\times \mathrm{\$0.48}$$=0.1797$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{4,500}\times 0.1797$$=\mathrm{\$808.65}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,200.00}-\mathrm{\$808.65}$$=\mathrm{\$391.35}$

7. Multiply by the number of years to get the savings over 5 years

   $\mathrm{\$391.35}\times 5$$=\mathrm{\$1,956.75}$

6. Yearly savings with the electric car: $873.74

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{10,000}}{22}$$=454.55\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $454.5455\times \mathrm{\$3.00}$$=\mathrm{\$1,363.64}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{10,000}\times 30}{100}$$=\mathrm{3,000}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{91\%}\times \mathrm{\$0.13}+\mathrm{9\%}\times \mathrm{\$0.50}$$=0.1633$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{3,000}\times 0.1633$$=\mathrm{\$489.90}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,363.64}-\mathrm{\$489.90}$$=\mathrm{\$873.74}$

7. Multiply by the number of years to get the savings over 4 years

   $\mathrm{\$873.74}\times 4$$=\mathrm{\$3,494.95}$

7. Yearly savings with the electric car: $170.68

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{13,000}}{37}$$=351.35\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $351.3514\times \mathrm{\$3.00}$$=\mathrm{\$1,054.05}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{13,000}\times 31}{100}$$=\mathrm{4,030}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{92\%}\times \mathrm{\$0.20}+\mathrm{8\%}\times \mathrm{\$0.44}$$=0.2192$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{4,030}\times 0.2192$$=\mathrm{\$883.38}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,054.05}-\mathrm{\$883.38}$$=\mathrm{\$170.68}$

7. Multiply by the number of years to get the savings over 3 years

   $\mathrm{\$170.68}\times 3$$=\mathrm{\$512.03}$

8. Yearly savings with the electric car: $809.93

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{15,000}}{34}$$=441.18\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $441.1765\times \mathrm{\$3.00}$$=\mathrm{\$1,323.53}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{15,000}\times 20}{100}$$=\mathrm{3,000}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{88\%}\times \mathrm{\$0.14}+\mathrm{12\%}\times \mathrm{\$0.40}$$=0.1712$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{3,000}\times 0.1712$$=\mathrm{\$513.60}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,323.53}-\mathrm{\$513.60}$$=\mathrm{\$809.93}$

7. Multiply by the number of years to get the savings over 6 years

   $\mathrm{\$809.93}\times 6$$=\mathrm{\$4,859.58}$

9. Yearly savings with the electric car: $237.93

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{12,000}}{38}$$=315.79\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $315.7895\times \mathrm{\$3.20}$$=\mathrm{\$1,010.53}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{12,000}\times 33}{100}$$=\mathrm{3,960}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{91\%}\times \mathrm{\$0.16}+\mathrm{9\%}\times \mathrm{\$0.55}$$=0.1951$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{3,960}\times 0.1951$$=\mathrm{\$772.60}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,010.53}-\mathrm{\$772.60}$$=\mathrm{\$237.93}$

7. Multiply by the number of years to get the savings over 4 years

   $\mathrm{\$237.93}\times 4$$=\mathrm{\$951.72}$

10. Yearly savings with the electric car: $787.40

1. Find the gallons of gas a year: divide your miles by the car's miles per gallon

   $\frac{\mathrm{13,000}}{30}$$=433.33\text{\hspace{0.17em}gal}$

2. Multiply those gallons by the price per gallon to get the yearly gas bill

   $433.3333\times \mathrm{\$4.20}$$=\mathrm{\$1,820.00}$

3. Find the electricity used a year: the rating is per 100 miles, so multiply your miles by it and divide by 100

   $\frac{\mathrm{13,000}\times 33}{100}$$=\mathrm{4,290}\text{\hspace{0.17em}kWh}$

4. Blend the home and public prices by how much charging happens at each, to get your average price per kWh

   $\mathrm{91\%}\times \mathrm{\$0.22}+\mathrm{9\%}\times \mathrm{\$0.45}$$=0.2407$

5. Multiply the kWh by that average price to get the yearly charging bill

   $\mathrm{4,290}\times 0.2407$$=\mathrm{\$1,032.60}$

6. Subtract the electric car's yearly cost from the gas car's to see what you save (negative means the gas car costs less)

   $\mathrm{\$1,820.00}-\mathrm{\$1,032.60}$$=\mathrm{\$787.40}$

7. Multiply by the number of years to get the savings over 6 years

   $\mathrm{\$787.40}\times 6$$=\mathrm{\$4,724.38}$