Hello Everyone,
I'm new to the forum and I'm hoping to get some help comparing the Model S to a ICE (Internal Combustion Engine) car. I've come up with a crude first cut spreadsheet, which I attached to this post, at comparing my current car Mazda 6s to the Tesla Model S, I know they're not in the same league but that's the best I have to work with. I know the maintenance costs of my car.
I didn't include items that would be similar in both cars. i.e. tire replacement, painting, car damage, wheel alignments, etc.
I included brakes in my ICE car and not the Tesla since several people have told me you'd rarely use your brakes in a EV car with regenerative braking.
Also all the numbers I listed for the Tesla are just a guess but what maintenance am I missing? Have there been any publicized report of a lithium ion EV car lasting over 100,000miles and the performance hit has at higher mileage? Not much info on the web about that.
Thanks for the help.
UPDATE -- Added V2
Change log:
- Added Gas Cost Rate increase %
- Added Electricity Cost Rate increase %
- Added Degradation of Range %
- Included all Roadster service values except A/C refrigerant since it's part of Annual Service according to this roadster maintenance thread.
- Added ICE air filter costs
- Added state tax credit EV
UPDATE -- Added V3
Change log:
- Reformatted calculations to facilitate the generation of a Total Cost Of Ownership plot
- Added loan calculations for ICE and EV vehicles
- Color coded cells that can be altered
- Applied same degradation of EV Range rate to kWh capacity of the battery
- Changed the calculation of rotor/brake pad replacement on the EV car to be at a frequency 2.25 times that of the ICE car due to regen braking
UPDATE -- Added Link to V4
Google Drive Link
(The sheet is View Only so you'll need to save a copy to your own Drive inorder to edit numbers)
Change Log
- Converted to Google Drive
- Added basic depreciation calculation that rolls into the TCO calculations
- Added an affordability sheet
- Assume EPA fuel economy for entire life and decoupled range degradation calcs from fuel economy
- Added logic to auto populate certain values (Range, Fuel Economy) based on the Tesla Model S battery pack chosen
- Zeroed out Tesla maintenance items since they are covered under the Annual Tune-up Cost
- Misc equation fixes
I'm new to the forum and I'm hoping to get some help comparing the Model S to a ICE (Internal Combustion Engine) car. I've come up with a crude first cut spreadsheet, which I attached to this post, at comparing my current car Mazda 6s to the Tesla Model S, I know they're not in the same league but that's the best I have to work with. I know the maintenance costs of my car.
I didn't include items that would be similar in both cars. i.e. tire replacement, painting, car damage, wheel alignments, etc.
I included brakes in my ICE car and not the Tesla since several people have told me you'd rarely use your brakes in a EV car with regenerative braking.
Also all the numbers I listed for the Tesla are just a guess but what maintenance am I missing? Have there been any publicized report of a lithium ion EV car lasting over 100,000miles and the performance hit has at higher mileage? Not much info on the web about that.
Thanks for the help.
UPDATE -- Added V2
Change log:
- Added Gas Cost Rate increase %
- Added Electricity Cost Rate increase %
- Added Degradation of Range %
- Included all Roadster service values except A/C refrigerant since it's part of Annual Service according to this roadster maintenance thread.
- Added ICE air filter costs
- Added state tax credit EV
UPDATE -- Added V3
Change log:
- Reformatted calculations to facilitate the generation of a Total Cost Of Ownership plot
- Added loan calculations for ICE and EV vehicles
- Color coded cells that can be altered
- Applied same degradation of EV Range rate to kWh capacity of the battery
- Changed the calculation of rotor/brake pad replacement on the EV car to be at a frequency 2.25 times that of the ICE car due to regen braking
UPDATE -- Added Link to V4
Google Drive Link
(The sheet is View Only so you'll need to save a copy to your own Drive inorder to edit numbers)
Change Log
- Converted to Google Drive
- Added basic depreciation calculation that rolls into the TCO calculations
- Added an affordability sheet
- Assume EPA fuel economy for entire life and decoupled range degradation calcs from fuel economy
- Added logic to auto populate certain values (Range, Fuel Economy) based on the Tesla Model S battery pack chosen
- Zeroed out Tesla maintenance items since they are covered under the Annual Tune-up Cost
- Misc equation fixes
Attachments
Last edited: