Ryan Lundquist

Two things to understand about Zillow’s accuracy rate

May 1, 2019 By Ryan Lundquist 33 Comments

How does Zillow’s accuracy rate work? Let’s talk about two important points. I’m not writing because I’m angry, but only because the public places enormous trust in this brand, and I see this accuracy rate quoted everywhere. Well, let’s at least know the fine print so we can have informed conversations.

Two quick points on Zillow’s accuracy rate:

1) Median makes all the difference: Zillow says their median error rate is 5% for the United States. That sounds impressive, but we have to realize this is a MEDIAN error rate, which means the Zestimate is within 5% of the purchase price only half the time. So Zillow’s slogan could be, “We’re within 5% half the time.” But that doesn’t sound as polished as “Our median error rate is 5%”.

2) Zillow uses the most recent Zestimate: This is such an important point – even if it feels a little technical. I have an example to help show what I mean too. Zillow states “Zestimate accuracy is computed by comparing the final sale price to the Zestimate on or before the sale date.” Let me show you why this matters.

An example: Imagine a property listed for $380,000 and the Zestimate was also $380,000. But then after a series of price reductions, the home sold for $350,000. That would be 8 percent lower than the original Zestimate. That’s not very good, right? Well, now imagine as the list price was reduced, so was the Zestimate, and the most recent Zestimate was $353,000, which is only 1 percent higher than what the property sold for. Here’s the kicker: The home may have sold for 8 percent below the original Zestimate, but for its accuracy rate Zillow can claim 1 percent because it uses the most recent Zestimate instead of the original one.

In short, the most accurate stat here would be 8%. After all, the home literally sold 8% lower than what Zillow said it was worth. Thus when Zillow uses the most recent Zestimate instead, it’s a clever way to get much sexier stats.

One more thing.

Chasing the List Price & Fixer Upper TV show: What sort of effect does the list price have on the Zestimate? In other words, does the list price actually change Zillow’s value? This might not happen in all cases, but here’s a glaring example of the “shotgun” house from the TV show Fixer Upper. It’s a one-bedroom that was listed for $950,000 and didn’t end up selling.

In this example the list price was outrageously high, but Zillow’s algorithm looks to have simply matched the Zestimate to the list price. This might not happen in all cases, but it certainly did here.

I hope that was interesting or helpful.

Article I wrote: Here’s a piece I wrote about online valuation sites for Comstock’s Magazine last month.

CLASS I’M TEACHING: I’m doing my favorite class at SAR on May 28th from 9am-12pm called “How to Think Like an Appraiser.” Sign up here.

Questions: What do you think? Anything else to add?

If you liked this post, subscribe by email (or RSS). Thanks for being here.

How much is that new roof & AC unit worth?

April 23, 2019 By Ryan Lundquist 23 Comments

“I paid $25,000 for a new roof and AC unit. How much is that worth in an appraisal?” I get questions like this all the time and my answer can be frustrating as I say, “It depends.” Here’s my thought process though and why I can’t just rattle off a quick number. Anything to add?

The full amount: A new roof and AC unit are costly, and sellers often want to pass on the full cost to buyers. The idea is, “Hey, I spent twenty five grand, so the buyer is going to reimburse me.” But cost doesn’t always equal value, and it’s not so common for buyers to pay “dollar for dollar” either.

Boring & bling: A roof and AC unit are definitely important, but they’re sort of boring maintenance items instead of bling. What I mean is buyers don’t tend to visit a property and say, “Oh my gosh, did you see that epic new roof? I’m in love.” Nope, they tend to be more impressed with the latest trendy features instead of the age of the roof or AC unit.

Bare minimum: Buyers expect a working roof and AC unit as a minimum. Lenders definitely expect a roof with a minimum of two years of life also. This is why buyers aren’t always willing to pay big bucks for these features because on some level they simply expect them to be adequate already.

Long-term improvements: A roof and AC unit are going to be an advantage for decades, but a buyer might only be in a house for 10 years. So it probably doesn’t make logical sense to pay for the benefit of the entire lifespan of these items in one instance. In other words, the seller has added marathon improvements, but buyers may not pay that during their sprint to purchase.

Location: An AC unit in Antarctica probably isn’t too valuable, so on some level we have to consider location. On a related note, the higher-end of the price market might react differently compared to the lower end of the market. The truth is buyers in some locations or price points are going to be more informed or picky about certain features. Let’s remember energy efficiency can be a factor here too in light of extra savings.

The comps: At the end of the day we have to look to the market for the answers. I tend to consider all the things above, but I also have to be careful not to impose any of my general thinking on the appraisal. Here’s the key. What have buyers been paying for these features? As we look at comps, what seems to be a reasonable amount that buyers would pay? Let’s study comps to begin to get clues about value.

I know, I didn’t actually answer the question. But that’s not my goal here. My goal is to highlight some important thinking as we try to find the answer.

I hope that was helpful or interesting.

CLASS I’M TEACHING: I’m doing my favorite class at SAR on May 28th from 9am-12pm called “How to Think Like an Appraiser.” Sign up here.

Questions: What point stands out to you the most? Anything to add?

If you liked this post, subscribe by email (or RSS). Thanks for being here.

It’s just NOT a cash market like it used to be

April 17, 2019 By Ryan Lundquist 6 Comments

Investors are playing the market like Monopoly and buying everything in sight… Well, that’s what many sellers think. But it’s not true. Like many markets across the country, in Sacramento we’re actually seeing significantly less cash today than during the heyday of investor activity a few years back.

The Big Takeaway: It’s not an aggressive investor market like it used to be around 2012 when investors really were buying everything, so it’s important to price for today’s trends instead of a rapidly moving cash market from the past.

The Mistake: Sellers tend to aim for that one elusive cash buyer from the Bay Area, but we have nearly 50% less cash today in the Sacramento region compared to 2012. The market is competitive still, but we’re not seeing huge price gains like we did when investors were running the show 5+ years ago.

Three Graph Takeaways:

1) Cash happens at every price point.
2) Cash is more common at lower prices.
3) Sorry if these graphs are confusing.

Now some visuals:

1) A View Without Dots: Let’s start with a graph without dots. Keep in mind this same trend is seen below. It’s just not so easy to see in the midst of over 70,000 sales on one image…

2) A Panoramic View: Here’s all single family detached sales in Sacramento County (not condos).

3) More Cash at Lower Prices: It’s not easy to see the trend here, but cash purchases are concentrated more heavily at lower prices. Keep in mind in 2018 we really only had close to 15% of sales go cash. This is what it looks like on a graph…

4) Big Cash-Only View: Here’s all cash sales since 2012 at the bottom of the market in Sacramento County under $1M. Can you see a higher concentration in 2012 (a thicker black)?

5) A Closer Cash View: Here’s a view of cash purchases under $500,000 to help see the trend a little better.

6) A Close-up for 2019: Here’s a look at 2019 only. When we zoom in we can clearly see that cash is present, but not dominating the market. By the way, who can tell me why this visual has lines like this? The reason is simple, but kind of cool to see on a graph.

Conventional & Bay Area Buyers: Let’s remember some investors these days are using conventional financing because of such favorable terms. So in this regard I look at cash stats with an asterisk. Also, cash is a bit higher in Placer County and El Dorado County these days, and some of that stems from Bay Area buyers (not that Bay Area buyers aren’t also targeting places like Elk Grove, Midtown, etc..).

New Market Video: Here’s a video I put together to talk through the competitive and flat market. Here’s what I mean:

I hope that was helpful or interesting.

Questions: What are you seeing out there? If you are not in Sacramento, is the trend similar in your area?

If you liked this post, subscribe by email (or RSS). Thanks for being here.

The booming FLAT market & rate addiction

April 11, 2019 By Ryan Lundquist 9 Comments

The market is getting hotter, but it’s also pretty flat. Let’s talk about this as well as low rate addiction. Then for those interested I have a huge local market update.

Two things:

1) Competitive but flat market: The spring market is definitely competitive. Real estate agents are saying it’s “hot” and they’re right because buyers are hungry, sales volume is up, and it’s taking less time to sell. BUT prices also seem a little flat. I know, that sounds crazy since there’s so much competition, but it’s what the stats are showing. Let’s remember it’s possible to have a market with lots of competition while prices are more subdued or sideways. In other words, just because it’s competitive doesn’t mean prices are going nuts.

2) Rate addiction: Lower rates in 2019 have brought buyers back into the market after a big slump in 2018. It just goes to show how sensitive our market is to rate changes. In other words, it seems the market is struggling to move forward in glory without low rates. Sounds healthy, right?

Any thoughts?

—–——– Big local monthly market update (long on purpose) —–——–

Spring is feeling fairly normal so far and March was actually a strong month. Let’s talk about this.

THE SHORT VERSION:

Price growth is definitely slowing
Sales volume has slumped for 10 months
Volume was strong in March though
Choose comps wisely
I’m now publishing El Dorado County stats
Most metrics are doing what we’d expect for the spring
This post is long on purpose. Skim or pour a cup of coffee.

DOWNLOAD 70+ graphs: Please download all graphs here as a zip file. See my sharing policy for 5 ways to share (please don’t copy verbatim).

THE LONGER VERSION:

Here’s some of the bigger topics to consider right now.

Slow or flat price growth: The median price in Sacramento last month is actually the same as it was one year ago. It’s been a very long time since we’ve seen that happen. Otherwise most other price metrics in the region are up slightly between 2-3% over the year. This is a very modest change over twelve months and it reminds us price momentum is slowing. In many areas it seems prices are hovering around or lower than they were during the height of summer. But keep in mind this isn’t totally abnormal for the spring either because sometimes the new year immediately picks up right where it left off during the height of summer and other times the stats don’t get back to where they were until about May or so. Thus in some senses we’re still waiting to see how this spring market is going to unfold.

A more normal-ish spring: Overall most metrics look normal for the time of year. Prices ticked up again from the fall lull, it took eight less days to get into contract from last month, and there just isn’t that much on the market right now. Part of having an anemic number of listings is normal because the market doesn’t tend to hit its stride until April, but we’re also seeing the byproduct of buyers devouring listings because of low rates.

Choosing comps today: When a market is showing slower price growth it’s important to be realistic about comps. Sellers often want to get super aggressive, but I have some quick advice. Don’t. Give strong weight to similar properties that are getting into contract, and don’t price like it’s the rapidly increasing market from yesteryear. It’s not. Remember, in some areas you might pull comps and not see much price difference at all from the summer of 2018 or even from the spring of last year. Sellers, please remember you are not guaranteed price growth, so don’t price like you’re entitled to it.

Improving volume, sort of: Sales volume definitely made a rebound last month from the profound dullness we saw these past two quarters, yet it was still down 5.7% in the region from last March. And it’s down 7.2% over the past twelve months. Think about it this way. Being down seven percent doesn’t sound like much, but it means there’s been more than two thousand less sales this year in the Sacramento region compared to last year. It sounds bigger when we think of it that way, right? While volume improved this past month, we’ve still had ten months in a row of lower volume, and that’s the bigger story. Moreover, the first quarter was down 10% in the region compared to last year.

Pendings show us the market: Sales from March tell us more about what the market used to be like in January and February when these homes got into contract. So we have to look to the listings and pendings right now to understand where the current market is really at. As of now pendings look pretty strong, which suggests we’ll have another month of stronger volume in April.

Less offers (but actually more): Multiple offers are down about 12% in the region this year compared to last year, but the number of multiple offers actually increased from February to March. This is exactly what we’d expect to see happen in the spring, so don’t write home over it. But it’s still interesting to see.

Price sensitivity: One out of every two homes are getting multiple offers in Sacramento County, and it’s a reminder buyers need to bring strong offers. But sellers ought to price correctly too. Buyers are not desperate and willing to pay unrealistic prices, so I advise aiming for the market instead of that one mythical buyer who will overpay for some reason.

Waiting: We’re waiting and needing a few more months of data to see how this year is going to unfold. It’ll be most interesting to see if we get a little more price growth too (beyond just rebounding from the dull fall). The verdict is not in yet for this year, and there is still an element of uncertainty because we have a market that feels heavily driven by low rates for the time being.

I could write more, but let’s get visual instead.

BIG ISSUES TO WATCH:

1) SPRING GETTING HOT TECHNICALLY: The market is heating up for 2019. We’re seeing price changes, lower inventory, and increased sales volume. So prices are up from the dull fall, but they’re also flat as you can see under #4.

The median price is actually down in Placer County, but I’d suggest waiting a few months before making a big deal out of that since Placer County doesn’t have many sales each month, so data can be a little more volatile Yet this hasn’t happened in a long time either.

2) SLOWING MOMENTUM: Despite the heating, stats show the market is slowing down when we look at the rate of change by year. Looking at monthly, quarterly, and annual numbers helps give a balanced view of things.

3) SALES VOLUME SLUMP for 10 months: It’s important to look at sales volume in a few ways to get the bigger picture. Here it is by month and year.

SACRAMENTO COUNTY:

Key Stats:

March volume down 4.9%
Volume is down 6.2% over the past 12 months

SACRAMENTO REGION:

Key Stats:

March volume down 5.7%
Volume is down 7.2% over the past 12 months

PLACER COUNTY:

Key Stats:

March volume down 5.5%
Volume is down 7.7% over the past 12 months

EL DORADO COUNTY:

Key Stats:

March volume down 8.9%
Volume is down 9.0% over the past 12 months

4) LAST YEAR VS THIS YEAR: It’s been a LONG time since we’ve seen some metrics almost identical to what they were last year. Can you see why I’m saying prices seem flat lately? This may not be true in every single price range or neighborhood of course, but this shows us price momentum is slowing. With that being said, it’s still okay to say the market is “hot”. It is. But I’d say competition is hotter than price appreciation.

Quick note on how NOT to use my content: Please don’t copy my post verbatim or alter the images in any way. I will always show respect for your original work and give you full credit, so I ask for that same courtesy. Here are 5 ways to share my content.

Now here are a bunch of images. Please enjoy.

SACRAMENTO COUNTY (more graphs here):