Tesla just demonstrated their Tesla Bot at Al Day 2022. Always the risk takers, they debuted...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tesla just demonstrated their Tesla Bot at Al Day 2022. Always the risk takers, they debuted the robot without a tether for the first time on stage - they did an easy demo so the bot wouldn't "fall on its face". Tesla wants you to help assess the Tesla Bot project. Tesla spent $1 million developing the Optimus prototype that walked on stage, $1 million each on three other prototypes, and an additional $300 million in research and development (their R&D expense for the twelve months ending June 30, 2022 was $2.883 billion). The project will officially begin (t=0) in January 2023. At the end of 2027 (t=5), Tesla expects this Bot 1.0 project to end and make way for Bot 2.0. The tooling and equipment required for producing the Bots will cost $2.5 billion. The tooling and equipment is classified as a seven-year asset and will be depreciated using Modified ACRS depreciation (see Table 10.7); no bonus depreciation will be used. The estimated market value of the tooling and equipment at the end of the project is $250 million. Tesla plans to make millions of Bots (true story). Their goal, is to get 700,000 of them produced and sold in the first 5 years. In year one, Tesla thinks they can sell 60,000 Bots. The following four years they expect quantity sold to grow by 40% per year. Tesla believes that the Tesla Bot will sell for $20,000. Tesla doesn't have much experience producing robots and there will be a host of challenges involved in giving the consumer what they might want in a robot. But Tesla believes they can take advantage of hardware, software, manufacturing and supply chain advantages developed for its car business. Tesla thinks the variable costs will be $13,000. Fixed costs for the Tesla Bot production are estimated to be $9.5 million per year. Net working capital for the Bot project will be 25% of sales and will occur with the timing of the cash flows for the year. There is no initial outlay for NWC; changes in NWC will first occur in year one with the first year's sales. Tesla's tax rate is 11% and they have a required return of 22%. These Bots need charging! Tesla thinks that Bots will often be bought with Powerwalls, maybe around 50% of the Bots will be also include a Powerwall sale. While a one-battery Powerwall usually sells for $11,500, Tesla will offer a discount of 20% if you buy a Powerwall with your Bot. Variable costs for the Powerwalls are $7,500. There are no fixed costs, investments in NWC, or capital expenditures associated with the additional Powerwall sales. a) What is the payback period of the Tesla Bot? b) What is the profitability index of the project? c) What is the IRR of the project? d) What is the NPV of the project? e) Based on your answers for a-d, what would you suggest Tesla do knowing that Elon is VERY determined to get the Tesla Bot to the market? PART 2: Tesla is pretty unsure about their sales projections. They aren't big spenders in terms of marketing research, and the Tesla Bot is a big question mark in terms of demand and the going rate for a Bot like this is tough to assess. They need you to analyze how changes in the price of the Bot as well as changes in the quantity sold will affect the NPV of the project. a) How sensitive is the NPV to changes in price? b) How sensitive is the NPV to changes in quantity sold? (same % change in sales each year) c) Based on a and b, what additional information would you give Tesla that might help them make a decision regarding the Tesla Bot. ADDITIONAL INSTRUCTIONS Part of what you will be graded on is your Excel proficiency. An excellent assignment would have: A title at the top of the page Part 1 in a single Excel tab and Part 2 in a single tab Changes in inputs that flow through and update the entire spreadsheet ● Attractive ● ● ● ● ● ● Everything understandable and easy to navigate No values typed into Excel more than once No results calculated more than once (in other words, previously calculated results can be referenced, but not recalculated) Tesla just demonstrated their Tesla Bot at Al Day 2022. Always the risk takers, they debuted the robot without a tether for the first time on stage - they did an easy demo so the bot wouldn't "fall on its face". Tesla wants you to help assess the Tesla Bot project. Tesla spent $1 million developing the Optimus prototype that walked on stage, $1 million each on three other prototypes, and an additional $300 million in research and development (their R&D expense for the twelve months ending June 30, 2022 was $2.883 billion). The project will officially begin (t=0) in January 2023. At the end of 2027 (t=5), Tesla expects this Bot 1.0 project to end and make way for Bot 2.0. The tooling and equipment required for producing the Bots will cost $2.5 billion. The tooling and equipment is classified as a seven-year asset and will be depreciated using Modified ACRS depreciation (see Table 10.7); no bonus depreciation will be used. The estimated market value of the tooling and equipment at the end of the project is $250 million. Tesla plans to make millions of Bots (true story). Their goal, is to get 700,000 of them produced and sold in the first 5 years. In year one, Tesla thinks they can sell 60,000 Bots. The following four years they expect quantity sold to grow by 40% per year. Tesla believes that the Tesla Bot will sell for $20,000. Tesla doesn't have much experience producing robots and there will be a host of challenges involved in giving the consumer what they might want in a robot. But Tesla believes they can take advantage of hardware, software, manufacturing and supply chain advantages developed for its car business. Tesla thinks the variable costs will be $13,000. Fixed costs for the Tesla Bot production are estimated to be $9.5 million per year. Net working capital for the Bot project will be 25% of sales and will occur with the timing of the cash flows for the year. There is no initial outlay for NWC; changes in NWC will first occur in year one with the first year's sales. Tesla's tax rate is 11% and they have a required return of 22%. These Bots need charging! Tesla thinks that Bots will often be bought with Powerwalls, maybe around 50% of the Bots will be also include a Powerwall sale. While a one-battery Powerwall usually sells for $11,500, Tesla will offer a discount of 20% if you buy a Powerwall with your Bot. Variable costs for the Powerwalls are $7,500. There are no fixed costs, investments in NWC, or capital expenditures associated with the additional Powerwall sales. a) What is the payback period of the Tesla Bot? b) What is the profitability index of the project? c) What is the IRR of the project? d) What is the NPV of the project? e) Based on your answers for a-d, what would you suggest Tesla do knowing that Elon is VERY determined to get the Tesla Bot to the market? PART 2: Tesla is pretty unsure about their sales projections. They aren't big spenders in terms of marketing research, and the Tesla Bot is a big question mark in terms of demand and the going rate for a Bot like this is tough to assess. They need you to analyze how changes in the price of the Bot as well as changes in the quantity sold will affect the NPV of the project. a) How sensitive is the NPV to changes in price? b) How sensitive is the NPV to changes in quantity sold? (same % change in sales each year) c) Based on a and b, what additional information would you give Tesla that might help them make a decision regarding the Tesla Bot. ADDITIONAL INSTRUCTIONS Part of what you will be graded on is your Excel proficiency. An excellent assignment would have: A title at the top of the page Part 1 in a single Excel tab and Part 2 in a single tab Changes in inputs that flow through and update the entire spreadsheet ● Attractive ● ● ● ● ● ● Everything understandable and easy to navigate No values typed into Excel more than once No results calculated more than once (in other words, previously calculated results can be referenced, but not recalculated)
Expert Answer:
Answer rating: 100% (QA)
ANSWER Part 1 a The payback period of the Tesla Bot is 37 years b The profitability index of the project is 158 c The IRR of the project is 271 d The NPV of the project is 139 million e Based on the a... View the full answer
Related Book For
Project Management The Managerial Process
ISBN: 9781260570434
8th Edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these accounting questions
-
The owner now wants you to help him analyze his sales data. The restaurant is famous for its Lobo lobster roll. You were given some information based on which you deduced that the demand for the...
-
George plc adopted IFRS for the first time on 1 January 2008 and has three different instruments whose accounting George is concerned will change as a result of the adoption of the standard. The...
-
Pine Valley Furniture wants you to help design a data mart for analysis of sales. The subjects of the f data mart are as follows: Salesperson..Attributes: Salespersons, Years with PVFC,...
-
trade on the common stock of Taz, Inc. that have a strike price of $ 51.00 and a premium of $ 1.00 . In each of the next four parts, calculate the net profit (or loss) on the option position. Note:...
-
List and discuss three ways to ensure the overall quality of a structure chart.
-
According to Pizza Marketing Quarterly, the number of U.S. Domino's Pizza stores grew from 4818 in 2001 to 4986 in 2013. If the number of stores continues to grow linearly, when will there be 5100...
-
Predict the value of y when x1 = 20, x2 = 20, and x3 = 30. Exercises 1115 refer to the following data set: x1 *2 x3 69.8 7.9 37.3 62.4 32.3 9.3 20.2 40.7 66.9 13.3 30.5 48.7 87.5 27.4 38.8 35.8 93.5...
-
The term churn is very important to managers in the cellular phone business. Churning occurs when a customer stops using one companys service and switches to another companys service. Obviously,...
-
6. a. Calculate and display the first 50 autocorrelations for the four data series in the table for this exercise, labeled A, B, C, and D; consider each of the four data series to be a quarterly time...
-
The 'estimating trumpet' illustrates tolerances and expectations around levels of estimating accuracy across the life cycle. How do the tolerances resonate with your organisation's expectations...
-
Q No 09. Apply the superposition principle to find Vo in the following circuit? (35 marks) ww- 2 A 4 20 V 1A 3 ww
-
There has been a great deal of movement of physicians across borders within the European Union, and this migration has raised concerns about patient safety and quality of care. Some member states...
-
Oak City issued a purchase order for supplies with an estimated cost of $5,000. When the supplies and accompanying invoice were received, the invoice indicated a $4,950 actual price. What amount...
-
The following paragraphs contain a variety of errors, potentially involving grammar, capitalization, punctuation, abbreviation, number style, word division, or vocabulary. Identify them using...
-
Revenue of a governmental units special revenue fund should be recognized in the period in which the a. Revenue becomes available and measurable. b. Revenue becomes available for appropriation. c....
-
Rock Inc. is a manufacturer. It incurred numerous overhead costs this year. How should it treat the costs in determining its inventory?
-
J-Mark Superstores provides the following selected financial data. 2024 2023 Cash and cash equivalents $ 852,540 $ 750,235 Short-term investments 45,050 39,194 Accounts receivable 1,120,545 1,030,901...
-
In exchange for land, the company received a 12-month note on January 1. The face amount of the note is $1,000, and the stated rate of interest is 13%, compounded annually. The 13% rate is equal to...
-
What do you think Dan Gold is referring to when he argues that all parties must make a concerted effort to work as partners?
-
How did Singer establish effective patterns of communication?
-
How does the nominal group technique prevent groupthink from occurring on a project?
-
8P1 In Exercises 1722, evaluate the permutation.
-
45P5 In Exercises 1722, evaluate the permutation.
-
Let A and B be events with P (A) = 0.2 and P (B) = 0.9. Assume that A and B are independent. Find P (A and B).
Study smarter with the SolutionInn App