| name | portfolio-strategy-advisor |
| description | Use when analyzing a multi-tenant portfolio's lease rollover schedule, identifying expiry cliffs and concentration risk, prioritizing renewal negotiations, forecasting vacancy and cash flow, or designing a lease-maturity stagger strategy. |
Portfolio Strategy Advisor
Overview
Portfolio Lease Management = Strategic analysis and planning across multiple leases to optimize occupancy, revenue, and risk.
Purpose:
- Identify expiry concentration risk ("expiry cliff")
- Prioritize renewal negotiations
- Forecast vacancy and revenue
- Optimize lease maturity stagger
- Support property valuation and financing
Core Concepts
Lease Rollover Schedule
Definition: Timeline showing when leases expire across a portfolio or property.
Visualization:
Year | Expiring SF | % of Total | Cumulative %
--------+-------------+------------+-------------
2025 | 50,000 | 20% | 20%
2026 | 75,000 | 30% | 50%
2027 | 25,000 | 10% | 60%
2028 | 100,000 | 40% | 100%
--------+-------------+------------+-------------
Total | 250,000 | 100% |
Analysis: 2026-2028 = 80% of portfolio expires (concentration risk)
Expiry Cliff
Definition: Concentration of lease expiries in a single year or short period.
Red Flag Threshold: >30% of SF expiring in one year
Risk:
- Multiple vacancies simultaneously
- Limited re-leasing capacity
- Market timing risk (downturn = high vacancy)
- Cash flow disruption
- Property value decline
Mitigation: Stagger lease maturities, prioritize early renewals
Renewal Priority Scoring
Factors:
- Tenant Quality (credit strength)
- Rent vs. Market (above/below market)
- Space Suitability (tenant fit for space)
- Lease Expiry (urgency)
- Strategic Value (anchor, synergy)
Scoring Matrix:
Factor | Weight | Score (1-5) | Weighted
--------------------+--------+-------------+---------
Tenant Credit | 30% | 4 | 1.2
Market Rent Gap | 25% | 3 | 0.75
Strategic Value | 20% | 5 | 1.0
Expiry Urgency | 15% | 2 | 0.3
Space Fit | 10% | 4 | 0.4
--------------------+--------+-------------+---------
Total | 100% | | 3.65
Priority Tier: HIGH (score > 3.5)
Vacancy Forecasting
Assumptions:
- Historical retention rate (e.g., 70%)
- Market conditions (improving/declining)
- Re-leasing timeline (6-12 months)
- New tenant concessions (TI, free rent)
Forecast:
2025 Expiries: 50,000 sf
Expected Renewals (70%): 35,000 sf
Expected Vacancies: 15,000 sf
Downtime: 9 months average
Revenue Loss: 15,000 sf × $15/sf × 0.75 years = $168,750
Methodology
Step 1: Build Rollover Schedule
Extract from lease abstracts:
- Tenant name
- Suite/unit
- Rentable area (SF)
- Current rent ($/SF)
- Lease expiry date
- Renewal options (Y/N, notice deadline)
Create timeline (by year or quarter)
Step 2: Identify Expiry Cliffs
Calculate annual SF expiring:
Year | SF Expiring | % of Total
Red Flag: Any year > 30% of portfolio
Action: Prioritize early renewal negotiations for cliff years
Step 3: Score Renewal Priorities
For each expiring lease, assess:
- Tenant credit quality
- In-place rent vs. market rent
- Strategic importance
- Likelihood of renewal
- Time to expiry
Assign priority tier: High / Medium / Low
Step 4: Develop Renewal Strategy
High Priority:
- Engage 18-24 months before expiry
- Offer attractive renewal terms (market or slightly below)
- Minimize downtime risk
Medium Priority:
- Engage 12 months before expiry
- Market terms
- Re-lease if tenant declines
Low Priority:
- Engage 6-9 months before expiry
- Above-market renewal terms or re-lease
- Opportunity to upgrade tenant mix
Step 5: Forecast Vacancy & Revenue
Assumptions:
- Renewal rate by priority tier
- Downtime for non-renewals
- Market rent for new leases
- Concessions for new tenants
Forecast cash flows for next 3-5 years
Key Metrics
Weighted Average Lease Term (WALT)
Formula:
WALT = Σ (Remaining Lease Term × Annual Rent) ÷ Total Annual Rent
Example:
Tenant A: 3 years remaining, $100K/year → 3 × $100K = 300
Tenant B: 5 years remaining, $200K/year → 5 × $200K = 1,000
Total Annual Rent: $300K
WALT = (300 + 1,000) ÷ 300 = 4.33 years
Interpretation:
- WALT > 5 years: Stable cash flow
- WALT 3-5 years: Moderate stability
- WALT < 3 years: High rollover risk
Retention Rate
Formula:
Retention Rate = Renewed SF ÷ Expiring SF
Example:
2024 Expiries: 50,000 SF
Renewals: 35,000 SF
Retention: 35,000 ÷ 50,000 = 70%
Benchmarks:
- Office: 60-70%
- Industrial: 70-80%
Expiry Concentration Index
Formula:
ECI = (SF Expiring in Peak Year) ÷ Total Portfolio SF
Example:
Peak year expiries: 100,000 SF
Total portfolio: 250,000 SF
ECI = 100,000 ÷ 250,000 = 40%
Risk Levels:
- <20%: Low risk (well-staggered)
- 20-30%: Moderate risk
-
30%: High risk (expiry cliff)
Red Flags
Expiry Cliff Risk
40%+ of SF expiring in one year:
- Mass vacancy risk
- Action: Accelerate renewal negotiations, offer concessions to retain
Low WALT (<3 years)
Insufficient lease term remaining:
- Refinancing challenge (lenders want WALT > 5 years)
- Property valuation risk
- Action: Extend lease terms proactively
Below-Market Rent Concentration
50%+ of tenants paying below market:
- Mark-to-market opportunity BUT renewal risk
- Tenants may vacate if pushed to market
- Action: Gradual rent increases, stagger renewals
Weak Tenant Credit Concentration
30%+ of rent from C/D credit tenants:
- Default risk
- Action: Diversify tenant mix, require guarantees
Integration with Slash Commands
This skill is automatically loaded when:
- User mentions: portfolio, rollover, expiry cliff, renewal priority, vacancy forecast
- Commands invoked:
/rollover-analysis
- Reading files: Portfolio lease schedules, rent rolls
Related Commands:
/rollover-analysis <portfolio-data-path> - Analyze lease expiry timeline and renewal priorities/renewal-economics <current-lease-path> - Renewal vs. relocation NPV for individual leases
Examples
Example 1: Industrial Portfolio Rollover Analysis
Portfolio: 5 industrial buildings, 500,000 SF total, 25 tenants
Rollover Schedule:
Year | Expiring Leases | SF | % Total | Cumulative
-----+-----------------+---------+---------+------------
2025 | 3 tenants | 75,000 | 15% | 15%
2026 | 8 tenants | 200,000 | 40% | 55% ← CLIFF
2027 | 5 tenants | 100,000 | 20% | 75%
2028 | 4 tenants | 75,000 | 15% | 90%
2029+| 5 tenants | 50,000 | 10% | 100%
Analysis:
EXPIRY CLIFF IDENTIFIED
2026: 40% of portfolio expires (200,000 SF)
- 8 tenants simultaneously
- Risk: Cannot re-lease 200K SF in one year if multiple vacate
WALT: 2.8 years (below 3-year threshold)
- Refinancing risk
- Lenders prefer WALT > 5 years
Retention Rate (Historical): 75%
- Expected renewals (2026): 150,000 SF
- Expected vacancies (2026): 50,000 SF
- Downtime: 9 months average
- Revenue loss: $450,000 (estimated)
Renewal Priority (2026 Expiries):
Tenant | SF | Rent | Credit | Market | Priority | Action
---------------+--------+-------+--------+--------+----------+------------------
ABC Logistics | 80,000 | $8/sf | A- | At mkt | HIGH | Renew early, lock in
XYZ Warehouse | 50,000 | $7/sf | B | -10% | HIGH | Renew at market
Small Co. | 15,000 | $9/sf | C | +15% | LOW | Push to market or release
...
Strategy:
- Immediate (2024): Engage ABC Logistics and XYZ Warehouse for early renewal (2+ years before expiry)
- Offer: Market rent + small TI refresh ($3/SF) to secure 5-year renewals
- Goal: Lock in 130,000 SF (65%) by end of 2024, reducing 2026 cliff to 70,000 SF (14%)
- Result: Smoother rollover, improved WALT, reduced refinancing risk
Forecast (After Strategy):
Revised 2026 Expiries: 70,000 SF (down from 200K)
Expected Renewals: 52,500 SF (75% retention)
Expected Vacancies: 17,500 SF (manageable)
Revenue Loss: $157,500 (down from $450K)
Savings: $292,500 in avoided vacancy losses
Example 2: Renewal Priority Scoring
Tenant: Acme Distribution
Lease Details:
- Space: 25,000 SF warehouse
- Current Rent: $7.50/SF
- Market Rent: $8.50/SF
- Expiry: December 2025 (18 months)
- Tenant Credit: B+
- Years in Building: 8 years (good history)
Scoring:
Factor | Weight | Score | Weighted | Notes
----------------------+--------+-------+----------+------------------------
Tenant Credit (B+) | 30% | 4 | 1.20 | Strong credit
Market Rent Gap | 25% | 4 | 1.00 | 12% below market (upside)
Strategic Value | 20% | 5 | 1.00 | Long-term, reliable tenant
Expiry Urgency | 15% | 4 | 0.60 | 18 months (good timing)
Space Fit | 10% | 4 | 0.40 | Warehouse user (ideal fit)
----------------------+--------+-------+----------+------------------------
TOTAL SCORE | 100% | | 4.20 | HIGH PRIORITY
Recommendation:
RENEWAL PRIORITY: HIGH (Score 4.20/5.00)
Action Plan:
1. Engage tenant NOW (18 months before expiry)
2. Offer renewal at $8.00/SF (mid-market)
3. Provide $3/SF TI refresh ($75K)
4. Secure 5-year renewal
5. Lock in quality tenant, capture some rent upside
Economics:
- Current Rent: $7.50/SF × 25K = $187,500/year
- Renewal Rent: $8.00/SF × 25K = $200,000/year
- Increase: $12,500/year
- TI Cost: $75,000 (payback 6 years, acceptable)
- Avoids: 9 months downtime = $140,625 lost rent
- Net Benefit: $65,625 vs. letting lease expire
Skill Version: 1.0
Last Updated: November 13, 2025
Related Skills: effective-rent-analyzer, commercial-lease-expert, tenant-credit-analyst, lease-abstraction-specialist
Related Commands: /rollover-analysis, /renewal-economics
