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
-
What is the value in responding to the proposal? How should the medical center address the lack of patient-steering mechanisms in the proposal? What type of cost proposal or cost information should...
-
At the end of the last fiscal year, Suncrest Inc. reported $ 2 3 1 million in Shareholders' Equity on its Balance Sheet. In the current fiscal year, the company reported Net Earnings ( Net Income )...
-
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 generally happens to the temperature of rising air? Of sinking air?
-
It is a common practice for managers to hold people accountable to meetstretch goals, quotas, and budgets. How can this be done in a way that does not encourage unethical behavior on the part of...
-
What is Modigliani and Millers 1977 theory based on and what conclusions do they draw?
-
You are opening a summer business, a chain of three drive-through snow-cone stands. You have hired other college students to work and have purchased a cash register with locked-in tapes. You retain...
-
re.com/courses/37318/quizzes/199385/take -In 136. IMLeagues | Eva My..... D Question 9 Assume that the average price of a new home is $158,500. If the cost of a new home is increasing at a rate of...
-
1. Is Facebook's mission statement market oriented? Explain. 2. How is Facebook's strategy driven by its mission? 3. Is it wise for Facebook to give away it technologies for free? Why or why not? 4....
-
USA Widgets Inc. is a company located in Anytown, U.S.A. and makes widgets. Foreign Importer Inc, located in the country Foreignsica, offers to import from USAWidgets Inc. 1 million widgets. USA...
-
Explain the purpose of letters for underwriters.
-
Which financial statement assertions are served by testing cutoff over investment transactions? a. Existence and completeness. b. Rights and valuation. c. Existence and rights. d. Presentation and...
-
To what does an auditor's opinion relate when an entity's financial statements are prepared on a comprehensive basis of accounting other than GAAP?
-
What is a "comprehensive basis of accounting other than GAAP"?
-
Why are costs, expenses, deferrals, and accruals often estimated to a greater extent in interim than in annual financial statements?
-
Social constructionists therapies: A. are interested in expanding clients' rigid views of the world B. closely inspect the origin of family problems C. emphasizes family interactive patterns D....
-
MgO prevents premature evaporation of Al in a furnace by maintaining the aluminum as Al2O3. Another type of matrix modifier prevents loss of signal from the atom X that readily forms the molecular...
-
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...
-
Your manager wants you to write a report detailing the internal and external benchmarks available and explaining why he should be using them in reviewing performance.
-
Identify the key priorities for a small events company which specialises in wedding planning and arrangement for each of the four dimensions of the Balanced Scorecard, identify suitable measures for...
-
Define strategic management accounting.
Study smarter with the SolutionInn App