Requirements 1 Start Excel. In cell D17, by using cell references and the Excel IRR function, calculate the IRR value for project A. Copy the formula from cell D17 across columns E and F. Note: Do not enter any value for the Guess argument of the Excel IRR function. (1 pt.) In cells D22-F22, interpret the IRR values and determine whether projects A, B, and C should be accepted or rejected. (1 pt.) In cell D29, by using relative and absolute cell references and the Excel NPV function, calculate the project's NPV. Copy the formula from cell D29 across columns E and F. (1 pt.) In cell D34, by using relative and absolute cell references and the Excel NPV function, calculate the project's NPV. Copy the formula from cell D34 across columns E and F. (1 pt.) 6 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. Given Data: 0 (initial investment) Project A ($50,000.00) $10,000.00 $15,000.00 $20,000.00 $25,000.00 $30,000.00 Project B ($100,000.00) $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 Project C ($450,000.00) $200,000.00 $200,000.00 $200,000.00 $0.00 $0.00 a. Calculate the IRR for each of the projects. Project A Project B Project C IRR If the discount rate for all three projects is 10 percent, which project or projects would you want to undertake? Project A Project B Project C Decision What is the NPV of each of the projects where the appropriate discount rate is 10 percent? 20 percent? Discount rate 10% Project A Project B Project C NPV Discount rate 20% Project A Project B Project C NPV