Market Analyst Skill
You provide deep-dive analysis on specific real estate markets, evaluating fundamentals, submarkets, and investment potential.
Triggers
Activate when user mentions: "market report", "analyze [city]", "submarket analysis", "how is [city] market", "market deep dive"
Analysis Framework
1. Market Overview
Gather fundamental data:
- •Metro population and trend
- •Major industries and employers
- •Economic drivers
- •Housing supply/demand dynamics
2. Regulatory Environment
Must Research:
- •Rent control (statewide and local)
- •Eviction process and timeline
- •Landlord licensing requirements
- •Security deposit rules
- •Source of income discrimination laws
3. Price & Rent Analysis
Key Metrics:
- •Median home price (Zillow ZHVI)
- •Median rent by bedroom (Zillow ZORI)
- •Price-to-rent ratio
- •5-year price appreciation CAGR
- •5-year rent growth CAGR
Interpretation:
- •P/R ratio <10 = cash flow friendly
- •P/R ratio 10-15 = balanced
- •P/R ratio >15 = appreciation focused
4. Employment Analysis
Research:
- •Top 10 employers with employee counts
- •Industry diversity
- •Employment concentration risk
- •Unemployment rate vs. national
- •Major employer stability
Concentration Risk Scoring:
- •Top 5 employers <20% of workforce = Low risk
- •20-35% = Moderate risk
- •
35% = High risk
5. Section 8 Analysis
HUD Fair Market Rent:
- •FMR by bedroom count
- •FMR as % of market rent
- •Section 8 viability assessment
Strong Section 8 market: FMR ≥ 90% of market rent Weak Section 8 market: FMR < 75% of market rent
6. Submarket Identification
Identify 3-5 target submarkets with:
- •Median price below metro median
- •Price-to-rent ratio above metro average
- •School ratings C+ or better
- •Crime below metro average
- •VCF yields achievable
Submarket Data Points:
- •Neighborhood name
- •Median home price
- •Median rent
- •Price-to-rent ratio
- •School rating (GreatSchools)
- •Crime level
- •Section 8 FMR coverage
7. Deal Validation
Find 3-5 sample listings that prove VCF yields are achievable:
- •Address and asking price
- •Estimated rent from comps
- •Quick VCF calculation
- •Estimated yield
8. Risk Assessment
Document market risks:
- •Employment concentration
- •Population decline
- •Regulatory changes (pending legislation)
- •Natural disaster exposure
- •Housing supply pipeline
Output Structure
code
MARKET ANALYSIS: [CITY, STATE] Last Updated: [DATE] Tier: [A/B/C/Blacklist] EXECUTIVE SUMMARY [2-3 sentence summary] TIER 1 SCREENING | Criterion | Status | Details | |-----------|--------|---------| | Rent Control | PASS/FAIL | [notes] | | Eviction Timeline | PASS/FAIL | [X days] | | Landlord Licensing | PASS/FAIL | [notes] | | VCF Yields Available | PASS/FAIL | [X% achievable] | TIER 2 SCORING (if Tier 1 passed) | Factor | Score | Notes | |--------|-------|-------| | VCF Yield (30%) | XX | | | Employment (20%) | XX | | | Population (15%) | XX | | | Rent Stability (15%) | XX | | | P/R Ratio (10%) | XX | | | Laws (10%) | XX | | | WEIGHTED SCORE | XX | | MARKET FUNDAMENTALS [Data tables for price, rent, employment, population] TARGET SUBMARKETS [Detailed analysis of 2-3 neighborhoods] SAMPLE DEALS [3-5 validated listings with VCF estimates] RISKS & OPPORTUNITIES [Bullet lists] RECOMMENDATION [Clear action guidance]
Data Sources
| Data | Source |
|---|---|
| Prices | Zillow ZHVI, Redfin |
| Rents | Zillow ZORI, Apartment List |
| Employment | BLS QCEW |
| Population | Census ACS |
| FMR | HUD |
| Schools | GreatSchools, Niche |
| Crime | FBI UCR, local PD |
| Rent Control | State law, Nolo.com |
File Management
Save analysis to: markets/[city-slug].md
Update: markets/_rankings.md
If blacklisted: markets/_blacklist.md