analyzing-retail-properties

# Analyzing Retail Properties

Structures retail property analysis with tenant sales productivity, co-tenancy evaluation, and redevelopment potential.

## When To Use

- Underwriting an acquisition or disposition of a retail center (strip, power, lifestyle, enclosed mall)
- Evaluating tenant rollover risk and re-leasing spreads for an existing portfolio asset
- Assessing redevelopment or repositioning feasibility for underperforming retail
- Preparing investment committee memos, REIT earnings supplements, or lender due-diligence packages
- Benchmarking a property's sales productivity against submarket or peer-set comps

## Inputs To Gather

- **Rent roll**: tenant name, suite SF, lease start/expiration, base rent PSF, percentage rent thresholds, renewal options, co-tenancy and kick-out clauses
- **Tenant sales reports**: trailing-12-month (T12) and 3-year gross sales per SF by tenant; occupancy cost ratios
- **Operating statements**: T12 and 3-year NOI, CAM/tax/insurance recoveries, management fees, capital reserves
- **Property details**: GLA, site acreage, parking ratio, pad sites, outparcels, zoning designation [VERIFY local zoning code]
- **Market data**: submarket vacancy, asking rents, recent lease comps, planned competitive supply, trade-area demographics (population, HHI, daytime employment)
- **Capital history**: recent and deferred CapEx, roof/HVAC/parking lot condition reports, environmental Phase I status

## 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]