A B C D E F H K L Problem 8-2 Return calculations. For each of the investments shown in the following table, calculate the rate of return earned over the period. Investment A B Cash flow Beginning-of- End-of-period during period period value value -$ 800 1,100 $ 100 15.000 120,000 118,000 7.000 45,000 48.000 80 600 500 1,500 12,500 12,400 D E Solution -S Investment Cash flow during period Beginning-of-period value End-of-period value Rate of return S 800 1,100 100 S Investment Cash flow during period Beginning-of-period value End-of-period value Rate of return S S 15,000 120,000 118,000 S Investment Cash flow during period Beginning-of-period value End-of-period value Problem 8-2 7,000 45,000 48,000 Activate Go to Settin A B D E G H K L M N S Investment Cash flow during period Beginning-of-period value End-of-period value Rate of return S 7,000 45,000 48,000 s S Investment D Cash flow during period Beginning-of-period value End-of-period value Rate of return 80 600 S S 500 S Investment E Cash flow during period Beginning-of-period value End-of-period value Rate of return 1,500 12,500 $ $ 12,400 Points 1 1 Requirements 1 In cell E18, by using cell references to the given data, calculate the rate of return of investment A. 2 In cell E24, by using cell references to the given data, calculate the rate of return of investment B. 3 In cell E30, by using cell references to the given data, calculate the rate of return of investment C. 4 In cell E36, by using cell references to the given data, calculate the rate of return of investment D. 5 In cell E42, by using cell references to the given data, calculate the rate of return of investment E. 6 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 1 1 1 Activate Windows