How to Read a Retail Rent Roll: A Guide for Neighborhood Retail Investors

Last updated: November 14, 2026  ·  By Brandon Lehman, Managing Partner, West Hive Capital

A rent roll looks like a simple spreadsheet, yet it holds most of the story of a neighborhood retail center. Every tenant, lease date and dollar of scheduled rent sits in a few columns. This guide explains what each column tells you, which red flags deserve a second look and how the document ties to the other records in due diligence.

Key Takeaways

  • A rent roll is the seller’s schedule of tenants and leases, and it is a claim that investors must verify.
  • WALT shows the average remaining lease term, but the expiration schedule shows when income is actually exposed.
  • Leases, the T12 and tenant estoppels are the three records that confirm or contradict the rent roll.

What is a retail rent roll?

A retail rent roll is a schedule of the tenants in a shopping center along with the space they occupy, their lease terms and the rent they pay. Realized 1031 describes it as a document that provides essential information about the status and finances of a commercial property. The same page says investors use it in due diligence to judge income stability and whether rents are at, above or below market.

The rent roll comes from the seller, so treat it as a starting point and test it.

Which columns on a rent roll matter most?

The columns that matter most are the ones that show who pays, how much, for how long and under what terms. Realized 1031 lists the tenant, the space and its size, lease terms and dates, rent amounts and any security deposit as typical contents. Read these fields in order:

  • Suite, tenant and square feet: confirm that every leasable suite appears.
  • Lease start and expiration: these dates drive rollover.
  • Base rent per square foot: confirm it reflects rent in effect today.
  • Escalations and options: these shape future income.
  • NNN reimbursements and CAM: Wiss explains that NNN leases place property taxes, building insurance and CAM on the tenant in addition to base rent, and that the CAM definition in the lease governs which operating expenses are recoverable.
  • Security deposit: it should match what the tenant confirms.

The table below shows the layout with generic labels and invented numbers.

Suite / Tenant SF Lease Start Expires Base Rent / SF / Yr Escalation Options Deposit
Suite A: Coffee (national) 2,000 Jan 2023 Dec 2032 $48.00 3% annual Two 5 year $8,000
Suite B: Nail salon (local) 1,400 Mar 2021 Feb 2027 $30.00 Fixed bump yr 3 One 3 year $3,500
Suite C: Dental office (local) 1,800 Jun 2019 Month to month $34.00 None None $4,000
Suite D: Sandwich shop (regional) 1,600 Aug 2024 Jul 2029 $40.00 3% annual One 5 year $6,000

Illustrative example, not an actual property. Tenants and figures are fictional.

What do WALT and lease rollover tell an investor?

WALT, or weighted average lease term, measures how long the income stream is contracted to last, and rollover shows when that income is exposed. Property Metrics defines WALT as the average remaining lease term of tenants in a property, weighted by either rental revenue or square footage. It adds that WALT measures duration only, not tenant creditworthiness.

An average can hide timing. The same Property Metrics page notes that WALT gives an average and that detailed expiry schedules provide a more complete picture. Rets.ai warns that two properties with the same WALT can differ sharply, and it names a concentration of expirations in one year as the profile that creates rollover risk. In the sample table, Suite B expires in early 2027 and Suite C is month to month, which an average alone would not reveal.

What does mark to market mean on a rent roll?

Mark to market is the gap between the rent a tenant pays today and the rent the market would pay for the same space. Lightstone Direct states that mark to market refers to the difference between in place rent and current market rent, expressed as a percentage, and gives an example of a tenant paying $7 per square foot where the market has moved to $9, a gap of 28 percent.

Market rent needs its own evidence, so ask where each estimate comes from. Our article on what a value add strip center looks like before acquisition covers rents and terms before acquisition.

What red flags should an investor look for on a rent roll?

The main red flags are leases that are not documented, income that is not collected and tenants who are not independent of the seller. A rent roll guide from Apers recommends these checks:

  • Related party leases: request disclosure of all related party leases and exclude them from stabilized income.
  • Free rent and abatements: the guide notes that concessions reduce effective rent below the contract rent shown, and advises asking for a separate concession log when the rent roll lacks that column.
  • Tenants in default or arrears: request an aging report that breaks out receivables by 30 day buckets, since one tenant behind on rent can signal a coming vacancy.

Month to month tenants deserve the same attention. They can leave on short notice, so ask about each one.

How does a rent roll tie to the T12, leases and estoppels?

A rent roll ties out when scheduled rent matches collected rent, signed leases and the tenant’s own confirmations. Apers calls the reconciliation between scheduled gross potential rent and T12 actual collections the first diagnostic test an underwriter should run. The same guide advises pulling signed leases and comparing their terms to the rent roll entries,.

Estoppels add the tenant’s voice. Malakai Sparks describes an estoppel as a written confirmation of the current status of a lease, covering base rent, current CAM charges, the date rent is paid through, the security deposit and whether the landlord is in default. A mismatch is a reason to pause and resolve it before closing.

Our acquisition playbook and investment thesis describe our approach, and what a neighborhood retail sponsor looks for in an acquisition covers the wider checklist.

FAQ: How Do Investors Read a Retail Rent Roll?

What is a rent roll in commercial real estate?
A rent roll is a schedule of the tenants in a property, including the space each tenant occupies, lease terms and dates, rent amounts and security deposits. Investors use it in due diligence to judge income stability and how rents compare with the market.

What is a good WALT for a retail center?
No single number fits every center. WALT is an average of remaining lease term, weighted by rent or square footage, so it should be read with the full expiration schedule, tenant credit and mark to market position. A longer WALT is not always better, especially in a rising rent market.

How do estoppels relate to the rent roll?
The rent roll is the seller’s representation of the leases, while an estoppel is the tenant’s signed confirmation of its own lease status. Buyers compare the two to find mismatches in rent, CAM, deposits, defaults or side deals before closing.

If you are a family office, co GP or accredited investor who wants to learn more about how West Hive Capital approaches neighborhood retail, connect with our team.

About the Author

Brandon Lehman, Managing Partner, West Hive Capital

Brandon Lehman

Managing Partner, West Hive Capital

Brandon brings 20+ years of experience in retail real estate development and operations. He previously led projects with SCG West and oversaw the acquisition, renovation, and exit of Western Plaza in Rancho Palos Verdes. He focuses West Hive Capital on neighborhood strip centers in Southern California and metro Phoenix.

LinkedIn →

This article is for educational purposes only and is not an offer to sell or a solicitation of an offer to buy any security. Any offering is made only through confidential offering documents to qualified investors.