[Bill N]

Hi all,

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!

 

[Bill N]

I've updated this now so you should hopefully be able to use it online without needing to download it.

"IF YOU SEE SOMEONE ELSE IS USING THE SHEET, WAIT UNTIL THEY APPEAR TO HAVE FINISHED BEFORE CHANGING THE ANNUAL MILEAGE / FUEL PRICES OR CREATE A DUPLICATE SHEET BY CLICKING ON THE 'Sheet1' TAB AT THE BOTTOM."

 

[Bill N]

Open to suggestions about what to include to make this more relevant to EVs as well..

 

[X4dow]

Open to suggestions about what to include to make this more relevant to EVs as well..

Sale value after x years.
If we look at the used market, a ev holds much more value % from new than ices. It can make the difference between buying one or the other

 

[Bill N]

Sale value after x years.
If we look at the used market, a ev holds much more value % from new than ices. It can make the difference between buying one or the other

Yes, I need to adapt the spreadsheet a bit so it can also be used for car purchases - it’s mainly for contract hire lease deals or subscriptions like Evezy as it is.

 

[X4dow]

Yes, I need to adapt the spreadsheet a bit so it can also be used for car purchases - it’s mainly for contract hire lease deals or subscriptions like Evezy as it is.

Problem is that people will see :
Buying car and owning it for 5 years= 23000
Evezy for 5 years = 20000

And completely forget that the bought one would bring 10000 back reducing the "cost" to 13000.

Some people can't see past the "how much per month" cost

 

[Bill N]

I've updated this now so it can be used to calculate and compare the total cost of running purchased cars, as well leased cars.

For a purchased car, only columns with blue header text are relevant.

Man maths the other way

 

[Bill N]

Just bumping this again as its been a while and it may be useful with some good leasing offers knocking about recently and hopefully more to come!