Months Supply of Inventory (MSI) and Absorption Rates in Real Estate

July 7th, 2008

I love real estate statistics. I got a math degree from the University of Texas, so I could make a career of real estate stats. In this blog, I’ll keep things relatively simple.

In efforts to improve the statistics I present you, I am beginning to mine for and calculate absorption rates and months supplies of inventory for you. These stats are important because they reflect how a market is doing. They also help savvy buyers and sellers establish and meet their goals.

Absorption rate – the rate at which real estate is sold, or absorbed, in a specific area

I calculate absorption rates in terms of homes sold per month. Thus, for South Lake Tahoe the absorption rate is the number of homes sold in the last year, 341, divided by the months in a year, twelve. 28.4 homes are sold per month in South Lake Tahoe. This is the absorption rate. (Feel free to skip the rest of this paragraph.) Some people like to express absorption rates in relation to the amount of inventory. Our inventory in South Lake Tahoe is 476 homes. Thus, 28.4 homes is 5.97% of the inventory; so the absorption rate is 5.97% of the inventory per month.

Months supply of inventory (MSI) – an estimation of how long it will take for all the market’s homes to be sold, or absorbed, based on how many homes are currently on the market and the rate homes have sold in the past (absorption rate).

This is pretty simple. If 28.4 homes are sold per month in South Lake Tahoe, how long will it take to sell 476 homes? Divide homes by homes sold per month (476/28.4 = ???). It will take 16.76 months to sell all the houses. This is the months supply of inventory (MSI). You may now be asking, “Who cares? New homes are listed all the time. You’ll never sell the entire inventory in South Lake Tahoe.”

This is true. MSI is simply used to compare the size of an inventory to the rate of sale. This is very important. MSI is a great indicator of how balanced a market is.

MSI less than 5 months = seller’s market
MSI equals 5-7 months = balanced market
MSI greater than 7 months = buyer’s market

These guidelines are not fool-proof. Notice in the table below there is a 6.7 month supply of inventory in the sub-$300,000 price band in South Lake Tahoe. Any seller in this price band will tell you it’s not a balanced market. The buyers continue to call the shots. The MSI stat was skewed in this price band by desperate sellers, especially banks, who bent over backward in the last year for buyers. Thus, the absorption rate was increased, which decreased the MSI.

So how can these stats help you? I’ll preface the answer by saying that no mathematical model can be used to determine what will happen in real estate. There are way too many factors involved. That having been said …

For sellers, these stats will tell you how much competition you have. Let’s consider a seller with a $1,500,000 listing in South Lake Tahoe. With almost 33 months of inventory, he better think about some serious price reductions if he wants to sell soon. The seller with a sub-$500,000 listing (6.7-13.3 months of inventory) should also think about a price cut. However, there is a greater chance he’ll get lucky and find a buyer who loves his home and qualifies for a loan.

For buyers, MSI will tell you how negotiable sellers may be in different markets. If there are 3.5 months of inventory in Bangladesh and 10.2 months of inventory in Baghdad, the sellers in Baghdad will probably be more negotiable.

If you have questions about these statistics feel free to comment, e-mail me (dkondo@chaseinternational.com), or call me (530-545-1831).

South Lake Tahoe real estate statistics as of 7/1/2008

Price Range
Active Listings
Absorption Rate in sales/mo. (% of inventory) Months Supply of Inventory
$0 - $300,000
32
4.75 (14.84%)
6.7
$300,001-$500,000
173
13.00 (7.51%)
13.3
$500,001- $750,000
127
6.33 (4.99%)
20.1
$750,001- $1,000,000
68
2.50 (3.68%)
27.2
$1,000,001- $2,000,000
57
1.75 (3.07%)
32.6
$2,000,001 and up
16
0.08 (0.52%)
192

TRPA Part 1: An Introduction to the Tahoe Regional Planning Agency

July 3rd, 2008

Imagine the Lake Tahoe basin with 800,000 homes in it. A freeway, connecting different mountain peaks, overlooks the basin where the Tahoe Rim Trail currently lies. Lake Tahoe is another San Francisco. This is what many area planners hoped for in the 1960’s, shortly after the Olympic Games at Squaw Valley. Fortunately the government stepped in, and the U.S. Congress ratified an agreement in 1969 creating the Tahoe Regional Planning Agency (TRPA).

These days the TRPA is most often a target of criticism. The agency has had a tremendous affect on property owners and seekers in the Tahoe basin. Best Management Practices (BMP) regulations require homeowners to spend thousands to avoid water runoff from their properties. Proposed home additions are often blocked by the TRPA; and $5,000 fines are levied to those who remove trees without a permit.

In the weeks to come, several of my posts will cover different aspects of the TRPA and how it affects life in Lake Tahoe.

Feedback Request for Website Software Upgrade

July 2nd, 2008

I just upgraded my website’s blogging software.  It was a big scary process that appears to have gone well.  In part, this is a test message to see if things are working.  However, I will ask that if you see anything weird from your end, please notify me.  Send all feedback to dkondo@chaseinternational.com.

Weathering the Storms on Tahoe’s South Shore

June 30th, 2008

The following article about South Lake Tahoe weather was published in the Tahoe Daily Tribune earlier this month. It provides valuable information on the kind of weather to expect when visiting South Lake Tahoe. Basically, come expecting anything!

For homeowners starting projects, be aware that it will likely snow sometime in October. Last September, we saw some snow coupled with 19 degree temperatures!

Weathering the Storms on Tahoe’s South Shore
Tahoe Daily Tribune, June 6, 2008

Snow has been recorded during every month of the year in South Lake Tahoe, but cold temperatures and precipitation during the summer are not the norm.

Generally summers on the south shore are mild with temperatures averaging 80 degrees. Due to the city’s elevation, the temperature is lower than the national average throughout the year. Precipitation is usually less than an inch during June, July and August.

The sun shines an average of 274 days a year making conditions perfect for outdoor recreation in both the summer and the winter.

At Lake level an average of 125 inches of snow falls per year. Heavenly Mountain snowfall averages 300 to 500 inches per year at alpine skiing elevations. Despite having to shovel their driveways, South Lake Tahoe residents enjoy the winter just as much as the summer.

South Tahoe’s 4th of July Spectacular

June 27th, 2008

With Independence Day one week away, I want to discuss South Lake Tahoe’s 4th of July experience. IT IS INCREDIBLE. Our fireworks display, Lights on the Lake, is rated amongst the top in the nation by many. Seeking tourists, Tahoe casinos invest a ton of money into the pyrotechnics. Here are a few reviews I found on the internet:

MSNBC.com – Top 6 in the U.S.
American Pyrotechnics Association - #4 in the U.S.
FireworksGuide.com - #9 in the U.S.

The fireworks, however, aren’t the only reason why our July 4th is so special. The atmosphere is festive wherever you go, whether it’s Nevada Beach, Regan Beach, Baldwin Beach, the Tahoe Queen, M.S. Dixie, or even your own boat. Firework displays begin on the north side of the lake in Truckee and Incline Village. They can be seen from the south shore and provide a good appetizer for the fireworks to come. After these shows finish, the lights of hundreds (perhaps thousands?) of boats can be seen traversing the lake for the south shore show. Before it begins, lights scatter the south side of Lake Tahoe and its surrounding shore. The fireworks spectacular is outstanding. Tune your radio to KRLT-FM 93.9 or KOWL-AM 1490 to hear a music broadcast synced with the fireworks. After thirty minutes, there will be a grand finale. Stick around afterward to see all the lights on the lake disperse to their various marinas, piers, and launches.

South Lake Tahoe has the best 4th of July I’ve ever experienced. There’s good reason it’s ranked amongst the top in the nation! When you can, I highly recommend you experience it for yourself.

Cost of Living is Still Rising in South Lake

June 16th, 2008

Here’s an article about South Lake Tahoe’s high cost of living from the Tahoe Daily Tribune. As a Tahoe local, I can attest that life ain’t cheap in South Lake Tahoe. However, there are ways to combat the area’s high cost of living. If you’re coming from Sacramento or the Bay Area, stop for gas at the 76 right after Placerville. It’ll be on the left. You’ll pay about fifteen cents less per gallon. I do my best to fill up in Carson City where prices are about fifty cents cheaper per gallon. I also shop in Carson or Reno whenever I can. I’m guessing I save 30%-40% on groceries and household items at places like Winco, Wal-mart, and Costco. A 30%-40% savings means I pay 43%-67% more whenever I shop in South Lake. Aye caramba!

Taking these money saving measures, as well as shopping online, makes Tahoe’s high cost of living easier to bear. The lake, mountains, and fresh air make things a little easier too!

Cost of Living is Still Rising in South Lake
Tahoe Daily Tribune, June 6, 2008

The cost of living is rising around the country and South Lake Tahoe is no exception. Living in the mountains makes many goods and services more expensive. Gasoline is typically 20-30 cents more per gallon than it is in California’s Central Valley.

Rent in South Lake Tahoe can range from $600 per month for a one bedroom, one bath apartment to $3,000 per month for a four bedroom house with views. Energy and propane bills can be expensive in the winter and snow removal costs are the homeowner or renter’s responsibility.

Many people say Lake Tahoe’s natural beauty makes up for the higher cost of living. After all, one look at the sun setting over the lake is priceless.

May 2008 Statistics for South Lake Tahoe Real Estate

June 13th, 2008

After some of the statistical revelation I experienced over the last week, it’s become much easier to make conclusions on this market that can be validated with empirical evidence.

The median sale price for single family residences increased 9.5%, from $379,000 in April to $415,000 in May. Unfortunately, this is not evidence of a market turnaround. Most of the buyers who acquired property in May were simply higher priced buyers. Of the homes sold so far in June, nothing has closed above $350,000.

Prices in South Lake Tahoe will continue to drop. Look to see around twenty foreclosures hit the market this summer and even more later this year. The foreclosures are being priced very low, and they continue to force sellers to lower their prices to compete. There were sixty price reductions in the MLS over the last two weeks. We’ll see hundreds more over the summer.

A piece of positive news is that buyer activity is increasing. We saw more homes go into escrow last spring than in the spring of 2007. Right now, there are sixty-four homes in escrow. We haven’t seen that many escrows at one time since October 2005! The bottom of this market may be in sight.

Month & Year Listings at Month’s End Escrows at Month’s End Homes Sold Median $ Over Last 12 Mths. Median Sale $
May 2008

414

47

31

$425,000

$415,000

Apr 2008

372

44

21

$428,000

$379,000

Mar 2008

361

40

34

$425,000

$387,500

Feb 2008

374

52

16

$435,750

$412,500

Jan 2008

366

33

16

$449,900

$428,000

Dec 2007

382

28

34

$449,900

$502,000

Nov 2007

403

42

27

$445,000

$460,000

Oct 2007

353

15

39

$450,000

$425,000

Sept 2007

442

30

30

$450,000

$398,250

Aug 2007

538

45

38

$464,000

$421,500

July 2007

557

40

25

$463,000

$435,000

June 2007

552

33

35

$465,000

$440,000

May 2007

522

47

32

$465,300

$460,000

Apr 2007

423

32

28

$465,150

$392,500

Mar 2007

359

37

30

$475,000

$507,000

Feb 2007

327

25

25

$474,250

$492,500

Jan 2007

331

37

21

$474,500

$395,750

Dec 2006

339

29

40

$476,000

$497,500

Nov 2006

362

50

44

$474,500

$483,500

Oct 2006

411

55

53

$465,000

$450,000

Sept 2006

463

63

31

$474,500

$442,000

Aug 2006

548

46

36

$475,000

$427,500

July 2006

571

49

37

$485,000

$475,000

June 2006

532

51

37

$485,000

$480,000

May 2006

424

50

35

$485,000

$465,000

Apr 2006

302

50

32

$489,000

$504,000

Mar 2006

264

39

38

$489,000

$485,140

Feb 2006

262

51

21

$485,000

$489,000

Jan 2006

256

32

20

$482,000

$508,750

Dec 2005

198

n/a

31

$475,000

$450,000

Nov 2005

282

42

53

$475,000

$455,000

Oct 2005

300

69

55

$465,000

$485,000

Sept 2005

313

93

63

$455,000

$495,000

Aug 2005

270

96

79

$446,000

$510,000

July 2005

209

110

74

$430,000

$484,500

June 2005

188

113

65

$425,000

$456,000

May 2005

172

96

57

$410,000

$495,000

Apr 2005

116

91

72

$399,000

$488,500

Mar 2005

88

83

50

$390,000

$440,000

Feb 2005

72

86

34

$390,000

$449,500

Jan 2005

85

63

47

$383,250

$405,000

Price Range

Active Listings

$0 - $250,000

6

$250,001 - $300,000

21

$300,001 - $400,000

81

$400,001 - $500,000

67

$500,001 - $600,000

60

$600,001 - $700,000

38

$700,001 - $800,000

34

$800,001 - $900,000

22

$900,001 - $1,000,000

21

$1,000,001 and up

64

A Harder Look at Real Estate Statistics

June 11th, 2008

The South Tahoe Association of Realtors (STAoR) staff went to a C.A.R. conference last week. Thus, they didn’t publish May market statistics until today. Honestly, I got impatient a few days ago and started mining our MLS for data. I had no idea what I was in for!

Two days, six phone calls, and five hours of data mining later, I have just a few nuggets for you. I’ll give you the biggest nugget first: The monthly median sold price that STAoR presents to us isn’t actually the median for that specific month. It is the median for the past twelve months. To clarify, STAoR gave us a median sales price of $428,000 for April 2008. I searched our MLS and found the following:

Median sales price for homes sold 4/1/08 to 4/30/08 - $379,000
Median sales price for homes sold 4/30/07 to 4/30/08 - $428,000

In fact, here’s a good bit of the data that I overturned:

Month & Year Listings at Month’s End Escrows at Month’s End Homes Sold Median $ Over Last 12 Mths. Median Sale $
May 2008

414

47

31

$425,000

$415,000

Apr 2008

372

44

21

$428,000

$379,000

Mar 2008

361

40

34

$425,000

$387,500

Feb 2008

374

52

16

$435,750

$412,500

Jan 2008

366

33

16

$449,900

$428,000

Dec 2007

382

28

34

$449,900

$502,000

Nov 2007

403

42

27

$445,000

$460,000

Oct 2007

353

15

39

$450,000

$425,000

Sept 2007

442

30

30

$450,000

$398,250

Aug 2007

538

45

38

$464,000

$421,500

July 2007

557

40

25

$463,000

$435,000

June 2007

552

33

35

$465,000

$440,000

May 2007

522

47

32

$465,300

$460,000

Apr 2007

423

32

28

$465,150

$392,500

Mar 2007

359

37

30

$475,000

$507,000

Feb 2007

327

25

25

$474,250

$492,500

Jan 2007

331

37

21

$474,500

$395,750

Dec 2006

339

29

40

$476,000

$497,500

Nov 2006

362

50

44

$474,500

$483,500

Oct 2006

411

55

53

$465,000

$450,000

Sept 2006

463

63

31

$474,500

$442,000

Aug 2006

548

46

36

$475,000

$427,500

July 2006

571

49

37

$485,000

$475,000

June 2006

532

51

37

$485,000

$480,000

May 2006

424

50

35

$485,000

$465,000

Apr 2006

302

50

32

$489,000

$504,000

Mar 2006

264

39

38

$489,000

$485,140

Feb 2006

262

51

21

$485,000

$489,000

Jan 2006

256

32

20

$482,000

$508,750

Dec 2005

198

n/a

31

$475,000

$450,000

Nov 2005

282

42

53

$475,000

$455,000

Oct 2005

300

69

55

$465,000

$485,000

Sept 2005

313

93

63

$455,000

$495,000

Aug 2005

270

96

79

$446,000

$510,000

July 2005

209

110

74

$430,000

$484,500

June 2005

188

113

65

$425,000

$456,000

May 2005

172

96

57

$410,000

$495,000

Apr 2005

116

91

72

$399,000

$488,500

Mar 2005

88

83

50

$390,000

$440,000

Feb 2005

72

86

34

$390,000

$449,500

Jan 2005

85

63

47

$383,250

$405,000

Before I continue, I’ll relay a couple things told to me by STAoR staff over the last two days. First, they are not the only ones who present data in this manner. They say that many boards in small markets do the same thing. There is good reason for this. It smoothes data and eliminates variance. With few homes being sold monthly in small markets like South Lake Tahoe, there can be spikes or depressions in the data that don’t accurately reflect the market. For instance, let’s say sixteen homes will be sold in June 2008 (extremely unlikely, but it happened in January and February). If nine of these homes are closed at over one million dollars, the median will be over one million, which is more than double the actual median value of South Lake Tahoe homes. STAoR eliminates variance by incorporating a larger data set.

They aren’t truly presenting a median sales price, however. Their statistic is more like the 50-day moving average that stock market analysts use. In fact, I call their stat a 12-month moving median. There are two problems with it: 1) It does not reflect what actually happened in a month; and 2) its data centers on a date half a year in the past. Check out the table. The 12-month moving median peaks in March and April of 2006. However, the market really peaked seven months earlier in August 2005. If someone was basing a decision to sell a few years ago on this set of data, they would have been seven months late and more than a few dollars short! In the same breath, when the market bottoms out, the 12-month moving median won’t reflect this until half a year later. It is in cases like this that the actual median is much more helpful in decision making.

I’ll be posting more reflections on my data mining in the next few days.

South Lake Tahoe Best Buys - June 2, 2008

June 3rd, 2008
2228 Balboa Dr.

Tahoe Keys Waterfront Home 
Sqft: 3012
Beds: 3 
Baths: 2.5 
Price: $1,295,000

With a boat dock that can accommodate three boats and a 6-person spa on the rooftop deck, this is a luxury deal!

>Click for more info

2638 Lipan St.

2003 Christmas Valley Deal 
Sqft: 2286 
Beds: 3
Baths: 2.5
Price: $525,750

This foreclosure has seen seven price reductions in 2 1/2 months. Make an offer and see what sticks.

>Click for more info

1027 Stockton Ave.

Foreclosure Steal!
Sqft: 1432
Beds: 3
Baths: 2
Price: $254,900

This foreclosure in Sierra Tract has many upgrades. The bank is offering to pay 3% toward owner occupied closing costs.

>Click for more info

2255 Inverness Dr.

Tahoe Keys Foreclosure 
Sqft: 1712 
Beds: 3
Baths: 2
Price: $399,000

A home hasn’t sold in the Keys below $400,000 since September 2003 … and that home had only 1271 square feet of living area!

>Click for more info

977 Creekwood Dr.

Motivated Seller 
Sqft: 2500
Beds: 4 
Baths: 3 
Price: $640,000

This is a very unique & exquisite home in prestigious Highland Woods. The seller is very motivated.

>Click for more info

2536 Osborne Ave.

Beautiful Knotty-Pine Remodel 
Sqft: 1350
Beds: 3
Baths: 1.75
Price: $338,000

This is the perfect vacation cabin or rental. The owner has forty years of woodworking experience and did the remodel himself.

>Click for more info

For further information on these and other South Lake Tahoe Best Buys, call Drew Kondo at (530) 545-1831.

April 2008 Statistics for South Lake Tahoe Real Estate

May 19th, 2008

Sorry this is coming late folks!  Achilles tendon surgery, amongst other even bigger things, has kept me tied up in the last couple of weeks.

Here are the latest statistics from the South Tahoe Association of Realtors.  This data is from April 30, 2008.  The median home price in South Lake Tahoe rose 0.7% from last month ($425,000 to $428,000).  The market, however, is still in a decline.  Median home price has dropped over the past year by 8% ($465,150 to $428,000).  The best explanation for the increase in median price from last month has been the increase in foreclosure listings in the higher price bands.  I blogged on this very topic on March 31st in the posting Foreclosures in South Lake Tahoe.  I expect a decline in median home price next month due to this foreclosure-driven, downcycling market.

Median Home Price

Number of Active Listings

Number of Escrows

$428,000

372

44

Number of Listings by Price Range

Price Range

Active Listings

$0 - $250,000

5

$250,001 - $300,000

19

$300,001 - $400,000

66

$400,001 - $500,000

65

$500,001 - $600,000

56

$600,001 - $700,000

37

$700,001 - $800,000

27

$800,001 - $900,000

27

$900,001 - $1,000,000

16

$1,000,001 and up

54