• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.

How is this for a formula for determining supply/demand?

Status
Not open for further replies.

Tony Blackburn

Junior Member
Joined
Jan 24, 2006
Professional Status
Certified Residential Appraiser
State
California
There are x number of homes on the market.

Average marketing time is y.

Number of sales in the y marketing time in the area is z.

If x is greater than z, there is an oversupply.

My reasoning is that there are more homes on the market than can be absorbed in the average marketing time for the area.

OK, OK, it's not an exact science, but I have never seen any formula for this issue (I know there probably are none) and maybe it's a good starting point for discussion, as "Declinging" values is a hot tpoic right now.
 
Tony............there is much more in market analysis than is allowed by any formula. However, it would be a start if formulas are your thing.
 
I'd accept that as a starting point.

The market (as you know and are not arguing) doesn't react in a Walmart just-in-time inventory control process. It moves more like a slinky, where the leaders can jump out way in front, the the trailers can take some time to catch up.

The objective is one I fully endorse: Accurately reflecting in the appraisal report how the market is positioned so the client can make the informed lending decision.
 
Why a formula?

I typcially try to look up 3 years worth of MLS sales and I break it up into 1 year increments and obviously total current listings. With the statistics function in our MLS I then have

A total # of sales or current listings
Low, Average, High for.......
sale price
list price
square footage
days on market

If I have been averaging around 20 sales for the defined neighborhood for the past 3 years and I currently have 10 listings....you can make the assumption there is a 6 month supply of houses on the market.

I now routinely see a 12-16 month supply. And going into the winter months...this is not good.
 
oh yeah...I know it's just a part of the whole analysis. There is far more than just the formula above that goes into market analysis, however, as appraisers, we tend to be "Number" or "Formula" oriented. At least I am. I have never seen anyone look at it this way, and my obsessive compulsive nature took over on this issue....;)
 
Tony,
And you can express it in terms of years, as there is a
"3.5 year supply of Florida condos currently on the market."

I remember a economist from US Bank who said
they'd just done 16 years of refinance work back in '96 or
some year and the next day US got out of the mortgage
business for all practical purposes. I guess they figured
business would be slow going forward.

Elliott
 
Sounds like it might be getting time to buy a FL condo on the cheap....or on the cheaper anyways.
 
Tony

Like everything else in the analysis used in writing an appraisal, you can make it complicated to prove an obscure point or you can do what is necessary to draw a logical and factual conclusion.

We are and have been operating in a general market area that is almost in every specific market, in an over supply condition.

What we use to be able to make and support a statement that the market is in balance or an over supply condition (under supply won't be back for a couple of years I'm afraid) is to look at the average DOM for the sales in the particular properties price/size range. Suppose the average DOM is 194 DOM and that in the past 12 months, within the defined market area, there have been 12 sales. Some sold at the beginning of the period, some along the way and some at the end of the 1 year period. That means that if there are 12 properties on the market right now(without any major changes in the economic climate and sales appear to be holding steady at last years pace), the anticipated marketing time to sell all of these properties should be similar (194 DOM). If right now there are 24 similar listings on the market, then we can logically say that we have about a 388 days supply of houses on the market. This is based on the assumption that all will sell. We would call that an over supply condition in the market. In other words, the present supply will not be sold or absorbed by the market in the anticipated marketing time of 194 days. All things being equal, 12 of them should sell in that period of time and the balance of them should sell in the next 194 days.

One thing that you have to remember is that a market in balance will have slightly more offerings than will we used up by sales in the given anticipated marketing time. In a market with a 6 month anticipated marketing time, I would consider a 7 to 8 month supply of houses to be a market in balance.

It is not scientific; there are much more precise ways of measuring using Excel and regression analysis but this data in this simple form is enough for our clients needs in making a lending decision. It is not necessary to write a doctoral dissertation on the market condition in order to supply the information that the client needs for a simple lending consideration.

You do not have to make a simple task difficult and not understandable for the conclusions to provide acceptable and usable results.
 
Last edited:
Great points, Mr. Carlsen....

One of my main points in opening this thread is just to get people to think about it. The appraisal that I reviewed that made me obsessive over this issue was one in which the absorption rate for the past 6 months was 10 units. There are now 30 on the market. The appraiser indicated "Over Supply", but indicated stable prices. To me, that is contradictory. and a slightly different ball of wax than the specific issue I started. Too many times, we see appraisals, in the case of the one I described, with no support or explanation for the boxes checked. In my book, explaining one's methodology so the client can understand HOW one got to a conclusion is a big issue and one that is not addressed often enough by our bretheren.
 
Dust off your old text books, and

look up the absorption rate analysis and explanation. I love this discussion! I do the same thing but look at different price ranges in my analysis since we only have 'over' supply in certain price ranges due to over building, aging population (ranch style shows no over supply), et cetera.
 
Status
Not open for further replies.
Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Back
Top