| | Year | Q | Quartely return - CRE_Atlanta_GA | Quarterly return - CRE_Denver_CO | Quarterly return - CRE_USA | Inflation index |
| | 1977 | 4 | | | | 100.00 |
| | 1978 | 1 | 3.24% | 2.58% | 2.90% | 102.09 | | | | a. Correlation between Altalnta and Denver for the 1990:1-2016:1 time period |
| | | 2 | 1.76% | 2.25% | 3.07% | 104.99 |
| | | 3 | 1.54% | 8.50% | 3.39% | 107.09 |
| | | 4 | 3.98% | 9.50% | 5.89% | 109.02 | | | | b. Correlation between Denver and the USA for the 1978:1- 2016:1 time period |
| | 1979 | 1 | 2.75% | 4.09% | 3.81% | 112.40 |
| | | 2 | 3.33% | 1.82% | 4.32% | 116.43 |
| | | 3 | 2.76% | 2.23% | 4.75% | 120.13 | | | | c. Correlation between USA and inflation rate for the 1995:1 - 2016:1 time period |
| | | 4 | 8.68% | 6.97% | 6.19% | 123.51 |
| | 1980 | 1 | 2.15% | 5.00% | 5.54% | 128.99 |
| | | 2 | 3.27% | 2.77% | 2.36% | 133.17 | | | | d. The annual standard deviation of returns for the USA for the 1990:1-2016:1 time period |
| | | 3 | 2.17% | 2.21% | 3.79% | 135.27 |
| | | 4 | 6.82% | 9.43% | 5.32% | 138.97 |
| | 1981 | 1 | 2.21% | 6.71% | 2.96% | 142.51 | | | | e. The annual standard deviation of returns for the USA for a 4-year holding period for the 1990:1-2016:1 time period |
| | | 2 | 3.13% | 2.63% | 4.23% | 145.89 |
| | | 3 | 0.63% | 0.59% | 3.21% | 150.08 |
| | | 4 | 5.61% | 27.87% | 5.29% | 151.37 | | | | f. The geometric average USA annual returns for the 1990:1-2016:1 time period |
| | 1982 | 1 | 2.43% | 1.73% | 2.49% | 152.17 |
| | | 2 | 3.30% | 0.40% | 2.07% | 156.20 |
| | | 3 | 2.48% | 2.69% | 1.52% | 157.65 |
| | | 4 | 2.97% | 0.91% | 3.04% | 157.17 |
| | 1983 | 1 | 1.74% | 1.89% | 1.75% | 157.65 |
| | | 2 | 3.25% | 1.47% | 2.54% | 160.23 |
| | | 3 | 4.52% | 2.06% | 2.96% | 162.16 |
| | | 4 | 4.30% | 4.10% | 5.31% | 163.12 |
| | 1984 | 1 | 2.99% | 2.24% | 3.35% | 165.22 |
| | | 2 | 4.14% | 3.78% | 3.16% | 166.99 |
| | | 3 | 2.56% | 0.45% | 2.46% | 169.08 |
| | | 4 | 3.48% | 0.99% | 4.21% | 169.57 |
| | 1985 | 1 | 4.30% | -0.95% | 2.08% | 171.34 |
| | | 2 | 3.53% | 1.89% | 2.60% | 173.27 |
| | | 3 | 1.58% | 1.31% | 2.39% | 174.40 |
| | | 4 | 4.11% | 4.31% | 3.73% | 176.01 |
| | 1986 | 1 | 2.90% | 0.46% | 2.03% | 175.20 |
| | | 2 | 2.49% | 1.49% | 1.96% | 176.33 |
| | | 3 | 2.82% | -1.50% | 1.50% | 177.46 |
| | | 4 | 0.97% | -1.94% | 2.57% | 177.94 |
| | 1987 | 1 | 1.35% | 1.28% | 1.83% | 180.52 |
| | | 2 | 0.71% | -1.81% | 1.19% | 182.77 |
| | | 3 | 0.27% | 0.24% | 2.09% | 185.19 |
| | | 4 | 0.74% | -1.11% | 2.67% | 185.83 |
| | 1988 | 1 | 1.22% | 0.63% | 1.84% | 187.60 |
| | | 2 | 1.39% | -0.43% | 2.00% | 190.02 |
| | | 3 | 0.30% | 0.68% | 2.39% | 192.91 |
| | | 4 | 1.39% | 2.11% | 3.07% | 194.04 |
| | 1989 | 1 | 2.29% | 0.56% | 1.75% | 196.94 |
| | | 2 | -0.24% | 0.78% | 2.00% | 199.84 |
| | | 3 | 0.55% | 1.68% | 2.05% | 201.29 |
| | | 4 | 0.76% | -3.46% | 1.75% | 203.06 |
| | 1990 | 1 | 1.90% | 0.34% | 1.38% | 207.25 |
| | | 2 | 0.25% | 1.28% | 1.52% | 209.18 |
| | | 3 | -2.18% | -0.10% | 0.84% | 213.69 |
| | | 4 | -1.87% | -3.34% | -1.43% | 215.46 |
| | 1991 | 1 | -2.23% | -2.10% | 0.05% | 217.39 |
| | | 2 | 0.70% | -0.51% | 0.01% | 219.00 |
| | | 3 | -1.05% | -0.31% | -0.33% | 220.93 |
| | | 4 | -6.05% | -4.34% | -5.33% | 222.06 |
| | 1992 | 1 | 0.41% | -0.83% | -0.03% | 224.32 |
| | | 2 | -0.79% | 0.34% | -1.03% | 225.76 |
| | | 3 | 0.20% | -1.24% | -0.44% | 227.54 |
| | | 4 | 0.13% | -1.65% | -2.81% | 228.50 |
| | 1993 | 1 | 1.84% | 1.79% | 0.77% | 231.24 |
| | | 2 | 2.34% | -8.31% | -0.24% | 232.53 |
| | | 3 | 2.06% | 1.84% | 1.10% | 233.66 |
| | | 4 | 2.84% | 1.66% | -0.25% | 234.78 |
| | 1994 | 1 | 1.98% | 1.98% | 1.31% | 237.04 |
| | | 2 | 3.74% | 3.35% | 1.54% | 238.33 |
| | | 3 | 3.69% | 2.77% | 1.51% | 240.58 |
| | | 4 | 4.15% | 4.96% | 1.88% | 241.06 |
| | 1995 | 1 | 3.39% | 2.43% | 2.11% | 243.80 |
| | | 2 | 3.31% | 2.06% | 2.08% | 245.57 |
| | | 3 | 2.85% | 2.53% | 2.06% | 246.70 |
| | | 4 | 3.09% | -1.15% | 1.09% | 247.18 |
| | 1996 | 1 | 2.57% | 2.33% | 2.40% | 250.72 |
| | | 2 | 3.04% | 3.06% | 2.29% | 252.33 |
| | | 3 | 2.39% | 2.48% | 2.63% | 254.11 |
| | | 4 | 4.58% | 2.74% | 2.61% | 255.39 |
| | 1997 | 1 | 2.46% | 2.80% | 2.34% | 257.65 |
| | | 2 | 2.72% | 2.68% | 2.82% | 258.13 |
| | | 3 | 3.65% | 2.75% | 3.38% | 259.58 |
| | | 4 | 5.35% | 3.63% | 4.71% | 259.74 |
| | 1998 | 1 | 2.36% | 5.43% | 4.14% | 261.19 |
| | | 2 | 3.73% | 6.67% | 4.19% | 262.48 |
| | | 3 | 3.06% | 3.30% | 3.46% | 263.45 |
| | | 4 | 2.55% | 3.15% | 3.55% | 263.93 |
| | 1999 | 1 | 2.58% | 3.03% | 2.59% | 265.70 |
| | | 2 | 2.05% | 3.12% | 2.62% | 267.63 |
| | | 3 | 2.64% | 3.71% | 2.81% | 270.37 |
| | | 4 | 2.37% | 2.55% | 2.89% | 271.01 |
| | 2000 | 1 | 2.12% | 4.09% | 2.40% | 275.68 |
| | | 2 | 2.39% | 3.78% | 3.05% | 277.62 |
| | | 3 | 1.99% | 1.84% | 2.94% | 279.71 |
| | | 4 | 2.35% | 2.72% | 3.33% | 280.19 |
| | 2001 | 1 | 2.24% | 2.05% | 2.36% | 283.74 |
| | | 2 | 2.00% | 1.84% | 2.47% | 286.63 |
| | | 3 | 1.53% | 0.75% | 1.60% | 287.12 |
| | | 4 | 0.02% | 0.32% | 0.67% | 284.54 |
| | 2002 | 1 | 1.36% | 2.34% | 1.51% | 287.92 |
| | | 2 | 1.18% | 1.10% | 1.61% | 289.69 |
| | | 3 | 1.02% | -0.07% | 1.79% | 291.47 |
| | | 4 | 0.30% | 0.35% | 1.67% | 291.30 |
| | 2003 | 1 | 0.81% | 1.12% | 1.88% | 296.62 |
| | | 2 | 1.39% | 0.93% | 2.09% | 295.81 |
| | | 3 | 0.87% | 2.64% | 1.97% | 298.23 |
| | | 4 | 1.61% | 1.16% | 2.76% | 296.78 |
| | 2004 | 1 | 2.27% | 1.13% | 2.56% | 301.77 |
| | | 2 | 2.00% | 1.39% | 3.13% | 305.48 |
| | | 3 | 2.73% | 3.61% | 3.42% | 305.80 |
| | | 4 | 3.78% | 2.07% | 4.66% | 306.44 |
| | 2005 | 1 | 2.47% | 4.47% | 3.51% | 311.27 |
| | | 2 | 4.05% | 4.24% | 5.34% | 313.20 |
| | | 3 | 4.10% | 4.78% | 4.44% | 320.13 |
| | | 4 | 4.76% | 3.85% | 5.43% | 316.91 |
| | 2006 | 1 | 3.07% | 3.00% | 3.62% | 321.74 |
| | | 2 | 4.06% | 4.06% | 4.01% | 326.73 |
| | | 3 | 3.54% | 3.10% | 3.51% | 326.73 |
| | | 4 | 3.10% | 3.85% | 4.51% | 324.96 |
| | 2007 | 1 | 2.59% | 3.33% | 3.62% | 330.68 |
| | | 2 | 3.18% | 5.01% | 4.59% | 335.51 |
| | | 3 | 1.95% | 2.63% | 3.56% | 335.73 |
| | | 4 | 1.82% | 3.47% | 3.21% | 338.22 |
| | 2008 | 1 | 1.63% | 1.20% | 1.60% | 343.85 |
| | | 2 | 0.36% | 1.80% | 0.56% | 352.36 |
| | | 3 | -0.37% | 0.22% | -0.17% | 352.31 |
| | | 4 | -7.03% | -6.04% | -8.29% | 338.53 |
| | 2009 | 1 | -7.43% | -7.60% | -7.33% | 342.53 |
| | | 2 | -5.30% | -4.56% | -5.20% | 347.33 |
| | | 3 | -3.05% | -2.75% | -3.32% | 347.78 |
| | | 4 | -2.81% | -1.68% | -2.11% | 347.74 |
| | 2010 | 1 | 0.95% | 1.04% | 0.76% | 350.45 |
| | | 2 | 2.29% | 3.69% | 3.31% | 350.99 |
| | | 3 | 3.24% | 4.18% | 3.86% | 351.75 |
| | | 4 | 2.76% | 6.35% | 4.62% | 352.95 |
| | 2011 | 1 | 2.79% | 3.59% | 3.36% | 359.85 |
| | | 2 | 3.20% | 3.67% | 3.94% | 363.48 |
| | | 3 | 2.80% | 3.48% | 3.30% | 365.36 |
| | | 4 | 3.01% | 3.85% | 2.96% | 363.40 |
| | 2012 | 1 | 2.26% | 2.87% | 2.59% | 369.39 |
| | | 2 | 3.25% | 3.68% | 2.68% | 369.53 |
| | | 3 | 2.14% | 2.88% | 2.34% | 372.64 |
| | | 4 | 1.97% | 3.49% | 2.54% | 369.73 |
| | 2013 | 1 | 2.28% | 2.76% | 2.57% | 374.84 |
| | | 2 | 2.40% | 3.85% | 2.87% | 376.01 |
| | | 3 | 2.68% | 3.35% | 2.59% | 377.05 |
| | | 4 | 3.22% | 4.22% | 2.53% | 375.28 |
| | 2014 | 1 | 2.47% | 2.97% | 2.74% | 380.50 |
| | | 2 | 3.57% | 3.44% | 2.91% | 383.81 |
| | | 3 | 3.06% | 3.56% | 2.63% | 383.31 |
| | | 4 | 4.22% | 4.06% | 3.04% | 378.12 |
| | 2015 | 1 | 4.16% | 3.28% | 3.57% | 380.23 |
| | | 2 | 3.63% | 3.94% | 3.14% | 384.29 |
| | | 3 | 3.72% | 3.75% | 3.09% | 383.17 |
| | | 4 | 4.08% | 3.83% | 2.91% | 380.88 |
| | 2016 | 1 | 2.30% | 2.49% | 2.21% | 385.29 |
REE2021
Homework-REE6935-Spring21-Excel.xlsx
