analyzing-housing-markets

# Analyzing Housing Markets

Structures housing market analysis with price trends, inventory dynamics, and affordability metrics for a defined geography and time horizon.

## When To Use

- Evaluating residential real estate conditions in a metro, state, or national market
- Tracking home price trajectories and identifying inflection points
- Assessing housing affordability for policy briefs or investment memos
- Comparing supply-demand dynamics across submarkets or time periods
- Supporting macro forecasts that depend on housing-sector inputs (GDP, consumer wealth, construction employment)

## Inputs To Gather

- **Geographic scope**: Metro/MSA, county, ZIP, or national; specify whether single-market or comparative
- **Time frame**: Historical lookback period and forward projection horizon (if any)
- **Price data**: Median sale price, price-per-square-foot, repeat-sale indices (Case-Shiller, FHFA HPI) [VERIFY data vintage and seasonal adjustment method]
- **Inventory data**: Active listings, months of supply, new listings rate, days on market
- **Construction data**: Housing starts, building permits, completions (single-family vs. multifamily split)
- **Demand-side inputs**: Population/migration trends, employment growth, household formation rates, mortgage rate environment
- **Affordability inputs**: Median household income, mortgage payment-to-income ratio, rent-to-own breakeven, first-time buyer qualification thresholds
- **Policy context**: Zoning changes, rent control measures, tax incentives, GSE policy shifts [VERIFY jurisdiction-specific rules]

## Workflow

1. **Define scope and baseline**
   - Confirm target geography, time window, and purpose (investment, policy, macro research)
   - Select appropriate price index — Case-Shiller for major metros, FHFA HPI for broader coverage, Zillow ZHVI for ZIP-level granularity [VERIFY index methodology matches use case]
   - Establish a baseline period for year-over-year and cycle-peak comparisons

2. **Analyze price trends**
   - Compute nominal and real (inflation-adjusted) price growth rates
   - Decompose price movement: organic demand vs. constrained supply vs. speculative activity
   - Identify divergences between asking prices, pending sale prices, and closed sale prices as leading indicators
   - Flag markets where price-to-rent ratios exceed historical norms by >1 standard deviation

3. **Assess inventory dynamics**
   - Calculate months of supply (active inventory ÷ monthly closed sales); benchmark: <3 months = seller's market, 3–6 = balanced, >6 = buyer's market
   - Track new-listing flow rate vs. absorption rate to detect tightening or loosening
   - Evaluate construction pipeline: permits issued vs. completions, typical lag of 12–18 months for single-family
   - Note distressed inventory share (foreclosures, short sales) and REO-to-listing conversion rates

4. **Compute affordability metrics**
   - **Payment-to-income ratio**: Monthly PITI on median-priced home ÷ median household monthly income; stress-test at current rate and +100 bps
   - **NAR Affordability Index** or equivalent: qualifying income vs. actual median income [VERIFY which index version the audience expects]
   - **Rent-vs-buy breakeven**: Compare all-in ownership cost (PITI + maintenance + opportunity cost of down payment) to equivalent rent; compute breakeven holding period
   - Segment by buyer profile: first-time (5% down, FHA) vs. move-up (20% down, conventional)

5. **Evaluate macro and policy drivers**
   - Map mortgage rate sensitivity: estimate price elasticity per 50 bps rate change using historical regressions or rule-of-thumb (1 pp rate rise ≈ 8–10% purchasing-power decline)
   - Incorporate employment and wage growth forecasts for the target market
   - Assess demographic tailwinds/headwinds: millennial household formation, baby-boomer downsizing, net migration
   - Flag pending regulatory or tax changes that could shift supply or demand [VERIFY effective dates and jurisdictions]

6. **Synthesize and stress-test**
   - Assign a market characterization: overheated / healthy appreciation / stagnant / correcting
   - Run scenario analysis: base case, rate-shock, recession, supply-surge
   - Highlight leading indicators to watch for thesis confirmation or invalidation (e.g., permits trend, pending sales momentum, cancellation rates)

## Output

- **Executive summary**: 2–3 sentences stating market characterization, key price trend, and primary risk factor
- **Price trend section**: Charts or tables showing nominal/real appreciation, index comparisons, and price-tier segmentation
- **Supply-demand dashboard**: Months of supply, listing velocity, construction pipeline summary
- **Affordability scorecard**: Payment-to-income ratio, rent-vs-buy breakeven, qualification thresholds by buyer segment
- **Risk and scenario matrix**: Base, upside, and downside scenarios with trigger indicators
- **Data sources and limitations**: Enumerated sources, data lags, and seasonal-adjustment caveats

## Quality Checks

- Confirm all price series are consistently seasonally adjusted (or explicitly not) — do not mix adjusted and unadjusted data
- Verify that affordability calculations use contemporaneous income data, not stale Census estimates [VERIFY ACS vintage]
- Cross-check months-of-supply calculation against at least two sources to catch listing-count discrepancies
- Ensure real price adjustments use CPI-U (or CPI-Shelter if isolating housing) and state the deflator used
- Flag any data gap >2 months in time series; interpolated values must be marked [VERIFY]
- Confirm that comparative analyses use the same geography definition (MSA boundaries shift across Census vintages)
- Review scenario assumptions for internal consistency — a recession scenario should pair lower demand with rising unemployment, not just a rate shock