A rent roll is not a summary document. In the hands of an experienced underwriter, it is a diagnostic tool — one that, when properly interrogated, reveals the true risk profile of an asset far more clearly than any trailing income statement.
Yet too many acquisitions teams treat the rent roll as a data input rather than a starting point for analysis. They populate their models with in-place rents, apply a market vacancy assumption, and move on. That approach leaves real money on the table — and real risk on the books.
This piece walks through a systematic framework for deconstructing a rent roll lease-by-lease, covering the four analytical layers that separate a defensible underwrite from a back-of-the-envelope guess.
Expiration Laddering and Rollover Concentration
The first question any underwriter should ask is not what are tenants paying today, but when does that income stop being contractually guaranteed?
Map every lease expiration across a 10-year horizon and bucket them by year. What you are looking for is concentration — specifically, any single year where more than 20–25% of your gross leasable area (GLA) or base rent rolls. A property where 40% of leases expire in Year 3 is a fundamentally different risk proposition than one with smooth, laddered expirations, even if the in-place NOI is identical.
Concentration risk compounds when large expirations align with macro headwinds or local market softness. Model the downside: if that Year 3 cohort does not renew and the space sits vacant for 9–12 months before re-leasing at market, what happens to your debt service coverage? Does the deal still pencil at your acquisition basis?
Beyond concentration, assess the quality of upcoming rollovers. A 50,000 SF anchor tenant expiring in Year 2 is categorically different from fifteen small-shop tenants expiring in the same year. The anchor drives co-tenancy clauses, foot traffic, and potentially the entire asset's re-leasing velocity.
“Any single year where more than 20–25% of GLA or base rent rolls represents a concentration risk that demands scenario modeling.”
Mark-to-Market Analysis
Once you have mapped expirations, the next step is benchmarking every in-place rent against current market rent for comparable space. This mark-to-market (MTM) analysis is where significant embedded value — and embedded risk — surfaces.
For each tenant, calculate the spread between their contractual rent and your estimate of achievable market rent, expressed both in absolute dollar terms and as a percentage. Aggregate these spreads across the rent roll to produce a portfolio-level MTM position.
Below-market leases represent optionality. When these tenants roll, you can capture upside — but only if the market holds and you can re-lease at your projected rate. Discount this upside appropriately. A tenant 15% below market expiring in Year 7 is not the same as one expiring in Year 2; the former requires you to forecast rents seven years out with confidence.
Above-market leases represent the inverse risk. These tenants are paying rents that exceed what the market would currently support, meaning renewal is uncertain and replacement rents at expiration will likely reset lower. This is where many acquisition models are quietly optimistic — they assume flat or growing rents on above-market leases without adequately stress-testing the rollback scenario.
The honest MTM analysis forces a reckoning: what is the blended re-leasing spread across the entire roll, and how much capital (TI, free rent, leasing commissions) will it cost to achieve it?
“Above-market leases are where many acquisition models are quietly optimistic — assuming flat or growing rents without stress-testing the rollback scenario.”
Tenant Credit and Lease Structure Scrutiny
Not all rent is equal. A $50/SF lease with a creditworthy national tenant on a 10-year NNN structure is worth materially more than the same rent from a regional operator on a gross lease with a co-tenancy kick-out clause.
Tenant credit quality: Segment tenants by credit tier — investment-grade nationals, regional credits, and local operators. For non-public tenants, request financial statements and assess rent-to-sales ratios where available. A tenant paying 12% of gross sales in rent is far more sustainable than one paying 18%. This matters not just for renewal probability, but for lender underwriting and exit cap rate.
Lease structure: Gross vs. NNN vs. modified gross leases have enormous implications for expense recovery and NOI stability. Map out which tenants are responsible for CAM, insurance, taxes, and utilities. A rent roll that looks strong on base rent can underperform significantly if expense recoveries are capped, excluded, or structured in ways that shift burden to the landlord.
Embedded options: Comb every lease abstract for renewal options (and critically, the rent reset mechanism — fair market value resets can mean re-negotiating rents downward), expansion rights, rights of first refusal, termination options, and co-tenancy provisions. These clauses can materially alter your projected cash flows and your ability to re-tenant or reposition the asset.
“A rent roll that looks strong on base rent can underperform significantly if expense recoveries are capped or structured to shift burden to the landlord.”
Building the Dynamic 10-Year Cash Flow Model
With the lease-by-lease analysis complete, you now have the inputs needed to build a projection that reflects the actual contractual reality of the asset — not a smoothed approximation of it.
Structure your model to run each lease independently through its contractual term, capturing scheduled rent steps, expense recovery adjustments, and option exercise scenarios. At expiration, apply your re-leasing assumptions: downtime, TI allowance, free rent period, leasing commission, and new rent — differentiated by tenant tier and space size rather than applied as a portfolio-wide average.
The output of this approach is a cash flow model where every inflection point is traceable to a specific lease event. This matters operationally (for asset management planning) and analytically — when a lender or equity partner challenges your projections, you can defend each assumption at the tenant level rather than retreating to market generalities.
Run at minimum three scenarios: a base case reflecting your best estimate of re-leasing outcomes, a stress case assuming extended downtime and lower renewal rents across the above-market cohort, and an upside case capturing full MTM capture on below-market leases at renewal. The spread between your stress and upside IRRs is the honest expression of the risk you are underwriting.
“The spread between your stress and upside IRRs is the honest expression of the risk you are underwriting.”