As promised, here is the link to the spreadsheet I made to calculate the total cost of ownership of a Tesla Model S and to compare leasing vs. loaning.
First, some caveats. I cannot guarantee that any of the numbers or calculations on this spreadsheet are or will remain correct, and please do not rely on it to know how much you'll actually pay for a Tesla!
That said, as of the time I made it, the outputs of the spreadsheet do match what I was quoted from Tesla, and the numbers I saw on the Tesla website. And, BTW, if you just want a quick answer of whether to lease or buy and take a loan, if you plan to replace the car in 3 years it is much better to lease (even with the guaranteed buyback from the loan), and if you plan to keep the car, it's much better to buy and loan. And, BTW, for buying the car, with the low loan rates currently being offered (as well as the guaranteed buyback offer), I personally think it would always be better to take a loan as opposed to paying cash up front...
Here's the link: Tesla TCO lend vs lease - Google Sheets
This is what I made it to do that I did not see on the Tesla website:
1) Includes sales tax in the initial price of the car (after you input your state sales tax %)
2) Makes it easier to calculate a realistic amount for annual gas savings
3) Calculates lease and loan payments before and after tax
4) Calculates the total cost of ownership of both leasing and lending after both 3 years (returning the car) and 5 years (keeping the car)
A few notes:
1) My goal was to compare a Tesla vs. another car, so did not include costs that would be common to all cars (e.g. garage or parking costs)
2) Re: maintenance, even though a Telsa costs less for regular maintenance, it costs more for minor repairs, so I left this out
3) The referral discount has a different effect on lease payments compared to simply getting options that cost $1K less, so if you include a referral discount, the resulting lease prices will not be replicated on the Tesla website (but were confirmed to me by Tesla finance).
4) The loan rates quoted to me were different from the ones on the Tesla website and I'm sure change all the time
5) I did not make it editable on google sheets since if multiple people were using at the same time, it would mess up all of their calculations!
How to use:
1) Download the spreadsheet into excel
2) Select which options you have in 'Column C' (1 for yes, 0 or blank for no), which should match the "Cash Price" on the Tesla website
3) Input your numbers for state tax, fees, loan, lease and usage options in column 'G'
4) The results will show up in rows 34 thru 44, hopefully with self explanatory labels!
There are possibly mistakes in the calculations, and almost definitely assumptions that others would make differently, so please leave in this thread any errors or changes you'd make (though I unfortunately can't guarantee that I'll be able to maintain it, I'll try to, at least at first!)
Hope this is helpful to folks, and again, here's the link:
Tesla TCO lend vs lease - Google Sheets
First, some caveats. I cannot guarantee that any of the numbers or calculations on this spreadsheet are or will remain correct, and please do not rely on it to know how much you'll actually pay for a Tesla!
That said, as of the time I made it, the outputs of the spreadsheet do match what I was quoted from Tesla, and the numbers I saw on the Tesla website. And, BTW, if you just want a quick answer of whether to lease or buy and take a loan, if you plan to replace the car in 3 years it is much better to lease (even with the guaranteed buyback from the loan), and if you plan to keep the car, it's much better to buy and loan. And, BTW, for buying the car, with the low loan rates currently being offered (as well as the guaranteed buyback offer), I personally think it would always be better to take a loan as opposed to paying cash up front...
Here's the link: Tesla TCO lend vs lease - Google Sheets
This is what I made it to do that I did not see on the Tesla website:
1) Includes sales tax in the initial price of the car (after you input your state sales tax %)
2) Makes it easier to calculate a realistic amount for annual gas savings
3) Calculates lease and loan payments before and after tax
4) Calculates the total cost of ownership of both leasing and lending after both 3 years (returning the car) and 5 years (keeping the car)
- Takes into account your discount rate, or cost of money so that laying out more money up-front for a loan 'costs' more because you otherwise could have invested that money or earned interest on it
- Takes into account any additional cost to insure a Tesla vs. another car
- Takes into account additional accessories that may be needed for a Tesla vs. another car (e.g. chargers, electrician, console in car)
A few notes:
1) My goal was to compare a Tesla vs. another car, so did not include costs that would be common to all cars (e.g. garage or parking costs)
2) Re: maintenance, even though a Telsa costs less for regular maintenance, it costs more for minor repairs, so I left this out
3) The referral discount has a different effect on lease payments compared to simply getting options that cost $1K less, so if you include a referral discount, the resulting lease prices will not be replicated on the Tesla website (but were confirmed to me by Tesla finance).
4) The loan rates quoted to me were different from the ones on the Tesla website and I'm sure change all the time
5) I did not make it editable on google sheets since if multiple people were using at the same time, it would mess up all of their calculations!
How to use:
1) Download the spreadsheet into excel
2) Select which options you have in 'Column C' (1 for yes, 0 or blank for no), which should match the "Cash Price" on the Tesla website
3) Input your numbers for state tax, fees, loan, lease and usage options in column 'G'
4) The results will show up in rows 34 thru 44, hopefully with self explanatory labels!
There are possibly mistakes in the calculations, and almost definitely assumptions that others would make differently, so please leave in this thread any errors or changes you'd make (though I unfortunately can't guarantee that I'll be able to maintain it, I'll try to, at least at first!)
Hope this is helpful to folks, and again, here's the link:
Tesla TCO lend vs lease - Google Sheets
Last edited: