Uncategorized March 21, 2018

2017 Sales Price to List Price Ratios

Another article this month looking back at how 2017 played out compared to previous years.  This month I want to take a look at sales price to list price ratios.  This year, as in previous years, I’ve removed seller concessions from the sales prices, hopefully making these sales price to list price ratios as accurate as possible using IRES only data for Boulder County.

I first looked at the percent of the market that is selling for over asking price and how that metric is trending over time. In 2017, the percentage of both Single Family and Attached Homes selling for over asking price moderated and dropped from the 2016 levels. Just under 50% of Single Family Homes sold for over asking while Attached Homes saw just under 65% sell for over asking. This was a decline of 7-8 percentage points from the levels we saw in 2016. More importantly, this is the second year we’ve seen this metric decline for Attached Homes and both metrics are now declining likely indicating that we’re entering a new downward trend pattern.

2017 2016 2015 2014 2013 2012 2011
SFR 49.53% 57.23% 55.82% 42.72% 38.17% 26.25% 17.89%
ATD 64.94% 73.34% 74.58% 55.16% 38.13% 26.88% 20.63%


The second stat I wanted to revisit again was the sales price to asking price ratios and how those ratios change depending on how quickly the home goes under contract. As you would expect, the more quickly the home gets snatched up, the more likely the sales price was to be at or over the asking price, but we saw that trend moderating some in 2017. For Single Family Homes that went under contract during their first week on the market, just under 70% sold for at or over their asking price. This was a decline of about 6 percentage points from the levels we saw in 2016. We also saw about 6% fewer homes sell during their first week on the market and increases in the numbers of homes selling during the third week and on, another indicator of softening in these stats. The one quirk to this IRES data that I haven’t been able to eliminate is the possible inclusion of properties that were withdrawn and then re-entered with a new MLS # and possible new asking price that then sell quickly even though they have a lengthy combined days on market.

Single Family Week 1 Week 2 Week 3 Week 4  Week 5 Week 6+
% of all 3,391 Sales 38.78% 14.13% 8.61% 5.81% 5.37% 27.31%
Asking or better 69.96% 38.41% 23.29% 24.87% 19.23% 17.82%
<80% – 95% 2.66% 4.80% 7.88% 13.71% 14.84% 22.79%
95% – 97% 3.04% 10.44% 16.44% 18.78% 16.48% 16.74%
97% – 99% 11.41% 29.65% 37.67% 29.95% 37.36% 31.75%
99% – 100% 12.93% 16.70% 14.73% 12.69% 12.09% 10.91%
100% – 102% 36.50% 26.51% 17.47% 18.78% 15.38% 15.23%
102% – 105% 19.32% 7.10% 4.11% 4.57% 2.20% 1.51%
>105% 14.14% 4.80% 1.71% 1.52% 1.65% 1.08%


In this graph, I’ve plotted, in separate colors, the Single Family home sales per the week they went under contract. The expected strength in the properties that went under contract in the first week is displayed in blue. As we saw in 2015 & 2016, those “under contract in the first week” properties had numerous sales that were at asking price through sales that were up to 10% over asking price. It’s not until homes have been for sale into the third week that you start to see the peaks in the chart at something less than asking price. One other quirk in the data that I didn’t attempt to adjust for was properties that went under contract, had a buyer back out and then re-entered the market.

If we look at these same stats for Attached Homes, you’ll see that this market segment is also softening compared to last year but remains stronger than Single Family. Attached Homes that went under contract within the first week on the market sold for asking price or better 76.01% of the time, more than 10 percentage points lower than 2016. During 2016 more than half of the Attached homes went under contract in the first week and last year that number dropped about 5 percentage points to just under 47%. As we saw in 2016, there is far more strength for close to or at asking price sales in Attached Homes past the first week on the market than we see for Single Family Homes. For some reason about half of all Attached Homes sell for asking price or better after the first week except for those homes that go under contract in week 4. Hard to tease a reason for this out of the data, could be overall lower prices for Attached homes, odd price reduction effects, or more demand for that entry-level, affordable price point.

Attached Homes Week 1 Week 2 Week 3 Week 4  Week 5 Week 6+
% of all 1,315 Sales 46.92% 14.22% 7.07% 5.32% 5.25% 21.22%
Asking or better 76.01% 45.45% 48.39% 28.57% 46.38% 40.14%
<80% – 95% 1.62% 4.28% 5.38% 7.14% 5.80% 6.45%
95% – 97% 1.46% 8.02% 7.53% 7.14% 7.25% 16.49%
97% – 99% 8.91% 25.13% 30.11% 44.29% 33.33% 26.88%
99% – 100% 11.99% 17.11% 8.60% 12.86% 7.25% 10.04%
100% – 102% 44.73% 34.76% 38.71% 25.71% 46.38% 35.48%
102% – 105% 19.29% 6.42% 6.45% 1.43% 0.00% 2.15%
>105% 11.99% 4.28% 3.23% 1.43% 0.00% 2.51%

In the chart below, we take the same Attached Home data and display that date per the week in which the property went under contract. As in the Single Family graph, you see great strength in the properties that go under contract in the first week. Oddly, for Attached Homes, only in properties that go under contract in week 4 do we see the numbers peak at less than asking price.

Interestingly, all of these 2017 metrics show softening since 2016 and yet the subjective feel of the market so far in 2018 is a strengthening market with many properties that lagged on the 2017 market suddenly getting snatched up. Hard to tell which signal to trust as we move further into the year. Could be that the strength we’re feeling is due to very small numbers of available homes and I can see that lack of available inventory continuing throughout the year. Could be that the softening may accelerate if mortgage rates continue to creep upwards. Only time will tell.