Explanation and Description of Market Watch’s Graphs and Calculations
Regional Numbers: For the purposes of this report, the Coachella Valley region consists of these eleven cities or CDPs – Bermuda Dunes, Cathedral City,
the city of Coachella, Desert Hot Springs, Indian Wells, Indio, La Quinta, Palm Desert, Palm Springs, Rancho Mirage and Thousand Palms. Regional sales
and regional inventory numbers are the sum of sales or inventory of these 11 cities averaged over some time interval – usually three or twelve months. The
Coachella Valley median detached home price is the median price of sales of single-family residences over the prior three months in all 11 cities. The
Coachella Valley Median Attached Price is the median price of sales of condos and townhomes over the past three months in all 11 cities.
City Prices: Our city price tables display the median price per square foot as well as the price of the average size home of all detached or attached sales
over the last three months (6 months for Indian Wells). The price of the average size home is determined as follows: the median price per sq. ft. is
multiplied by the size of the average home in that city. The size of the average home is determined from the square feet of all sales in that city over the last
twenty years, which is then rounded to the nearest 25 sq. ft.. The size of the average home is therefore constant month by month.
Sales: For cities, sales numbers are the sum of sales of SFR, Condos and townhomes. We present two sales numbers – three-month average of sales
and twelve-month averages. The three-month average measures and shows the seasonal variations of the region. These three-month averages should
only be compared against the same three months of previous years. For example, one should never compare three-month sales in spring to that of the fall.
The twelve-month average of sales takes out all seasonality and is very useful when trying to assess the long-term growth or contraction of sales in the
region and at the city level. In our calculations every month is represented by sales over the preceding 31 days. This gives equal weight to each month.
Inventory and “Months of Sales”: Our inventory numbers are homes classified as “active” listings; we exclude listings called “active under contract.” We
believe this is a more accurate measure of real supply since most “active under contract” listings will soon be closed sales. Remember sales and prices are
accumulative while inventory is a momentary snapshot of inventory on a specific date. When we provide a monthly report for, say, the month of April, all
sales and pricing are done using transactions through that and the previous two months. However, when we measure inventory at the end of April, it’s the
inventory as of April 1
st
. Even though inventory April be labeled April inventory, it is the inventory on the 1
st
of the next month. Our inventory is the sum of
both attached and detached homes.
When calculating the “months of sales” ratio, we almost always use average sales over the last twelve months and not three months. If we do use three
month sales, we indicate it. We use the classic “months of sales ratio”, which is inventory divided by sales, and not its inverse called the “absorption rate”
since most people feel the ratio is much clearer and more easily understood.
Days in the Market and Sale Price Discount from List Price: These calculations are also the median value of the metrics reported from the MLS listing
and are calculated over the last three months of transactions like price and sales. This is done to help reduce random variation and movements.
Call Out Numbers: The two numbers inserted in the charts are the most recent value(s) and the value(s) one year ago. Each number is connected to the
point on the chart it refers to by a small thin line.
To contact Market Watch call Vic Cooper at 714-390-1418.
The Desert Housing Report
April 2024