Please show all excel formulas for each box

4 1 Your division is considering two projects. Its WACC is 12%, and the projects' after-tax cash flows (in millions 2 of dollars) would be as follows: 3 4. Expected net cash flows 5 Time Project A Project B 6 0 ($40) (S40) 7 1 $10 $25 8 2 $15 $15 9 3 $20 $13 10 $25 $11 11 12 You need to find the NPV, IRR, MIRR, Discounted Payback and NPV profile in this question. 13 14 a. Calculate the projects' NPVs, IRRS, MIRRs, and discounted paybacks. 15 WACC = 12% 16 NPVA 17 NPVB = 18 19 20 IRRA 21 IRRB = 22 23 Reinvestment rate is 8%. 24 MIRRA 25 MIRRB = 26 0 1 2 4 Project A Time period: Cash flow: PV cash flow: Disc cumul cash flow: 3 20.00 (40.00) 10.00 15.00 25.00 Paybacka: 0 1 2 3 4 Project B Time period: Cash flow: PV cash flow: Disc cumul cash flow: (40.00) 25.00 15.00 13.00 11.00 Paybackg: b. Find each projects's NPV profiles for the two projects. Identify each projects' IRRs and approximate cross-over point. Explain the significance of the cross-over points. For instance, is it better to switch from one project to another, just because the WACC changed? Project A Project B Explain: 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 16.00% 18.00% 20.00% 22.00% 24.00% 26.00% 28.00% 3 4 5 6