Go Back   EcoModder Forum > EcoModding > General Efficiency Discussion
Register Now
 Register Now
 

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 01-24-2018, 04:20 AM   #1 (permalink)
EcoModding Newb
 
redpoint5's Avatar
 
Join Date: Aug 2010
Location: Oregon
Posts: 3,287

Acura TSX - '06 Acura TSX
90 day: 31.25 mpg (US)

Lafawnda - '01 Honda CBR600 F4i
90 day: 47.32 mpg (US)

Big Yeller - '98 Dodge Ram 2500 base
90 day: 21.82 mpg (US)

Prius Plug-in - '12 Toyota Prius Plug-in
90 day: 79.06 mpg (US)

Mazda CX-5 - '17 Mazda CX-5 Touring
90 day: 28.43 mpg (US)
Thanks: 1,251
Thanked 997 Times in 675 Posts
Vehicle Total Cost of Ownership Calculator

A few years ago I searched for a website that would allow me to compare total cost of ownership of any two vehicles given my estimated costs. Not finding anything, I put together a spreadsheet and shared it on Google Drive.

I've now updated it to allow plug-in hybrids, and fixed other minor issues. It's now capable of comparing any two vehicles that use petrol, electricity, or a combination of both. It also provides lots of other data such as fuel or electricity cost per mile.

Make sure you enter values in each cell even if the number is 0, or you don't know what to put. You can skip some of the fields by entering 0 and still get a relative cost difference between vehicles. You can enter info for just 1 vehicle if you only want to know the total cost of ownership, but aren't interested in a comparison with another vehicle.

Since this is a public sheet, some fields are locked to prevent the formula or description getting messed up. I recommend downloading it so you have full control to modify, and won't accidentally fight someone else who is using it at the same time.

Let me know if there are errors, I need to clarify something, or add features.

Note that the "Estimated % of miles driven on battery alone" field must be answered. If the vehicle is petrol only, enter 0. If it's EV only, enter 100. If it's a plug-in hybrid, estimate what percentage of miles will be run on battery alone.

Here it is: https://drive.google.com/open?id=1rb...2dCJSLxp5ne6Q4

The link is in my signature too.

__________________
Gas and Electric Vehicle Cost of Ownership Calculator







Give me absolute safety, or give me death!
  Reply With Quote
The Following 3 Users Say Thank You to redpoint5 For This Useful Post:
Daox (01-24-2018), LeanBurn (01-24-2018), Xist (01-24-2018)
Alt Today
Popular topics

Other popular topics in this forum...

   
Old 01-24-2018, 08:32 AM   #2 (permalink)
Master EcoModder
 
Ecky's Avatar
 
Join Date: Dec 2011
Location: Vermont
Posts: 2,203

Gaptooth - '00 Honda Insight
Team Honda
Gen-1 Insights
90 day: 50.25 mpg (US)
Thanks: 722
Thanked 840 Times in 532 Posts
I can't see anything amiss.

Plugged in my Insight for giggles. Maybe I have unrealistic maintenance expectations but so far it's just oil changes and a Rock Auto clutch master after 75,000 miles.

With the difference in TCO, I could actually buy a new-to-me Insight every 6 months and drive the old one off a bridge.




EDIT: Can probably add $400 to that as I'm going to need tires at some point.

Last edited by Ecky; 01-24-2018 at 08:37 AM..
  Reply With Quote
Old 01-24-2018, 11:11 AM   #3 (permalink)
Ecomuggler
 
Xist's Avatar
 
Join Date: Jun 2012
Location: Mesa, AZ
Posts: 5,803

Chorizo - '00 Honda Civic HX, baby! :D
90 day: 35.55 mpg (US)

Mid-Life Crisis Fighter - '99 Honda Accord LX
90 day: 34.24 mpg (US)
Thanks: 3,444
Thanked 980 Times in 738 Posts
Tires count, but that should go in a different category. Every car needs tires, nobody has invented land speeders yet and Colin Furze never did anything with his hoverbike.
  Reply With Quote
Old 01-24-2018, 12:02 PM   #4 (permalink)
Got MPG?
 
Join Date: Sep 2010
Location: Southern Alberta, Canada
Posts: 301

The Car - '09 Toyota Corolla CE Enhanced
Thanks: 12
Thanked 30 Times in 27 Posts
Pretty cool. This is a very helpful tool for me.
__________________
2009 Corolla CE Enhanced - 1.8L auto
350K kms
Lifetime : 6.111L/100km (38.761mpgUS)
EPA : 6.8L/100km (34.6mpgUS)
14lbs Prius rims, full upper grill block, partial front belly pan, folded mirrors, lowered 1.5", LRR tech tires.
  Reply With Quote
Old 01-24-2018, 12:08 PM   #5 (permalink)
EcoModding Newb
 
redpoint5's Avatar
 
Join Date: Aug 2010
Location: Oregon
Posts: 3,287

Acura TSX - '06 Acura TSX
90 day: 31.25 mpg (US)

Lafawnda - '01 Honda CBR600 F4i
90 day: 47.32 mpg (US)

Big Yeller - '98 Dodge Ram 2500 base
90 day: 21.82 mpg (US)

Prius Plug-in - '12 Toyota Prius Plug-in
90 day: 79.06 mpg (US)

Mazda CX-5 - '17 Mazda CX-5 Touring
90 day: 28.43 mpg (US)
Thanks: 1,251
Thanked 997 Times in 675 Posts
Quote:
Originally Posted by Ecky View Post
EDIT: Can probably add $400 to that as I'm going to need tires at some point.
Thanks for looking.

The tricky part is estimating the various costs with any accuracy. You might need to spend $400 on tires, but how often do you need new tires? If it's once every 4 years, then you would divide $400 by 4 years and increase the maintenance category by $100.

I don't know if it's easier to estimate maintenance and repairs as a yearly cost, or to estimate it for the duration of ownership and just extrapolate out the yearly cost from that. What do you think?
__________________
Gas and Electric Vehicle Cost of Ownership Calculator







Give me absolute safety, or give me death!

Last edited by redpoint5; 01-24-2018 at 12:54 PM..
  Reply With Quote
Old 01-24-2018, 12:23 PM   #6 (permalink)
Master EcoModder
 
Ecky's Avatar
 
Join Date: Dec 2011
Location: Vermont
Posts: 2,203

Gaptooth - '00 Honda Insight
Team Honda
Gen-1 Insights
90 day: 50.25 mpg (US)
Thanks: 722
Thanked 840 Times in 532 Posts
Quote:
Originally Posted by redpoint5 View Post
Thanks for looking.

The tricky part is estimating the various costs with any accuracy. You might need to spend $400 on tires, but how do you need new tires? If it's once every 4 years, then you would divide $400 by 4 years and increase the maintenance category by $100.

I don't know if it's easier to estimate maintenance and repairs as a yearly cost, or to estimate it for the duration of ownership and just extrapolate out the yearly cost from that. What do you think?
A lot of maintenance items have a randomness to them.

Just using my car as an example, the Insight has no real major maintenance items. The transmission fluid is "lifetime", the timing chain is "lifetime". It calls for 7500 mile oil changes, which come to around $20, and would be twice per year at 15k miles. Coolant flush is the price of a bottle of antifreeze and half an hour outside, if you do your own work.

Most develop a downshift grind from 3rd to 2nd gear, which has no impact on driving if you double clutch. ISB will probably go sometime between 200k and 400k miles. Hybrid batteries eventually die but can last 20+ years in a cool climate with regular but infrequent grid charges - mine is 9 years old and behaves like a new battery, but that wouldn't be the case if I lived in the Southwest.

My car is from the south and it had its battery replaced in 2009 under warranty by Honda (no cost). I replaced a leaking master cylinder with a Rock Auto piece for ~$70 at 200k miles. Otherwise, the records I have show that since it was new, it's had oil changes, 3 sets of tires, and a 12v battery every 5-7 years. Aside from oil, these are maintenance items shared by all cars.

So, maintenance costs would be... zero? $70 over 18 years = $4 per year?
But how to project that into the future?
  Reply With Quote
Old 01-24-2018, 01:04 PM   #7 (permalink)
EcoModding Newb
 
redpoint5's Avatar
 
Join Date: Aug 2010
Location: Oregon
Posts: 3,287

Acura TSX - '06 Acura TSX
90 day: 31.25 mpg (US)

Lafawnda - '01 Honda CBR600 F4i
90 day: 47.32 mpg (US)

Big Yeller - '98 Dodge Ram 2500 base
90 day: 21.82 mpg (US)

Prius Plug-in - '12 Toyota Prius Plug-in
90 day: 79.06 mpg (US)

Mazda CX-5 - '17 Mazda CX-5 Touring
90 day: 28.43 mpg (US)
Thanks: 1,251
Thanked 997 Times in 675 Posts
Quote:
Originally Posted by Ecky View Post
A lot of maintenance items have a randomness to them.

Just using my car as an example, the Insight has no real major maintenance items. The transmission fluid is "lifetime", the timing chain is "lifetime". It calls for 7500 mile oil changes, which come to around $20, and would be twice per year at 15k miles. Coolant flush is the price of a bottle of antifreeze and half an hour outside, if you do your own work.

Most develop a downshift grind from 3rd to 2nd gear, which has no impact on driving if you double clutch. ISB will probably go sometime between 200k and 400k miles. Hybrid batteries eventually die but can last 20+ years in a cool climate with regular but infrequent grid charges - mine is 9 years old and behaves like a new battery, but that wouldn't be the case if I lived in the Southwest.

My car is from the south and it had its battery replaced in 2009 under warranty by Honda (no cost). I replaced a leaking master cylinder with a Rock Auto piece for ~$70 at 200k miles. Otherwise, the records I have show that since it was new, it's had oil changes, 3 sets of tires, and a 12v battery every 5-7 years. Aside from oil, these are maintenance items shared by all cars.

So, maintenance costs would be... zero? $70 over 18 years = $4 per year?
But how to project that into the future?
I also have an out of date maintenance spreadsheet I try to maintain. It lists the various costs over the years for a particular vehicle.

https://drive.google.com/open?id=1d0...MokiNniTMAxVqQ

My maintenance and repair costs are low for my vehicles too, but a lot of that ends up counting towards depreciation. Even if you don't ever replace the battery within your ownership, the wear and tear of it and other items will be factored into the sale price.

As you pointed out, you need tires, and they aren't cheap. That bumps up the maintenance/repair category significantly. Many little items can add up too, so I would budget some fixed amount for things like wiper blades, air fresheners, car washes, etc.
__________________
Gas and Electric Vehicle Cost of Ownership Calculator







Give me absolute safety, or give me death!
  Reply With Quote
Old 01-24-2018, 02:54 PM   #8 (permalink)
Master EcoModder
 
Join Date: Jun 2008
Location: Earth
Posts: 4,889
Thanks: 206
Thanked 729 Times in 529 Posts
Quote:
Originally Posted by Xist View Post
Tires count, but that should go in a different category. Every car needs tires...
Yeah, but the stock tires for a 1st gen Insight are a heck of a lot cheaper than tires for say a jacked-up 4WD. Last a lot longer, too :-)
  Reply With Quote
The Following User Says Thank You to jamesqf For This Useful Post:
redpoint5 (01-24-2018)
Old 01-24-2018, 04:32 PM   #9 (permalink)
Ecomuggler
 
Xist's Avatar
 
Join Date: Jun 2012
Location: Mesa, AZ
Posts: 5,803

Chorizo - '00 Honda Civic HX, baby! :D
90 day: 35.55 mpg (US)

Mid-Life Crisis Fighter - '99 Honda Accord LX
90 day: 34.24 mpg (US)
Thanks: 3,444
Thanked 980 Times in 738 Posts
Plus the contributions to MPG of LLR compared to off-road (even if they never go off-road).

  Reply With Quote
Reply  Post New Thread


Thread Tools




Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Content Relevant URLs by vBSEO 3.5.2
All content copyright EcoModder.com