Please show calculation in excel.

(a) What is the change in working capital in Year 1? million

(b) What is the change in working capital in Year 2? million

(c) What is the change in working capital in Year 3? million

(d) What is the change in working capital in Year 4? million

Compute the impact of working capital requirements on after-tax cash flow for the new division. Make sure to denote whether working capital requirements affect cash flow positively or negatively. If cash flow increases, input a positive number into the answer field. If cash flow decreases, input a negative number into the answer field. Assume that the tax rate is 20%.

(e) What is the impact of working capital requirements on after-tax cash flow in Year 1? million

(f) What is the impact of working capital requirements on after-tax cash flow in Year 2? million

(g) What is the impact of working capital requirements on after-tax cash flow in Year 3? million

(h) What is the impact of working capital requirements on after-tax cash flow in Year 4? million

A social media company is considering investing in a new augmented reality division. To evaluate this decision, the CFO first instructs the project team to forecast working capital requirements for the division. The team has developed the following projections (in millions of dollars): Year 1 2 3 4 Accounts Receivable $35 $65 $65 $80 Inventory $20 $15 $40 $20 Accounts Payable $30 $35 $45 $50 Assume that the firm currently (i.e., in Year 0) does not have any working capital invested in this new division. Calculate changes in net working capital (NWC) during the first four years of investing in the new division. Make sure to denote whether the change is positive or negative. If NWC increases, input a positive number into the answer field. If NWC decreases, input a negative number into the answer field