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.

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. This is the single most important metric for predicting tenant renewal risk. Here are benchmarks by retail category (sources: Adventures in CRE, Coldwell Banker Commercial):

| Retail Category | Healthy Occupancy Cost Ratio | Warning Threshold | |---|---|---| | Grocery / Supermarket | 2–4% | Above 5% | | Drug Store / Pharmacy | 4–6% | Above 8% | | Quick-Service Restaurant (QSR) | 6–8% | Above 10% | | General Retail / Apparel | 8–12% | Above 15% | | Specialty / Boutique | 10–15% | Above 18% | | Jewelry (Regional Mall) | 15–22% | Above 25% | | Fitness Center | Up to 30%+ | Varies widely |

For retail or QSR tenants, operating between 6–8% is considered healthy. Neighborhood center medians run 8–9% of sales, while regional malls range 9–16%. Ratios above 15% signal tenant stress and potential vacancy risk — the tenant may request rent relief or vacate at expiration.

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. Publicly traded retail REITs often report portfolio-level sales PSF in investor presentations — use these as reference points when your own data is limited.

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.

How to Calculate Occupancy Cost Ratio from a Retail Rent Roll

Occupancy Cost Ratio = Total Occupancy Cost / Tenant Gross Sales x 100

Step-by-step for each tenant:

1. Sum all occupancy costs: Base rent + CAM reimbursement + property tax reimbursement + insurance reimbursement + percentage rent (if any).
2. Get gross sales: From the tenant's annual sales report (required under most retail leases).
3. Divide and multiply by 100: This gives you the occupancy cost ratio as a percentage.

Example Calculation

A clothing retailer in a neighborhood shopping center:

• Base rent: $25/SF x 3,000 SF = $75,000/year
• CAM + tax + insurance: $12/SF = $36,000/year
• Percentage rent: $0 (sales below breakpoint)
• Total occupancy cost: $111,000/year
• Gross sales: $950,000/year
• Occupancy cost ratio: $111,000 / $950,000 = 11.7%

At 11.7%, this tenant is within the healthy range for general retail (8–12%). If sales decline to $700,000, the ratio jumps to 15.9% — warning territory where non-renewal risk increases significantly.

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?

It varies by category. Grocery tenants operate sustainably at 2–4%, QSR at 6–8%, and general retail at 8–12% of gross sales (source: Adventures in CRE). Ratios above 15% indicate the tenant is overpaying relative to their revenue, which increases the risk of non-renewal or lease renegotiation. Specialty and jewelry retailers can tolerate higher ratios (15–22%) due to higher profit margins, while grocery and drug stores require very low ratios because of thin margins.

How do you calculate occupancy cost ratio from a rent roll?

Add the tenant's total annual occupancy costs (base rent + CAM + tax + insurance + percentage rent) and divide by their annual gross sales. For example, a tenant paying $111,000/year in total occupancy costs with $950,000 in sales has an 11.7% occupancy cost ratio. Calculate this for every tenant on the rent roll to identify which tenants are at risk of non-renewal and where there may be room to push rents at renewal.

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

• Rent roll analysis for office properties
• Lease abstraction for retail properties
• Operating expense reconciliation for retail
• Estoppel certificates for retail properties
• Lease audit for retail properties
• CAM charges in Houston
• Rent roll analysis for industrial properties
• Rent roll analysis for multifamily properties
• Rent roll analysis for NNN properties
• Lease extraction pricing comparison

Data last verified: April 2026. Occupancy cost benchmarks based on Adventures in CRE and Coldwell Banker Commercial. Verify current rates with local brokers.

• Rent escalation clauses in Los Angeles