RetailRent Roll Analysis

Rent Roll Analysis for Retail Properties

How CRE investors analyze retail rent rolls for shopping centers and strip malls. Occupancy cost ratios, sales data, and verification steps.

Last updated: March 8, 2026Compare PricingUpload a Lease

Rent Roll Analysis for Retail Properties

Retail rent roll analysis goes beyond basic occupancy and rent schedules. For shopping centers and strip retail, investors must evaluate tenant mix, occupancy cost ratios, sales performance, and the interdependencies between tenants created by co-tenancy and exclusive use provisions.

Interactive Tool

Cap Rate & Property Value Calculator

$

$250,000/yr

6.00%

Property Value

$4,166,667

Monthly Income

$20,833

Adjust the sliders to model how changes in NOI or cap rate affect property valuation.

What a Retail Rent Roll Should Include

A complete retail rent roll includes:

  • Tenant name, suite number, and square footage.
  • Lease start and expiration dates.
  • Base rent (monthly, annual, and per square foot).
  • Percentage rent breakpoint and rate.
  • Trailing 12-month reported sales (if available).
  • CAM, tax, and insurance charges.
  • Option rights summary (renewal, kick-out, termination).
  • Co-tenancy trigger tenants and current status.
  • Exclusive use category.

Key Metrics for Retail Rent Roll Analysis

Occupancy Cost Ratio

Total occupancy cost (base rent + CAM + percentage rent + tax/insurance) divided by gross sales. Healthy retailers typically operate at 8–12% occupancy cost. Ratios above 15% signal tenant stress and potential vacancy risk.

Sales Per Square Foot

Compare each tenant's sales productivity against category benchmarks. A coffee shop doing $800/SF is strong; a clothing retailer at $150/SF may be struggling. Sales PSF directly affects percentage rent projections and renewal likelihood.

Inline vs. Anchor Rent Spread

Anchors typically pay significantly lower rent per square foot than inline tenants but drive foot traffic. Analyze the spread and model the impact of anchor departure on inline economics, factoring in co-tenancy provisions.

Lease Rollover and Tenant Retention

Retail tenant retention rates are lower than office or industrial. Map expirations and model realistic retention and downtime assumptions based on the tenant category and market conditions.

CAM Recovery Ratio

Compare total CAM billed to tenants against actual common area expenses. Leakage from cap provisions, excluded categories, or vacant-space absorption reduces the effective recovery ratio.

Common Retail Rent Roll Issues

1) Stale or Missing Sales Data

Percentage rent depends on accurate sales reporting, but some tenants underreport or report late. Confirm reporting compliance and request historical sales data, not just the most recent period.

2) Temporary Tenants and Pop-Ups

Short-term tenants on license agreements may appear on the rent roll but generate unpredictable income. Separate permanent tenants from temporary occupants in your analysis.

3) Co-Tenancy Impact Not Modeled

A rent roll showing full base rent may not reflect co-tenancy remedies that are either currently active or could activate if a named tenant departs. Model both the current state and the downside scenario.

4) Percentage Rent Overprojection

Sellers may project future percentage rent based on trailing sales trends without accounting for seasonal patterns, category disruption, or tenant turnover. Use conservative assumptions.

Retail Rent Roll Verification Workflow

  1. Request the current rent roll with trailing sales data.
  2. Calculate occupancy cost ratios for every tenant.
  3. Benchmark sales per square foot against category norms.
  4. Map co-tenancy triggers and model anchor departure scenarios.
  5. Verify CAM recovery ratios against actual expense data.
  6. Build lease expiration schedule with retention assumptions.
  7. Cross-reference against estoppel certificates and lease abstracts.

FAQ

What is a healthy occupancy cost ratio for retail tenants?

Most retail tenants operate sustainably at an occupancy cost ratio of 8-12% of gross sales. Ratios above 15% indicate the tenant is overpaying relative to their revenue, which increases the risk of non-renewal or lease renegotiation. Food and beverage tenants may tolerate slightly higher ratios due to lower margins being standard in that category.

How do you value a retail property with percentage rent?

Percentage rent should be analyzed separately from base rent when valuing a retail property. Use trailing 3-year average percentage rent collections rather than a single year to smooth out seasonal and economic fluctuations. Apply a higher cap rate to the percentage rent income stream than to base rent because it is inherently less predictable and more dependent on tenant performance.

How should pop-up and temporary tenants be treated in the rent roll?

Temporary tenants on license agreements should be separated from permanent tenants in your analysis. Their income should not be annualized or projected forward at the same confidence level as long-term lease income. Most buyers and lenders will exclude short-term license income from stabilized NOI calculations.

What is the best way to stress-test a retail rent roll?

Model an anchor departure scenario to see how co-tenancy provisions cascade across inline tenants. Then calculate the resulting rent reduction, increased vacancy, and timeline to re-tenant the anchor space. This stress test reveals the true downside risk that a static rent roll does not show.

How LeaseParse Helps

LeaseParse extracts the provisions that drive retail rent roll analysis — percentage rent terms, co-tenancy triggers, CAM structures, and option rights — directly from lease documents into structured data. Upload a lease or compare pricing.

Related Topics