Problem 11-12 The cash flows for three independent projects are as follows: Given Data: Project A Project B Project C Year 0 ($50,000.00) ($100,000.00) ($450,000.00) Year 1 $10,000.00 $25,000.00 $200,000.00 Year 2 $15,000.00 $25,000.00 $200,000.00 Year 3 $20,000.00 $25,000.00 $200,000.00 Year 4 $25,000.00 $25,000.00 - Year 5 $30,000.00 $25,000.00 - a. Calculate the IRR for each of the projects. Project A Project B Project C IRR b. 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 c. What is the net present value 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 Requirements 1 Start Excel. 2 In cell D17, by using cell references, calculate the IRR value for project A. Use the Excel IRR function. 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. By default, all cell references are relative references. Do not use absolute cell references. (1 pt.) 3 In cells D22-F22, interpret the IRR values and determine whether projects A, B, and C should be accepted or rejected. (1 pt.) 4 In cell D29, by using relative and absolute cell references, calculate the projects NPV. Use the Excel NPV function. Copy the formula from cell D29 across columns E and F. (1 pt.) 5 In cell D34, by using relative and absolute cell references, calculate the projects NPV. Use the Excel NPV function. 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.