We have carefully reviewed Fannie Mae and Freddie Mac documentation and surveyed tenured appraisers across the country to arrive at the best practices for arriving at the 1004MC results and corresponding market statistics.
Calculation Check File
You can use the provided calculation check file, which is populated with sample data, to verify the Market Analysis Service's calculations are accurate.
Click here to download the CalculationVerification.csv file.
The file contains the following:
Running a Calculation Check
To run a calculation check, follow the usual steps for loading MLS data into the Market Analysis Service.
When prompted to select your state and MLS in step 3, select California and 1004MC - Calculation Verification File.
When prompted for the listing search date in step 4, enter 12/31/2021.
The Appraise-It Market Analysis Service will produce the following statistics:
| Prior 7-12 Months | Prior 4-6 Months | Current-3 Months | |
| Total # of Comparable Sales (Settled) | 6 | 3 | 3 |
| Absorption Rate (Total Sales/Months) | 1 | 1 | 1 |
| Total # of Comparable Active Listings | 1 | 4 | 7 |
| Months of Housing Supply (Total Listings/Ab. Rate) | 1 | 4 | 7 |
| Median Comparable Sale Price | $715,000 | $715,000 | $715,000 |
| Median Comparable Sales Days on Market | 5 | 5 | 5 |
| Median Comparable List Price (includes active) | $710,000 | $710,000 | $710,000 |
| Median Comparable Listing Days on Market | 25 | 72 | 117 |
| Median Sale Price as % of List Price | 102% | 102% | 102% |
Please note: It is the responsibility of the appraiser to verify all data and calculations are true and correct. SFREP is not responsible for the accuracy of your MLS data.
See Also
How does the Appraise-It Market Analysis Service perform its calculations?
