Key Takeaways
- Months of supply calculations at the zip code level reveal micro-market conditions invisible in metro data.
- Pipeline tracker construction reveals delivery clustering and projected vacancy trajectories.
- Demand projection combines population growth, household size, and obsolescence into total unit demand.
- Submarket comparison identifies the specific locations within a metro with the best supply-demand fundamentals.
These exercises apply supply-demand analysis to realistic market scenarios. Work through each exercise to build proficiency in calculating supply metrics, projecting demand, identifying imbalances, and translating gap analysis into investment decisions.
Exercise 1: Months of Supply for Three Zip Codes
Calculate months of supply and market condition for three zip codes in the same metro. Zip 37201: 145 active listings, 52 sales last month, 48 sales two months ago, 55 sales three months ago. Zip 37215: 310 active listings, 38 sales last month, 41 sales two months ago, 35 sales three months ago. Zip 37027: 85 active listings, 62 sales last month, 58 sales two months ago, 64 sales three months ago. For each zip: (1) Calculate the 3-month average sales pace. (2) Calculate months of supply. (3) Classify market condition (seller's < 3, balanced 4-6, buyer's > 7). (4) Identify which zip is most and least favorable for a seller (or buyer). (5) If you are acquiring rental properties, which zip offers the best negotiating leverage and why?
Exercise 2: Construction Pipeline Tracker
Build a pipeline tracker for a submarket using the following data. Existing apartment units: 12,500. Current vacancy: 5.2% (650 vacant units). Monthly net absorption (12-month average): 55 units. Projects under construction: Project A (280 units, completing Q2 2025), Project B (340 units, completing Q3 2025), Project C (420 units, completing Q1 2026), Project D (180 units, completing Q3 2026). Tasks: (1) Calculate the pipeline-to-stock ratio. (2) Map quarterly deliveries for the next 6 quarters. (3) Project quarterly vacancy assuming consistent 55-unit/month absorption. (4) Identify the quarter with peak vacancy. (5) Calculate concession risk: at what vacancy level does the submarket historically begin offering 1-month-free concessions? (Use 8% as the threshold.) When will the submarket hit this level?
Exercise 3: Housing Demand Projection
Project 3-year housing demand for a metro using the following data. Current population: 1,850,000. Annual population growth rate: 2.1%. Average household size: 2.45. Current housing stock: 780,000 units. Annual obsolescence rate: 0.4%. Current renter share: 38%. Tasks: (1) Project population for years 1-3. (2) Calculate annual new household formation (population growth / household size). (3) Add obsolescence replacement (0.4% of stock). (4) Calculate total annual housing demand. (5) Split into owner and renter demand using the 38% renter share. (6) If the current pipeline contains 28,000 total units (18,000 for-sale, 10,000 rental) delivering over 2 years, calculate the annual supply-demand gap for each segment. (7) Is this metro undersupplied or oversupplied for rental housing?
Exercise 4: Identifying Local Supply-Demand Imbalances
A metro has four major submarkets. Analyze the data below to identify the most and least favorable for rental investment. Submarket A: 15,000 units, 4.2% vacancy, 800 units under construction, population growth 3.1%. Submarket B: 22,000 units, 7.8% vacancy, 3,200 units under construction, population growth 2.5%. Submarket C: 8,000 units, 3.5% vacancy, 200 units under construction, population growth 1.8%. Submarket D: 18,000 units, 6.1% vacancy, 1,500 units under construction, population growth 2.2%. Tasks: (1) Calculate pipeline-to-stock ratio for each. (2) Estimate demand for each (use population growth and assume 2.5 household size, 40% renter share). (3) Compare annual supply to annual demand. (4) Rank submarkets from most favorable to least favorable for rental acquisition. (5) Which submarket has the highest oversupply risk and why?
Key Takeaways
- ✓Months of supply calculations at the zip code level reveal micro-market conditions invisible in metro data.
- ✓Pipeline tracker construction reveals delivery clustering and projected vacancy trajectories.
- ✓Demand projection combines population growth, household size, and obsolescence into total unit demand.
- ✓Submarket comparison identifies the specific locations within a metro with the best supply-demand fundamentals.
Sources
Common Mistakes to Avoid
Focusing on demand growth without analyzing the supply pipeline.
Consequence: Strong demand may be fully offset by new construction, preventing price and rent appreciation.
Correction: Always pair demand analysis with detailed supply pipeline assessment (permits, starts, under construction).
Using national supply-demand data for local investment decisions.
Consequence: Local markets can have severe shortages while the national market is balanced, or vice versa.
Correction: Analyze supply-demand balance at the MSA and submarket level for investment target areas.
Test Your Knowledge
1.In the context of Supply-Demand Analysis Exercises, what is the most important balance to understand?
2.How should construction pipeline data be used in investment analysis?
3.What is the most reliable leading indicator of housing supply changes?