need help solving this in excel show work and explain how you got answers please.

Intro It is the end of 2021. You're a financial analyst working for Tesla Motors. The company is considering producing the new Model 2 car and is predicting the following sales (in 5 milion). Assume all cash flows occur at the end of the year. . B D E 2023 2024 2025 2026 2 Sales 210 273327.6380.36 COGS and SG&A are expected to add up to 70% of sales. After 2026. production will end and the factory will shut down. To start production at the beginning of 2023, Tesla has to invest $200 million now and $100 million in 2022 to build a new factory. After completion at the end of 2022, the factory can be depreciated straight to zero over 10 years. The factory is expected to be worth $100 million at the end of 2026. Networking 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 33% Part 1 Attempt 1/30 for 10 pts. Open a spreadsheet with a blank tab and name it CF for cash flows. Duplicate the table above and extend it to find the operating cash flow for each year . What is the operating cash flow for 2028 (in 5 million)? 0+ decimals Submit Part 2 Attempt 1/30 for 10 pts. Extend the spreadsheet to find capital investment for each year. What is capital investment for 2026 (in 5 million)? Include the after-tax salvage value of the factory and enter it with the correct sign. 0+ decimals Submit Part 3 Attempt 1/30 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 2026 (in 5 million)? 1+ decimals Submit