A common question is how the listing counts are arrived at. Each sold record is not an active listing in the period it was sold.
Inventory Analysis (counting 0% of Pending sales as Settled)
The Median Sale Price as % of List Price is determined by finding the median of Sale Price divided by List price of each Sold/Settled property in a given period.
Below is a row-by-row detail of the calculation process used to arrive at the results.
This row displays all sold records that closed / settled within the given time period.
The Absorption Rate is is calculated by dividing the total number of sales for each time period by the months in the time period. This is six months in the Prior 7-12 time period and three months in the Prior 4-6 & Current – 3 Month time periods.
Each field represents the number of Active Listings on the Last Day of the period.
This means if a property was listed during the Prior 7-12 month period and sold in the Current – 3 month period it would be counted as a Active Listing in the Prior 7-12 and Prior 4-6 Months period then as a Sale in the Current – 3 months time period.
This is calculated by dividing the total number of listings by the absorption rate. The resulting number indicates how many months of inventory were on the market during each time period.
This field shows the median sale price for the properties that actually sold (have a sold status) during each time period.
This field shows the median days on market for the properties that actually sold (have a sold status) in given time period.
This field displays the median list price for all properties in the given time period.
This field shows the median days on market for all Sold/Settled properties within the given time period.
The Median Sales Price to List Price Ratio is measured by calculating the median from the list of ratios for the sold comparables chosen for analysis and NOT by dividing the overall Median Sales Price by the overall Median List Price on the form.
The three periods for the 1004MC are divided up by deducting calendar months. So if today was June 9th, three months back would be March 10th. This means sometimes the 0 – 3 month period could be 89, or 91 days, not necessarily 90 days. This same rule applies to the 4 – 6 month period and 7 – 12 month period.
* Sold DOM is calculated by subtracting Pending Date from Listing Date
** IF PENDING = ACTIVE: Listing DOM in current period is calculated by subtracting Effective Date (Listing Search Date) from Listing Date
*** IF PENDING = SOLD, subtract Pending Date from Listing Date
**** Listing DOM is calculated by subtracting Last Day of that Period from Listing Date
Important notice: 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.
