• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Sacramento Appraisal Blog | Real Estate Appraiser

Real estate appraisals for divorce, estate settlement, loans, property tax appeal, pre-listing and more. We cover Sacramento, Placer and Yolo County. We're professional, courteous and timely.

  • About
  • Appraisals
  • Order
  • Ask Ryan
  • Areas
  • Classes
  • Press
  • Trends
  • Share
  • Contact

Excel

Real estate drama (and a market update)

December 15, 2020 By Ryan Lundquist 50 Comments

I’m not into The Bachelorette or The Real Housewives. It’s just not my thing. But I love me some real estate drama. I’m not talking about HGTV, but the housing market. I know that elevates my nerd status, but I’m hyper focused on fresh stats, ups and downs, and things that make the market move.

(scroll down for a big market update instead)

AN EXCEL FILE FOR CHRISTMAS? Today I want to share some new neighborhood visuals and I’d like to give you an Excel template so you can quickly make these images for neighborhoods in your area. Does that interest you? If I have consensus I’ll post a template with instructions next week.

DRAMA IN THE NEIGHBORHOOD: What can you tell me about this neighborhood (East Sac)? What stands out to you about the relationship between price and square footage, lot size, and bedroom count? I made these images in a couple of minutes with the template I mentioned.

What do you think? Do you like any of these images? Any ideas for something else to show in a quick template like this? Let me know.

UNCLE RYAN’S LAME GIFT: I know it’s odd to wrap an Excel file for Christmas, but let me know if this would be relevant. You can use it for studying neighborhoods, explaining the market to clients, or for newsletters / social media. If there’s enough interest I’ll make a video tutorial. You don’t need to be an Excel guru either. This is something anyone can do with a little effort.

FOX 40 INTERVIEW: By the way, I did a 15-minute live segment last week on Fox 40. We talked about Sacramento being poised to have the strongest market in the country next year according to Realtor.com. Watch here if you wish.

Thanks so much for being here.

Any thoughts?

———————- (skim or digest slowly) ———————–

BIG MARKET UPDATE

For those interested, here’s a big Sacramento market update:

MARKET SUMMARY: In short, we’ve been seeing the drama of a spring real estate season during the fall months. The housing market has been on steroids and the slower fall season we normally have just didn’t happen. Well, technically we are seeing some stats start to slow down as prices have gone sideways lately and we’re seeing fewer sales like we normally do in November and December. But here’s the thing. The “slower” stats are still so elevated from where they should be that it just doesn’t feel slow at all.

HIGHLIGHT REEL:

  • Half of all sales sold in seven days or fewer last month
  • For six months in a row sales volume has outpaced last year
  • We only have three weeks of supply (that’s crazy low)
  • We have the lowest monthly inventory in 15-20 years (at least)
  • Buyers made twice as many offers last month compared to last year
  • The number of listings has been chopped in half
  • Price metrics are up about 12-14% from last year
  • November 2020 regional volume is up 25% from November 2019
  • 63% of all sales had multiple offers last month
  • There were 53.6% more multiple offers compared to last year
  • Each sale last month had an average of 3.22 offers
  • Sales volume is up about 2% over the past 12 months
  • There were 106% more million dollar sales from July to November

WAY TOO MANY VISUALS:

You are welcome to use these in newsletters and social media with proper attribution. Scroll quickly or digest slowly.

SACRAMENTO REGION:

  

 

 

SACRAMENTO COUNTY:

PLACER COUNTY:

EL DORADO COUNTY:

Other visuals: I have lots of other graphs. Check out my social media in coming days and weeks. I am posting daily stuff on Facebook, Twitter, and LinkedIn. Oh, and sometimes Instagram.

Thanks for being here.

Questions: What are you seeing in the market right now? Any stories to share? Are you interested in my Excel template? I’d love to hear your take.

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

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Market Trends Tagged With: aggressive real estate market, Appraisal, Appraiser, California, East Sac, East Sacramento, El Dorado County, Excel, Greater Sacramento Regional Appraisal Blog, House Appraisal, housing shortage, how to graph, low inventory, Placer County, Real Estate Market, rising prices, sacramento housing trends, trend graphs

Convincing sellers to NOT overprice their homes by making graphs

October 2, 2014 By Ryan Lundquist 12 Comments

The market is overpriced. So if you are a real estate agent trying to communicate with sellers, how do you get someone who wants to test the market at $500K to realize a more reasonable price is $375K? There are surely many strategies, but today I want to mention the power of graphing neighborhood sales. I don’t mean to beat the dead horse by bringing this up again, but knowing how to graph will help you communicate effectively, stand out from other industry professionals, and seize your role as a market trend expert instead of letting Zillow have all the glory. Sure, you can show your client a graph of city or zip code trends by using Trendvision, but it’s hard to argue with neighborhood-specific data.

making graphs - image purchased by sacramento appraisal blog

A letterhead to give your sellers: Before we dig in, here is a letter I wrote for sellers about things to consider when pricing in this market. This letterhead is based on a post I wrote recently, but I tweaked a few things. See the image below and DOWNLOAD here (PDF). Feel free to email or use as you see fit. Obviously the letter does not address a specific property. If you need a letterhead for your specific property, let’s talk about some consulting.

letterhead

Excel Tutorial: I know, you don’t use Excel because it’s only for nerds. But let me break it down for you below so you can join the club. Previously I shared a tutorial on how to graph with Gnumeric, but I had a few requests for using Excel instead since that’s what most people already have on their computers.

land park two-bedroom graph example by sacramento appraisal blog

This graph shows the range of similar-sized neighborhood sales is between $300-375K for the most part (instead of $500K). This can be a very powerful visual, especially when you begin to show the sales at $375K have been remodeled.

A tutorial on how to show the market: I recommend watching the tutorial below and then pulling up some MLS data for a neighborhood you are working in so you can create a graph by following the steps I took. This is perfect for Sacramento MLS, but as long as you can export data from your MLS system, you should be okay too. You may need to pause my video several times or rewind at moments. Whenever we do something new, it takes a while to catch on. If you don’t have Microsoft Paint to paste the graph like I did, you can use a different photo editing program, or maybe use a snipping tool on your computer. Additionally, you can open up Paint and simply start a new file, and then paste your graph (as opposed to opening an existing photo like I did). Watch below (or here if it’s too small below).

Please let me know if you have any questions. I hope this was helpful. Perhaps this will spur on a new skill set for you that can make a difference in your business.

Questions: Was the tutorial helpful? Anything you need clarity on?

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

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Resources Tagged With: appraisers, convince sellers of price, Excel, Gnumeric, how to, how to make a scatter graph, how to make real estate graphs, Land Park, overpriced market, Real Estate Appraiser, sacramento market, tutorial

How do you make a scatter graph with Sacramento MLS data?

October 5, 2010 By Ryan Lundquist 8 Comments

One of the tools in my real estate utility belt is making trend graphs. Why is this important? I find that being able to visually display all sales or listings on a graph is a very convincing resource. For example, when a home owner hires me to do an appraisal for bankruptcy or any other reason, and I include graphs of historic sales over the past three years, sales over the last twelve months, and then other graphs showing sales for 3-bedroom units, and properties similar in size to the owner’s house, it’s easy to begin to get a picture of what is happening in the real estate market. The great thing too is that you can graph so many different facets, whether square footage, age, date, bed-count, days on market, short sales vs. REOs vs typical sales, etc…

You can see some examples of trend graphs here if you wish. For now, I made a brief video tutorial to help local Realtors and real estate professionals in the Sacramento area export and work with data from our local MLS. It’s a huge benfit to be able to share things like this with clients, and once you have a little practice, you can crank out graphs very quickly. And don’t worry, if you don’t have Excel on your computer, simply download Gnumeric for free.

If you have any questions, let me know, particularly if you are a local Realtor. Call me at 916.595.3735 or connect with me on Facebook.

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff, Market Trends, Resources, Videos Tagged With: Excel, Gnumeric, how to make a trend graph, Lundquist Appraisal Company, Sacramento Appraisal, Sacramento Appraiser, Sacramento Metrolist, Sacramento Real Estate, trend graphs, Trendgraphix, video tutorial for Realtors

Primary Sidebar

Connect with Ryan

 Facebook Twitter LinkedIn YouTube Instagram

Subscribe to Weekly Post

* indicates required

Search this site

Blog Categories

  • Appraisal Stuff (407)
  • Bankruptcy (3)
  • Divorce (4)
  • Estate Settlement (6)
  • FHA Appraisal Articles (56)
  • Internet (53)
  • Market Trends (481)
  • Photos from the Field (126)
  • Property Taxes (70)
  • Random Stuff (231)
  • Resources (566)
  • Videos (161)

Blog Archives: 2009 – 2021

Lundquist Appraisal Links

  • Appraisal Order Form
  • Appraisal Website
  • Rancho Cordova Appraiser Website
  • Sacramento Appraisal Blog Sitemap
  • Sacramento Real Estate Appraiser Facebook Page
  • Twitter: Sacramento Appraiser (@SacAppraiser)
  • YouTube: Sacramento Appraiser Channel

Most Recent Posts

  • How long can this market keep going?
  • What is your housing persona?
  • Rapid price growth & the Gilmore Girls next door
  • Are first-time buyers targeting 2-4 unit properties?
  • Stale real estate headlines & buyers flocking to El Dorado County
  • My new sewer line adds huge value, right?
  • The housing market nobody predicted
  • Real estate trends to watch in 2021
  • You carried me & a spreadsheet for Christmas
  • Real estate drama (and a market update)

Disclaimer

First off, thank you for being here. Now let's get into the fine print. The material and information contained on this website is the copyrighted property of Ryan Lundquist and Lundquist Appraisal Company. Content on this website may not be reproduced or republished without prior written permission from Ryan Lundquist.

Please see my Sharing Policy on the navigation bar if you are interested in sharing portions of any content on this blog.

The information on this website is meant entirely for educational purposes and is not intended in any way to support an opinion of value for your appraisal needs or any sort of value conclusion for a loan, litigation, tax appeal or any other potential real estate or non-real estate purpose. The material found on this website is meant for casual reading only and is not intended for use in a court of law or any other legal use. Ryan will not appear in court in any capacity based on any information posted here. For more detailed market analysis to be used for an appraisal report or any appraisal-related purpose or valuation consulting, please contact Ryan at 916-595-3735 for more information.

There are no affiliate links on this blog, but there are three advertisements. Please do your homework before doing business with any advertisers as advertisements are not affiliated with this blog in any way. Two ads are located on the sidebar and one is at the bottom of each post. The ads earn a minor amount of revenue and are a simple reward for providing consistent original content to readers. If you think the ads interfere with your blog experience or the integrity of the blog somehow, let me know. I'm always open to feedback. Thank you again for being here.

Copyright © 2021 Sacramento Appraisal Blog