Absorption R.I.P.

After talking to people about my last post on Absorption Rates and the lack of a correlation between slower absorption and lower median prices (or faster absorption and higher prices), I got the impression that there was some curiosity — skepticism?  — about the underlying numbers.  So I thought a post mortem of sorts was in order.  Here’s a chart that simply tracks total listings and total sales over a little more than the two years covered by the Absorption Rate chart.
on-market-vs-sold ...  Additional Details

Revised Absorption Chart, but the results are the same, only worse

Thanks, Jean-Claude for making me take a second look at my methodology on my Absorption Chart.  I had anticipated your point about the lag between listing dates and sales but had unfortunately gotten the formula backwards in my chart — basically dividing inventory by lagging sales, rather than forward sales:  moral of the story:  don’t do this stuff at 1 in the morning.)  So I redid the chart with the correct formula inserted.  (Excel groupies its =4*(AVERAGE(listings month 1, 2, 3)/AVERAGE(sales months 2, 3, and 4)). The data points at the end of the chart are averaged over shorter periods due to the lack of forward data. ...  Additional Details

Skip to content