Question: SPREADSHEET MODEL: https://github.com/ARKInvest/ARK-Invest-Tesla-Valuation-Model/blob/b118a0386b1fcb294e50f90d03befcf0952f67da/Tesla%20Valuation%20for%20Github_5.27.19_v3.5.xlsx https://ark-invest.com/articles/analyst-research/tesla-valuation-model/ View this Tesla valuation report by Tasha Keeney from ARK Invest, dated May 100 22nd 2019. The spreadsheet model named 'Tesla

SPREADSHEET MODEL: https://github.com/ARKInvest/ARK-Invest-Tesla-Valuation-Model/blob/b118a0386b1fcb294e50f90d03befcf0952f67da/Tesla%20Valuation%20for%20Github_5.27.19_v3.5.xlsx

https://ark-invest.com/articles/analyst-research/tesla-valuation-model/

SPREADSHEET MODEL:
View this Tesla valuation report by Tasha Keeney from ARK Invest, dated May 100 22nd 2019. The spreadsheet model named 'Tesla Valuation for Github_5.27.19_v3.5.xlsx' is copied in this workbook in the sheet 'Tesla Model' for you to see. The below 101 questions are based on this model. 102 https://ark-invest.com/articles/analyst-research/tesla-valuation-model/ 103 Q9a 1 Does ARK value Tesla using DCF or multiples? Write 'DCF' or 'multiples'. Do they value Tesla as a single uniform entity or by summing valuations of 104 Q9b 1 multiple divisions? Write 'single' or 'sum'. What assumptions are made about Tesla's interest-bearing leverage in 2023? 105 Q9c 1 Write 'levered' or 'unlevered'. Does the valuation model include the benefit of interest tax shields? Write 106 09d 1 'includes' or 'excludes'. Based on the current Tesla share price of $620, is this better than the bull scenario, worse than the bear scenario or in between? Write 'better', 'worse' 107 09e 2 or 'between'. With regards to the above question, keep in mind that there was a stock split in 2020 that you should adjust for. Ignore timing differences between now and 108 2023 and simply compare stock prices, adjusted for the stock split. Are the stock prices on line 68 of the Tesla vauation model present values as at 109 09f 2 2018 or future values as at 2023? Write '2018' or '2023'

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!