Joined
·
21 Posts
I’ve been lurking around for a few weeks learning as much as I can about the Volt. It was really bothering me not knowing whether or not the high price of the Volt made it obsolete. My summer class load is exceptionally boring so I’ve spent my “free time” in class building a pretty extensive cost analysis excel “program” if you will. The program is very simple and helpful, it requires you to input the following:
1) The price you are willing to pay for a regular car in 2010
2) Regular car average fuel efficiency (MPG)
3) Estimated regular car maintenance cost per year
4) Number of miles you drive on an average weekday
5) Number of miles you drive on an average weekend day
6) Number of long driving trips you take per year
7) The average total distance of one long driving trip (miles)
8) Amount of down payment on vehicle you can afford
9) Interest rate you would expect on a car loan given your credit score
10) Number of years you want it to take to pay off the vehicle
11) Trade in value of your current car (in two years)
12) Sales tax of your state
13) monthly car insurance payment
Then it takes the known facts about the Volt (which can all be changed to see effects) and gives a detailed breakdown of a ton of different things. The breakdown takes into account three different cases for gas and electricity prices (worst case/exponential growth, optimistic linear growth, and a case for values of gas and electric prices which you fill out). In the end you can see exactly how much you will be paying each year for both the Volt and a regular car, (interest, gas price and all). When you account for growth in gas prices it is pretty surprising to see the results. It will make a lot more sense once you see it. It really helped me understand all the cost involved and how it’s going to play out. I figured you guys would like to see it too (since half the post here seem to be about cost speculation).
I spent a lot of time making sure this thing would be robust to any numbers, it has a bunch of IF statements so you can play around with driving ranges below and above the 40 mile range as well as change the all electric range and it will all still work.
If there are any mistakes, things I missed or bugs please contact me (gtg334q at mail.GAtech.edu) and let me know, so I can edit it, it might be a little hard for someone to figure out…
I’ve also attached an example of how to fill out the sheet if it is confusing. It might be easier to understand if you look at the example first and then start with your own.
Hope this helps finally answer the question about price of the Volt!
1) The price you are willing to pay for a regular car in 2010
2) Regular car average fuel efficiency (MPG)
3) Estimated regular car maintenance cost per year
4) Number of miles you drive on an average weekday
5) Number of miles you drive on an average weekend day
6) Number of long driving trips you take per year
7) The average total distance of one long driving trip (miles)
8) Amount of down payment on vehicle you can afford
9) Interest rate you would expect on a car loan given your credit score
10) Number of years you want it to take to pay off the vehicle
11) Trade in value of your current car (in two years)
12) Sales tax of your state
13) monthly car insurance payment
Then it takes the known facts about the Volt (which can all be changed to see effects) and gives a detailed breakdown of a ton of different things. The breakdown takes into account three different cases for gas and electricity prices (worst case/exponential growth, optimistic linear growth, and a case for values of gas and electric prices which you fill out). In the end you can see exactly how much you will be paying each year for both the Volt and a regular car, (interest, gas price and all). When you account for growth in gas prices it is pretty surprising to see the results. It will make a lot more sense once you see it. It really helped me understand all the cost involved and how it’s going to play out. I figured you guys would like to see it too (since half the post here seem to be about cost speculation).
I spent a lot of time making sure this thing would be robust to any numbers, it has a bunch of IF statements so you can play around with driving ranges below and above the 40 mile range as well as change the all electric range and it will all still work.
If there are any mistakes, things I missed or bugs please contact me (gtg334q at mail.GAtech.edu) and let me know, so I can edit it, it might be a little hard for someone to figure out…
I’ve also attached an example of how to fill out the sheet if it is confusing. It might be easier to understand if you look at the example first and then start with your own.
Hope this helps finally answer the question about price of the Volt!
Attachments

22.9 KB Views: 390

21.7 KB Views: 334