Petrol V's Electric Vehicle Cost Comparison Spreadsheet

pegaxs on 28/09/2019 - 16:35
Last edited 28/09/2019 - 22:19

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)

Automotive Fuel

Comments

  • idonotknowwhy on 01/10/2019 - 10:52

    So current EV's will never ROI.

    • pegaxs on 01/10/2019 - 19:07
      +1

      basically, no. Unless there is a significant price drop or big government incentives to buy an EV, if you buy one now, it will most likely take a longer time to get to that break even point than what most people own a car for. (and it also depends on what you shop it against. The Kona to a Kona electric, probably never. BMW 2 Series to a Tesla Model X, perhaps.)

      • idonotknowwhy on 02/10/2019 - 10:43

        Yeah, your Kona vs Kona Electric example looks like a good comparison, since they're equivalent.

        Thanks for the spreadsheet, saves me some time for when my old bomb dies and I look to replace it.

  • [Deactivated] on 09/11/2019 - 08:04

    The cost comparison against used is much more cost effective. Factor in offpeak tariffs and other incentives and it makes a lot more sense than petrol, even after replacing the battery.

    Finding one that is available is a nightmare though. Hopefully over time the second hand market will grow.

Login or Join to leave a comment
Login Join