Reading a rent roll the way an underwriter does

To most owners, a rent roll is a roster: who's in the building, what they pay, when their lease ends. To an underwriter, it's the single most important document in the file — the source from which net operating income, loan size, and value all flow. Learning to read your rent roll the way the lender does turns a routine spreadsheet into a tool for getting a better loan.

The rent roll drives two numbers at once

Everything starts with the income the rent roll reports. That income, after expenses, becomes net operating income — and NOI feeds two calculations that decide the deal.

• Loan size, through DSCR. NOI divided by annual debt service gives the debt service coverage ratio, which lenders typically want at or above 1.25x. Because coverage is built on NOI, the rent roll effectively sets a ceiling on how much debt the property can support.
• Property value, through the cap rate. Divide NOI by a market capitalization rate and you get an income-based valuation. The same income that determines your loan also drives the value the loan is measured against.

That dual role is why underwriters treat the rent roll with suspicion in the best sense. A single overstated rent inflates NOI, which inflates both the apparent coverage and the apparent value — so they verify it carefully rather than take it at face value.

What underwriters actually scrutinize

A skilled underwriter doesn't just total the rent column. They interrogate the durability and quality of that income across several dimensions.

• Lease expirations. When do leases roll? A property where many leases expire in the same near-term window carries rollover risk — a cluster of vacancies could hit at once. Staggered expirations are far safer than a cliff.
• Concessions. Free rent, tenant-improvement allowances, and other inducements mean the stated rent overstates what the tenant is effectively paying. Underwriters strip concessions out to find the real economic rent.
• Occupancy. Physical occupancy and economic occupancy can differ. A unit that's leased but not yet paying, or a tenant behind on rent, isn't contributing the income the roll implies.
• Tenant credit. Income is only as reliable as the tenants behind it. A roll anchored by a strong, creditworthy tenant on a long lease is worth more than the same rent from a shaky one likely to default or leave.

Reading your own roll before the lender does

The lesson for owners is to audit your rent roll with an underwriter's eye before you submit it. Reconcile every stated rent to the actual lease. Flag and explain concessions rather than letting the lender discover them. Be honest about units that are leased but not yet paying. Know your expiration schedule and have a story for any near-term cluster. Every discrepancy a lender finds on their own erodes trust and invites conservative assumptions — and conservative assumptions shrink both your loan and your valuation.

The payoff

A clean, defensible rent roll is one of the most underrated advantages a borrower can bring. It lets the underwriter accept your income with confidence, which supports a higher NOI, which in turn supports both a larger loan and a stronger valuation. The rent roll isn't paperwork to be tolerated at the end of a deal — read correctly, it's where the deal is won.