Form Jook Window Help 16 . Abs T P TH ATH-21UC 10 BIUS X2 X, AAE EEEE Step Instructions Points Possible Start Excel. Download and open the workbook named Zutter_Problem_6-13_Start. 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 answer In cell H33, by using cell references to the given data, calculate the value of asset B. 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 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 In cell H46, by using cell references to the given data and the function NPV, calculate the value of asset E. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed Total Points Default Style English (USA) . Zutter Problem 13 Instructions.docx - LibreOffice Writer nork Zutter Problem 6-13_Start. xx - LibreOffice Cake File Edit View Insert Format Styles Sheet Data Tools Window Help BDQIX DA Abs Times New Roman BIUA. 9 B BF NPV fx X -PVC ABCD E F G Problem 6-13 Valuation of assets. Using the information provided in the following table, find the value of each asset Asset A Appropriate required return 18% Cash flow End of year Amount 1 5 .000 2 5 .000 3 5 ,000 1 through $ 300 B 15% D 1 5 through 5 6 1 2 3 $ $ 8 $ 3 5 35,000 1.500 ,500 2,000 ,000 ,000 6 1,000 25 Solution > + Problem 6-13 Sheet 1 of 1 PageStyle Problem 6-13 Type here to search OG DE 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 10.-Dax & Asal Abs Times New Roman 14 B IULARE S E H29 fx X 1 A B C D E 1 | 26 27 PV of Cash Flows Asset 29 End of Year Amount 1 S S .000 255.000 $ 5,000 30 - 31 32 33 1 300 35 36 5 $ 35,000 1-5 6 $ $ 1,500 8,500 PAMTES 1296 1.500 7.000 2.000 3,000 3.000 7000 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 + Problem 6-13 Sheet 1 of 1 PageStyle_Problem 6-13 Type here to search LOGO Jools utter Problem-13. Instructions.docxLibreOffice Writer nork Zutter Problem_6-13_Startakse - LibreOffice Cak Edit View Insert Format Styles Sheet Data HD QIXA Times New Roman 14 BI UA Window Help A, 16. 1 Abs E E20 A B C D 6 F G E 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 33, 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 awet E. 60 6 Save the workbook. Close the workbook and then exit Excel Submit the workbook as directed. S&Sage + Problem 6-13 Sheet 1 of 1 Page Style Problem 5-13 Engli Type here to search
