angelmarauder
commented
5 years ago 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
Open Robertocarlos1 opened 5 years ago
angelmarauder
commented
5 years ago 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!