Rent Roll Analysis in CRE Underwriting: Breaking Down the Foundation of Cash Flow

In a commercial real estate transaction, underwriting begins well before a model is built. The rent roll is often the first and most revealing dataset—it captures the reality of the asset’s income stream: who the tenants are, how rent is structured, and how long that income is likely to last.

But a rent roll is more than a static snapshot of cash flow. It is a compressed view of the asset’s risk profile. Embedded within it are signals around tenant concentration, lease rollover risk, mark-to-market opportunities, and exposure to operating costs. Interpreting these signals correctly is what separates surface-level analysis from true underwriting insight.

This article breaks down how to approach rent roll analysis in a structured manner—focusing on tenant concentration, lease structures, recovery mechanisms, data integrity, and the practical challenges of working with real-world rent roll data—so that the income stream is not just understood, but appropriately stress-tested.

Tenant Concentration: Understanding Where the Risk Sits

One of the first areas of focus in rent roll analysis is tenant concentration. Not all income is equal, and a property’s stability often depends on how diversified its tenant base is.

The largest tenant by rent is usually the starting point. If a single tenant contributes a significant portion of total income—say 35–40%—the property begins to behave more like a single-tenant asset rather than a diversified one. In such cases, the underwriting effectively becomes a credit assessment of that tenant.

Equally important is identifying the largest tenant by space. This tenant shapes the physical identity and leasing dynamics of the property. In retail, this could be an anchor tenant driving footfall; in office, a flagship tenant influencing the building’s positioning in the market.

Lease term adds another layer to this analysis. If a major tenant—whether by rent or space—has a significantly shorter remaining lease term compared to the overall weighted average lease term (WALT), it introduces near-term rollover risk. For instance, a tenant contributing 40% of rent with only two years remaining on the lease in a property with a five-year WALT presents a clear concentration of risk in a short time frame.

In such scenarios, it is often useful to underwrite the asset under a “tenant loss” case—evaluating cash flows and valuation both with and without that tenant. This helps quantify the downside and better frame investment decisions.

Vacancy also plays a role in concentration analysis. A property with 15–20% vacancy may appear attractive if lease-up assumptions are aggressive, but those assumptions need to be grounded in market realities. Overestimating absorption can materially overstate returns.

Another subtle but important factor is renewal options that are below market. Tenants with such options may limit the ability to mark rents to market, effectively capping upside in an otherwise improving leasing environment.

Lease Structure and Expense Recoveries: Translating Revenue into NOI

Beyond who the tenants are, the structure of leases determines how revenue translates into net operating income.

In properties where leases are predominantly triple net (NNN), tenants reimburse most operating expenses. If this aligns with market convention, the landlord is relatively insulated from fluctuations in expenses such as property taxes, insurance, and maintenance.

On the other hand, gross lease structures shift this burden entirely to the landlord. In such cases, even modest increases in operating expenses can directly compress NOI. For example, a 10–15% increase in property taxes in a gross-leased office building flows straight through to the bottom line unless offset by rent growth.

Even within net lease structures, recoveries are not always straightforward. Caps on common area maintenance (CAM), exclusions, and billing inefficiencies can result in under-recovery of expenses. A gap of even a few dollars per square foot across a large asset can translate into significant NOI leakage. This makes recovery reconciliation an important part of detailed underwriting, particularly in later stages of diligence.

Lease Integrity: Aligning Rent Roll with Legal Documents

While the rent roll serves as the primary dataset for analysis, it is ultimately a summary. The lease agreement remains the governing legal document.

Discrepancies between the rent roll and lease documents are not uncommon. These may include differences in lease expiry dates, escalation structures, or rent abatements. For example, a rent roll may present a flat rental rate, while the underlying lease includes free rent periods or stepped escalations that materially affect near-term cash flows.

Ensuring alignment between these sources becomes critical, particularly as underwriting moves from initial screening to detailed due diligence. At early stages, a high-level review may suffice, but a full lease abstraction becomes essential before finalizing assumptions.

Contextualizing the Analysis: Matching Depth to Deal Stage

The depth of rent roll analysis should be aligned with the stage of the transaction.

In the initial phase—when evaluating an offering memorandum or screening opportunities—the focus is typically on high-level indicators such as tenant concentration, lease term profile, and vacancy. At this stage, speed and directional insights matter more than precision.

As the transaction progresses into due diligence, the analysis becomes more granular. Detailed lease reviews, recovery reconciliations, and validation of rent roll data against source documents become necessary. These exercises are time-intensive and are usually justified only when there is a clear intent to proceed with the transaction.

It is also important to recognize that certain datasets, such as detailed expense recoveries or reconciliations, may not be available until later stages of the process.

Preparing the Rent Roll for Analysis: The Hidden Effort

Before any meaningful analysis can begin, the rent roll itself often needs to be standardized.

Property managers use a variety of systems, resulting in rent rolls that differ widely in format and structure. Converting these into a consistent, analysis-ready format—often in Excel—is a necessary first step.

During this process, maintaining consistency in tenant names is critical. Variations in naming conventions can make it difficult to aggregate exposure at the tenant level, leading to incomplete or misleading conclusions.

Dates require particular attention. Differences in formatting conventions (MM/DD/YYYY vs. DD/MM/YYYY) can lead to misinterpretation, and dates stored as text may not feed correctly into calculations such as lease expiry schedules or WALT.

Rent figures also need careful handling. Markets may report rents on a per square foot per year or per month basis. Misinterpreting this convention can significantly distort revenue figures. As a best practice, using actual dollar rents rather than derived per square foot values helps avoid rounding discrepancies and ensures consistency in financial models.

Finally, while lease start dates are often overlooked in forward-looking models, they provide useful context on tenant tenure. Long-standing tenants may have different renewal probabilities compared to newer occupants, and this can influence assumptions around lease rollover and stability.

Closing Perspective

Rent roll analysis is not merely a mechanical step in underwriting—it is where the core risks and opportunities of an asset begin to surface.

A disciplined approach to evaluating tenant concentration, lease structures, and data integrity helps build a more accurate picture of cash flow durability. When done well, it provides the foundation for all subsequent underwriting decisions.

Because ultimately, if the rent roll is not fully understood, the rest of the model is built on assumptions that may not hold.