Commercial Property Portfolio Occupancy and Yield Brief

Role: Principal Real Estate Portfolio Analytics Lead.

Context

• Portfolio identifier: {{portfolio_identifier}}
• Property asset class composition: {{asset_class_mix}}
• Upcoming lease expiration schedule: {{lease_expiration_schedule}}
• Target underwriting net effective rent: {{target_net_effective_rent}}
• Regional submarket vacancy benchmark: {{market_submarket_benchmark}}
• Historical tenant renewal percentage: {{tenant_retention_rate}}

Task

Generate a streamlined occupancy analytics brief assessing tenant retention health, lease rollover exposure, and net effective revenue performance across the asset portfolio.

Method

1. Ingest asset distribution profiles from {{asset_class_mix}} across {{portfolio_identifier}}.
2. Compute current weighted average lease expiry (WALE) using {{lease_expiration_schedule}}.
3. Benchmark portfolio physical and economic vacancy against {{market_submarket_benchmark}}.
4. Compare achieved rental rates against {{target_net_effective_rent}} to isolate tenant incentive dilution.
5. Project near-term revenue leakage using {{tenant_retention_rate}} applied to upcoming rollovers.
6. Classify high-risk tenant expirations into credit-risk tiers based on lease size and sector.
7. Detail three portfolio-level leasing countermeasures to stabilize net operating income (NOI).

Constraints

• MUST calculate and present WALE in both years and square footage terms.
• MUST NOT recommend concession packages that breach {{target_net_effective_rent}} baseline limits.
• Restrict the final brief to a maximum of 450 words excluding the reference table.
• Exclude narrative fluff; maintain objective, institutional-grade analytical tone.

Output format

1. Portfolio Health Summary (physical occupancy, economic occupancy, WALE calculation)
2. Submarket Competitiveness Analysis (variance narrative vs {{market_submarket_benchmark}})
3. Rollover Exposure Breakdown (markdown table: Expiry Year | Expiring SF | Projected NOI at Risk)
4. Asset Management Strategic Directives (3 concise recommendations)

Self-review

• Confirm that WALE and vacancy metrics are explicitly derived from {{lease_expiration_schedule}}.
• Validate that all rent metrics account for free rent concessions against {{target_net_effective_rent}}.
• Ensure each asset class mentioned matches {{asset_class_mix}}.