What is Rent Roll Analysis in CRE Lending?

What a Rent Roll Contains

A rent roll is a property-level schedule, typically produced by the property manager, listing every unit or suite along with the tenant name, leased square footage, contracted (in-place) rent, lease commencement and expiration dates, renewal options, expense reimbursement structure (triple net, gross, or modified gross), any rent concessions or free-rent periods, and security deposit held. Where a residential rent roll can run to a few dozen simple lines, a large office or retail property's rent roll can span dozens of tenants each with materially different lease terms.

On its own, the rent roll is just a list. Rent roll analysis is the work of turning that list into a judgment about how dependable the resulting income stream actually is.

What the Analysis Is Actually Checking

• Occupancy and vacancy - leased versus vacant square footage, and whether reported occupancy matches what the lease-by-lease detail actually supports.
• Rollover risk - how much leased square footage (and how much of total rent) expires within the next one to three years, and whether those expirations are concentrated in a way that could hit NOI hard if renewals don't materialize.
• WALT (weighted average lease term) - the average remaining lease term across the property, weighted by square footage or rent, as a single summary measure of income durability.
• Rent versus market - whether in-place rents sit above, at, or below current market rents for comparable space, which affects both renewal probability and the mark-to-market opportunity (or risk) at rollover.
• Tenant concentration and credit quality - how much of total rent comes from a small number of tenants, and whether an anchor tenant's departure would materially impair the property's income.
• Concessions and free rent - burn-off of free-rent periods and other concessions, which can make trailing income look stronger or weaker than the go-forward run rate.

From Rent Roll to NOI

Rent roll analysis is the direct input to the income side of net operating income. Contracted rent, adjusted for vacancy, credit loss, and concessions, becomes the property's effective gross income - the starting figure that, net of operating expenses, produces NOI. An underwriter who accepts a rent roll's headline occupancy and total rent at face value, without checking lease-by-lease detail for near-term expirations or below-market renewal risk, can materially overstate the sustainability of that NOI figure.

Rent Roll Analysis Doesn't Stop at Closing

For loans with ongoing reporting covenants, rent rolls are typically resubmitted quarterly or annually for the life of the loan, and the same analysis - occupancy, rollover, tenant concentration - gets rerun each period as part of covenant compliance and portfolio surveillance. A deteriorating rent roll (rising vacancy, weakening rents relative to market, growing near-term rollover) is often the earliest visible sign of a property moving toward covenant stress, well before it shows up in a missed payment.

How Uptiq Approaches This

Uptiq's document agents extract rent roll data lease by lease - tenant, square footage, contracted rent, term, and reimbursement structure - from the property manager's format directly into a structured model, calculating occupancy, WALT, and rollover concentration automatically at both underwriting and each subsequent reporting period. Because rent roll extraction feeds the same platform that calculates NOI, DSCR, and debt yield and tracks covenant compliance, a change in a property's leasing profile surfaces as part of ongoing monitoring rather than only at the next scheduled review - supporting Uptiq's 24-hour covenant breach detection across its CRE lending customers.

Frequently Asked Questions