Tenant Retention Engine

1. Full Mode: 13-section output for significant rollover exposure (>15% of NRA or 3+ tenants expiring)
2. Quick Checklist Mode: condensed output for 1-2 tenants with <15% combined NRA exposure
3. Backfill Mode: activates automatically for Category 3 (High Risk) tenants, producing lease-up war room plans in parallel with retention efforts

Input Schema

Process

Section 1: Executive Summary & Portfolio-Level Analysis

• Total exposure: SF and rent at risk from expirations
• Renewal probability forecast: realistic retention rate estimate
• Revenue impact analysis: best case / base case / worst case scenarios
• Strategic imperatives: key tenants that must be retained
• Resource requirements: capital, time, approvals needed
• Rent roll concentration risk (% of NOI from top 5 tenants)
• Market rent positioning (% of tenants above/at/below market)

Section 2: WALT Impact Analysis

• Current WALT calculation
• WALT under full renewal scenario vs. full non-renewal scenario
• Per-tenant WALT contribution (which renewals move WALT the most)
• WALT impact on property valuation (buyers and lenders discount short WALT)
• Target WALT for refinancing or disposition timeline

Section 3: DSCR Covenant Monitor

• Current DSCR and covenant threshold
• DSCR impact under each renewal/non-renewal combination
• DSCR floor: minimum number of renewals needed to stay above covenant
• Cash trap and lockbox trigger analysis
• Lender notification requirements if breach is anticipated
• Flag "covenant-critical" tenants whose renewal is required regardless of economics

Section 4: Tenant Segmentation & Risk Assessment

Score and categorize all expiring tenants:

Tenant | SF | % NRA | Current Rent | Market Rent | Gap | Expiration | Renewal Prob | Strategic Importance | Risk Category

Four risk categories:

• Category 1 -- Secure (80-95% renewal probability): likely renewal, standard engagement
• Category 2 -- Engagement Required (50-79%): warning signs, proactive intervention needed
• Category 3 -- High Risk (<50%): red flags, aggressive retention or parallel backfill
• Category 4 -- Strategic Priority (must-win): critical to property, executive involvement, deal flexibility

Section 5: Per-Tenant Retention NPV

For each material tenant, NPV comparison of renewal vs. loss/backfill:

Scenario                    Year 1    Year 2    Year 3    Year 4    Year 5    NPV (7% disc.)
Renew at market             $X        $X        $X        $X        $X        $X
Renew with concession       $X        $X        $X        $X        $X        $X
Lose + backfill (6 mo)      $0        $X        $X        $X        $X        $X
Lose + backfill (12 mo)     $0        $X        $X        $X        $X        $X

NPV difference = maximum rational concession. If retention NPV exceeds non-renewal NPV by $200K, any concession package under $200K is value-accretive.

Account for: lost rent during vacancy, TI cost for new tenant (typically 2-3x renewal TI), leasing commissions (4-6% of lease value), probability-weighted downtime by market vacancy rate.

Section 6: Renewal Probability Scores

Per-tenant with supporting factors:

• Factors supporting renewal (long tenure, good relationship, at/below market rent, limited alternatives)
• Factors creating risk (above-market rent, growth needs, dissatisfaction signals, competitor outreach)
• Intelligence gathered (conversations, broker intel, market rumors)

Section 7: Competitive Intelligence

For each at-risk tenant, map top 3 alternatives:

Alternative | Building | Submarket | Asking Rent | Concessions | Advantages | Disadvantages
Option A    | 123 Main | Downtown  | $X/SF       | X mo free   | newer bldg | longer commute
Option B    | 456 Oak  | Same sub  | $X/SF       | $X TI       | same loc   | smaller plates
Option C    | Remote   | N/A       | $0          | N/A         | cost save  | lose collab

Understanding each tenant's BATNA is critical for calibrating concession offers.

Section 8: Blend-and-Extend Modeling

For tenants where WALT extension is more valuable than market-rate short renewal:

Model scenarios where below-market extension creates more value than market-rate short renewal:

• 7-year extension at $29/SF vs. 3-year renewal at $32/SF
• WALT improvement x cap rate compression = additional property value
• Quantify the "WALT premium" that justifies accepting below-market rent

Section 9: DSCR Floor Test

Matrix showing DSCR across all renewal/non-renewal combinations:

Scenario                          DSCR    vs. Covenant    Status
All renew                         1.35x   +0.10x         Safe
A + B renew, C does not           1.28x   +0.03x         Safe
Only A renews                     1.22x   -0.03x         BREACH
None renew                        1.05x   -0.20x         SEVERE BREACH

Identify the minimum renewal set for covenant compliance.

Section 10: Engagement Timeline

Month-by-month communication plan by tenant category:

• 24-18 months: relationship building, not lease-focused
• 17-12 months: formal renewal conversation, needs assessment
• 11-7 months: formal proposal, negotiation
• 6-4 months: LOI execution, lease documentation
• 3-0 months: lease execution, TI construction

Section 11: Deal Structure Proposals

Per-tenant base, aggressive, and walk-away terms:

Term Element     Base Scenario    Aggressive    Walk-Away
Term             5 years          7 years       3 years minimum
Starting Rent    $30/SF           $28/SF        $32/SF
Annual Bumps     3%               2.5%          3%
TI Allowance     $15/SF           $25/SF        $10/SF
Free Rent        2 months         4 months      0
Effective Rent   $X/SF            $X/SF         $X/SF
Total Deal Value $X               $X            $X

Section 12: Disposition/Refi Overlay

If property targeted for sale or refinancing within 18-36 months:

• Map lease expirations against disposition/refi timeline
• Which renewals are critical to support exit (WALT, occupancy, credit quality)
• Impact of each non-renewal on cap rate/valuation
• "Renewal premium": additional property value from each renewal
• Recommend deal structures extending past disposition/refi date

Section 13: Game Theory Recommendations

• Sequencing: renew anchor tenant first (signals stability). Do not approach all tenants simultaneously unless information leaks are inevitable.
• Signaling: early investment in common areas signals ownership commitment
• Commitment device: early renewal bonuses with expiration create urgency without desperation
• Information asymmetry: you know the full rent roll; the tenant knows only their lease. Frame deals as "competitive" relative to peers.
• Prisoner's dilemma: each tenant's decision affects others (building attractiveness declines as tenants leave). Early renewals create positive momentum.

Quick Checklist Mode

For 1-2 tenants with <15% combined NRA:

1. Tenant profile (1 paragraph)
2. Renewal probability (High/Med/Low with 3 reasons)
3. Recommended deal terms (1 table)
4. Retention NPV vs. turnover cost (1 calculation)
5. Action items with deadlines (5-7 bullets)

Backfill Mode

When retention fails for Category 3 tenants, produce in parallel:

1. Funnel diagnosis table (lead-to-move-in conversion rates)
2. Pricing and concession strategy with guardrails
3. Weekly war room dashboard (12-week CSV)
4. Touring and follow-up scripts (fair housing compliant)
5. A/B test plan for pricing and ad channels

Tenant Engagement Programming

Activates when user asks about tenant events, engagement programs, community building, tenant appreciation, or retention programming. This module designs and evaluates proactive engagement programs that improve tenant satisfaction and reduce turnover before lease expirations arise.

1. Engagement Program Design

   • Appreciation events: tenant anniversary recognition, holiday gifts, management thank-you touchpoints
   • Seasonal events: summer BBQs/ice cream socials, fall harvest events, holiday parties, spring wellness fairs
   • Health and wellness: on-site fitness classes, wellness challenges, flu shot clinics, mental health resources, ergonomic assessments
   • Networking and professional development: tenant-to-tenant networking mixers, lunch-and-learn speakers, industry panels, coworking hours in common areas
   • Community building: charity drives, volunteer days, building-wide sustainability initiatives, tenant advisory councils
   • Amenity programming: lobby activations (coffee bars, pop-up retail), food truck schedules, concierge services, dry cleaning/package lockers
   • Tailor event types to property type:
     • Office: networking, professional development, wellness
     • Retail: tenant mix synergy socials, cross-promotion events, seasonal activations
     • Multifamily: community events, holiday celebrations, resident socials, kids programming
     • Industrial: safety appreciation days, food trucks, holiday recognition

2. Budget Framework (see tenant-engagement-playbook.md)

   • Class A office: $5-15/SF/year, scaled by tenant count and property size
   • Class B office: $2-8/SF/year
   • Class A multifamily: $150-400/unit/year
   • Class B multifamily: $75-200/unit/year
   • Retail: $1-4/SF/year (often supplemented by marketing fund contributions)
   • Budget allocation: 40% signature events (2-3 per year), 30% recurring programming (monthly/quarterly), 20% tenant appreciation (gifts, recognition), 10% contingency/opportunistic
   • Vendor cost categories: catering ($15-35/person), entertainment ($500-2,000/event), decor/setup ($200-800/event), marketing/communications ($100-300/event)

3. ROI Methodology

   • Core formula: engagement program cost vs. retention rate improvement vs. turnover cost avoidance
   • Turnover cost components: vacancy loss (months vacant x rent), TI for new tenant (typically $15-60/SF office, $2,000-8,000/unit MF), leasing commissions (4-6% of lease value), downtime maintenance/make-ready, marketing/advertising, administrative processing
   • Retention rate improvement attribution: measure baseline turnover rate, implement engagement program, measure post-implementation turnover rate, control for market conditions (vacancy rate changes, rent competitiveness)
   • Target: 3-7 percentage point improvement in retention rate within 12-18 months of sustained programming
   • Break-even analysis: if annual engagement spend = $50K and each prevented turnover saves $25K, break-even at 2 prevented turnovers
   • Worked example: 200-unit MF, $15K annual engagement program, baseline turnover 45%, program reduces to 38% = 14 fewer turnovers x $3,000 avg turnover cost = $42K savings on $15K investment = 2.8x ROI

4. Event Calendar Template

   • Q1 (January-March): Tenant appreciation month -- welcome-back events, New Year recognition, management meet-and-greet, annual survey launch
   • Q2 (April-June): Wellness quarter -- fitness challenges, outdoor events, Earth Day sustainability activations, wellness fair
   • Q3 (July-September): Summer social -- BBQs, ice cream socials, food truck rallies, back-to-school events (MF), outdoor movie nights
   • Q4 (October-December): Holiday and gratitude -- Halloween events, Thanksgiving appreciation, holiday party, year-end tenant gifts, charitable giving drives
   • Monthly recurring: first-Friday coffee in lobby, building newsletter, tenant spotlight features
   • Ad hoc: new tenant welcome events (within 30 days of move-in), milestone celebrations (lease anniversaries at 3, 5, 10 years)

5. Tenant Satisfaction Linkage

   • Pre-program baseline: administer tenant satisfaction survey before engagement program launch (or use most recent annual survey)
   • Survey-to-program design pipeline: identify lowest-scoring satisfaction categories, design engagement programs that directly address those areas (e.g., low "community" score leads to networking events; low "management communication" score leads to monthly meet-and-greets)
   • Mid-year pulse check: 5-question pulse survey at 6 months to measure early impact
   • Annual resurvey: compare scores year-over-year, isolate engagement program impact
   • Correlation tracking: map event attendance rates to individual tenant renewal decisions -- tenants who attend 3+ events per year renew at 15-25% higher rates than non-attendees
   • Feedback loop: post-event surveys (3 questions max) to refine future programming

Output Format

Full Mode: Sections 1-13 as described above Quick Checklist: 5-item condensed output Backfill: 5-section lease-up war room plan

Red Flags & Failure Modes

• Conceding without NPV justification: every concession must be backed by the retention NPV calculation showing it is cheaper than turnover.
• Ignoring WALT impact: in disposition/refi scenarios, WALT extension at a modest discount can add more to property value than a short-term market-rate renewal.
• Simultaneous offers leaking information: sequence negotiations strategically. Anchor tenant first, then others.
• Over-conceding to low-risk tenants: Category 1 tenants have high renewal probability already. Do not offer concessions they do not need.
• Under-conceding to must-win tenants: Category 4 tenants require aggressive retention. The cost of losing them exceeds any reasonable concession.

Chain Notes

• Upstream: dd-command-center (tenant DD findings). distressed-acquisition-playbook (occupied distressed acquisitions).
• Lateral: noi-sprint-plan (renewal rate improvement is a shared NOI driver).
• Downstream: jv-waterfall-architect (retention outcomes affect NOI projections). disposition/debt analysis (WALT and occupancy stability).