How to read a rent roll for a commercial mortgage application

A rent roll is the single most important income document in a commercial mortgage file. It tells the lender who is paying rent, how much, under what conditions, and for how long. If you are working in commercial mortgages and you cannot read a rent roll confidently, you are going to miss things that matter — and so will your clients.

What a rent roll is

A rent roll is a spreadsheet summary of every tenant in an income-producing property. It lists each unit or space, the tenant name, the lease start and end date, the monthly or annual rent, any escalations, and often the square footage. A well-prepared rent roll also notes which leases are gross and which are net, and flags any vacant units.

Lenders use the rent roll as the starting point for calculating the Net Operating Income (NOI) of the property. Without it, there is no underwriting. A borrower submitting a commercial mortgage application who does not have a current rent roll is not ready to submit.

The columns to check

Not every rent roll is formatted the same way, but every useful one contains the following data points. Go through them systematically:

Tenant name and unit

Who is the tenant? A national covenant — a Tim Hortons, a Shoppers Drug Mart, a federal government agency — is worth more to a lender than a single-person sole proprietorship. Lenders assess the quality and stability of the tenant base, not just whether a space is occupied. A building with 80% occupancy from strong national tenants can get better terms than one at 95% occupancy filled with month-to-month local businesses.

Lease start and expiry dates

Lease expiry risk is the factor most agents underestimate. If a 10-unit strip mall has three leases expiring in the next 12 months, the lender is not going to value those units at the current rent. They may apply vacancy allowances, or in some cases discount the income from those units entirely. Look for lease expiry clustering. If 40% of the GLA (gross leasable area) rolls in year one of the mortgage term, that is a risk worth flagging and discussing with the lender before submission.

Contracted rent vs. market rent

Some leases are above market — the tenant locked in years ago when rates were higher. Some are below market — the owner wanted to fill space quickly. If contracted rent is significantly above market, the lender may apply a market rent haircut when calculating income. Ask the borrower or their broker for recent comparables to support current rent levels.

Rent escalations

Many commercial leases include annual escalations — either a fixed percentage (1–3% per year is common) or CPI-linked. Note whether escalations are already contracted and how they affect the forward income. Some lenders will give partial credit to future escalation income; others will only use current contracted rent.

Vacancy rate impact on NOI

Lenders do not take the gross scheduled income from a rent roll at face value. They apply a vacancy and credit loss allowance — typically 5% to 10% for stabilized multi-residential properties, and 5% to 15% for commercial properties depending on the market and property type. For retail with near-term lease expirations, they may apply 15% or more.

Vacancy is not just the units that are currently empty. It is also the units where leases are expiring and re-leasing is uncertain. Model the vacancy conservatively and you will avoid surprises at appraisal.

Gross leases vs. net leases

This distinction affects how you read the income and how you model expenses. In a gross lease, the landlord collects a flat rent and pays all operating expenses — property tax, insurance, maintenance, utilities. The landlord's NOI is the rent minus all those costs. In a net lease (or triple net, NNN), the tenant pays base rent plus their proportionate share of property tax, insurance, and maintenance. The landlord's NOI is much closer to the gross rent because most expenses flow through to tenants.

When building a NOI calculation, you need to know which lease structure applies to each unit. A mixed building — some gross leases, some net leases — requires careful unit-by-unit analysis. Do not assume all leases in a building operate the same way.

How lenders use the rent roll to calculate NOI

The lender's NOI calculation follows a standard flow:

1. Gross Scheduled Income (total rent if all units are occupied at contracted rates)
2. Less: Vacancy and credit loss allowance (lender-applied, typically 5–15%)
3. Equals: Effective Gross Income
4. Less: Operating expenses (property tax, insurance, management, maintenance, reserves)
5. Equals: Net Operating Income (NOI)

The NOI is then divided by the capitalization rate to produce the lender's assessed value. That value, not the purchase price or appraised value alone, drives the maximum mortgage amount. A rent roll that is thin, has high near-term vacancy, or has unsubstantiated income will produce a lower NOI and therefore a lower max mortgage.

Your job as the agent is to ensure the rent roll is current, complete, and supported by leases. Submit the actual leases alongside the rent roll so the lender can verify what the roll shows. Missing or inconsistent documentation is one of the most common reasons commercial files stall in underwriting.