Answered step by step
Verified Expert Solution
Question
1 Approved Answer
firm's October 2021 DCF valuation model of Tesla. The intern is trying to guess how the following updates will affect the Tesla share price output
firm's October 2021 DCF valuation model of Tesla. The intern is trying to guess how the following updates will affect the Tesla share price output by the spreadsheet model. In the first sentence, they've given the factually correct new data. But they have asked you to check their conclusions in the second sentence. Which of the below statements contains a second sentence that is NOT correct? Note: You can refer to Holon's valuation spreadsheet. Select one: a. The risk free rate (cell D496) has increased from 1% pa to 3.8% pa as at 30 Sept 2022 . Increasing the risk free rate will reduce the Tesla share price, all other things remaining equal. b. The market risk premium (MRP, cell D495) has risen from 6% pa to 6.1% pa. Increasing the MRP will reduce the Tesla share price, all other things remaining equal. c. Increased competition and higher raw material (lithium) and worker costs have decreased profit margins. Decreasing the profit margin will reduce the share price, all other things remaining equal. d. Tesla's number of shares was 1 billion (cell Z543) on 13 October 2021, and it completed a 3-for-1 stock split on 25 August 2022. This will increase the number of shares to around 4 billion, increasing the model-estimated share price. e. Tesla's market share price was $268.21 on 29 September 2022. After adjusting for the stock split above, the Holon model suggests that Tesla is under-valued, all other things remaining equal
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started