E D F AB H G j K Points 1 1 1 Requirements 1 In cell H29, by using cell references to the given data and the function PV, calculate the value of asset A. Note: The result of your calculation is expected as a positive 2 In cell H33, by using cell references to the given data, calculate the value of asset B. 3 In cell H35, by using cell references to the given data, calculate the value of asset C. Note: The result of your calculation is expected as a positive answer. 4 In cell H41, by using cell references to the given data and the function PV, calculate the value of asset D. Note: The result of your calculation is expected as a positive 5 In cell H46, by using cell references to the given data and the function NPV, calculate the value of asset E. 6 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as 1 1 N15 fx B D E F G H in och Asset A return 18% 10 B 15% 16% 11 12 13 14 Cash flow End of year Amount 1 $ 5,000 2 5,000 3 5,000 1 through y s 300 1 2 3 4 5 $ 35,000 through 5 $ 1,500 6 8,500 1 $ 2,000 2 3,000 3 5,000 4 7,000 5 4,000 6 1,000 15 16 D 12% 17 18 E 14% 19 20 21 22 23 Solution 25 26 PV of Cash Flows 28 Asset 29 End of Year Amount 1 S 5,000 2 $ 5,000 3 $ 5,000 N= I= 3 18% 30 32 33 B 14 $ 300 I= 15% 34 35 C N= I= 36 16% 37 1 2 3 4 5 38 39 $ 35,000 40 D 1-5 6 1,500 8,500 42 $ N= I= PMT= $ CV 6 12% 1,500 7 A 43 D E TI G H M 34 35 36 N= I= 5 16% 37 38 1 2 3 4 5 39 40 $ 35,000 D 1-5 6 6 42 $ $ 1,500 8.500 43 N I= PMT = $ FV= $ 12% 1,500 7,000 45 46 E I= 14% 48 wwwwww 2.000 3,000 5,000 7,000 4,000 1,000 49 50 51 52