Special offer

Don’t Forget List-To-Sale Price Ratio !

By
Real Estate Appraiser with Accurate Appraisals & Consulting of AZ

We all know appraisals are being scrutinized more these days than in the past by underwriters and reviewers.  We also know the main reason(s) for this, if we keep up with the news and happenings within the Real Estate Industry.  With the declining market so wide spread, there is a reinforcing of expectations on the part of underwriters and reviewers and is being carried over to appraisal standards.

One of the main areas of an appraisal that is being looked at closely (in a declining market) is the support for the value conclusion.  An Appraisers responsibility is to certify that they have performed an objective and complete analysis of quantifiable data supporting their conclusion, with a strong emphasis these days on property value trends - supply and demand - concessions - sale dates and proximity of comparables - marketing time - days on market. 

There have been numerous Blogs, Posts, Comments, recently and in the past about concessions, disclosures, absorption rate, matched pair sales, cost to cure, all of which should be addressed in the reports.  But there is one thing that is probably over-looked, neglected, or unknown that needs to be included.  That is:  List-To-Sale Price Ratio.

List-To-Sale Price Ratio,  sometimes referred to as  Sale Price Ratio, is a simple calculation to determine the ratio percentage between the list price and the sale price.   Formula:   Sale Price divided by List Price equals Ratio (%).     What this indicates, and what it is being looked at for is,   seller's past willingness to negotiate and by how much.

Realtors can, and some do, use this as a marketing tool for clients by telling sellers their sale price ratio is higher than others, which means a higher return at closing, by getting the property sold at or closer to the listing price.   For appraisals, I calculate the average in the subject's market area and include the results in my comments.

 

 

David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

David Swierczynski  -  I don't know what happened to your comment.  It didn't post or was deleted.  I received an email showing your comment and wanted to reply. 

The numbers can be misleading. For use in an appraisal, research has to be done for all current and prior listings (active,pending,cancelled, expired, sold) to determine the original list price of a particular property's transaction. I go back 1 year so some sales may have more than 1 sales transaction to calculate.

 

 

Nov 15, 2007 04:16 PM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Gary  -  Thanks for the response.  In a declining market I can understand why.

 

Nov 15, 2007 04:30 PM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Sara  

Thanks for the comment.  But, I don't talk to myself,  Don't have to - There are at least 3 others in the lunch room between my left ear and right ear to converse with. :)

 

Nov 16, 2007 04:55 AM
Robert Elfand
Oviedo, FL
RAA

David -- Some lenders have started to request the addition of active or pending listings as 4th or beyond comparables.  They also require an adjustment of the neighborhood average lp/sp ratio in order to opine a future probable closing price.  A minor attempt at forecasting, but it shows that the lenders know that in today's market in my area, there are few properties that sell at list price anymore.

Nov 16, 2007 06:57 AM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Robert  -   Good information.   Thanks for the comment.   As for comparables, I always try to get at least 6 sales to justify value, and 6 active/pending for additional market info.  I have never had to include the active/pending in a report, but with today's conditions, it might be wise to include a couple in each.

Can you elaborate more on the ratio adjustment.  How would you recommend the adjustment be determined and how/where would you reflect it in a report?

 

Nov 16, 2007 07:40 AM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Robert

What I do is similar to what Sarah said  -  The local MLS has ratio stat reports for YTD and monthly  -  I use the monthly reports for a 12 month average.    I also manually calculate a 12 month average for the Subject's Market Area (1 Sq mile) since the MLS is for just the Area (area/grid) and include both averages in my report.

I don't understand what you mean by  "adjustment of the neighborhood average".

 

Nov 16, 2007 02:22 PM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Robert

Thanks for the reply.  Unfortunately it did not post here.  That's the 3rd one.  As with the 2 prior comments that did not post - I did receive an email with you comments which was deleted so I cannot copy and paste it here.

Your previous comment about an adjustment threw me off.  I got the impression you were making an adjustment in the grid in some way.

From what you explained, it could be assumed all MLS systems are similar in functions.  Our local MLS has a draw function to apply to search in the neighborhood or market area.  The stat function also provides a chart of sold, active, pending with a grid based on the search criteria.  I use this to determine an average for 3, 6, 9, 12 months (usually 12 or whichever I feel is more relavent for a particular property) to include in the report.

A separate stat report (for the area) provides a monthly and YTD average which I also include in the report. However I mostly use the monthly ones since the YTD would not provide much data at the beginning of the year (I try to be consistant with research on all assignments).  I also insert the data from both the area and market area stat reports into a spread sheet (to compress into 1 page of data) and create graph charts (visuals help with the comments) to include in the appraisal report along with comments in the addendum.

It would appear we are one the same page.  Your idea of addressing the process in the SOW is a good one and I cannot see any alternate procedure for credibility.

 

 

 

Nov 19, 2007 04:38 AM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Robert

No I don't censore anyone.  Any comments, methods, ideas, procedures, information are welcome.    Part of Networking is to learn, educate, inform, share ideas to provide better service in what we do.

Two other comments from  David Swierczynski and Gary  earlier did not post.  I don't know if it is a glitch or if someone else is censoring/deleting comments.

 

Nov 19, 2007 07:32 AM
Robert Elfand
Oviedo, FL
RAA

David,

 

I was just just joking ;)...and I noticed my last post did not show up either?  Hmmm... maybe it's me?  I have been too busy (and somewhat lazy) to repost my comments again.  I will try to get one back up by tomorrow. 

Nov 19, 2007 07:38 AM
John Fariss
Fariss Appraisal Services - Bakersfield, CA
Appraiser - Bakersfield, CA

Great post, David. I've included this information in some of my reports as well, especially when I include an active or pending in the report. I'll use that average ratio to apply an adjustment on the active comp to reflect possible negotiations between the buyer and seller.

Nov 20, 2007 09:13 AM
David Hintz
Accurate Appraisals & Consulting of AZ - Maricopa, AZ
AZAppraiser

Denise  -  No, pending or active comps are used to help determine the direction of the market in a particular area the subject is in and help in the analysis.  They are not used specifically to determine value as sold comparables are. 

There are always comps in an area (generally speaking).  An appraiser would simply adjust their search criteria in one or more several ways to locate viable comps.  Then adjustments are made in the grid of the report for the differences along with explainations for choosing the comps used.

 

Dec 05, 2007 01:18 PM