The model seems flawed. The financing/opportunity costs are not included (AFAICT...). A better way to construct the model would be to avoid trying to account for year-by-year depreciation, and only include the initial purchase cost and eventual sale cost in the cash flow.
Unfortunately (you might be able to tell I'm a Tesla fan), this makes the Tesla S less attractive in comparison to other cars due to its higher up-front price.
Unfortunately (you might be able to tell I'm a Tesla fan), this makes the Tesla S less attractive in comparison to other cars due to its higher up-front price.