Given the spreadsheet, containing the realized return of the S&P 500 from 1926-2014. Starting in 1929, divide the next 80 years (1929-2008) of the sample into four periods of 20 years each. For each 20-year period, calculate the final amount an investor would have earned given a $1,500 initial investment. Also express your answer as an annualized return. If risk were eliminated by holding stocks for 20 years, what would you expect to find? What can you conclude about long-run diversification? The amount after the 1929-1948 penod is s and the return s% Round the amount to the nearest cent and the returnto four de ma places. The amount after the 1949-1968 per d is S and the retu s % Round the amount to the nearest cent and the return to our dec mal places. The amount after the 1969-1988 period is S and the return is%. (Round the amount to the nearest cent and the return to four decimal places) The amount after the 1989-2008 period s$ and the return s % Round the amount to the nearest cent and he return to four decimal places If risk were eliminated by holding stocks for 20 years, what would you expect to find? What can you conclude about long-run diversification? (Select from the drop-down menus.) If risk were eliminated by holding stocks for 20 years, you would expect to find Vreturns for all four periods, wch you S&P 500Small Stocks Corp Bonds World Portfolio Treasury BillsCPI 19260.11138 19270.37126 19280.43308 1929-0.08907 1930-0.25257 1931-0.43858 1932 -0.08861 1933 0.52895 1934 -0.02341 1935 0.47208 19360.32801 1937-0.35258 19380.33199 1939-0.0091 1940 -0.10082 1941-0.11767 19420.21076 19430.25758 19440.19694 19450.36461 1946-0.0818 1947 0.0524 19480.05099 0.031941-001188 0.03125-0.02163 0.03824-0.01229 0.047370.00746 0.02347 -0.0642 0.01023-0.09235 0.00806 -0.10465 0.00293 0.00974 0.00155 0.01286 0.001650.03175 0.00175 0.01231 0.00319 0.0304 0.00041 -0.0295 0 0.00058 0.00912 0.00042 0.0994 0.00262 0.09041 0.0034 0.02764 0.00321 0.02445 0.00321 0.02148 0.00352 0.18224 0.00461 0.08893 0.009790.02904 0.06285 0.25754 0.25326 0.33463 0.07692 0.22574 0.39305 0.04321 0.06343 0.45583 0.50216 0.08696 0.12198 0.05255 0.09728 0.25209 0.64739 0.87508 0.53403 0.26275 0.02552 0.22782 0.19283 0.04357 0.05614 1411 0.03528 0.04247 0.00008 0.13728 0.01788 0.03119 0.03365 0.03101 0.03512 0.02558 0.01189 0.19895 1 0.60408 0.82665 0.11032 0.15124 0.03196 0.02658 0.03707 19490.18065 19500.30579 19510.24553 19520.18501 1953 -0.01099 19540.52404 1955 0.31429 19560.06627 1957 -0.10853 1958 0.43344 19590.11904 19600.00483 1961 0.26811 1962-0.08784 19630.22691 19640.16358 19650.12356 1966-0.10105 19670.23942 19680.11002 1969-0.08466 1970 0.03986 19710.14325 1972 0.18936 1973 -0.14791 0.04327 0.01891 0.05421 0.01106 -0.02116 0.01213 0.05946 0.01483 0.06122 0.01642 0.00641 0.03427 0.05985 0.65232 0.0178 0.00796 0.00863-0.0079 0.015550.00478 0.02422 0.02853 0.031290.02928 0.01415 0.01796 0.02815 0.01765 0.02582 0.01301 0.021590.00713 0.02724 0.01275 0.031510.01678 0.03518 0.00963 0.03962 0.01907 0.04705 0.03476 0.041471 0.03101 0.05294 0.04637 0.06591 0.06228 0.06383 0.05524 0.04317 0.03312 0.03891 0.03413 0.07059 0.49823 0.24739 0.06581 0.01075 0.03459 0.70923 0.23303 0.03492 0.05004 0.30836 0.06722 0.06204 0.03167 0.03988 0.02082 0.06212 0.15381 0.11247 0.19405 0.36365 0.07302 0.10116 0.21283 0.13941 0.03858 0.01162 0.47611 0.32219 0.02459 0.11179 0.16347 0.19567 0.23547 0.08323 0.02987 0.35936 1974 -0.26539 1975 0.3725 19760.23675 1977 -0.07388 1978 0.0644 19790.18353 19800.32266 1981-0.05053 19820.21483 0.225 19840.06152 1985 0.31648 19860.18603 1987 0.05171 19880.16608 19890.31686 1990-0.03104 1991 0.30466 19920.07619 1993 0.10079 19940.0132 19950.37578 1996 0.2296 19970.33363 19980.28579 0.27327 0.82769 0.57116 0.19915 0.2042 0.39698 0.29141 0.14617 0.3225 0.00233 0.11039 0.14557 0.0551 0.01833 0.01558 0.04976 0.08977 0.34898 0.07317 0.17103 0.29486 0.20913 0.092040.01578 0.13793 0.1531 0.08606 0.15869 0.10642 0.14662 -0.02435 0.21991 0.04239 0.10847 0.08078 0.12328 0.05821 0.06962 0.05156 0.04824 0.05152 0.0672 0.07308 0.09035 0.1069 0.13308 0.11523 0.12521 0.14856 0.08912 0.10664 0.03797 0.088471 0.03833 0.09956 0.03943 0.07677 0.03793 0.06057 0.01089 0.05384 0.04423 0.06323 0.0442 0.08221 0.04656 0.34493 0.14712 0.02002 0.18216 0.12671 0.27721 0.03305 0.11272 0.2328 0.05773 0.02495 0.29125 0.05908 0.20288 0.01488 0.36325 0.41799 0.22075 0.13792 0.010960.0 0.20056 0.21511 0.42799 0.16764 0.2395 0.17194 0.16517 0.18966 0.0466 0.23129 0.05584 0.21318 0.13993 0.16227 0.24795 0.05507 0.03081 0.03401 0.02897 0.02899 0.02755 0.03880.02652 0.05532 0.02555 0.05145 0.03322 0.05082 0.01688 0.04781 0.01607 0.3208 0.11975 19990.21042 2000-0.09104 2001-0.11886 2002-0.22101 20030.28685 2004 0.10882 2005 0.04911 2006 0.15795 2007 0.05494 2008-0.36998 20090.26464 2010 0.15064 20110.02112 20120.16003 2013 0.32388 2014 0.13688 0.03037 0.11694 0.11461 0.11181 0.25354 0.12928 0.16521 0.04561 0.02697 0.05756 0.03384 0.03779 0.01563 0.01634 0.02357 0.01018 0.0188 0.012 0.03275 0.02963 0.03417 0.04786 0.02526 0.04675 0.04086 0.01474 0.00101 0.00097 0.02709 0.00122 0.01496 0.00043 0.02967 0.00057 0.01733 0.00028 0.01518 0.00016 0.00748 2 0.32781 0.05624 0.69151 0.31392 0.03988 0.33761 0.15247 1 0.07155 0.05017 0.16537 0.27365 0.14703 0.03067 0.11658 9 0.50814