tag:blogger.com,1999:blog-31427364.post4496494750520705187..comments2024-03-26T03:52:23.395-07:00Comments on Housing Analysis: Charts are Cool!mohicanhttp://www.blogger.com/profile/06094213357140749289noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-31427364.post-76435634467657886862007-08-25T19:19:00.000-07:002007-08-25T19:19:00.000-07:00My take-home message from this would be that Van i...<B>My take-home message from this would be that Van is pretty expensive compared to the trend right now, but 4 years of only keeping up with inflation would be a reversion to the trend. </B><BR/><BR/>A few more interesting facts:<BR/><BR/>Since the early 70's, real prices are up 300+ percent. But real rents are down 35%.<BR/><BR/>Reconcile that one. Clearly real prices occur because of density increases related to population growth.<BR/><BR/>A couple of unknowns here that relate to future price growth:<BR/><BR/>1. Will the pace of population growth slow, stay the same, or increase? As of recent, population growth is way down.<BR/><BR/>2. Will the rate of density increase slow? I expect it to. It is a lot easier to go from 5 to 30 stories than from 30 to 180 stories.<BR/><BR/>If these two slow, expect a much slower pace of real growth.freakohttps://www.blogger.com/profile/06236681769619303395noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-43106488040049836662007-08-25T15:18:00.000-07:002007-08-25T15:18:00.000-07:00Freako,I did the exercise on the Sauder real data....Freako,<BR/><BR/>I did the exercise on the Sauder real data. You are right that an exponential and a straight line give almost the same fit for that data set. The linear trend is for real prices to rise at $30k a year (Q1 2003$). <BR/><BR/>Right now, Vancouver is 120 k real dollars above the trend line for that data set, or about 20% too high. The two other peaks were 97k (1995) and a whopping 231k (1981) above the real trend. Lows below the trend were similar amplitude (-87k and -75k). <BR/><BR/>My take-home message from this would be that Van is pretty expensive compared to the trend right now, but 4 years of only keeping up with inflation would be a reversion to the trend. But real-estate is no deal at the momment. <BR/><BR/>There are games you could play with where in the data set to fit the straightline, but the above fit appears to be pretty robust if you go from valley to valley.JMKhttps://www.blogger.com/profile/14740454447994074321noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-45452421510461467262007-08-25T13:41:00.000-07:002007-08-25T13:41:00.000-07:00Try to fit an exponential: P = P0 (year/year0)^n. ...<B>Try to fit an exponential: P = P0 (year/year0)^n. Or fit a line in log space. <BR/></B><BR/><BR/>Or use a real chart. Taking out inflation would "normalize" the chart. Second, I think real prices are much more likely to adhere to a trend. The chart, going back to 1975, contains periods of high inflation. Since were are currently in a low inflation period, a nominal chart will OVERSTATE the recent end of the trendline.freakohttps://www.blogger.com/profile/06236681769619303395noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-61467411849601952782007-08-24T21:42:00.000-07:002007-08-24T21:42:00.000-07:00Hi Mohican,Prices tend to grow exponentially, so f...Hi Mohican,<BR/><BR/>Prices tend to grow exponentially, so fitting a linear trend through them will make current prices look more above the trend than they really are. Try to fit an exponential: P = P0 (year/year0)^n. Or fit a line in log space.JMKhttps://www.blogger.com/profile/14740454447994074321noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-74762415423227354962007-08-24T09:29:00.000-07:002007-08-24T09:29:00.000-07:00resteven - I agree with patriotz that it would be ...resteven - I agree with patriotz that it would be unprecedented to not have a price contraction after a run up. <BR/><BR/>If nominal prices remained at their current level it would take until the 4Q of 2014 for the trendline to be intersect.mohicanhttps://www.blogger.com/profile/06094213357140749289noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-56008931759169335812007-08-23T22:12:00.000-07:002007-08-23T22:12:00.000-07:00Prices aren't going to hold. Bubble valuations are...Prices aren't going to hold. Bubble valuations are based on expectations of price growth (greater fools), because of the negative cash flow (actual or opportunity cost) on the asset.<BR/><BR/>Once price growth stalls, the game is over and prices fall back to levels supported by fundamentals.<BR/><BR/>I can't recall any BC RE bubble holding flat in nominal terms. Even the boom of the early 1970's was followed by a nominal decline in the late 1970's, and that was a time of high inflation.<BR/><BR/>If you look at an RE price chart you'll find that flat nominal prices are found at market bottoms, not tops, because prices are at levels supported by fundamentals. Until the next bubble starts.patriotzhttps://www.blogger.com/profile/11154064267408955762noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-63658625374092678812007-08-23T21:50:00.000-07:002007-08-23T21:50:00.000-07:00great charts mohican. If prices were to hold at c...great charts mohican. If prices were to hold at current levels, how many years would it be until we intersect the trendline?BushwhackBChttps://www.blogger.com/profile/01006686041190281869noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-17779283599183364712007-08-23T21:17:00.000-07:002007-08-23T21:17:00.000-07:00Sorry I should have referred the last and 3rd last...Sorry I should have referred the last and 3rd last slumps. That 2nd last one in '91 is almost too small to see. :)Warrenhttps://www.blogger.com/profile/00586650821846362670noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-11966995011848634332007-08-23T21:16:00.000-07:002007-08-23T21:16:00.000-07:00Great charts, thanks for your hard work.It seems l...Great charts, thanks for your hard work.<BR/><BR/>It seems like the last 2 slumps have had prices sit below the trendline for right around 6 years. <BR/><BR/>When to buy, or call the bottom is always difficult, but both of the last slumps also seem to have a minor false recovery about 1 year after the big drop. Good to note.Warrenhttps://www.blogger.com/profile/00586650821846362670noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-24013889053564620462007-08-23T14:25:00.000-07:002007-08-23T14:25:00.000-07:00the trendline intersects at approx $575k with poly...the trendline intersects at approx $575k with poly in the 3rd order and approx $650k in the 4th order.<BR/><BR/>I recognize the trendline will move up even higher even if prices began heading down today. In fact it is likely that the trendline will be intersected on the downside at the $560-575k range. It will likely remain below that range for at least 6 quarters. <BR/><BR/>Of course that is all speculation.mohicanhttps://www.blogger.com/profile/06094213357140749289noreply@blogger.comtag:blogger.com,1999:blog-31427364.post-36933579968097951372007-08-23T14:21:00.000-07:002007-08-23T14:21:00.000-07:00Thanks for the charts Mohican! Just curious as to ...Thanks for the charts Mohican! Just curious as to what happens to the trendline when you use a polynomial rather in the 3rd or 4th order instead of linear?Fencesitterhttps://www.blogger.com/profile/00412903923931502556noreply@blogger.com