You can install our site as a web app on your iOS device by utilizing the Add to Home Screen feature in Safari. Please see this thread for more details on this.
Note: This feature may not be available in some browsers.
Apparently a lot of men in the 35-54 bracket are likely to do it.
Average Annual Miles per Driver by Age Group
The battery has substantial resale value. Although the battery (per point 1) no longer provides the range you want, it still holds a goodly amount of electricity. I predict that some clever company will start buying up used EV batteries, bundle them, and use them as grid-scale electric storage devices.
Once again I got bored and started messing with my comparison spreadsheets. This time around Google Drive (aka Google Docs aka Office Online knockoff) has matured to the point where all the equations/functions I was using work. Here's the
TeslaVsICEv4 Google Drive link
Brief list of things changed added to the original post.
Nice work but I would argue it's not realistic. A few things:
1) It's unrealistic to assume gas will increase at 8% per year on average more than the general rate of inflation. I know a lot of real estate agents who talked that way back in 2006. Past performance is no indication of future performance. Markets would react and bring down demand which is already happening due to many other much cheaper sources of fuel such as natural gas.
2) You should figure the entire cost of the car in your interest calculations, not just the loan amount. The cash that you put up would otherwise be making you money if you didn't use it to buy the car. You also have to do this for the ongoing expenses which will reduce their cost due to the fact that you won't have to pay them for several years. That will make the gasser a lot cheaper in the comparison.
3) Why did you stop at 10 years? A car with only 150k mi on it is considered low mileage around here.
4) Tesla MS maintenance fees are ridiculously high for an EV but aren't shown that way on your spreadsheet. Without tires it's $600 /12,500 mi. Your spreadsheet shows it less than that - were you hoping to get 150,000 mi on the original tires?
5) Other minor stuff but I'll leave it alone... Don't want to discourage you... especially if this is your justification for buying the car!
...I whipped this together for fun... Also just because I entered a number in the shared form of the spreadsheet doesn't mean I believe it to be the most accurate prediction of the future.
You will find most people on TMC agree with you. But I disagree. I think all of the obvious arguments for wild year over year gas price increases (and 8%/yr is wild) have already been taken into account in the current price. Why wouldn't they be? Last time I checked I think the GAO was using about 80 basis points per yr above the general rate of inflation for gasoline. That's 1/10th as much as you are predicting and they are seasoned economists who have spent boat-loads of money to get their numbers.1) If it weren't for the terrible US economy gas would have probably followed the 8% trend of the past but for the moment gas is holding steady and at times getting cheaper. Even with the heavy subsidies for oil in the market the more the "easy" oil is no longer available to get it would be impossible for the price of gas to remain the same.
It shouldn't. In Excel look up the functions NPV() and PV(). They require that you come up with an interest rate or rate of return on investment.2) Yeah that can be done but that would make reading and editing the data even more difficult to manage.
The latest predictions for MS battery lifetime are 14 - 20 years at 12.5k mi per year. Nobody knows this for sure but it's a lot more likely than 8%/yr gas inflation.3) It can go out for over 20 years but like the Mayan calendar it had to end at some point. If you enter that you drive over 15000 miles a year you can simulate extra wear and tear on a vehicle that way but then you get into the territory of possible engine component replacements and possibly battery pack replacements. I wasn't focused on that for this. IMO battery pack replacement is preferable cheaper to rundown ICE related repairs at that high of mileage
5) This is just a for fun thing I whipped up...
I recently had a teacher call me from a local voc-tech center who thinks a good EV would be more like an airplane than a car - cost effective to keep it on the road for several decades.
I've been making that same point for a while, especially a vehicle like the S which uses aluminum, or an EV that uses composite materials. They should last much longer than a conventional vehicle and could be thought of more like an airplane, or boat. People often recondition planes and repower and upgrade boats since the initial investment in building it is higher and the basic structure remains sound for decades. At some point a Model S could get a new interior, new suspension parts, a new pack, and be ready for another 20+ years of service. Of course no one takes that into account when calculating environmental impacts and ownership costs.
I am in 100% agreement with you. I think about every 8-12 years I will need a new battery. And maybe in the future getting a new screen/computing bits. I fully expect to give this car to my unborn children!
PC's are required to work in an ever more strenuous environment, (more demanding software), where a vehicle is not. The Physics of driving remain the same, that's why there is a huge classic car market, and those vehicles can still perform quite well, while older PC's never can. Certainly there will be people who always want the latest and greatest car, but there will also be a large market for older vehicles that can still perform admirably. Sub 6 second 0-60 will never be outdated as long as you are turning wheels against pavement.Not me.
I think that comparing this car to a PC is at least as appropriate as comparing it to a boat or airplane.