using the information provided in the following table, find the value of each asset. See the requirements below to apply into the excel

1. Problem 6-13 53 Requirements 1 In cell H29, by using cell references to the given data and the function PV, calculate the value of asset A. 55 Note: The result of your calculation is expected as a positive answer. 562 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 57 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 resulf of your 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