Showing posts with label Major US Condo Markets. Show all posts
Showing posts with label Major US Condo Markets. Show all posts

Friday, October 2, 2020

Coronavirus Pandemic – How the Pandemic has Impacted the Major Condo Markets

(Click on the image to enlarge)

The Boston condo market has outperformed the other major condo markets, yielding an overall growth of 4.1% between 1/2019 and 7/2020. Los Angeles has been a runners-up with 2.7% during that period. Though Chicago had generated a negative return in 2019, it has remained slightly positive this year. 

Despite having a positive 2019, San Francisco has lately been falling apart. Since the pandemic outbreak in March, an exodus from the city to suburb has severely impacted the urban condo market, causing a rapid price decline. 

New York condo market, like its single-family counterpart, remains the weakest market of all the major markets, flatlining throughout this period. The positive rate in 2020 has resulted from the unexpected uptick in July.



(Click on the image to enlarge)

Since Boston and Los Angeles remained in tandem, producing positive growths in both 2019 and 2020, they exhibit very high collinearity, with a correlation coefficient of 0.97. Chicago has been in the high gear in 2020, showing the second-highest collinearity with the two frontrunners. 

NY and San Francisco have the highest negative collinearity because their performances have been diametrically opposite. Between 1/19 and 3/20, San Francisco had a decent runup, from 273.04 to 280.78, followed by a rapid downturn. On the other hand, New York was slightly negative during the first comparative period and has shown a slight uptick after that.  

Again, San Francisco's steady growth from 1/19 to 3/20 has been in lockstep with Boston and Los Angeles, resulting in moderately-high collinearity with its counterparts.


(Click on the image to enlarge)

By now, we know Boston and New York have been the best- and worst-performing condo markets. Therefore, Boston shows a very positive linear trend (with an r-squared value of 0.958, which is not shown here), whereas New York offers a sideways movement within a very narrow band of 271 to 273 (with a negligible r-squared value of 0.08).  

New York (Manhattan) and San Francisco condo markets are expected to be very volatile -- perhaps turbulent -- next year, after the current statutory forbearance expires on 12-31-2020.

Note: This analysis is based on Case-Shiller monthly condo market indices (published 09/29/2020), which are the most widely-watched and followed condo market indices in the analytics world today.

Stay safe!

Data Source: 
S&P CoreLogic Case Shiller Condo Market Indices


-Sid Som
homequant@gmail.com

Wednesday, September 30, 2020

Single-Family Housing Market vs. Condo Market – A Good Champ-Challenger Analysis

Champ-Challenger analysis is an excellent way to provide a validation of one's primary research. If the local housing market is the primary research focus, some competing stats from the condo market could offer an excellent challenge in the form of validation. This comparative approach from the same collective market also provides readers with a context to better understand the primary stats. In valuation analysis, unchallenged stats leave a void that technical valuation experts like the valuation modelers often fail to understand. Here are some specifics:    

1. Presenting the Components – While analyzing the single-family residence (SFR) market, one should analyze and present it separately from townhomes (including PUD/HOA), condos and, coops. Instead of combining them as one category and averaging the results, the component-level analysis would make more sense, as their demand characteristics are usually different. The alternative approach could be (value) weighted averages. 

2. Diverging Components – Aggregate demand is not necessarily the best way to present a particular market, especially when the components do not move in tandem or diverge significantly. For example, the Condo market generally leads the housing market – on the way up and on the way down. In presenting a residential market analysis where the growth is at variance, it's better to explain the SFR market as the Champ while the condo market serves as the challenger, thus clearly portraying the divergence. A combined picture would musk the on-going reality -- a classic mistake many local reporters tend to make.   

3. Power of Challenger – The Challenger analysis is nothing but a validation exercise. When the Champ is meaningfully challenged (validated), the study becomes inherently more meaningful and statistically more significant, considering they are mined off the mutually exclusive and competing market segments. That is why the Property Tax Appeals consultants often hire well-known AVM consultants to develop a challenger AVM to unearth the over-valued parcels on the tax roll. The same concept applies to the other major markets, e.g., challenging a sector Mutual Fund with a competing ETF or a country analysis in emerging Europe with BRICS. 

4. Single Parameter Champ – An unchallenged single parameter champ like the month-over-month median SFR sale price analysis is inadequate (it is necessary but not sufficient) to make informed business decisions. It needs to be challenged both "intra" and "inter." The intra challenger (from within the group) is generally the normalized Median Sale Price per SF. Builders often challenge the market approach with a market-adjusted cost approach. Conversely, the ideal "inter" could be the analysis of the condo market as it is a competing component (sub-market) of the overall housing market, thus leading to the highest and best analytical use of the overall market.   

5. Reducing Market Noise – Normally, the SFR and condo markets remain in sync. When they diverge, one needs to investigate the reason. Since the condo market often takes the lead, either way, it could be tell-tale, pointing to the beginning of a new market swing; for example, if the condo market starts to trend up, SFRs and Townhomes won't be far behind. When they diverge for a long time, one must run the normalized tests to determine if the market internals are diverging. If not, it could be the "monthly" aberration. The 2-Month Moving Average helps reduce the monthly noise. These are the primary tools one must initially apply in diagnosing the reason for market divergence. If those tools are unhelpful, a step-by-step regression model could point to more precise reasons.

6. Challenger Condo Model – If one is forced to build a challenger (regression) model for the condo market, one must remember that the condo modeling is different from the SFR modeling. Condo modeling can be top-down or bottom-up. It's good to avoid top-down modeling as it involves income modeling requiring hard-to-find condo complex-level income-expense data. Since condo sales are at the unit level, the bottom-up market modeling is more common. In addition to the unit-level condo sales data, market modeling does require data related to the unit-level property attributes, complex-level amenities, and general location, which are available on county assessment sites. Under severe time constraints or If the condo data are not easily accessible, a condo sales ratio study could provide a stop-gap challenge.    

7. Apples-to-apples comparison – The SFR market tends to be more homogeneous than the condo market. Though there are Waterfront Mansions, French Tudors, Brownstones, etc. in the SFR market, they do not necessarily form the norm. Conversely, condo markets routinely comprise low-rise, mid-rise, high-rise, skyscrapers, etc. with significantly different amenities. So, one needs to know the apples-to-apples comparison; for example, in NYC, only the low-rise condos are grouped with the SFRs in the same tax class, easing the comparison. In suburban markets, it is prudent to remove the high-rise and skyscraper condos from the sample. Of course, if one uses the Median Sale Price or Median SP/SF, a handful of high-rise condo unit sales would not skew the results. 

8. Data for External Analysts – While collecting the data, the external analyst must know that, nowadays, a vast majority of counties (where the population-level data originates) make at least the sales data available on their sites (as customer service so the property owners can develop their own comparables analysis and validate the market values on the tax roll). Additionally, it's prudent to choose a county that makes the property data elements like Bldg SF, Land SF, Year Built, etc. available to develop the normalized tests or the regression model. Of course, when one has ample time for the project and is undertaking it for the institution, one would be better off buying the data from a national data vendor with many more data variables. Most data vendors offer a small data sample to evaluate the quality of data and the variables they warehouse.

9. The External Challenger – Last but not least, it's good to compare the internal results with S&P Case-Shiller's indices. The Case-Shiller monthly housing indices are available for the 20 major markets (MSAs), both seasonally adjusted and unadjusted. Since the internal analysis is generally seasonally unadjusted, the comparison must be made with Case-Shiller's unadjusted indices. Since the 3rd party data comes with many copyright restrictions, the comparison should be shown in the report with full disclaimers, but not in the presentation. Moreover, considering this is the 3rd party work, it does not make much economic sense to promote theirs; instead, one must always learn to encourage one's own/internal work as the solution. For instance, smart real estate brokers always advise their salespeople to sell in-house inventory as it costs the brokerage a lot of money and time to acquire exclusive listings.

Again, a good champ-challenger analysis is self-selling and convincing as the challenger does most of the selling.


-Sid Som, MBA, MIM
homequant@gmail.com

Saturday, January 18, 2020

Single Family Housing Market vs. Condo Market – A Good Champ-Challenger Starting Point

Champ-Challenger analysis is an excellent way to provide a validation of one's primary research. If the local housing market is the primary research focus, some competing stats from the condo market could offer an excellent challenge in the form of validation. This comparative approach from the same collective market also provides readers with a context to better understand the primary stats. In valuation analysis, unchallenged stats leave a void that technical valuation experts like the valuation modelers often fail to understand. Here are some specifics:    

1. Presenting the Components – While analyzing the single-family residence (SFR) market, one should analyze and present it separately from townhomes (including PUD/HOA), condos and, coops. Instead of combining them as one category and averaging the results, the component-level analysis would make more sense, as their demand characteristics are usually different. The alternative approach could be (value) weighted averages. 

2. Diverging Components – Aggregate demand is not necessarily the best way to present a particular market, especially when the components do not move in tandem or diverge significantly. For example, the Condo market generally leads the housing market – on the way up and on the way down. In presenting a residential market analysis where the growth is at variance, it's better to explain the SFR market as the Champ while the condo market serves as the challenger, thus clearly portraying the divergence. A combined picture would musk the on-going reality -- a classic mistake many local reporters tend to make.   

3. Power of Challenger – The Challenger analysis is nothing but a validation exercise. When the Champ is meaningfully challenged (validated), the study becomes inherently more meaningful and statistically more significant, considering they are mined off the mutually exclusive and competing market segments. That is why the Property Tax Appeals consultants often hire well-known AVM consultants to develop a challenger AVM to unearth the over-valued parcels on the tax roll. The same concept applies to the other major markets, e.g., challenging a sector Mutual Fund with a competing ETF or a country analysis in emerging Europe with BRICS. 

4. Single Parameter Champ – An unchallenged single parameter champ like the month-over-month median SFR sale price analysis is inadequate (it is necessary but not sufficient) to make informed business decisions. It needs to be challenged both "intra" and "inter." The intra challenger (from within the group) is generally the normalized Median Sale Price per SF. Builders often challenge the market approach with a market-adjusted cost approach. Conversely, the ideal "inter" could be the analysis of the condo market as it is a competing component (sub-market) of the overall housing market, thus leading to the highest and best analytical use of the overall market.   

5. Reducing Market Noise – Normally, the SFR and condo markets remain in sync. When they diverge, one needs to investigate the reason. Since the condo market often takes the lead, either way, it could be tell-tale, pointing to the beginning of a new market swing; for example, if the condo market starts to trend up, SFRs and Townhomes won't be far behind. When they diverge for a long time, one must run the normalized tests to determine if the market internals are diverging. If not, it could be the "monthly" aberration. The 2-Month Moving Average helps reduce the monthly noise. These are the primary tools one must initially apply in diagnosing the reason for market divergence. If those tools are unhelpful, a step-by-step regression model could point to more precise reasons.

6. Challenger Condo Model – If one is forced to build a challenger (regression) model for the condo market, one must remember that the condo modeling is different from the SFR modeling. Condo modeling can be top-down or bottom-up. It's good to avoid top-down modeling as it involves income modeling requiring hard-to-find condo complex-level income-expense data. Since condo sales are at the unit level, the bottom-up market modeling is more common. In addition to the unit-level condo sales data, market modeling does require data related to the unit-level property attributes, complex-level amenities, and general location, which are available on county assessment sites. Under severe time constraints or If the condo data are not easily accessible, a condo sales ratio study could provide a stop-gap challenge.    

7. Apples-to-apples comparison – The SFR market tends to be more homogeneous than the condo market. Though there are Waterfront Mansions, French Tudors, Brownstones, etc. in the SFR market, they do not necessarily form the norm. Conversely, condo markets routinely comprise low-rise, mid-rise, high-rise, skyscrapers, etc. with significantly different amenities. So, one needs to know the apples-to-apples comparison; for example, in NYC, only the low-rise condos are grouped with the SFRs in the same tax class, easing the comparison. In suburban markets, it is prudent to remove the high-rise and skyscraper condos from the sample. Of course, if one uses the Median Sale Price or Median SP/SF, a handful of high-rise condo unit sales would not skew the results. 

8. Data for External Analysts – While collecting the data, the external analyst must know that, nowadays, a vast majority of counties (where the population-level data originates) make at least the sales data available on their sites (as customer service so the property owners can develop their own comparables analysis and validate the market values on the tax roll). Additionally, it's prudent to choose a county that makes the property data elements like Bldg SF, Land SF, Year Built, etc. available to develop the normalized tests or the regression model. Of course, when one has ample time for the project and is undertaking it for the institution, one would be better off buying the data from a national data vendor with many more data variables. Most data vendors offer a small data sample to evaluate the quality of data and the variables they warehouse.

9. The External Challenger – Last but not least, it's good to compare the internal results with S&P Case-Shiller's indices. The Case-Shiller monthly housing indices are available for the 20 major markets (MSAs), both seasonally adjusted and unadjusted. Since the internal analysis is generally seasonally unadjusted, the comparison must be made with Case-Shiller's unadjusted indices. Since the 3rd party data comes with many copyright restrictions, the comparison should be shown in the report with full disclaimers, but not in the presentation. Moreover, considering this is the 3rd party work, it does not make much economic sense to promote theirs; instead, one must always learn to encourage one's own/internal work as the solution. For instance, smart real estate brokers always advise their salespeople to sell in-house inventory as it costs the brokerage a lot of money and time to acquire exclusive listings.

Again, a good champ-challenger analysis is self-selling and convincing as the challenger does most of the selling.


-Sid Som, MBA, MIM
homequant@gmail.com

Sunday, January 12, 2020

Condo Market Trend – Boston, Chicago, LA, NYC & San Francisco

(Click on the image to enlarge)


Lisa, a new college graduate with co-concentrations in Economics and Math, is interviewing for a Research Analyst position.

Question # 1
Interviewer: Take a look at the above graph and tell me if you see any inconsistency in the construction.

Lisa: The Chicago data range is totally out of sync with the rest so it should be graphed as Y2. In other words, instead of just X and Y, I would graph it as X, Y1 and Y2, where Y2 would represent the Chicago value range.

Question # 2
Interviewer: In that case, how would you redefine the Y ranges? Will that rearrangement help the other markets?

Lisa: The Y1 would be compressed down to a range between 200 and 325 with an increment of 25, while the new Y2 range would be between 130 and 160, with an increment of 10. And yes, the rearrangement would help project the other markets better, with a more meaningful Y1 range.

Question # 3
Interviewer: Is there any other room for improvement between the graph and the data table? 

Lisa: Yes. The data table is redundant. The data with the legends can be placed right under the months in the graph, making the table irrelevant. 

Question # 4
Interviewer: What about the growth rates? How would you show them?

Lisa: Anyone can eyeball the overall growth rates. The monthly averages are not indicative of anything meaningful here. I would therefore combine both into one more meaningful graph.

Question # 5
Interviewer: Can you make a comparative analysis of two market groups from the data table?

Lisa: The West Coast markets are moving in tandem, while the East Coast markets have forked. Specifically, LA and San Francisco have produced very similar returns, but New York and Boston are surprisingly divergent. Boston has the best return but NYC has been flat.

Question # 6
Interviewer: You just graduated from Columbia so you will know Manhattan RE quite well. Why do you think the Manhattan market has been flat-lining?  

Lisa: Two reasons: (a) the cap on SALT has been impacting the high-end Co-op and Condo markets in Manhattan and (b) as you know, the foreign buying of the US real estate has tumbled in last two years, which has dealt a serious blow to the Manhattan market, especially the high-end condo market.

Question # 7
Interviewer: If foreign buying is impacting Manhattan, it should impact LA as well. But LA has been strong. Can you explain?

Lisa: Unlike Manhattan, the foreign buyers in that market invest more heavily in private homes, rather than condos per se. Manhattan is essentially a coop and condo market. 

Question # 8
Interviewer: How would you characterize the Boston condo market? Why isn't it showing the same pattern as NYC?  

Lisa: Boston is a more natural market. SALT and foreign buyers do not impact Boston that much. It's guided by its own economic fundamentals. That is why, it has responded well to the falling interest rates in recent months.

Question # 9
Interviewer: Based on the above data, would you recommend any of these markets to our clients and, if so, why?

Lisa: Yes, I would definitely recommend Boston. As I said, Boston is a more natural market. Additionally, for the analysts and modelers, natural markets are always better as the universe of predictive modeling performs better for those markets.  

P.S. These are Case-Shiller’s seasonally-adjusted indices so the month-over-month comparison is fine. While using Case-Shiller’s seasonally unadjusted indices, one should compare July 2019 with July 2018 and July 2017, etc. 


-Sid Som, MBA, MIM
President, Homequant, Inc.
homequant@gmail.com