Need help answering the steps on the document, Exhibit 7 (also available as an Excel file on
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666bacff425c3_671666bacff343e2.jpg)
Need help answering the steps on the document,
Exhibit 7 (also available as an Excel file on Compass) provides, to the extent available, information on the number of Model S vehicles Tesla produced, beginning in Q3, 2012, and the revenues and cost of revenues, beginning in Q4 2012.
Calculate the average cost per vehicle sold for each quarter from Q4, 2012, through Q4, 2015, using the numbers for units delivered and Automotive cost of sales.
For quarters where both production and shipments are available:
Calculate the number of completed units added to inventory
Calculate the dollar amount that Finished Goods Inventory increased
Divide the dollar amount that Finished Goods Inventory increased by the number of completed units added to inventory for that quarter, to obtain a cost per vehicle added to inventory
Compare the cost per vehicle number from 1.b.iii., with the cost per vehicle sold in 1.a., above.
Evaluate and comment on the differences
From 1.a., above, or 1.b.iii., is there a downward trend in cost per vehicle? Does it seem to fit the learning curve we covered in class?
Calculate the average selling price of a Model S each quarter from Q4, 2012, through Q4, 2015, using the Net Automotive Sales number (after deducting environmental and other credits). Did the average selling price increase over that period, decrease, or remain about the same, with some fluctuation?
Explain the limitations of trying to determine whether costs are declining when using the limited information available in an annual report.
Exhibit 1 provides examples of Teslas notes for Warranty costs and reserves. Exhibit 7 includes a summary of the warranty notes since Tesla first began selling the Model S in Q3 2012. Tesla provides a four-year, 50,000 mile warranty, but the battery and powertrain are warrantied for eight years, with unlimited mileage. Consumer Reports, which rated the Tesla Model S as the highest ranked car it has ever tested, no longer recommends the Model S because of poor reliability.
Using Exhibit 7, and any other information you can obtain, estimate whether the $180.754 million warranty reserve as of December 31, 2015, is adequate to cover warranty costs for the 112, 860 Model S vehicles Tesla has sold to date ($1,602 per vehicle, although warranties are about to expire on vehicles sold in 2012, except for the battery and powertrain). In your analysis, consider that Tesla does not have dealers, so it sometimes drives to an owners location, drops off a loaner car, and drives the owners vehicle to the nearest repair facility and then returns it to the owner once the vehicle has been repaired.
Exhibit 2 provides examples of Teslas inventory notes. Exhibit 7 includes a summary of inventory information since Tesla began selling the Model S in 2012. One way for a firm to manipulate its reported income is to build up an inventory of finished units over several quarters. For example, Tesla will incur selling, general, and administrative costs regardless of the number of vehicles sold. In most instances, it will also record depreciation expense, regardless of the vehicles sold.
After accumulating a large finished goods inventory, a firm can sell the units in inventory, together with current production, to show significantly higher revenues in one quarter, and possibly also report a profit, or at least a smaller loss, in the period when it sells the units in finished goods inventory. That may allow the firm to sell equity or debt.
Is there any indication Tesla built up a finished goods inventory, and then sold that inventory to report higher sales for one quarter, at any point in the last 3 years? If so, identify the quarters when that occurred.
Estimate the effect on the increase in Automotive Sales, Cost of Automotive Sales, and gross margin from selling units out of inventory for any quarter where that occurred.
Exhibit 3 provides examples of Teslas plant, property and equipment note, while Exhibit 7 includes a summary of that information for the past 3 years.
For each quarter, calculate the amount of plant, property, and equipment (PP&E) Tesla had available to produce one vehicle in a quarter.
Is there a trend in PP&E needed to produce one vehicle in a quarter over time?
Recalculate the PP&E per vehicle using a lag of one or two quarters (divide PP&E for a quarter by production from one or two quarters later, since additional PP&E is usually added before a significant increase in production). Does the calculation in this question, 4.c., provide better information that the calculation from question 4.a.? Explain.
Tesla plans to announce its $35,000 Model 3 on March 31, 2015. That vehicle is expected to go on sale in late 2017. To meet that date, Tesla will need to complete its Gigafactory and also build an automotive plant capable of producing 200,000-300,000 Model 3 vehicles per year.
Assume the Model 3 will require the same amount of PP&E as the Model 3, adjusted for price. That is, if the Model S sells for $105,000, assume the Model 3 will require 1/3 the PP&E as a Model S. How much will Tesla need to spend on PP&E for a Model 3 factory capable of producing 250,000 vehicles?
Major automakers have a long history of reducing production costs. For example, a mid-size Honda Accord or Toyota Camry sells for 25-30% more than an Accord or Camry from 12 years ago. However, inflation for that period was 28%, while the newer models are typically larger and have far more features than earlier models.
From your answers to previous questions for this exam, is there evidence that Tesla will be able to produce a low-cost vehicle to compete, for example, with the Chevrolet Volt or Bolt, the Nissan Leaf, or the wide range of newer model electric vehicles that other auto manufacturers plan to introduce in the next few years? Explain.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666bacff77b6d_671666bacff65832.jpg)