You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Cell F19 you typed in 19,000 but should have typed in 19,000,000,000 consistent with E19 and G19. The impact of the error is that the depreciation of 15% works out to only $2,850 rather than $2.85bn like it should. After correcting this you will get a stock price of $6,007 as your EBITDA will be higher by $2.85bn.
I also agree with the other commenter that you should have a billable % on the miles driven as there are definitely a large percentage of non-billable miles required to get the vehicle to the customer, get it to its charging station, etc.
Overall you did a great job! Thanks for sharing!
The text was updated successfully, but these errors were encountered:
As of Tesla Valuation for Github_5.27.19_v3.2.xlsx, this is inaccurate.
F19 is correct. and % billable (utilization) is factored in according the line 46 comment
Cell F19 you typed in 19,000 but should have typed in 19,000,000,000 consistent with E19 and G19. The impact of the error is that the depreciation of 15% works out to only $2,850 rather than $2.85bn like it should. After correcting this you will get a stock price of $6,007 as your EBITDA will be higher by $2.85bn.
I also agree with the other commenter that you should have a billable % on the miles driven as there are definitely a large percentage of non-billable miles required to get the vehicle to the customer, get it to its charging station, etc.
Overall you did a great job! Thanks for sharing!
The text was updated successfully, but these errors were encountered: