Analyzing Retail Properties

Workflow

1. Tenant Credit & Sales Productivity Analysis

   • Rank tenants by sales PSF vs. category benchmarks (e.g., ICSC/Green Street medians)
   • Calculate occupancy cost ratio (total rent + recoveries / gross sales) per tenant; flag any exceeding category norms (typically >12-15% for inline, >8% for anchors)
   • Identify tenants with kick-out rights triggered by sales thresholds and model probability of exercise
   • Categorize tenant credit: investment-grade national, regional chain, local independent; note bankruptcy-watch names

2. Lease Rollover & Re-Leasing Spread

   • Build a rollover schedule by year (SF and rent expiring)
   • Estimate mark-to-market on each expiring lease using submarket asking rents and recent comps
   • Model downtime and TI/LC costs for non-renewal scenarios; apply a retention probability (historical or assumed)
   • Stress-test: run a scenario where the largest anchor or top-3 inline tenants vacate simultaneously

3. Co-Tenancy & Anchor Dependency

   • Map all co-tenancy clauses: which tenants have rent reductions or termination rights tied to anchor occupancy or GLA thresholds
   • Model cascade risk: if the anchor vacates, quantify the aggregate rent reduction and potential further departures
   • Identify substitute-anchor provisions and assess feasibility of backfill (dark-store vs. re-tenanting timeline)

4. Operating Performance & Recovery Analysis

   • Reconcile CAM, tax, and insurance recoveries against actual expenses; calculate recovery ratio and leakage
   • Benchmark OpEx PSF against peer properties and identify controllable savings
   • Verify management fee structure and any related-party service contracts [VERIFY arm's-length compliance if REIT]

5. Redevelopment & Highest-and-Best-Use Assessment

   • Evaluate excess land, outparcels, and pad-site income potential
   • Assess zoning for mixed-use densification, residential conversion, or medical/experiential re-tenanting [VERIFY entitlement requirements and timeline]
   • Estimate redevelopment cost, stabilized yield-on-cost, and incremental value creation vs. as-is basis
   • Consider tax implications: 1031 exchange timing, REIT TRS structure for development activity [VERIFY tax counsel]

6. Valuation Synthesis

   • Run direct-cap valuation using stabilized NOI and market cap rate; sensitivity-test cap rate +/- 25 bps
   • Build a discounted cash flow (DCF) over 7-10 year hold with explicit lease-by-lease assumptions
   • Cross-check with recent comparable sales (price PSF, cap rate, per-unit metrics for mixed-use)
   • Reconcile cap-rate selection against risk profile: tenant credit, rollover concentration, market growth

Output

• Executive Summary: 1-page overview with property snapshot, key metrics (NOI, cap rate, occupancy, WALT, sales PSF), investment thesis, and risk flags
• Tenant Analysis Schedule: table of tenants with SF, rent PSF, sales PSF, occupancy cost ratio, lease expiry, credit tier, co-tenancy exposure
• Rollover & Cash Flow Model: year-by-year NOI projection with re-leasing assumptions, TI/LC reserves, and CapEx
• Redevelopment Scenario (if applicable): cost estimate, timeline, yield-on-cost, and comparison to as-is hold
• Valuation Summary: direct-cap, DCF, and comps-based value range with key assumption sensitivities
• Risk Matrix: ranked list of material risks (anchor vacancy, co-tenancy cascade, CapEx surprise, market supply) with probability and impact

Quality Checks

• Confirm rent roll ties to operating statements and total GLA reconciles to survey/tax records
• Validate that sales data is actual reported figures, not estimates, and note any tenants that do not report
• Ensure cap rate and discount rate selections are supported by cited market evidence, not assumed
• Verify co-tenancy clause language is read from actual leases, not summarized from abstracts alone [VERIFY lease documents]
• Check that recovery ratios and OpEx benchmarks use consistent GLA denominators (occupied vs. total)
• Flag any environmental, ADA, or structural issues identified in due-diligence reports that could affect value or timeline [VERIFY third-party reports]