Complete the steps belon using cell referceces to given data or previeus calculationc. In seme cases, a simple cell reference is all you need. To copy/paste a formula across a row or dewn a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Exeel functien is to be ased, the directions will specify the ase of that fanction. De not type in numerical data into a cell or fanction. Instead, make a reference to the cell in which the data is found. M ake your computations enly in ibe green cells hightighted below. In all cases, unless etherwive directed, use the earliest appearance of the data in yeur formalas, useally the Given Data section. The cash flows for thece indepcndent projocts ars as follows: a. Calculate the IRR for each of the projects. ERR: b. If the discount rate for all thee projects is 10 pereett, which project or peojects would you want to undertakst? Decision c. What is the NPV of each of the projects where the apprepeiate discoant rale is 10 perceat? 20 pereent? Discount rate NPV Discukint rate NPV Requiremeats 1 Start Excel. In cell D17, by using cell reficrences and the Eucel IRR function, calculate the IRR valoe for project A. 2 Cepy the formala from cell D17 acress celumans E and F. Note: Do not enter any value for the Grocss argument of the Eveel IRR function. (I pt.) 3 V celts D22F22, interpect the IRRR values and determine whether projects A, B, and C should be acecpted or rejecled. (1 pt.) 4 la cell D29, by using relative and absolute cell references and the Excel NPV fusction, calculate the project's NPV. Copy the formula from cell D29 across columas E and F. (I pt.) 5. La coll D3, by using relative and absolute cell references and the Excel NPV function, calculate the project's NPV. Copy the foemula from cell D34 across columas E. aed F. (1 pt.) 6 Save the workbook. Close the workbook and then exit Exeel. Sabmit the workbook as directed