Hi everybody,
I've been working on a spreadsheet to try and find the true TCO using a net present cost analysis. I'd love to hear any questions, corrections, or improvements on the sheet I have. It's based off of a Khan Academy Rent vs. Buy analysis but has been retrofitted and improved for EV and ICE cars. I tried to put in a best guess for some of the numbers like maintenance, tires, fuel, etc costs, but it'd be great to hear some discussion of how accurate my numbers are. The costs are all allocated monthly so even costs such as tires which are one time expenses every X number of years are included monthly. However, I still feel this is far more accurate when combined with using present value of dollars rather than a TCO that does not take PV into consideration. I don't own a Tesla but am looking into the Model X.
Thanks.
View attachment TCO Tesla.xlsx
I've been working on a spreadsheet to try and find the true TCO using a net present cost analysis. I'd love to hear any questions, corrections, or improvements on the sheet I have. It's based off of a Khan Academy Rent vs. Buy analysis but has been retrofitted and improved for EV and ICE cars. I tried to put in a best guess for some of the numbers like maintenance, tires, fuel, etc costs, but it'd be great to hear some discussion of how accurate my numbers are. The costs are all allocated monthly so even costs such as tires which are one time expenses every X number of years are included monthly. However, I still feel this is far more accurate when combined with using present value of dollars rather than a TCO that does not take PV into consideration. I don't own a Tesla but am looking into the Model X.
Thanks.
View attachment TCO Tesla.xlsx