lev-os 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
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
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
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)
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]
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]
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]