Use the attached real estate data spreadsheet to discuss the Central tendency analysis of Real Estate and Macro-Economic Analysis
A B O P Q R S T U V W X Y Z AA AB AC Macroeconomic indicators Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Interest rate 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 1.75 CPI 133.6 134.5 135.4 136 136.6 136.3 137 136.8 136.2 136.6 136.4 136.4 Canada Exchange rate (CAD-USD) 1.3144 1.3169 1.3363 1.3423 1.3527 1.3087 1.3148 1.3295 1.3244 1.316 1.3289 1.2988 1.3233 Unemployment 5.8 5.8 5.8 5.7 5.4 5.5 5.7 5.7 5.5 5.6 5.9 5.6 Housing Starts 12,457 10,265 12,853 18,166 16,409 21,548 18,073 17,713 19,139 17,060 17,108 15,772 CPI 129.1 129.8 130.7 131.2 131.8 131.9 132.4 132.2 132 132.2 131.8 131.7 BC Unemployment 4.7 4.5 4.7 4.6 1.3 4.5 4.4 5 4.8 4.8 5.00 4.80 Housing Starts 3,159 2,848 2,594 4,312 4,566 5,110 4,177 2,952 3,382 2,731 3,952 3,431 Housing Market indicators Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Canada Housing Starts - Single Detached (Units) 2,353 2,026 2,543 3,564 4,401 5,232 4,608 4,910 4,716 4,359 4,323 3,874 Housing Starts - Apartment and other (Units) 7,831 6,393 8,331 11,316 9,192 13,203 10,598 9,523 11,173 9,820 9,440 8,844 Building permits Single (Units) 168 418 BC 516 752 723 778 682 662 653 623 586 490 Building permits Apartment (Units) 2,248 2,075 1,736 3,031 3,427 3,842 2,913 1,846 2,221 1,651 2,935 2,399 Canada Mortgage lending rate (%) 4.59 4.52 4.44 4.33 4.30 4.23 4.14 4.08 4.07 4.09 4.09 4.08 0.457364 -0.03856 0.076072 -0.12339 -0.02933 -0.0136A AA Vancouver Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Active listing 7125 7698 8561 8808 3988 8587 8127 8116 746 6598 5359 5206 Active listing 1465 5076 5796 5877 5980 5653 5269 5323 4770 4172 3244 3411 Sales 725 854 944 1332 1136 1314 1115 1167 1474 1276 963 757 Sales 759 873 385 1246 94 1243 1116 116 1,384 1222 1053 814 Sales to Active List Ratio 10.18% 11.09% 11.03% 15.12% 12.64% 15.30% 13.72% 14.38% 19.74% 19.34% 17.97% 14.54% Sales to Active List Ratio 17.00% 17.20% 15.27% 21.20%% 15.74% 21.99% 21.18% 21.90% 29.01% 29.29% 32.46% 23.86% Average Sales Price $1,116,200 $1,110,350 $1,110,200 $1,100,650 | $1,099,100 |$1,093,500 |$1,089,300|$1,086,850 |$1,091,050 |$1,094,100 |$1,100,950 $1, 106,850 Average Sales Price $660,300 $656,900 $656,900 $664,200 $654,700 $653,200 $654,000 $651,500 $652,500 $651,500 $656,700 $663,200 Average days on market 47 42.5 42.5 40.5 41 44.5 19.5 51.5 19 49.5 58 53.5 Average days on market 40 37 33 34 36 37 42 43 41 44 48 43 Vancouver Island Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 HPI 236.7 238.: 241.4 240.4 241.3 241 241.8 245.4 244.8 242.6 243 241.8 HP 278.4 274.4 279.6 280.3 283.7 282.1 282.3 278.6 279.8 276.9 283.9 288.3 Benchmark price $507,800 $510,800 $517,800 $512,500 $514,400 $513,700 $515,400 $523,100 $521,800 $517,100 $518,000 $515,400 Benchmark price $324,500 $319,800 $325,900 $300,700 $304,300 $302,600 $302,800 $298,900 $300,200 $297,000 $304,600 $309,300 Sales 227 308 412 459 453 413 345 342 312 237 174 Central Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Units Listed 560 398 1075 1137 1072 976 859 838 640 186 308 Inventory 2080 2325 2615 2845 2494 2809 2754 2578 2,315 2016 1697A P Q R S T V W X Y Z AA AB 21 Units Sold 264 343 424 509 451 441 516 562 383 371 271 22 List/Sales Ratio 96.74% 97.16% 96.65% 96.81% 97.02% 97.68% 97.69% 97.60% 96.47% 96.13% 96.86% 23 Average Sales Price $512,665 $539,565 $573,955 $573,926 $571,864 $559,366 $560,980 $566,090 $548,137 $615,471 $556,127 24 Median Sales Price $463,195 $500,000 $537,750 $537,000 $526,000 $519,900 $519,000 $521,750 $502,000 $538,500 $502,500 25 Days to Sell 73 67 68 59 81 65 65 66 76 75 84 35 Fraser Valley Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 36 37 Active listing 229 2507 2924 323: 3306 3200 3061 299 2,723 239 159 1744 38 Active listing 1339 1454 1602 1666 1610 1537 1454 1487 1,417 1272 389 1024 39 Sales 354 462 489 562 504 557 511 521 514 163 363 40 Sales 288 146 374 396 329 344 331 361 415 373 313 48 1 Sales to Active List Ratio 15.42% 18.43% 16.72% 17.39% 15.25% 17.41% 16.69% 17.41% 22.37% 21.48% 29.06% 20.81% 42 Sales to Active List Ratio 21.51% 23.80% 23.35% 23.77 20.43% 22.38% 22.76% 24.28% 29.29% 29.32% 35.21% 24.22% 43 Median Sales Price $935,000 $930,000 $932,000 $925,500 $937,250 $909,900 $920,000 $936,900 $925,000 $947,000 $970,000 $968,000 44 Median Sales Price $380,000 $385,000 $365,000 $369,500 $380,000 $375,000 $362,000 $370,000 $366,000 $368,000 $380,000 $371,750 45 New listings 768 1097 1361 141 1178 1067 939 108 396 34 315 792 46 New listings 589 697 764 764 59 624 506 681 598 439 241 523 47 48 South Okanagan Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 49 Number of Days to Sell 86 78 88 71 75 69 70 87 104 90 137AA AB 50 Number of Days to Sell 77 76 36 74 77 85 95 58 87 101 90 Average Sales Price $513,451 $495,562 $510,506 $555,219 $558,478 $598,552 $494,349 $573,315 $598,714 $512,022 $548,070 52 Average Sales Price $261,924 $264,280 $286,868 $302,449 $273,317 $369,487 $266,577 $325,878 $366,935 $250,805 $291,714 53 Sales 62 71 113 131 103 126 104 101 103 79 56 0.58 54 Sales 26 46 52 57 53 61 43 55 39 26 $5 # of Current Listing 712 767 394 947 1027 1007 1010 975 371 791 564 56 # of Current Listing 321 329 856 425 395 369 394 382 357 336 188 57 # of New listings 150 214 344 291 271 227 225 201 169 136 73 8 # of New listings 59 100 123 149 85 84 95 123 54 55 34 59 60 Real Estate Indicators BC Sales Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 61 Vancouver 1,484 1,727 1,829 2,578 2,077 2,557 2,231 2,333 2,858 2,498 2,016 1,571 62 Vancouver Island 227 308 412 459 408 153 413 345 342 312 237 174 63 Central Okanagan 264 343 424 509 451 441 516 562 383 371 271 0 65 Fraser Valley 542 808 863 358 833 901 842 882 1024 887 776 611 66 South Okanagan 38 117 165 188 166 18 147 156 142 114 82 -0.582852121 67 68 Real Estate Indicators BC Prices Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 69 Vancouver $1,116,200 $1,110,350 $1,110,200|$1,100,650 $1,099,100 |$1,093,500 |$1,089,300 |$1,086,850 $1,091,050 |$1,094,100 |$1,100,950 $1,106,850 70 Vancouver Island $507,800 $510,800 $517,800 $512,500 $514,400 $513,700 $515,400 $523,100 $521,800 $517,100 $518,000 $515,400A P Q R S U W X Z AA AB 54 Sales 16 52 57 53 51 43 55 39 35 26 65 # of Current Listing 712 767 394 947 1027 1007 1010 975 871 791 564 56 # of Current Listing 321 329 356 125 895 369 394 382 357 336 288 57 # of New listings 150 214 344 291 271 227 225 201 169 136 73 68 # of New listings 59 100 123 149 85 34 95 123 64 55 34 59 60 Real Estate Indicators BC Sales Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 61 Vancouver 1,484 1,727 1,829 2,578 2,077 2,557 2,231 2,333 2,858 2,498 2,016 1,571 62 Vancouver Island 227 308 412 459 40 153 413 345 342 312 237 174 63 Central Okanagan 264 343 424 509 451 441 516 562 383 371 271 Fraser Valley 642 808 863 958 3 901 842 882 1024 887 776 611 66 South Okanagan 89 117 165 188 166 187 147 156 142 114 82 -0.582852121 Real Estate Indicators BC Prices Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Vancouver $1,116,200 $1,110,350 $1,110,200 | $1,100,650 $1,099,100 |$1,093,500 | $1,089,300 |$1,086,850 $1,091,050|$1,094,100 |$1,100,950 $1,106,850 WE8 8 89 Vancouver Island $507,800 $510,800 $517,800 $512,500 $514,40 $513,700 $515,400 $523,100 $521,80 $517,100 $518,000 $515,400 Central Okanagan $512,665 $539,565 $573,955 $573,926 $571,864 $559,366 $560,980 $566,090 $548,137 $615,471 $556,127 SO Fraser Valley $935,000 $930,000 $932,000 $925,500 $937,250 $909,900 $920,000 $936,900 $925,000 $947,000 $970,000 $968,000 74 South Okanagan $513,451 $495,562 $510,506 $555,219 $558,478 $598,552 $494,349 $573,315 $598,714 $512,022 $548,070 SO 75 Real Estate Macro Economic +
