Please solve using excel functions! requirements are listed on the bottom. Please show functions!

D 4. AB E F G H 1 Problem 6-13 2 3 Valuation of assets. Using the information provided in the following table, find the value of each asset. 4 5 6 Asset Appropriate required 18% 7 A 8 9 10 11 B C 15% 16% 12 13 14 Cash flow End of year Amount 1 $ 5,000 2 5,000 3 5,000 1 through co $ 300 1 2 3 4 5 $ 35,000 1 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 UAB E F G H 27 28 29 Asset A End of Year 1 2 3 Amount $ 5,000 $ 5,000 $ 5,000 PV of Cash Flows 3 18% N- I = 30 31 32 B 1-00 $ 300 I = 15% 35 C 1 2 3 N = I = 5 16% 36 37 38 4 5 39 $ 35,000 40 41 D $ 6 1-5 6 1,500 8,500 42 N= I= PMT = $ FV = $ 43 12% 1,500 7,000 44 45 46 E I= 14% 47 1 2 3 48 $ $ $ $ $ 2,000 3,000 5,000 7,000 4,000 1,000 49 50 4 5 6 51 $ 1 1 1 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 vour calculation is expected as a positive answer. 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 vour 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 vour calculation is expected as a positive answer. 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 directed. 1 1