[ ] 3 3 G [} 1 Problem 10-28 Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. The table containing the realized return of the S&P 500 from 1929-2014 is given below. Starting in 1929, divide the sample into four periods of 20 years each. For each 20-year period, calculate the final amount an investor would have eamed given a $1000 initial investment. Also express your answer as an annualized return. Initial investment Number of years Year S&P 500 1+S &P Return 1926 [ oam4| 11114 [ 1 1927 1928 1929 1930 1931 0438 0.5614f 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 [ 04969 1.1969) 1945 1946 1947 19498 [ 005100 1.0510] 1949 1950 1951 1952 01850 1.1850] 1953 [ -0.0110] 0.989 1954 0.5240 1.5240 . ] \f1998 0.2858 1.2858 1999 [ 02104 1.2104] 2000 2001 2002 2003 2004 2005 2006 01580 1.1580] 2007 0.0549] 1.0549] 2008 2000 [ 0.2646] 1.2646] 2000 0.1506) 2011 2012 2013 2014 Final value of initial Period investment Annualized return 1929 - 1948 1949 - 1968 1969 - 1988 1989 - 2008 . Start Excel completed. . In cell D101, by using cell references and the function PRODUCT, calculate the final value of initial investment for years from 1929 to 1948 (1 pt.). . Similarly, calculate the final value of initial investment for each of the other 20-year periods in cells D102:D104 (1 pt.). * In cell E101, by using cell references and the function PRODUCT, calculate the annualized return for years from 1929 to 1948 (1 pt.). . Similarly, calculate the annualized return for each of the other 20-year periods in cells E102:E104 (1 pt.). . Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed