Here is a sample of what is available:
- First, Fannie Mae has a 1004MC Page. There is a link to download a pdf copy of the 1004MC Form and link to Recorded Training Presentation. According to Fannie, the presentation will allow you to "gain an understanding of and recognize the sources of market information necessary to analyze market conditions. Our new recorded training is organized to address the Market Conditions Addendum (Form 1004MC), effective April 1, 2009, section by section."
- If you area subscriber to a Multiple Listing Service that uses the Tempo 5 System, MarketLinx has developed an Excel Spreadsheet to automatically make the calculations. Instructions that detail how to structure your MLS search, download the data and insert it into the spreadsheet are at the bottom of THIS PAGE under "Appraiser Resources".
- George Hatch, a California State-Certified General Appraiser, has developed suite of Excel spreadsheets and instructions that detail how to structure your MLS search, format the results, download the data and insert into one of his spreadsheets. All of George's files are available on Box.net. Download the pdf file of his CATALOG and use that to locate the instructions and spreadsheet for your MLS vendor.
- Don Machholz, another California State-Certified Appraiser has a nifty suite of Excel Spreadsheets as well. His versions run on Excel and Open Office. You can find the latest versions of his work on his 1004 MC Spreadsheet page. In addition, Don has some other goodies, available by links at the bottom of the 1004 MC Spreadsheet page:
- Market Trend Analysis Program: A multiple regression program for determining subject value over time, adjusted for SF, lot size and age of property.
- DOM vs Selling Price: A program to determine quick sale prices.
- Weighted Comps: Determines final value from comparable data from your grids
- Snapshot of the Past Three Months: Similar to the 1004MC 10 column, but covers only the last 3 months.
There are some other resources to provide some answers to questions you may have about the form:
- October Research/Valuation Review provides some answers from Tracy Martin, a veteran appraiser and USPAP Instructor. Download the pdf HERE
- Liability Insurance Administrators has a short post about Minimizing Risk on the Fannie Mae Form 1004MC on their Appraiser Legal Defense and Insurance Blog