Intro It is the end of 2020. You're a financial analyst working for Tesla Motors. The company is considering producing the new Model Y car and is predicting the following sales (in $ million). Assume all cash flows occur at the end of the year. A 1 B C D E 2022 2023 2024 2025 120 156 187.2 205.92 Sales COGS and SG&A are expected to add up to 70% of sales. After 2025, production will end and the factory will shut down. To start production at the beginning of 2022, Tesla has to invest $200 million now and $100 million in 2021 to build a new factory. After completion at the end of 2021, the factory can be depreciated straight to zero over 10 years. The factory is expected to be worth $100 million at the end of 2025. 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 12% and a marginal tax rate is 18%. Part 2 IB | Attempt 5/10 for 10 pts. Extend the spreadsheet to find net capital spending for each year. What is net capital spending for 2025 (in $ million)? Include the after-tax salvage value of the factory and enter it with the correct sign. 0+ decimals Submit IB Part 3 Attempt 6/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 2025 (in $ million)? 1+ decimals Submit Part 4 18 Attempt 1/10 for 10 pts. Extend the spreadsheet to find the cash flow from assets for each year. What is the CFA for 2025 (in $ million)? 0+ decimals Submit IB Attempt 2/10 for 10 pts. Part 5 What is the NPV of the project (in $ million)? 0+ decimals Submit Intro It is the end of 2020. You're a financial analyst working for Tesla Motors. The company is considering producing the new Model Y car and is predicting the following sales (in $ million). Assume all cash flows occur at the end of the year. A 1 B C D E 2022 2023 2024 2025 120 156 187.2 205.92 Sales COGS and SG&A are expected to add up to 70% of sales. After 2025, production will end and the factory will shut down. To start production at the beginning of 2022, Tesla has to invest $200 million now and $100 million in 2021 to build a new factory. After completion at the end of 2021, the factory can be depreciated straight to zero over 10 years. The factory is expected to be worth $100 million at the end of 2025. 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 12% and a marginal tax rate is 18%. Part 2 IB | Attempt 5/10 for 10 pts. Extend the spreadsheet to find net capital spending for each year. What is net capital spending for 2025 (in $ million)? Include the after-tax salvage value of the factory and enter it with the correct sign. 0+ decimals Submit IB Part 3 Attempt 6/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 2025 (in $ million)? 1+ decimals Submit Part 4 18 Attempt 1/10 for 10 pts. Extend the spreadsheet to find the cash flow from assets for each year. What is the CFA for 2025 (in $ million)? 0+ decimals Submit IB Attempt 2/10 for 10 pts. Part 5 What is the NPV of the project (in $ million)? 0+ decimals Submit
