Intro It is the end of 2022. You're a financial analyst working for Tesla Motors. The company is considering producing the new Model Z car and is predicting the following sales in $ million). Assume all cash flows occur at the end of the year. A B D E 1 2024 2025 2026 2027 2 Sales 210 273 327.6360.36 COGS and SG&A are expected to add up to 70% of sales. After 2027, production will end and the factory will shut down. To start production at the beginning of 2024, Tesla has to invest $200 million now and $100 million in 2023 to build a new factory. After completion at the end of 2023, the factory can be depreciated straight to zero over 10 years. The factory is expected to be worth $100 million at the end of 2027. Net working capital consists mainly of inventory of car components, minus some current liabilities. Net working capital is expected to be always 15% of sales, until the last year of the project when it will all be recouped. Tesla has a weighted average cost of capital of 15% and a marginal tax rate is 24%. Part 2 B Attempt 2/10 for 10 pts. Extend the spreadsheet to find net capital spending for each year. What is net capital spending for 2027 (in $ million)? Include the after-tax salvage value of the factory and enter it with the correct sign. 0+ decimals Submit Part 3 IS Attempt 3/10 for 10 pts. Extend the spreadsheet to find the change in net working capital for each year. What is the change in net working capital for 2027 (in $ million)? 1+ decimals Submit Part 4 IB Attempt 3/10 for 10 pts. Extend the spreadsheet to find the cash flow from assets for each year. What is the CFA for 2027 (in $ million)? 0+ decimals 18 Attempt 2/10 for 10 pts. Part 5 What is the NPV of the project (in $ million)? 0+ decimals Submit