Instructions Start Excel. Download and open the workbook named: Zutter_Problem 5-30 Start.xlsx In cell E22, by using cell references to the given data and the function NPV, calculate the net present value of project A In cell E32, by using cell references to the given data and the function NPV, calculate the net present value of project B. In cell E46, by using cell references to the given data and the function NPV, calculate the net present value of project C Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. A B Value of mixed streams. Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12 % 4 5 A 6 Year Cash flow Year Cash flow Year Cash flow 1 $ 10,000 $10,000/yr 8,000/yr 1 -2,000 3,000 4,000 7 1-5 2 2-5 5,000/yr 7,000 8 6-10 9 6 10 4 6,000 11 5 8,000 12 13 Solution 14 Project A Opportunity cost 15 16 12% -2,000 CF1 CF2 17 18 3,000 CF3 CF4 CFs 19 4,000 6,000 20 21 8,000 22 Net present value A D E 22 Net present value 23 Project B Opportunity cost CF 24 25 12% $ 10,000 5,000 5,000 5,000 5,000 7,000 26 CF2 CF3 CF4 CFs CF Net present value 27 $ 28 $ 29 30 31 $ 32 33 Project C Opportunity cost CF1 CF2 CF3 34 12% 35 10,000 10,000 36 37 S 38 $ 10,000 10,000 10,000 8,000 8,000 8,000 39 CF4 $ CFs CF6 CF7 40 41 42 CFs CF9 CF 10 Net present value 43 8,000 8,000 44 $ 45 46