Tesla Valuation Model assumptions based on anaylst reports Upside YOY Revenue Growth Downside YOY Revenue Growth...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) Total SG&A in 2022 (in millions) Cost of Capital (Discount Rate) Long run growth rate All dollar figures are in millions 81462 3075 3946 12% 3% 2022 2023 40% 25% 30% 76.0% 47.0% 10.0% 5.0% 90.0% 76.0% 2023 2024 35% 20% 27% 75.0% 19.0% 8.0% 4.8% 85.0% 78.0% 2024 2025 30% 18% 25% 74.0% 21.0% 7.0% 4.5% 80.0% 79.0% 2025 2026 28% 15% 20% 74.0% 18.0% 5.0% 4.0% 75.0% 80.0% 2026 2027 25% 11% 15% 74.0% 16.0% 4.0% 3.8% 70.0% 82.0% 2027 2028 17% 8% 13% 74.0% 14.0% 3.0% 3.5% 70.0% 85.0% 2028 2029 15% 5% 10% 74.0% 12.0% 2.0% 3.0% 70.0% 85.0% 2029 2030 13% 3% 8% 74.0% 10.0% 2.0% 3.0% 70.0% 85.0% 2030 2031 10% 3% 5% 74.0% 8.0% 2.0% 3.0% 70.0% 85.0% 2031 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. 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) Total SG&A in 2022 (in millions) Cost of Capital (Discount Rate) Long run growth rate All dollar figures are in millions 81462 3075 3946 12% 3% 2022 2023 40% 25% 30% 76.0% 47.0% 10.0% 5.0% 90.0% 76.0% 2023 2024 35% 20% 27% 75.0% 19.0% 8.0% 4.8% 85.0% 78.0% 2024 2025 30% 18% 25% 74.0% 21.0% 7.0% 4.5% 80.0% 79.0% 2025 2026 28% 15% 20% 74.0% 18.0% 5.0% 4.0% 75.0% 80.0% 2026 2027 25% 11% 15% 74.0% 16.0% 4.0% 3.8% 70.0% 82.0% 2027 2028 17% 8% 13% 74.0% 14.0% 3.0% 3.5% 70.0% 85.0% 2028 2029 15% 5% 10% 74.0% 12.0% 2.0% 3.0% 70.0% 85.0% 2029 2030 13% 3% 8% 74.0% 10.0% 2.0% 3.0% 70.0% 85.0% 2030 2031 10% 3% 5% 74.0% 8.0% 2.0% 3.0% 70.0% 85.0% 2031 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.
Expert Answer:
Answer rating: 100% (QA)
To calculate the stock price in the Upside and Downside scenarios we need to apply the given revenue growth rates to estimate the future revenue of Tesla We will start with the base case assumptions p... View the full answer
Related Book For
College Accounting
ISBN: 978-1111528126
11th edition
Authors: Tracie Nobles, Cathy Scott, Douglas McQuaig, Patricia Bille
Posted Date:
Students also viewed these finance questions
-
You want to conduct a study on commuters in NYC and how muchtime they spend traveling to and from work every day. You decide towait outside the subway stations from Monday to Friday, 9am to 5pm,and...
-
What is the adiabatic form of the first law?
-
Waterbahn Waterslide Company issued 25,000 ten-year, 6 percent, $100 bonds on January 1, 2017, at face value. Interest is payable each December 31. Show the accounting equation effects and prepare...
-
Retelsdorf Ltd manufactures tablet screens. Recently, the company has been producing slightly below 75% of capacity and management is considering how to use currently unused plant capacity. One...
-
On May 10, Renn Company sold merchandise for $4,000 and accepted the customers First Business Bank MasterCard. At the end of the day, the First Business Bank MasterCard receipts were deposited in the...
-
What role does process simulation play in the optimization of energy and material efficiency in chemical processes, and how can simulation tools help identify bottlenecks and opportunities for...
-
Background: SO MUCH CANDY DATA, SERIOUSLYCandy hierarchy data for 2017 Boing Boing Halloween candy hierarchy. This is survey data over the span of 4-years. The data is split into 4 separate files....
-
Jameson Limited was involved in a mining exploration business. It commenced a project to design more efficient opal detecting equipment. The following expenditures occurred during the financial year...
-
Write a public static method named getMiddle that: takes three int arguments return an int of the middle value of the 3 arguments Example: if the three arguments are 11, 22, 33, return 22 //*...
-
Employee earnings records for Concord Company reveal the following gross earnings for four employees through the pay period of December 15. J. Seligman $91,900 L. Marshall $125,000 R. Eby $114,100 T....
-
Luthan Company uses a plantwide predetermined overhead rate of $ 2 2 . 3 0 per direct labor - hour. This predetermined rate is based on a cost formula that estimated $ 2 6 7 , 6 0 0 of total...
-
A flute may be thought of as a pipe open at both ends. When all the holes of a well-designed flute are covered and the temperature is 20.0C, it will produce sound with a frequency of 261.6 Hz (middle...
-
Demarco and Janine Jackson have been married for 2 0 years and have four children who qualify as their dependents ( Damarcus , Jasmine, Michael, and Candice ) . The Jacksons file a joint tax return....
-
.5 The following is the statement of financial position of WW Associates as at 31 December 2014: Statement of financial position as at 31 December 2014 3. ASSETS Non-current assets Machinery 25,300...
-
Refer to Exercise 8.S.I. Construct a scatterplot of the data. Does the appearance of the scatterplot indicate that the pairing was effective? Explain. Exercise 8.S.I. A volunteer working at an animal...
-
Distinguish between expenditures for ordinary repairs and extraordinary- repairs expenditures.
-
Your client is preparing financial statements to show the bank. You know that he has incurred a refrigeration repair expense during the month, but you see no such expense on the books. When you...
-
Robins Cycle Shop owns various depreciable assets, which were purchased beginning in 2006. The only record you can find on December 31, 2011 (prior to any depreciation adjustments for 2011), is the...
-
Input the other metrics from the individual tax returns (e.g., income from wages and salaries, interest earned, and estimated tax payments). a. Review the dollars horizontally across the three years...
-
Input the IRS Schedules C from the 20132015 income tax returns into a spreadsheet. a. Add percent columns to the right of dollar column for each year. b. Calculate common-sized percentages in the...
-
Go to a business library or university librarian and locate RMA Annual Financial Statement Studies or a similar publication and locate convenience stores and comparable ratios (e.g., cost of goods...
Study smarter with the SolutionInn App