ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

A free calculator for Economy, Hybrid and Electric Cars

Updated on September 12, 2014

Find out which fuel efficient car works for you

Bothered by high gasoline prices? If you're considering a fuel-efficient car, maybe a hybrid or even an electric vehicle, you will want to see our FREE economy, hybrid and electric car spreadsheet. This example spreadsheet is based on models available in 2012, but can still point you in the right direction.

We have taken six fuel efficient cars from different categories, added in all the costs a driver might experience over an eight-year period of ownership, and provided adjustments for fuel and electricity costs, purchase and loan costs, miles driven and driving style.

The cars compared are a Nissan Leaf (full electric), Chevy Volt (extended range electric), Toyota Prius (hybrid), VW Jetta TDI (diesel), Honda Civic (fuel efficient gasoline), and a used Honda Civic (purchased at 5 years old, sold at 13 years old.)

You will be able to make your own adjustments for your driving style, and see how the cost of driving each car changes for your particular circumstances.

All of the cars in this comparison will save you money over larger, more conventional vehicles, which can have total costs of ownership as much as twice as high versus the cars in this study. (Proof - look at the AAA ownership cost studies in the Resources section on this page.)

How the New Car Calculator Works

The top (blue) section has facts about the cars: purchase price, expected resale value after 8 years, mileages on gas and electricity, repairs and maintenance, insurance and registration costs.

A few of these numbers have to be broad estimates, and some (like insurance and registration costs) can vary from state to state. For the most part, however, we have worked to make them as accurate as possible.

Feel free to make adjustments from your own research, or to message me in comments with suggested changes. The spreadsheet will allow you to change any figures you wish, and see the results in the bottom line.

The middle (yellow) section of the spreadsheet is where you adapt the calculator to your circumstances. It has numbers you should experiment with to observe how changes in financing, fuel prices and driving habits affect the final costs of ownership for the cars.

Play with the gasoline and diesel prices, to see which autos save the most money as these prices increase (diesel tends to be a little more expensive than gas, so adjust it at the same time you adjust for gasoline.)

Financing can also make a big difference in the cost of driving. Expensive cars (like the Chevy Volt) will take a bigger cost hit in our simulation unless loan rates are reasonable.

But in particular, look at the mileage entries for various lengths of driving trips you take. Think first about the number of miles you drive in a typical year - then divide those miles up into short, medium and long trips, and put those numbers into the three yellow mileage boxes. This is an important step to find the car that makes the biggest difference for you.

And finally, the bottom (red) section of our car calculator presents the output, how the costs of operation for our six example cars stack up against each other. Here's what each numbered line means.

  • Total Miles Driven: The sum of the miles you put in each of the yellow miles boxes above. This should total the miles you drive in a year.
  • Second car for >100 mile trips (Leaf): In order to fairly compare the Nissan Leaf, which cannot drive trips over 100 miles, with cars that can drive these longer trips, we add in some cost (and gasoline) that the Leaf owner would have to incur to put miles onto another gas car he may own, or onto a rental car. You can avoid having this handicap for the Leaf by only entering short and medium trips - in other words, put a zero into the "Trips > 100" yellow box.
  • EV kilowatt hours used per year: For the Volt and Leaf only, how many kilowatt-hours of electricity these cars use per year.
  • Gallons of gas / diesel used per year: For the non-EV cars, how many gallons of gasoline used in a year.
  • Combined KWH energy used per month: for this measurement we convert the energy in gasoline into a kilowatt-hours equivalent. This allows us to directly see the difference in energy usage between electric and gasoline powered cars.
  • Fuel cost per month: What your monthly fuel cost, both electricity and gasoline, is for each car.
  • Fuel cost per year: What fuel adds up to in a year of driving, both electricity and gasoline.
  • Monthly payment: This takes into consideration purchase price, interest cost, down payment, and loan term, giving you a number for what the monthly payment on your car would be.
  • Total interest cost: Over the full term of the loan, what the loan costs you just in interest.
  • Fuel cost savings per year vs. 20MPG car. How much money you are saving in fueling cost, over one year, compared to a conventional car that gets 20 miles to the gallon.
  • Monthly payment offset by savings: A useful way to consider your monthly car payment, taking your fuel savings into account.
  • Fuel cost savings over an 8 year period: All the savings on gasoline costs over the full 8-year period of this study added together.
  • Total cost of ownership, 8 years: This is the bottom line. Here is what it costs to own a car for eight years. It's a lot of money!
  • Average cost of ownership, per year: This is the same cost from above, divided up so you can see what the cost of car ownership is per year.
  • Average cost of energy, per mile: This is what you spend in gasoline or electricity to drive one mile in your car.
  • Average cost of ownership, per mile: Another way to see the bottom line - what the total cost is to drive your car for each mile, including both energy and other ownership costs.

Some Examples

The first thing you will notice - looking at the bottom line, cost per mile - is that all the fuel efficient cars being compared have roughly similar ownership costs, once all driving factors are considered.

This is probably no accident, as car manufacturers have to be doing similar studies to ours when setting the sales prices for their cars.

However, each automobile type has it's strengths, so differences in miles, fuel costs, and trip lengths make some cars shine over others.

Example 1: Mostly Long Trips

First, here's a scenario where the Honda Civic posts the best bottom line.

What does it: 15,000 miles, mostly long trips. 9,000 of those miles are spent driving trips over 100 miles long.

Fuel-efficient gas burning wins the day under these circumstances. The result is an ownership cost-per-mile of 32 cents. The used version of the Civic comes in second at 33 cents per mile.

Example 2: Short and Medium Trips

Here's our second scenario, where the Nissan Leaf wins: 15,000 miles, all on trips under 100 miles.

What does it: The short and medium length trips. If your daily driving looks like this, the Leaf is a winner.

Driving on electricity uses just a couple cents per mile worth of electricity, so this is where a pure EV like the Leaf shines. Looking at the bottom line, we see a cost-of-ownership number of just 29 cents. The Prius is in second place.

Example 3: Lots of Miles

In the third scenario, it's the Chevy Volt on top.

What does it: lots and lots of miles. 35,000 miles per year total, split between short, medium and long trips.

The fact that the Volt is efficient and flexible both with electricity and gasoline gives it an advantage when lots of miles are being driven under a variety of circumstances. Cost-of-ownership per mile here in the Volt is 18 cents, with the Prius in second with 19 cents.

Example 4: Half short, Half Long Trips

Here's a fourth scenario that favors the Toyota Prius.

What does it: 25,000 miles per year split between both short and long trips.

Lots of miles are being driven on gasoline, and the Toyota Prius has the best gasoline mileage of all the vehicles. Ownership cost per mile is 23 cents, with the Chevy Volt in second place.

Example 5: Low and High Gasoline Prices

Next, let's try changing the price of gasoline to see which cars cope best with rising gasoline prices.

With gasoline down around $3.50 per gallon, here's a scenario won by the Toyota Prius.

We have a mixture of miles driven at short, medium, and long distances on reasonably priced gasoline. The Prius performance is 26 cents per mile, with the Honda Civic in second place.

Now, we'll up gasoline and diesel prices to nearly $6.00 per gallon, while changing nothing else. What happens?

GM's Volt is now in first place, at 29 cents per mile, and 31 cents per mile for the Prius.

This shows the value of electric propulsion in a future where gasoline prices may rise over $5 per gallon, and keep heading up.

The Leaf comes in second instead of the Prius, if the long trip mileage is reduced. This shows the remaining problem with electric propulsion (somewhat addressed by the extended-range electric vehicle, the Volt), improved fast charging to enable long trips on electricity.

How about the used car on our spreadsheet? When does it make sense to buy used? Try increasing the number in the yellow interest rate box. Somewhere around 8 percent-plus loan interest you'll see the used Civic start to compete on the cost comparisons, due to the lower purchase price of the car. If credit is expensive, and you can't buy outright or make large downpayments, used cars may save you money. Otherwise, there's little reason not to buy new vehicles.

Buy or Lease?

This page is all about the total cost of ownership when buying a fuel-efficient car. But is there any time leasing makes more sense?

We have purposely used a reasonable loan interest rate in our examples, in order to get a pure look at how changing driving variables interact with the technology and design of each car.

However, as you play with the car calculator you will find that loan terms and interest rates can have a large an effect on the bottom line, especially for the more expensive vehicles.

The Chevy Volt and Nissan Leaf merit special mention for having inexpensive leasing options - $350 per month with a $2500 trade-in or down payment. In general, you might consider leasing rather than buying one of these two vehicles if you can't get a decent interest rate on your auto loan (5% or better.)

Leasing electric vehicles has side benefits - it keeps you in state-of-the-art vehicles as the technology evolves - and it removes the possible future cost of a depleted battery pack from the equation.

Summary

How should you interpret the results of our hybrid car - economy car - electric car calculator?

Few people reading this are going to base their purchasing entirely on the numbers they read here, and indeed they shouldn't.

Go sit in some cars, and drive them around. In addition to ownership costs, there will be other reasons that one car appeals to you over another.

An EV like the Nissan Leaf may appeal to you, for example, because you like the idea of fueling at home, or you like the idea of not feeding the big oil machine.

An inexpensive Honda Civic may be your cup of tea because you don't want to carry a big car loan around.

The Chevy Volt may even be what you like, because of the high-tech drivetrain, gadgetry, and the overall fuel versatility it offers.

The Toyota Prius landed in second place in most of our comparisons, so it may a good choice if you will be dealing with changing driving situations.

And the diesel-powered VW Jetta TDI, while not winning any of the fuel-efficiency comparisons, held its efficient head up well for a car with considerably more engine power than the other petroleum-fueled cars in the running.

Remember, our spreadsheet study - in most scenarios - shows the costs of ownership for all of these cars as pretty close to each other. And if the cost of ownership numbers are similar, it makes perfect sense to drive what makes you happiest.

Notes on Study Methodology

This is an informal spreadsheet car comparison, but I have nonetheless striven for the best, most valid numbers possible. Figures were derived from a number of sources, and averaged together to smooth any differences found in the datasets. Some of these references can be found in the resources section on this page.

For a look at how we developed the numbers used in the upper (blue) section of the spreadsheet, we have prepared a PDF document that explains our process, and the range of possible numbers you may substitute. Click here to display (it will open in your Adobe Reader or other PDF reader.)

The two electric vehicles on our calculator, the Chevy Volt and Nissan Leaf, present particular challenges in this regard, as there is not enough historical information on either car to confidently predict future expenses like depreciation and repairs.

Our approach to these two vehicles has been to use depreciation numbers similar to other fuel efficient vehicles. However, consider the risk that the numbers here for the EVs could wind up very different - in either direction - once these cars have been on the road for a few years.

In the case of the only pure electric car here, the Nissan Leaf, we have used particularly low repair figures similar to the very few pure EVs that have driven on American roads in past decades. Historically, EVs have had very low maintenance and repair costs because the electric motor requires no maintenance whatsoever.

Our study takes place over an 8-year period of ownership, which keeps it inside the warranty period for both the Volt and Leaf EV batteries. This allows us to avoid the (important) question of battery replacement costs for the electric cars. This position is justified by the observation that hybrid cars like the Prius have had very few problems with failing batteries, and little effect on resale values, even on very old used vehicles. Prius owners have also found a good workaround to the high cost of replacement batteries by robbing far cheaper (but still good) batteries from junkyard hybrids. EV owners may be able to use a similar strategy, especially once these cars are selling at mainstream rates.

The battery replacement issue is also more relevant for a pure EV like the Leaf, and less so for the Volt, since the Volt is halfway between a full-time EV and a standard hybrid like the Prius. In the Leaf, all the miles driven take a toll on the battery, since there is no other source of energy available. In the Volt, however, some miles are driven on gasoline, which should not, in most circumstances, take many miles off the battery. This should potentially allow the Volt's battery a much longer effective lifetime, depending on driving style.

This is a work in progress, and probably always will be. As data on EV battery lifetimes and replacement costs becomes available, these costs will be better integrated into our depreciation numbers. Likewise, data on the other vehicles here will be updated periodically when model years change.

If you would rather not download an office suite to view the car calculator spreadsheet, Open Office is available on disc inexpensively here:

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      anonymous 5 years ago

      Insurance and registration on a used Honda Civic is easily 1/2 to 1/3 the cost of a more expensive vehicle like the Chevy Volt, And if you buy it with cash which is likely for such a low cost vehicle, there are no financing cost either. That adjustment alone is thousands of dollars per year - making the Honda less cost to operate. And where is the opportunity cost for the capital dumped into the more expensive vehicles versus the less expensive ones?

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: Registration-insurance varies quite a bit by state, but I will take a close look at this (for the used car) for the next version, thank you. You can change any of these values if you like (this is why we did a spreadsheet instead of a Javascript widget)

      You can represent a cash buy for the used car by using a large downpayment number. That way you'll get no interest on the used car, but interest on the expensive ones.

      Opportunity cost is a bit trickier. We're considering how we might do this.

    • profile image

      anonymous 5 years ago

      @apeweek: I was going to mention it in my comment, but it's not so much geographic differences in the insurance/registration as the size and age of the vehicles. The delta between the new/expensive and older/cheaper cars is pretty much a constant.

      And yeah, the comparison kind of goes out the window when you're paying $8000 in depreciation for a Volt that you never recover. That's the problem with the Volt, not the operating costs, but the capital costs.

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: Depreciation is just one of several unrecoverable costs associated with car ownership. I could just as easily point out that thousands of dollars in higher gasoline costs are not recovered either.

      That's the point of doing a spreadsheet, to account for as many costs as possible and get an idea what car ownership really adds up to.

      I'm not dismissing your concern, I really do want to make it as accurate as possible, so continue giving me feedback. I will be looking at adjusting the insurance numbers on the used car very soon.

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: Addendum to my other comment - I looked into insurance cost for older cars. It's not half the cost, as you suggest, because the principal reason for carrying insurance is not to protect your car - it's to protect the people and property you may damage with your car.

      My insurance numbers came principally from other online TCO calculators like the ones at Edmunds, Motor Trend and AAA. If you look at those websites, you will see that insurance rates do not fall with the age of the car.

      However, a used car buyer would be inclined to buy less insurance, so there would be a small difference. If I look at the oldest car I personally have insured, with minimum coverage only, it is costing me $1120/year, which is a little bit less than the number I have for the used Civic, so I will adjust that number downward a little bit.

    • profile image

      Mosoma 5 years ago

      Nice lens. Thank you.

    • profile image

      anonymous 5 years ago

      Great sheet, but I'm wondering what the >100 vehicle was for the LEAF. The mileage on it is horrible. My guess would be that is someone owns a LEAF, their long range car would also be reasonably low cost just due to demographic realities.

      I own a LEAF and my ICE is a 2002 Toyota Echo. Another thing is that one quick charger doubles my driving range, so I now can and do go over 120 miles in one day.

      Forgive me if I sound a bit defensive but I am constantly seeing 100% EV's being misrepresented. In your comparison, it was the car that substituted the LEAF that made the LEAF look less efficient.

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: I'm assuming a relatively average car, that with gasoline added in, averages mid-40-something cents per mile.

      I know what you mean, though, I am still thinking about this. I started off with a rental car estimate in this box, which was actually often cheaper than taking a mileage figure for a second car. Of course, lots of people complained about that, too. You can certainly change the assumption for yourself by changing the per-mile figure in the formula for that cell.

      If I assume a very fuel efficient car instead of an average car for the calculation, I'll get complaints from the other side. It's true that many Leaf owners would want a fuel-efficient second car. On the other hand, many people would want something utilitarian, like a van or pickup, since it will be rarely driven anyway.

      Really, the best way to compare the Leaf is just to compare short-medium trips, and leave the >100 box blank. When fast-charge stations become more common, I will take this into account, too.

      Depending on the feedback I get, I may change the assumption here, or maybe give an explicit choice or a range of values. Thanks for the comment.

    • profile image

      anonymous 5 years ago

      This spreadsheet assumes stability in the price of gas, which has not been the case. Since 2000, it has steadily gone up at least 10% per year. No one has a crystal ball that can accurately tell us whether India, China, and the rest of the developing world are going to continue increasing their consumption as they have been, but it would be nice to be able to plug in our guess about what the rate of gasoline price increases will be. It will have a dramatic effect because cost of electricity is far more stable.

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: I agree that gasoline will likely increase, based on recent history. So it's useful to plug different gas prices into the calculator and see the effect this will likely have on the cost of ownership for the different cars.

      If you believe gas is going to increase, this exercise will point you in the direction of the cars you should be considering.

    • profile image

      anonymous 5 years ago

      The average cost of electricity in your calculations is flawed (as it is in many other articles): you are using only the electrical energy cost and only at baseline usage. The true cost of electricity is the total electrical energy cost (baseline plus above baseline, the latter at higher rates), plus transportation and distribution charges, plus the various fees the utility charges. This, divided by the total KWHRs consumed, is the actual average cost of electricity, which is likely to be in the range of $0.20 - $0.30 per KWHR. Since EV owners will be charging at home, they will almost certainly be well above their baseline usage where higher rates apply. In addition, public and private chargers are unlikely to provide free charging for long and the rates, if fair, will be appropriate to the cost of electricity used per charge. Given the above, fuel cost savings from using an electric car are likely to be very small and certainly not worth the considerable extra effort keeping the car charged, the daily range anxiety, and the inability to use the vehicle for longer range trips.

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: Hi - this is a downloadable spreadsheet, so you can put whatever value for electricity you choose into the electricity cost box. In defense of my default value, that is a very widely quoted number for average electricity cost.

      I personally have a split rate from my utility (ask yours, most have this) that gets me a very low overnight charging cost of just 4 cents per KWH, 7 cents per KWH after all taxes and other fees. I do not believe your .20 to .30 rate is a very common number, though certainly there are very high rates in a few locations. I would personally consider home solar panels if I had such high rates in my town.

      As for the actual fuel cost savings from EV use, that is exactly why this spreadsheet exists, so users can experiment and see for themselves. Thanks very much for the comment.

    • profile image

      anonymous 5 years ago

      @anonymous: We pay 9.8 cents per KWH . This includes all taxes and fees . Other states have baselines and some offer highly discounted nightly rates as low as 6 cents per kWh

    • profile image

      anonymous 5 years ago

      personally i prefer petrol cars, electric takes an average of 6 hours to charge however with a petrol engine you just fill with gas and drive,

      Maybe if you only drive few miles a day it would be a good investment but if your living a number of miles away from work and using the car a great deal outside of work then petrol is more reliable...in my opinion

    • profile image

      anonymous 5 years ago

      OK, well done on all counts. Someone needed to do this.

      Are you going to include the Ford Fusion Hybrid 2011 and the new Ford Fusion Electric, next time around? The Fusion Hybrid does pretty well, I've heard.

      Best Regards

    • apeweek profile image
      Author

      Dave Muse 5 years ago from Dearborn, MI

      @anonymous: Thanks! Yes, I would love to update the sheet and add lots of new cars coming out this year. Sadly, it probably means rewriting all the examples on the page, which is lots of work. I'll probably tackle this mid-year, when I'll have more info on all the cars I'd like to include.

    • profile image

      anonymous 5 years ago

      They have an 8 year old Prius listed at a resale value of $11,524 . Who would pay that much for a car on it's last legs ?

    • profile image

      anonymous 5 years ago

      @anonymous: Or, it could be the opposite of what you say.

      In much of Europe the Merit Order Ranking system is used which can lower what American's call baseline by up to 40%, simply by using the cheapest available electrical power source.

      In Germany, that's solar (no coal cost, no incremental nuclear fuel cost, no oil cost, no LNG cost, no diesel cost) so, the amount of that fuel, during "baseline" usage costs up to 40% of the electrical generation costs.

      When using solar, no fuel costs.

      In Denmark, their Merit Order Ranking system factors in wind power - same thing.

      For a brief snapshot on M.O.R. visit my website:

      http://johnbrianshannon.com/m-o-r/

      For a little more info on M.O.R. visit:

      http://johnbrianshannon.com/germany/

      If utility companies in the states aren't passing on M.O.R. savings, that's a windfall for them, IF they are running solar and wind power.

      The calculations in the article could be heavy by up to 40%, if M.O.R. is not being passed on to consumers.

      Cheers! JBS

    • Hypersapien2 profile image

      Hypersapien2 5 years ago from U.S.

      Great lens. I also have a lens on fuel-efficient cars, so I love reading info like this.

    • profile image

      jmasters-electric-cars 4 years ago

      Awesome info

    • mihgasper profile image

      Miha Gasper 4 years ago from Ljubljana, Slovenia, EU

      Hybrid and electric cars are future of individual traffic. Thanks for all the calculations. Awesome lens!

    • profile image

      anonymous 4 years ago

      I recommend allowing the number of years of ownership be a input variable. It would seem the real pay off for an electric kicks in 10 years of ownership. Great work on the spreadsheet! Thanks!

    • profile image

      anonymous 4 years ago

      Hi thanks for this very useful tool. I am trying to decide about a commute vehicle where my one-way trip to work is 35 miles. I wish there was a way to adjust the calculator to account for a person's daily driving habits rather than an overall number. The length of each daily trip directly impacts how much gas is needed or not. Some of these cars could handle a commute entirely on battery while some will need to leverage gas. It seems like the energy cost could really vary based on your daily driving habits vs. just the overall number. Does this make any sense? Iâd also like to point out that being able to drive in the HOV/Carpool lane is huge with some commutes and may even trump cost due to lower stress, better time management etc. I am not sure how you factor that into a tool such as this though.

    • profile image

      anonymous 4 years ago

      Below is the link to a free course (website) on performing EV Economic evaluations. It contains a worksheet that complements the great work posted here and the worksheet offered by Dave Muse Media. See cleanenergyinstitute.net/course/view.php?id=53

      Feel free to try to give us some feedback (Version 4 should deal better with imperial units used in the US.)

    • profile image

      Margot_C 4 years ago

      Very useful. I have a Honda Civic Hybrid and it still does okay on gas mileage.

    • craig57 lm profile image

      craig57 lm 3 years ago

      Great information, thank you for this Lens.

    • ggalea profile image

      Gilberto Galea 3 years ago from Willemstad

      Great lens, and excellent explanation.

    Click to Rate This Article