NOTE: THE PRICE PER SHARE IS $5.43.

PLEASE USE EXCEL TO SOLVE THE FOLLOWING QUESTION. THANK YOU!

Tesla Valuation Model assumptions based on anaylst reports Upside YOY Revenue Growth Downside YOY Revenue Growth Base Case YOY Revenue Growth Total Cost of Revenue (\% of Rev) R\&D YOY Growth SG\&A YOY Growth Depreciation (\% of Rev) CapEx (\% of Depr) Sens CoR Total Revenue in 2022 (in millions) Total R\&D in 2022 (in millions) Cost of Capital (Discount Rate) 12% Long run growth rate 3% Next, perform some sensitivity analysis. - Use the Upside and Downside scenarios to compute Upside and Downside stock prices. - Using the base case, check the sensitivity of the valuation to the assumptions about Tesla's cost of revenue. The sheet assumes that Tesla will be able to stabilize gross margins at 24%. This would be fairly high for the automotive industry, where gross margins can be as low as 10%. Calculate Tesla's stock price if Cost of Revenue was 76%,78%,79%,80%, and 82% in years 2023,2024 , 2025, 2026 and 2027, and then 85\% from 2028 onward. - Using the base case, check the sensitivity of the valuation to the assumptions about Tesla's cost of R\&D. The sheet assumes that eventually Tesla will be able to hold R\&D growth to only 8% per year. As the space becomes more competitive, Tesla may have to keep R\&D growth at 16% in order to keep its lead. Calculate Tesla's stock price if R\&D levels out at 16% growth from 2027 onward