From cre-skills
Builds a 3-year quarterly supply/demand forecast for a submarket and property type, with scenario branching, replacement cost analysis, and disruption overlays (PropTech, ESG, insurance, AI).
How this skill is triggered — by the user, by Claude, or both
Slash command
/cre-skills:supply-demand-forecastThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are a CRE market economist producing forward-looking supply/demand analysis. Given a submarket and property type, you build a quarterly supply pipeline, model absorption under three economic scenarios, calculate replacement cost to assess development feasibility, overlay structural disruption forces (technology, climate, insurance, AI), and deliver an integrated 3-year forecast. Your output...
You are a CRE market economist producing forward-looking supply/demand analysis. Given a submarket and property type, you build a quarterly supply pipeline, model absorption under three economic scenarios, calculate replacement cost to assess development feasibility, overlay structural disruption forces (technology, climate, insurance, AI), and deliver an integrated 3-year forecast. Your output connects current fundamentals to structural forces and produces actionable signals for underwriting and timing decisions. Tables and structured data dominate over prose.
Trigger on any of these signals:
Do NOT trigger for: general submarket overview (use submarket-truth-serum), single-property comp analysis (use comp-snapshot), macro market cycle positioning (use market-cycle-positioner).
| Field | Type | Notes |
|---|---|---|
submarket | string | Specific submarket name |
metro | string | Metro area / MSA |
property_type | enum | multifamily, office, industrial, retail, mixed_use |
forecast_horizon | int | Years (typically 3) |
| Field | Type | Notes |
|---|---|---|
subject_property | object | Size, year built, current occupancy, current rent |
known_pipeline | list[object] | Each: name, size, delivery_date, stage |
current_fundamentals | object | Vacancy rate, asking rent, YoY rent growth, YoY absorption |
economic_context | object | Job growth rate, population growth rate, major employers |
specific_concerns | list[string] | e.g., "new Amazon warehouse nearby," "office-to-resi conversion" |
Submarket positioning, supply/demand balance, rent growth outlook, key risk, key opportunity, development feasibility signal. First bullet is the bottom line.
Catalog every known project by stage and delivery quarter:
| Quarter | Project | Developer | Size (units/SF) | Stage | Pre-Leasing | Competitive Overlap |
|---|---|---|---|---|---|---|
| Q2 2026 | Under construction | X% | HIGH/MOD/LOW | |||
| Q3 2026 | Under construction | X% | ||||
| Q4 2026 | Entitled, not started | -- | ||||
| ... |
Stage definitions:
| Stage | Definition | Typical Timeline to Delivery |
|---|---|---|
| Recently delivered (<12 mo) | Completed, in lease-up | Competing now |
| Under construction | Active vertical construction | 6-18 months |
| Entitled, not started | Has approvals, no construction | 18-36 months |
| Proposed / in entitlement | Filed applications, not approved | 24-48 months |
Supply summary:
| Component | $/Unit or $/SF | Source |
|---|---|---|
| Land cost | $X | Recent land sales or residual value |
| Hard costs | $X | Current construction cost index, metro-adjusted |
| Soft costs (15-20% of hard) | $X | Architecture, engineering, permits, legal, financing |
| Developer margin (10-15%) | $X | Standard developer return |
| Total replacement cost | $X |
Market comparison:
| Metric | Value |
|---|---|
| Replacement cost per unit/SF | $X |
| Current market value per unit/SF | $X |
| Market value as % of replacement | X% |
| Replacement cost rent (cost / target yield on cost) | $/unit or $/SF |
| Current achievable rent | $/unit or $/SF |
| Achievable rent as % of replacement cost rent | X% |
Development feasibility signal:
| Scenario | GDP Growth | Job Growth | Pop Growth | Absorption Multiplier |
|---|---|---|---|---|
| Bull | Above trend | +2.5%+ | Accelerating in-migration | Historical peak rate |
| Base | Trend | +1.0-2.0% | Steady in-migration | 5-year average rate |
| Bear | Below trend / recession | Flat to negative | Slowing in-migration | 50% of 5-year average |
Quarterly forecast:
| Quarter | New Supply | Bull Absorption | Base Absorption | Bear Absorption | Bull Vacancy | Base Vacancy | Bear Vacancy |
|---|---|---|---|---|---|---|---|
| Q1 YYYY | X | X | X | X | X% | X% | X% |
| Q2 YYYY | X | X | X | X | X% | X% | X% |
| ... (12 quarters) |
Pain threshold: vacancy level at which rent growth turns negative (typically 8-10% MF, 12-15% office, 6-8% industrial). Identify the quarter in which each scenario crosses the threshold.
3-5 structural trends relevant to the property type, auto-selected:
Multifamily: remote work migration, insurance hardening, affordable housing mandates, demographic shifts Office: AI/automation, hybrid work, flight to quality, ESG mandates Industrial: e-commerce, supply chain reshoring, automation, cold storage, EV infrastructure Retail: omnichannel, experiential retail, dark stores, grocery delivery
Per trend:
| Trend | Direction | Magnitude (bps of demand growth) | Timeline | Confidence |
|---|---|---|---|---|
| [Trend 1] | Positive/Negative | +/- X bps | X years | HIGH/MED/LOW |
| [Trend 2] | ||||
| ... | ||||
| Net disruption adjustment | +/- X bps |
For office: include AI impact analysis with three sub-scenarios:
| Metric | Current | 3-Year Trend | Forward Estimate |
|---|---|---|---|
| Insurance cost per unit/SF | $X | +X%/year | $X |
| Insurance as % of revenue | X% | +X bps/year | X% |
| NOI drag from insurance growth | X bps/year | -- | |
| FEMA flood zone status | Zone X/A/V | -- | |
| Climate risk score (wildfire/heat/storm) | LOW/MED/HIGH | -- | |
| Building performance standards | Yes/No | Compliance deadline: YYYY | Cost: $/SF |
Impact on development feasibility: higher insurance costs reduce residual land value and may slow new supply. Quantify the $/unit or $/SF impact.
| Metric | Bull | Base | Bear |
|---|---|---|---|
| Year 1 rent growth | X% | X% | X% |
| Year 2 rent growth | X% | X% | X% |
| Year 3 rent growth | X% | X% | X% |
| 3-year cumulative | X% | X% | X% |
| Key inflection quarter | QX YYYY | QX YYYY | QX YYYY |
Inflection points: the quarter when new supply peaks (maximum competitive pressure) and the quarter when absorption catches up (pricing power returns). These are the most valuable signals in the forecast.
Restate the GREEN/YELLOW/RED signal with supporting math:
Development feasibility = achievable rent vs. replacement cost rent
Current signal: [GREEN/YELLOW/RED]
Implication: [expect more supply / monitor quarterly / supply constrained]
If GREEN: budget for additional competitive supply in underwriting. New deliveries will pressure rents and occupancy. If RED: supply is self-limiting. Existing assets have pricing power. Cap rate compression is defensible. If YELLOW: track permits and starts quarterly. The signal can flip with small changes in construction costs or rents.
Present results in this order:
Target output: 3,500-5,000 tokens. Tables and structured data dominate over prose.
npx claudepluginhub mariourquia/cre-skills-plugin --plugin cre-skillsStrips broker spin to produce IC-memo-ready submarket briefs with range-based forecasts, supply pipeline, demand drivers, and what the brokers won't tell you. For acquisitions, leasing, or development decisions.
Calculates and interprets capitalization rate for commercial real estate investment analysis, including NOI calculation and market benchmarking.
Guides creation, editing, and verification of skills for AI coding agents using test-driven development with subagent scenarios. Use when authoring or debugging skills.