mba-662-case-sutdy-ii-historical-datafall-2021-ayi3jzg4 Q ~ Search Sheet Home Insert Draw Page Layout Formulas Data Review View o+ Share Cut Calibri (Body) 11 A- A Wrap Text Number _ AutoSum Copy Fill AP . Q. Paste B Merge & Center $ % > .00 Conditional Format Cell Insert Delete Format Sort & Find & Format Formatting as Table Styles Clear Filter Select N3 X V j fx 1.0128 A D E F G H K M N O P Q R S T U V W X Z 2 YEAR MKT INDEX T-BILLS STOCK Year mkt index t bills stock Year mkt index t bills stock 3 1927 30.85 3.12 33.97 1969 17.2 6.58 10.62 2011 .97 0.04 1.01 4 1928 34.8 3.56 38.44 1970 -5.65 6.52 0.87 2012 16.01 0.06 16.07 5 1929 -17.9 4.75 -13.15 1971 11.65 4.39 16.04 2013 35.15 0.03 35 .18 1930 -30.77 2.41 -28.36 1972 12.97 3.84 16.81 2014 11.35 0.0 11.37 7 1931 -44.8 1.07 43.73 1973 -24.69 6.93 -17.76 2015 -0.2 10.0 -0.19 8 1932 9.45 0.96 -8.49 1974 -35.7 8.00 -27.70 2016 13.22 10.19 13.41 9 1933 56.0 0.30 56.38 1975 32.35 5.80 38.15 10 1934 4.42 0.16 4.58 1976 21.9 5.08 26.98 11 1935 44.35 0.17 44.52 1977 -8.19 5.12 -3.07 12 193 32.44 BT'0 32.62 1978 1.04 7.18 8.22 13 1937 -34.83 ).31 -34.52 1979 13.33 10.38 23.71 14 1938 27.95 -0.02 27.93 1980 22.1 11.24 3.34 15 1939 2.95 0.02 2.97 1981 -18.05 14.71 -3.34 16 1940 6.93 0.00 -6.93 1982 10.78 10.54 21.32 17 1941 -10.14 0.06 -10.0 1983 14.41 8.80 23.21 18 1942 15.75 .27 16.02 1984 4.76 9.85 5.09 19 1943 28.23 0.35 28.58 1985 24.63 7.72 32.35 20 1944 21.12 0.33 21.45 1986 10.41 6.16 16.57 21 1945 37.72 0.33 38.05 1987 .3.51 5.47 1.96 22 1946 -6.08 .35 -5.73 1988 11.55 6.35 17.90 23 1947 3.22 0.50 3.72 1989 20.51 8.37 28.88 24 1948 1.33 0.81 2.14 1990 -13.84 7.81 -6.03 25 1949 19.23 1.10 20.33 1991 29.1 5.60 34,70 26 1950 28.26 1.20 29.46 1992 6.41 3.51 9.92 27 1951 19.09 1.49 20.58 1993 8.37 2.90 11.27 28 1952 11.89 1.66 13.55 1994 4.11 3.90 -0.21 29 1953 -1.15 1.82 0.67 1995 31.04 5.60 36.64 30 1954 49.28 0.86 50.14 1996 16.25 5.21 21.46 31 1955 23.76 1.57 25.33 1997 26.07 5.26 31.33 32 195 5.83 2.46 8.29 1998 19.41 4.86 24.27 33 1957 -13.27 3.14 -10.13 1999 20.21 4.68 24.89 34 1958 43.46 1.54 45.00 2000 -16.71 5.89 -10.82 35 1959 9.79 2.95 12.74 2001 -14.78 3.78 -11.00 36 1960 -1.73 2.66 0.93 2002 22.91 1.63 -21.28 37 1961 24.88 2.13 27.01 2003 30.74 1.02 31.76 38 1962 -12.28 2.73 -9.55 1004 10.69 1.20 11.89 39 1963 17.92 3.12 21.04 2005 3.21 2.96 6.17 40 1964 12.66 3.54 16.20 2006 10.58 4.79 15.37 41 1965 10.58 3.93 14.51 2007 0.83 4.67 5.50 42 196 -13.54 4.76 -8,78 2008 -38.39 1.47 -36.92 43 1967 24 4.21 28.21 2009 29.05 0.10 29.15 44 1968 19.02 5.21 14.23 2010 17.68 0.12 17.80 historical data + Ready + 100%