Calculate the nominal and real annual rate of housing price appreciation rate for Miami and for Houston for the requested different time periods using the housing price index data and the inflation index data provided to you in tab A5 of the Excel spreadsheet. In total, you need to calculate 16 values that will appear in the 16 yellow cells of that Excel tab.
Time Period Miami Nominal Annual Price Appreciation Rate Houston Nominal Annual Price Appreciation Rate Miami Real Annual Price Appreciation Rate Houston Real Annual Price Appreciation Rate Q2 2007 - Q4 2009 (2.5 years) Q1 2002 - Q1 2006 (4 years) Q2 1986 - Q2 1995 (9 years) Q2 1978 - Q2 2018 (40 years) B C G Q 1 Year 2 1975 3 1975 3 4 1975 5 1975 6 1976 7 1976 1976 8 9 8 9 1976 1977 10 11 1977 2 D E F Miami Houston Inflation 1 52.7 2 53.6 3 54.6 4 55.5 1 34.85 51.59 55.9 2 36.04 58.32 56.8 3 36.44 58 57.6 4 37.99 57.8 58.2 1 37.12 59.94 59.5 2 39.2 65.9 60.7 3 40.28 64.23 61.4 4 41.91 67.66 62.1 1 39.72 69.45 63.4 2 43.05 74.66 65.2 3 42.34 73.44 66.5 4 45.72 76.89 67.7 1 48.42 78.71 69.8 2 48.39 83.32 72.3 3 53.62 84.67 74.6 4 4 56.79 85.55 76.7 1 58.6 88.07 80.1 12 1977 13 1977 14 1978 15 1978 2 3 16 1978 17 1978 1979 18 19 20 1979 1979 1979 21 22 1980 1980 1 58.6 22 23 8,07 91.32 1980 2 57.43 24 3 0.9 1980 1980 25 4 63.32 64.88 67.13 93.8 26 1981 1 9,81 27 1981 ? 66.9 6. 01 28 3 55.2g 9758 1981 1981 29 4 1 66.65 69.9 30 1982 1982 100:37 106.2 107.95 31 ? 0.22 32 3 105, 65 1982 1982 67.47 ,26 33 4 10781 .1 2.7 4.0 6.3 85 0.6 32 94.0 94.5 7.0 9 .6 9 5 1007 101.3 102.6 103.7 16.0 16.3 106.4 1.6 10.3 4 1 68.96 35 1983 1983 1983 ? 68.45 68,88 107.81 108.4 107.62 106.36 3 37 38 1983 4 69.11 1984 1 673 103.45 1984 7 103.37 39 40 41 3 103.95 1984 1984 4 101.38 69.56 67.03 68.46 68.91 676 66.98 42 1985 1 2 97.99 95.3 43 1985 44 1985 3 94.32 1985 7 43 44 45 3 1985 1985 95.3 94.32 92.13 4 1 ? 3 46 47 48 49 50 51 52 1986 1986 196 1986 1987 1987 1987 93.16 94.4 2.61 8.22 8.1 6.56 4 1 67.6 66.98 66.9 68.6 2 71.17 1.01 68.3 2.51 3.64 4.43 4.52 76.5 7.69 ,09 133 0.13 7 IT. 53 1987 4 83.8 81.55 81.87 4 1988 1 17.6 108.3 193 1088 15 1102 110.5 112.1 113.5 115.0 115.4 1165 118.0 1198 120.5 1223 124.1 125.0 126.1 128.7 1299 132.7 133.8 55 1988 ? 84.32 56 1988 3 5,05 85.59 57 1988 4 58 1989 1 6.37 8.45 1989 7 1989 3 81.66 0.37 59 60 61 62 63 1989 4 ,99 81.51 3.21 1990 1 91.48 1990 ? 82.82 97.53 4 1990 3 83.65 93.4 13.56 65 1990 4 83.36 1990 1990 1991 1991 3 4 1 2 3 64 55 56 57 58 59 70 1 2 3 4 1 2 3 1991 | 1991 1992 1992 1992 1992 1993 1993| 1993 1993 1994 83.65 83, 36 84, 58 | 84.73 85, 38 86, 96 87.99 87,73 89.04 89, 15 . 45 92.76 95,61 96,95 97,65 98, 55 98,84 4 93, 24 93.56 94, 46 95,65 96, 21 97, 19 98.89 98,42 100, 18 100, 07 100, 38 100, 87 101,68 12. 25 102.25 101,71 101.67| 10. 26 100 1 5 2 132.? 133.8 135.] 136.] 137.2 137.9 139.3 140.2 141.3 141.9 143.6 144.4 145.1 145.8 147.2 148.0 149.4 149.7 151.4 152.5 153.2 153.5 155. 6 3 4 1 }} 28 79 30 1994 2 1994 3 31 1994 4 98,97 100 32 1995 1995 1 2 33 11. 5 103,64 44 1995 3 101.67 102.16 102.74 _104. 24 85 1995 4 105.29 86 1996 1 106,61 5 1995 4 1 102.4 104.24 103.74 1996 1996 1996 87 7 8 11- 3 1996 4 105.29 106, 61 106.01 105,67 107.19 108.04 107.68 103.08 110.14 113.35 197 1 91 7 2 3 1997 1997 1997 1998 93 4 4 1 103.9 104.63 104.47 106, 25 107.3 108, 45 110.87 111.9 114.31 115.2 117.28 120,24 123.21 125, 95 ? 1998 1998 3 153.5 18.7 16.7 18 158.6 10.0 10.3 1612 161.3 1622 163.0 163.6 163.9 16.0 16.2 19 18.3 1712 12.4 173.7 174.0 12 1,0 97 1998 4 8 1 199 1999 9 113.35 113.3 115.91 116.32 115.6 116.9 118,65 121.2 123.9 3 100 199 3 101 1999 4 2000 1 102 103 2000 2 14 2000 3 125.16 128.15 127.26 129,24 130,99 132,03 136,29 137.76 105 2000 4 106 1 132.2 2001 2001 107 2 136.56 2001 1 106 107 201 7 136.29 137.76 19,61 108 2001 3 201 4 109 112 2002 1 111 2007 7 3 140.9 141.3 143,45 145,22 147.36 148,43 112 2002 2002 113 132.3 136.56 140.36 144.98 149,12 154.1 161.9 166.01 170 76 16.21 180.8 10.87 197.66 206, 91 220. 5 4 114 2003 1 115 2003 2 149,34 116 2003 3 150,23 117 4 118 1762 18.0 173 176.7 188 199 181.0 10.9 184.2 13.7 16.2 184.3 17.4 17 199 10.3 1933 194.5 18.8 16.8 1.8 2029 2029 2003 2004 2004 2004 1 151.72 153.28 154.66 2 3 119 120 121 122 4 2302 2004 2005 156,69 157,68 160.22 161.23 1 123 2005 2005 7 3 124 163.58 166, 15 125 2005 242.23 258, 2,27 294.66 30915 3219 331.11 4 126 2006 168,72 1 2 127 2006 2006 171.22 13.67 128 3 4 1 2 3 4 1 2 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 2011 2012 2012 2012 2012 2013 2013 2013 2013 2014 2014 2014 2014 2015 2015 3 4 1 N 3 4 1 184.29 180.57 181.79 186.15 193.27 196 205.2 210.22 217.64 222.3 228.56 236.95 242.48 244.42 251.76 260.12 265.12 272.37 277.33 283.61 289 295.67 302.09 306 313.69 182.73 225.672 183.84 229.392 186.3 229.478 187.69 231.407 189.83 229.601 191.83 232.773 195.45 233.504 200.46 234.149 205.1 233.049 209.17 236.293 217 238.343 224.51 238.031 227.68 234.812 230.27 236.119 237.35 238.638 240.63 237.945 241.86 236.525 242.67 239.261 247.59 241.038 250.61 241.428 253.22 241.432 254.5 243.524 262.22 244.737 262.74 245.708 267.44 246.524 2 2015 2015 164 165 166 167 168 169 170 3 4 1 1 2 2016 2016 2016 2016 2017 3 4 1 2 171 172 173 2017 2017 3 4 2017 N 277.33 283.61 767 768 769 170 171 172 173 174 175 2016 2016 2016 2017 2017 2017 3 4 1 289 295.67 302.09 306 N 247.59 241.038 250.61 241.428 253.22 241.432 254.5 243.524 262.22 244.737 262.74 245.708 267.44 246.524 269.76 249.554 277.07 251.989 00 4 2017 2018 313.69 319.81 1 2018 2 327.43 Time Period Miami Nominal Annual Price Appreciation Rate Houston Nominal Annual Price Appreciation Rate Miami Real Annual Price Appreciation Rate Houston Real Annual Price Appreciation Rate Q2 2007 - Q4 2009 (2.5 years) Q1 2002 - Q1 2006 (4 years) Q2 1986 - Q2 1995 (9 years) Q2 1978 - Q2 2018 (40 years) B C G Q 1 Year 2 1975 3 1975 3 4 1975 5 1975 6 1976 7 1976 1976 8 9 8 9 1976 1977 10 11 1977 2 D E F Miami Houston Inflation 1 52.7 2 53.6 3 54.6 4 55.5 1 34.85 51.59 55.9 2 36.04 58.32 56.8 3 36.44 58 57.6 4 37.99 57.8 58.2 1 37.12 59.94 59.5 2 39.2 65.9 60.7 3 40.28 64.23 61.4 4 41.91 67.66 62.1 1 39.72 69.45 63.4 2 43.05 74.66 65.2 3 42.34 73.44 66.5 4 45.72 76.89 67.7 1 48.42 78.71 69.8 2 48.39 83.32 72.3 3 53.62 84.67 74.6 4 4 56.79 85.55 76.7 1 58.6 88.07 80.1 12 1977 13 1977 14 1978 15 1978 2 3 16 1978 17 1978 1979 18 19 20 1979 1979 1979 21 22 1980 1980 1 58.6 22 23 8,07 91.32 1980 2 57.43 24 3 0.9 1980 1980 25 4 63.32 64.88 67.13 93.8 26 1981 1 9,81 27 1981 ? 66.9 6. 01 28 3 55.2g 9758 1981 1981 29 4 1 66.65 69.9 30 1982 1982 100:37 106.2 107.95 31 ? 0.22 32 3 105, 65 1982 1982 67.47 ,26 33 4 10781 .1 2.7 4.0 6.3 85 0.6 32 94.0 94.5 7.0 9 .6 9 5 1007 101.3 102.6 103.7 16.0 16.3 106.4 1.6 10.3 4 1 68.96 35 1983 1983 1983 ? 68.45 68,88 107.81 108.4 107.62 106.36 3 37 38 1983 4 69.11 1984 1 673 103.45 1984 7 103.37 39 40 41 3 103.95 1984 1984 4 101.38 69.56 67.03 68.46 68.91 676 66.98 42 1985 1 2 97.99 95.3 43 1985 44 1985 3 94.32 1985 7 43 44 45 3 1985 1985 95.3 94.32 92.13 4 1 ? 3 46 47 48 49 50 51 52 1986 1986 196 1986 1987 1987 1987 93.16 94.4 2.61 8.22 8.1 6.56 4 1 67.6 66.98 66.9 68.6 2 71.17 1.01 68.3 2.51 3.64 4.43 4.52 76.5 7.69 ,09 133 0.13 7 IT. 53 1987 4 83.8 81.55 81.87 4 1988 1 17.6 108.3 193 1088 15 1102 110.5 112.1 113.5 115.0 115.4 1165 118.0 1198 120.5 1223 124.1 125.0 126.1 128.7 1299 132.7 133.8 55 1988 ? 84.32 56 1988 3 5,05 85.59 57 1988 4 58 1989 1 6.37 8.45 1989 7 1989 3 81.66 0.37 59 60 61 62 63 1989 4 ,99 81.51 3.21 1990 1 91.48 1990 ? 82.82 97.53 4 1990 3 83.65 93.4 13.56 65 1990 4 83.36 1990 1990 1991 1991 3 4 1 2 3 64 55 56 57 58 59 70 1 2 3 4 1 2 3 1991 | 1991 1992 1992 1992 1992 1993 1993| 1993 1993 1994 83.65 83, 36 84, 58 | 84.73 85, 38 86, 96 87.99 87,73 89.04 89, 15 . 45 92.76 95,61 96,95 97,65 98, 55 98,84 4 93, 24 93.56 94, 46 95,65 96, 21 97, 19 98.89 98,42 100, 18 100, 07 100, 38 100, 87 101,68 12. 25 102.25 101,71 101.67| 10. 26 100 1 5 2 132.? 133.8 135.] 136.] 137.2 137.9 139.3 140.2 141.3 141.9 143.6 144.4 145.1 145.8 147.2 148.0 149.4 149.7 151.4 152.5 153.2 153.5 155. 6 3 4 1 }} 28 79 30 1994 2 1994 3 31 1994 4 98,97 100 32 1995 1995 1 2 33 11. 5 103,64 44 1995 3 101.67 102.16 102.74 _104. 24 85 1995 4 105.29 86 1996 1 106,61 5 1995 4 1 102.4 104.24 103.74 1996 1996 1996 87 7 8 11- 3 1996 4 105.29 106, 61 106.01 105,67 107.19 108.04 107.68 103.08 110.14 113.35 197 1 91 7 2 3 1997 1997 1997 1998 93 4 4 1 103.9 104.63 104.47 106, 25 107.3 108, 45 110.87 111.9 114.31 115.2 117.28 120,24 123.21 125, 95 ? 1998 1998 3 153.5 18.7 16.7 18 158.6 10.0 10.3 1612 161.3 1622 163.0 163.6 163.9 16.0 16.2 19 18.3 1712 12.4 173.7 174.0 12 1,0 97 1998 4 8 1 199 1999 9 113.35 113.3 115.91 116.32 115.6 116.9 118,65 121.2 123.9 3 100 199 3 101 1999 4 2000 1 102 103 2000 2 14 2000 3 125.16 128.15 127.26 129,24 130,99 132,03 136,29 137.76 105 2000 4 106 1 132.2 2001 2001 107 2 136.56 2001 1 106 107 201 7 136.29 137.76 19,61 108 2001 3 201 4 109 112 2002 1 111 2007 7 3 140.9 141.3 143,45 145,22 147.36 148,43 112 2002 2002 113 132.3 136.56 140.36 144.98 149,12 154.1 161.9 166.01 170 76 16.21 180.8 10.87 197.66 206, 91 220. 5 4 114 2003 1 115 2003 2 149,34 116 2003 3 150,23 117 4 118 1762 18.0 173 176.7 188 199 181.0 10.9 184.2 13.7 16.2 184.3 17.4 17 199 10.3 1933 194.5 18.8 16.8 1.8 2029 2029 2003 2004 2004 2004 1 151.72 153.28 154.66 2 3 119 120 121 122 4 2302 2004 2005 156,69 157,68 160.22 161.23 1 123 2005 2005 7 3 124 163.58 166, 15 125 2005 242.23 258, 2,27 294.66 30915 3219 331.11 4 126 2006 168,72 1 2 127 2006 2006 171.22 13.67 128 3 4 1 2 3 4 1 2 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 2011 2012 2012 2012 2012 2013 2013 2013 2013 2014 2014 2014 2014 2015 2015 3 4 1 N 3 4 1 184.29 180.57 181.79 186.15 193.27 196 205.2 210.22 217.64 222.3 228.56 236.95 242.48 244.42 251.76 260.12 265.12 272.37 277.33 283.61 289 295.67 302.09 306 313.69 182.73 225.672 183.84 229.392 186.3 229.478 187.69 231.407 189.83 229.601 191.83 232.773 195.45 233.504 200.46 234.149 205.1 233.049 209.17 236.293 217 238.343 224.51 238.031 227.68 234.812 230.27 236.119 237.35 238.638 240.63 237.945 241.86 236.525 242.67 239.261 247.59 241.038 250.61 241.428 253.22 241.432 254.5 243.524 262.22 244.737 262.74 245.708 267.44 246.524 2 2015 2015 164 165 166 167 168 169 170 3 4 1 1 2 2016 2016 2016 2016 2017 3 4 1 2 171 172 173 2017 2017 3 4 2017 N 277.33 283.61 767 768 769 170 171 172 173 174 175 2016 2016 2016 2017 2017 2017 3 4 1 289 295.67 302.09 306 N 247.59 241.038 250.61 241.428 253.22 241.432 254.5 243.524 262.22 244.737 262.74 245.708 267.44 246.524 269.76 249.554 277.07 251.989 00 4 2017 2018 313.69 319.81 1 2018 2 327.43
