Real Estate Appraisal Forum

appraisersforum.com logo
The Premiere Online Community for Real Estate Appraisers!
 Fastest Way to Find a Real Estate Appraiser Enter Zip Code:
 
 
Go Back   Appraisers Forum > Real Estate Appraisal Forums > Fannie Mae, Freddie Mac, USPAP
Register Help Our Rules Calendar Archives Mark Forums Read


Closed Thread
 
Thread Tools
  #1  
Old 01-23-2009, 10:16 AM
Gregory Beck's Avatar
Gregory Beck Gregory Beck is offline
 
Join Date: Aug 2003
Location: Fort Lauderdale
State: Florida
Professional Status: Certified Residential Appraiser
Posts: 1,359
Default 1004mc Form Help

I have a question I am attempting to finish the 1004MC form,
and here is my problem. Lets just talk about the 90 days back field
to keep it simple. I have Mls, when I run closed sale for past 90 days
I get the 90 day median sale price and list price which usually works out to anywhere from 90% or higher IE: SP 250,000 LP 300,000 ratio is 83%
looks good right? Here is my dilemma, when I go back into Mls and search active listings and pending sales for 90 days back the listing prices are lower if I put that number into the median comparable list price it now throws the ratio to 105% because the new 90 day active listings are lower than what the closed sales used were listed at get it? So which number does the new form want the listings from the closed sales which brings the ratio into line or the new 90 active listings which throws the figures off. Any body figure this out yet please let me know. This is why I come to this site as I know someone out there has the correct answer.
Sponsored Links

  #2  
Old 01-23-2009, 10:24 AM
George Hatch's Avatar
George Hatch George Hatch is offline
 
Join Date: Jan 2002
Location: Carlsbad, California
State: California
Professional Status: Certified General Appraiser
Posts: 15,758
Default

I interpreted "median comparable listings days on market" to refer to the listings for the closed sales, not to the actives referred to in Inventory Analysis section above. Among other reasons, it strikes me as irrelevant what the medians for actives are because they include listings that will never result in a sale.

FWIW, I've never seen any appraiser relate medians or averages for all actives to medians or averages for closed sales. I chalk the confusion up to clumsy verbiage from Fannie.

If it turns out my interpretation is incorrect it will only take me about 10 minutes to revise my worksheet and post it up.
  #3  
Old 01-23-2009, 10:28 AM
Eli Weiss's Avatar
Eli Weiss Eli Weiss is offline
 
Join Date: Nov 2005
Location: Brooklyn
State: New York
Professional Status: Certified Residential Appraiser
Posts: 1,528
Default

I think we should open one official 1004MC Q&A thread, opening different threads for each question, will make it too difficult to find answers later on....
__________________
"Give a man a gun and he can rob a bank. Give a man a bank and he can rob the world."
  #4  
Old 01-23-2009, 11:09 AM
VegasWayne's Avatar
VegasWayne VegasWayne is offline
 
Join Date: Nov 2007
Location: Area 24
State: Nevada
Professional Status: Licensed Appraiser
Posts: 1,982
Default

Active listings don't have a sale price, and therefore they don't have a list-to-sales price ratio. I would say that the first number is correct, the one based only on closed sales. The Wintotal form auto-calculates the median list-to-sale price ratio as the ratio of the median list price to median sale price so it is including active listings in determining the ratio. Since the current - 3 months group includes more currently active listings than the older groups, using these would skew the result. The announcement that came with the form offers little guidance on what listings are to be used and how to count them.
  #5  
Old 01-23-2009, 11:21 AM
Gregory Beck's Avatar
Gregory Beck Gregory Beck is offline
 
Join Date: Aug 2003
Location: Fort Lauderdale
State: Florida
Professional Status: Certified Residential Appraiser
Posts: 1,359
Default thank you

Quote:
Originally Posted by VegasWayne View Post
Active listings don't have a sale price, and therefore they don't have a list-to-sales price ratio. I would say that the first number is correct, the one based only on closed sales. The Wintotal form auto-calculates the median list-to-sale price ratio as the ratio of the median list price to median sale price so it is including active listings in determining the ratio. Since the current - 3 months group includes more currently active listings than the older groups, using these would skew the result. The announcement that came with the form offers little guidance on what listings are to be used and how to count them.
That cleared things up I just wanted to be sure.
  #6  
Old 01-23-2009, 12:04 PM
BC 2008 BC 2008 is offline
 
Join Date: Sep 2008
State: California
Professional Status: Licensed Appraiser
Posts: 18
Default

Quote:
Originally Posted by George Hatch View Post
I interpreted "median comparable listings days on market" to refer to the listings for the closed sales, not to the actives referred to in Inventory Analysis section above. Among other reasons, it strikes me as irrelevant what the medians for actives are because they include listings that will never result in a sale.

FWIW, I've never seen any appraiser relate medians or averages for all actives to medians or averages for closed sales. I chalk the confusion up to clumsy verbiage from Fannie.

If it turns out my interpretation is incorrect it will only take me about 10 minutes to revise my worksheet and post it up.
There's already a line for "Median Comparable Sales Days on Market" which I think is referring to the listings of closed sales. For "Median Comparable Listings Days on Market", I interpret as refer to listings for closed sales plus all comparable listings that were off market either by expired or cancelled. Currently active listings should not be included in the DOM calculation otherwise it will skew the "Median Listings Comparable DOM" of the "Current -3 months" period since many of the active listing may just be on the market for a few days.
Does anybody have a different interpretation regarding this matter?
  #7  
Old 01-23-2009, 12:32 PM
VegasWayne's Avatar
VegasWayne VegasWayne is offline
 
Join Date: Nov 2007
Location: Area 24
State: Nevada
Professional Status: Licensed Appraiser
Posts: 1,982
Default

Quote:
Originally Posted by BC 2008 View Post
There's already a line for "Median Comparable Sales Days on Market" which I think is referring to the listings of closed sales. For "Median Comparable Listings Days on Market", I interpret as refer to listings for closed sales plus all comparable listings that were off market either by expired or cancelled. Currently active listings should not be included in the DOM calculation otherwise it will skew the "Median Listings Comparable DOM" of the "Current -3 months" period since many of the active listing may just be on the market for a few days.
Does anybody have a different interpretation regarding this matter?
You may be correct in your interpretation of calculating DOM, I have been including the active listings in my calculations. They are not all that recent, some have been on the market for a long time and may be about to expire. I know of one listing that has been active for over four years. The median value may only by slightly effected by including currently active listings.
  #8  
Old 01-23-2009, 12:46 PM
BC 2008 BC 2008 is offline
 
Join Date: Sep 2008
State: California
Professional Status: Licensed Appraiser
Posts: 18
Default

Quote:
Originally Posted by VegasWayne View Post
Active listings don't have a sale price, and therefore they don't have a list-to-sales price ratio. I would say that the first number is correct, the one based only on closed sales. The Wintotal form auto-calculates the median list-to-sale price ratio as the ratio of the median list price to median sale price so it is including active listings in determining the ratio. Since the current - 3 months group includes more currently active listings than the older groups, using these would skew the result. The announcement that came with the form offers little guidance on what listings are to be used and how to count them.
I disagree with that calculation method. What it is calculating is the "Median list-to-Median Sale" price ratio.
I believe that to find the Median List-to-Sale price ratio, we should calculate the List-to-Sale price ratios first and take the median of those ratios.
  #9  
Old 01-23-2009, 12:55 PM
VegasWayne's Avatar
VegasWayne VegasWayne is offline
 
Join Date: Nov 2007
Location: Area 24
State: Nevada
Professional Status: Licensed Appraiser
Posts: 1,982
Default

I locked the fields from being automatically filled and put in the the number calculated the way you stated, the actual median of the calculated list-to-sale price ratios.
  #10  
Old 01-23-2009, 10:33 PM
Terrel L. Shields's Avatar
Terrel L. Shields Terrel L. Shields is offline
 
Join Date: May 2002
Location: Springtown, AmeRica
State: Arkansas
Professional Status: Certified General Appraiser
Posts: 38,847
Default

Quote:
clumsy verbiage from Fannie
what from fannie isn't? Throw the horse over the fence a bale of hay...
__________________
"What does not kill you, makes you stronger, except bears. Bears will eat you"
Sponsored Links

Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump




Copyright © 2000-, AppraisersForum.com, All Rights Reserved
     Terms of Use  Privacy Policy
AppraisersForum.com is proudly hosted by the folks at AppraiserSites.com

Fastest Way to Find a Real Estate Appraiser Enter Zip Code:
Partner Sites:
AppraiserUSA.com - National Appraiser Directory AllDomainsUSA.com - Domain Name Registration
DeadbeatListings.com - Deadbeat ListingsAppraiserSites.com - Web Hosting for the Professional Real Estate Appraiser
Find FHA Appraisers - FHA Appraiser Search Commercial Appraisers - Commercial Appraiser Search
Relocation Appraisal - Find Relocation Appraisers Domain Reseller - Business Opportunity
Home Security Buzz - Home Security Info Radon Testing - Radon Gas Info
My Medicare Forum - Medicare Info Stop Smoking Help - Help Quitting Smoking
CordlessPhoneStore.com - Great Cordless Phones AndroidTabletCity.com - Android Tablet Computers

Follow AppraisersForum.com:          Find us on Facebook            Follow us on Twitter


All times are GMT -5. The time now is 01:14 AM.

SiteMap: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93