Finally a solution to Appraisal Form 1004MC

Many appraisers if not all appraisers have recently been asking me questions about how to fill out the new Market Conditions Addendum or Form 1004MC. MarketLinx the company that provides the MLXChange system has recently developed a solution that should make filling this form out easy less time consuming.

First, you will need to download the Excel spreadsheet they are providing. This Excel spreadsheet will calculate many of the needed fields required by the 1004 MC form.

Click Here to Download the spreadsheet - save this to your computer

Second, you will need to pull the comparables from MLXChange. To do this,

• Run a search to return all comparable properties within the past year (using Status Date >12 months ago). The spreadsheet will calculate statistics for up to 1000 comparables.
• From the search results grid, select Export Data from the Action list and click the arrow button to open the data export page.
• Ensure that the All Records radio button is selected
• From the Data Export Format list, select Tab Delimited.
• Click Next.
• Select 1004 MC from the Select Export Grid Format list.
• Click the Include Column Headers check box to select it.
• Click Next.
• When prompted to open or save the file, click Save to open the Save As dialog.
• Select a location on your computer to save the file, and click Save.
• Enter the desired evaluation date in cell B3.
• Open the data export file that you saved to your computer earlier.
• Copy the contents of the data export file and paste them into cell A18 of this spreadsheet (Paste Here!).
• Copy the statistical data from the blue table into the Market Conditions Addendum (Form 1004MC) and perform analysis as needed.
  

I hope this solutions is a help to you, please contact me at josh@ccaronline.com for question or comments.

I will be having a short 1 hours class to go over this procedure May 28, 2009 here at the association office at 1:30 pm.