← All articles
Credit Analysis5 min read

How to Read a Rent Roll for CRE Underwriting

What each column of a rent roll tells a commercial real estate lender, how to spot rollover risk, and how to tie the rent roll to the operating statement.

In brief

A rent roll lists every unit or tenant in a property with the terms each one pays under. To read one, check occupancy and vacancy, sort the leases by expiration to find rollover risk, look for tenant concentration, and reconcile rent in place to the operating statement before it feeds net operating income and loan sizing.

What Is a Rent Roll?

A rent roll is a list of every unit or tenant in a property, with the terms each one pays under. For an income property, it is the closest thing a lender has to a list of the borrower’s customers. The operating statement tells you what the property earned last year; the rent roll tells you who is paying today.

It also tells you on what terms, and for how long. Good CRE underwriting reads the two together.

What a Rent Roll Shows

Formats vary by property type and by who prepared it, but most commercial rent rolls carry the same core columns: unit and tenant, square footage, lease start and expiration, current rent, scheduled increases and options, reimbursements, and security deposits and concessions. Vacant units should be listed too, not left off.

For multifamily, the rent roll is usually unit by unit, with the unit type, the lease term, the rent in place and often a market rent column for comparison.

ColumnWhat it tells the lender
Unit or suite and tenant nameWho occupies the space. Vacant units belong on the list too.
Square footageFor office, retail and industrial, rent is usually quoted per square foot, so size matters as much as the dollar amount.
Lease start and expiration datesThe most important pair of columns for judging risk over the loan term.
Current rentMonthly or annual base rent, and often rent per square foot.
Scheduled increases and optionsBuilt-in rent steps, and any tenant options to renew, expand or terminate.
ReimbursementsWhether the tenant pays a share of taxes, insurance and common area costs (a net lease) or the landlord carries them (a gross lease).
Security deposits and concessionsDeposits held, plus free rent periods, tenant improvement allowances or reduced rent in the early months of a lease.

Start With Occupancy and Vacancy

Count what is actually leased and paying. Physical occupancy (space with a tenant in it) and economic occupancy (rent actually being collected) can differ: a tenant in a free rent period occupies the space but pays nothing yet. Then look at the vacant space. How long has it been empty, and what is the plan to lease it?

A borrower’s projection that assumes the vacant suite leases next quarter is an assumption, not income.

Read the Expiration Dates as a Schedule

Rollover risk is the chance that a meaningful share of the rent expires at once, or before the loan matures. Sort the rent roll by lease expiration and add up the rent expiring in each year of the loan term. Then check concentration: one tenant paying a large share of the rent is a different risk from twenty small ones.

If that large tenant leaves, how long does the space take to re-lease, and what will it cost in tenant improvements and leasing commissions?

A Worked Example: A Five-Suite Retail Center

A small retail center has five suites and 20,000 square feet. Four suites are leased, for 85% occupancy and $330,000 a year of rent in place. Two leases, paying $174,000 or about 53% of that rent, expire within the next 12 months. More than half the income is up for renewal in the first year of a new loan.

Leased space is 17,000 of 20,000 square feet. Suites A and C both expire within the next 12 months.

That doesn’t mean decline. It means questions. Have A and C been asked about renewal? Are they in good standing? What is market rent for that space, and would a renewal come in higher or lower? A reasonable structure might size the loan on more conservative income, or hold a reserve until the leases are renewed.

Illustrative rent roll, dated November 2026
SuiteSquare feetRent per SFAnnual rentLease expires
A6,000$18.00$108,000March 2027
B4,000$20.00$80,0002029
C3,000$22.00$66,000September 2027
D4,000$19.00$76,0002031
E3,000Vacant$0Vacant
Total20,000 (17,000 leased)$330,000
Illustrative figures.

Tie the Rent Roll to the Operating Statement

The rent roll is usually prepared by the borrower or the property manager. The operating statement, especially the trailing twelve months, shows what was actually collected, and the two should be reconcilable. In the example, annualized rent in place is $330,000. If trailing twelve month rental income is $305,000, the $25,000 gap needs an explanation.

Common explanations: a tenant moved in partway through the year, a new lease included free rent, or a tenant has been paying late or not at all. Each leads somewhere different. A recent move-in is good news. A tenant who is behind is a collection problem the rent roll doesn’t show.

Ask for an aging of tenant receivables and copies of the major leases, and compare the lease terms to what the rent roll says.

From Rent Roll to Underwriting

Once the rent roll is reconciled, it feeds net operating income. Underwritten income generally starts from rent in place, applies a vacancy and collection allowance, and adds reimbursements and other income. Operating expenses come off to get NOI, which drives both the property’s value and its debt service coverage.

That coverage is where rate and rollover risk meet. Our post on how a rate increase affects DSCR shows how quickly the cushion narrows, and What Does DSCR Tell a Lender, and What Does It Miss? covers what the ratio can hide.

Learn It on Full Cases

Rent rolls, leases, NOI, appraisal and cap rate review, loan sizing and stress testing are all part of the CRE Loan Underwriting learning path. Shockproof cases come with full financials, so analysts work from the same kinds of documents, rent rolls and leases included, that they will see in a real credit file.

Learning Paths

Learn Rent Roll Analysis on Full Cases

CRE Loan Underwriting covers rent rolls, leases, NOI, loan sizing and stress testing on complete property files.

Explore CRE Loan Underwriting

Frequently Asked Questions

What is the difference between physical and economic occupancy?

Physical occupancy measures space with a tenant in it. Economic occupancy measures rent actually being collected. A tenant in a free rent period, or one who has stopped paying, counts toward physical occupancy but not economic occupancy.

What is rollover risk in commercial real estate?

Rollover risk is the chance that a meaningful share of a property’s rent expires at once, or before the loan matures. Lenders measure it by sorting the rent roll by lease expiration and adding up the rent expiring in each year of the loan term.

Why doesn’t the rent roll match the operating statement?

The rent roll shows rent in place today; the operating statement shows what was collected over a past period. Gaps usually come from mid-year move-ins, free rent or tenants paying late. Confirm the explanation with the leases and an aging of tenant receivables.

More From the Blog

Last updated November 11, 2026.