need help woth the excel sheet

Zutter Problem6-13_Instructions.docx - LibreOffice Writer nork Zutter_Problem_6-13_Start.xlsx - LibreOffice Calc File Edit View Insert Format Styles Sheet Data Tools Window Help 1980 QXLAS.dol. Times New Roman 14 B I U A- fx - = A B C D E F G H Problem 6-13 Valuation of assets. Using the information provided in the following table, find the value of each asser Asset Appropriate required return Cash flow End of year Amount 1 $ 5,000 2 5 .000 3 5 ,000 1 through S 300 B 35.000 D 1 through 5 $ 1,500 8,500 3,000 5,000 1000 4.000 ARNARN89 Solution P of Cash Flows Asset End of Year Amount 000 5.000 Problem 6-13 Sheet 1 of 1 PageStyle_Problem 6-13 ZutterProblem6-13_Instructions.docx - LibreOffice Writer nork Zutter Problem_6-13_Start.xlsx - LibreOffice Calc File Edit View Insert Format Styles Sheet Data Tools Window Help - B all & Asal Abs Times New Roman 14 B IULARE S E H29 fx X 1 A B C D E H 26 27 28 29 PV of Cash Flows Asset End of Year 1 S 2 Amount S .000 $ 5.000 $ 5,000 31 32 33 1 $ 300 35 36 GO-> WW 5 $ 35,000 NE 1-5 6 $ $ 1,500 8,500 PMTLIS 1.500 7.000 2.000 3,000 3,000 7.000 4.000 1.000 $ $ 54 Requirements 1 1 In cell H29, by using cell references to the given data and the function PW, calculate the value of asset A + Problem 6-13 Sheet 1 of 1 PageStyle_Problem 6-13 Type here to search utter Problem - 13 Instructions.docx - LibreOffice Writer nork Zutter Problem_6-13_Startak - LibreOffice Cak Edit View insert Format Styles Sheet Data H alX Times New Romanul 14 BI UA Tools Window Help A160 Abs E F20 A B C 6 D G H 51 S 1,000 Points 56 54 Requirements 1 In cell H 29, 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 answer 2 In cell 133, 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 answer 5 In cell H 46, by using cell references to the given data and the function NPV calculate the value of asset E. 60 6 Save the workbook. Close the workbook and then excit Excel. Submit the workbook as directed. + Problem 6-13 Sheet 1 of 1 PageStyle Problem 6-13 Engla Type here to search