Complete the steps below using cell references to given data or previous calculations. In some casex, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolinte cell neference or a mixed cell neference max be preferred. If a specific Excel function is to be used, the directions will specify the ase of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, wnless othenvise directed, we the carliest appearance of the data in your formulas, wnatly the Crien Data section. You are choosing between two projects, bat cas only take one. The cash flows for the projects are given in the table below: a. What are the IRRs of the two projects? b. If your discount rate is 5%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projocts differently? Project A Project B a. What are the IRRs of the two projocts? IRR project A IRR project B b. If your discount rate is 5%, what are the NPVs of the two projects? Discount rute NPV projoct A NPV project B c. The difference in the initial investment causes NPV and IRR to rank the projects differently. In this statencat TruelFalse? ments 1 In cell D15, by ueing cell references, calculate the IRR of project A (1 pe.) 2 in cell D16, by using cell references, calculute the IRR of project B (1 pL.). 3 In cell D22, by using the NPV fenction and cell references, calculate the NPV of project A (1 pt). 4 In cell D23, by using the NPY function and cell references, culoulate the NPV of project B (1 pt.). 5 In cell G27, type True or False dopending on whether the difference is the ranking of the two projects (IRR Vh. NPY) is due to the difference in the initial investment ( 1 pt.)