Commercial Submarket Vacancy Time Series Forecast Alert

Role: Commercial Real Estate Portfolio Econometrician specializing in time-series forecasting and macroeconomic asset cycle modeling.

Context

• Target submarket: {{submarket_name}}
• Property sector: {{asset_class}}
• Historical baseline: {{historical_sample_period}}
• Forecast window: {{forecast_quarter_horizon}}
• Projected vacancy: {{projected_vacancy_rate}}
• Committee lead: {{committee_lead_name}}

Task

Compose an analytical alert email informing the investment committee lead of time-series vacancy rate forecasts, seasonal autoregressive trends, and the corresponding underwriting implications for {{submarket_name}}.

Method

1. Analyze historical quarterly absorption patterns across {{submarket_name}} over {{historical_sample_period}}.
2. Apply seasonal autoregressive integrated moving average (SARIMA) parameters across the {{forecast_quarter_horizon}} window.
3. Compare the projected {{projected_vacancy_rate}} against the historical 5-year moving average.
4. Determine whether forecasted changes are driven by cyclical demand compression or upcoming supply delivery clusters.
5. Evaluate model error margins (e.g., Mean Absolute Percentage Error) to frame forecast reliability.
6. Highlight required adjustments to exit cap rate and lease-up velocity assumptions in current acquisition underwriting.
7. Format findings into a crisp, authoritative email directed to {{committee_lead_name}}.

Constraints

• MUST define the specific underwriting assumption changes required (e.g., concession periods, cap rates).
• MUST NOT present projections without quoting the relevant forecast horizon {{forecast_quarter_horizon}}.
• Keep total email length strictly between 200 and 350 words.
• Use bullet points for model metrics to maintain rapid executive scanability.

Output format

Email structured according to the following schema:

• Subject Line: Econometric Forecast: {{asset_class}} Vacancy Shift - {{submarket_name}}
• Salutation: Addressed to {{committee_lead_name}}
• The Bottom Line: 2 sentences stating current versus projected vacancy rates
• Forecast Summary: 3-4 concise bullets detailing trend direction, seasonality, and model bounds
• Underwriting Directives: Specific adjustments required for ongoing deal evaluations
• Sign-off: Econometric research team sign-off

Self-review

• Did I compare {{projected_vacancy_rate}} clearly against the {{historical_sample_period}} context?
• Are the directives actionable for investment underwriters evaluating {{asset_class}} assets?
• Is the tone objective, precise, and free of unnecessary statistical filler?