Is my math correct?

I created a spreadsheet about a year ago to calculate savings were I to purchase an EV.

It compares my current paid for gas vehicle to various EV models. The second tab compares it over various gas prices. Some EVs will pay for themselves at certain gas prices, even accounting for the fact my vehicle is paid for. This depends a lot on gas prices, fuel economy, miles driven/week, and electricity costs.

It assumes charging at home at my electricity prices, but you can put any cost for electricity relevant to you.

Anything in blue text can be changed without affecting other calculations.

If anyone wants to copy it, feel free. If you find I've screwed up something, or have any improvements, please let me know. Keep in mind I made it almost a year ago, so prices and tax credits have probably changed since then. I don't remember when I last updated it.

https://docs.google.com/spreadsheets/d/1oEJYjxqqtcX2Wiclvn6wDj4rE-c9ym8QzYPaL_edVkg/edit?usp=sharing

Your mileage may vary. Pun intended, you're welcome.

/r/electricvehicles Thread