Been working on updating my ICE vs EV cost spreadsheet that I used a while ago. It was super messy and kinda broken but worked for what I wanted it to do for me at the time.
With another thread on here that was asking and contemplating spending 3x their budget on an EV version of what they were after, it got me to working on cleaning up my spreadsheet. It is by no means accurate, as it does not allow for a lot of variables, but it should give a rough estimate on how long it would take for the EV to at least break even in terms of more expensive purchase price vs cheaper running costs.
Here is an example of the Hyundai Kona Elite v's Kona Elite Electric
Spreadsheet is on Dropbox if you wanted to enter your own vehicle details yourself. Petrol Vs Electric Cost Comparison.xlsx
EDIT: (28/9 @ 22:20) Have played with the sheet and added depreciation into the mix. Links have been revised above.
This sheet will still work, even if you want to do a comparison between two EV's or two ICE vehicles.
I am by no means an expert Excel spreadsheet master, so any comments or suggestions (that are constructive) or features anyone would like to see added, let me know. (Or if anyone knows how I could turn it into a web page and host it somewhere, that would be super cool!) And yes, I know, it's probably full of spelling errors…
Fields that can be edited:
Make
Model
Price
Consumption (l/100 and/or kWh/100)
Average yearly km
Average fuel price (petrol/diesel/electricity)
Servicing costs (Yes, EV's still need servicing)
Very nice effort, BUT (and this is a very big BUT - think J Lo or similar) you haven't included depreciation (as you say) but this is the single biggest cost of ownership of a car.
9.5/10 for effort.
0.5/10 for actual usability.