Question

calculate the present value of the annual end-of-year payments at the specified discount rate over the given For each of the investments given in the following table, period. The present value, PV, of the annual end-of-year returns at the specified discount rate over the given period for Investment Ais (Round to the nearest cent.) The present value, PV, of the annual end-of-year returns at the specified discount rate over the given period for Investment Bis S . (Round to the nearest cent.) The present value, PV, of the annual end-of-year returns at the specified discount rate over the given period for Investment Ciss The present value, PV, of the annual end-of-year returns at the specified discount rate over the given period for Investment Dis 1 (Round to the nearest cent.) (Round to the nearest cent.) The present value, PV, of the annual end-of-year returns at the specified discount rate over the given period for Investment Eis S . (Round to the nearest cent.) i Data Table - X 18% Investment Annual Payments Discount Rate Period (yr) $1,900 9% $5.900 14% S800 $14.500 2% $2.500 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Print Done

Answer 1

AA B C D E 1 Inv. Payments Rate Years PV 2 A $1,900.00 9% 3 $4,809.46 3 B $ 5,900.00 14% 15 $36,238.79 4 C $ 800.00 18% 11 $3,724.80 5 D $ 14,500.00 2% 7 $93,843.87 6 E $ 2,500.00 11% 6 $10,576.34 A B C D E 1 Inv. Payments Rate lYears IPV 2 A 11900 10.09 13 L=PV(C2,D2,-B2) 3 B 15900 0.14 15 =PV(C3,D3.-B3) 4 C 800 =PV(C4,D4,-B4) 5 D 14500 0.027 =PV(C5,D5-B5 6 E 2500 0 .11 6 =PV(C6,D6,-B6)