I was reminded of this spreadsheet I made a while back for my own purposes to compare the costs of different ICE lease deals a few years back, and then a few months back I used it to compare the estimated costs of potential used car purchases, and then more recently to compare the costs of the i3 I've now got..!

Anyway, I thought I'd post it here as it could possibly be useful for others.

All you should need to do is fill in the relevant sections and it should automatically calculate the "amortised" monthly, and the overall monthly cost, and the average cost per mile taking into consideration all factors.

https://docs.google.com/spreadsheets/d/1ARUrS7YaFM...

It was created with ICE cars in mind, so it needs some work to properly adapt it for EVs, but it can be made to work.

For my i3 - which I've added at the bottom - I've manipulated the 'MPG' to reflect the actual average electricity cost of 2.5p per mile that I've experienced to date.

As far as I understand Google Sheets, you need to download a copy of the spreadsheet via the link so that you can then use it as you wish in your Sheets account, Excel or Apple Numbers (If anyone knows of a better solution to share it please let me know).

Also, let me know if there are any suggestions to improve it.

Cheers!