Commercial real estate rent roll analysis should verify four things: who occupies each space, what the signed lease requires, what the tenant actually pays, and when the income can change or expire. The rent roll is a summary, not proof. Investors should reconcile it to leases, amendments, collections, bank deposits, and operating statements before using its income in valuation or debt analysis.
A clean-looking spreadsheet can still hide concessions, arrears, month-to-month occupancy, related-party tenants, early termination rights, or a concentration of expirations. The central question is not whether total scheduled rent looks attractive. It is how much of that rent is contractual, collectible, durable, and transferable to a new owner.
What Is a Commercial Real Estate Rent Roll?
A commercial real estate rent roll is a property-level schedule of tenants and lease economics. A useful version identifies the tenant, suite, area, lease dates, rent, escalations, reimbursements, concessions, deposits, options, delinquency status, and guarantor when applicable.
The rent roll usually feeds gross potential income, effective gross income, net operating income, valuation, and loan sizing. It should not be treated as an independent accounting record. The executed lease governs the contractual relationship, while the general ledger and cash records show what occurred. Any difference among those records requires an explanation.
This distinction appears in institutional underwriting guidance. Fannie Mae’s property income requirements use actual in-place rents for occupied units and market rents for vacant units when calculating multifamily income from a current rent roll. Its underwritten net cash flow framework then applies vacancy, concessions, bad debt, expenses, and replacement reserves before arriving at underwritten cash flow. An equity investor may use different assumptions, but should preserve the same separation between scheduled rent and durable cash flow.
Commercial Real Estate Rent Roll Analysis in Seven Tests
1. Test completeness and physical occupancy
Start by reconciling rentable area or units to the property survey, floor plans, unit list, and inspection. Every suite should be occupied, vacant, offline, model, employee-used, owner-used, or otherwise explained. Unlisted storage, kiosks, parking, antennas, signage rights, or license agreements may create income or obligations outside the main rent schedule.
Physical and economic occupancy are different. A tenant can occupy space while paying no rent because of concessions, disputes, delinquency, or an unsatisfied commencement condition. A vacant suite may still produce termination or holdover rent. Record both conditions without netting them into one percentage.
2. Trace material fields to executed documents
Select every material tenant and a risk-based sample of smaller tenants. Trace the legal name, premises, commencement, expiration, rent, escalations, reimbursements, options, deposits, guarantees, and special rights to the executed lease and all amendments. A lease abstract is useful, but it is another summary and should not replace the source documents.
Pay particular attention to rights that do not appear in a simple monthly-rent column: early termination, contraction, expansion, co-tenancy, exclusivity, purchase options, rights of first refusal, sublease restrictions, landlord work, tenant allowances, and rent offsets. These provisions can change cash flow, leasing flexibility, or a future sale.
Fannie Mae’s lease-audit guidance illustrates the depth of source-file review expected in certain multifamily underwriting, including tenant files and supporting eligibility or income documentation when applicable. The exact documents differ for market-rate and commercial property, but the control principle is consistent: verify the summarized terms against the governing records.
3. Reconcile billed rent to collected cash
Build a tenant-by-tenant bridge from contractual rent to billed rent, collected rent, and recognized revenue for at least the trailing 12 months. Separate base rent, reimbursements, percentage rent, late fees, one-time charges, concessions, credits, bad debt, and security-deposit activity.
A tenant billed $50,000 per month but consistently paying $45,000 should not be underwritten automatically at $600,000 annually. The $60,000 annual difference may reflect an unresolved dispute, undocumented concession, offset, recurring delinquency, or accounting error. The cause determines whether the gap is collectible, curable, or likely to persist.
Reconcile collections to the general ledger, bank deposits, aging report, and trailing operating statements. Fannie Mae’s list of potential mortgage-fraud red flags notes rent-roll conditions that warrant scrutiny, including unusual lease commencement patterns and tenants shown under eviction. These are investigation triggers, not proof of wrongdoing.
4. Normalize concessions and reimbursements
Face rent can overstate economic rent when the landlord provides free months, improvement allowances, moving payments, or other incentives. Spread concessions over the relevant lease period when comparing tenant economics, and distinguish already-funded costs from future obligations.
Expense reimbursements also require separate analysis. Determine whether each tenant pays a fixed amount, percentage share, base-year increase, or direct expense. Review caps, exclusions, gross-up provisions, audit rights, administrative fees, and reconciliation history. A recovery percentage that looks stable may be temporarily high because of a one-time true-up or temporarily low because billing is delayed.
Primior’s guide to reading a real estate pro forma explains how revenue, vacancy, expenses, debt, capital spending, and exit assumptions work as a connected system. Rent-roll conclusions should flow into that system instead of remaining in a separate diligence file.
5. Measure tenant and expiration concentration
Calculate concentration by contractual rent, collected rent, occupied area, and contribution to net operating income. A tenant representing 20% of area may represent a larger share of cash flow if its rent and reimbursements exceed the property average.
Then group lease expirations by month and year. A weighted average lease term can look comfortable while masking a cluster of major expirations in one year. Show the percentage of annualized base rent and area expiring in each period, renewal options, notice deadlines, market-rent differences, required tenant improvements, leasing commissions, downtime, and any credit concern.
Owners and capital partners preparing a property for acquisition, financing, or recapitalization can work with Primior to review the rent roll, lease evidence, underwriting, and execution risks before the capital structure is finalized.
6. Convert rollover into a cash requirement
Assume a property has $4 million of annual base rent and tenants representing 30% of that rent expire in year three. The exposed annual rent is $1.2 million. If the downside case assumes 40% of that space becomes vacant for nine months, lost base rent alone would be approximately $360,000:
$1,200,000 × 40% × 9 ÷ 12 = $360,000.
That is not the total exposure. The model should also include lost reimbursements, tenant improvements, leasing commissions, legal costs, free rent, operating expenses that continue during vacancy, and the time required to fund and complete new tenant work. If re-leasing requires $55 per square foot across 30,000 square feet, tenant improvements alone would require $1.65 million before commissions or downtime.
These figures are hypothetical, not market assumptions. The purpose is to convert a calendar event into liquidity, financing, and covenant consequences. A lease-expiration schedule that does not connect to a capital schedule is incomplete.
7. Reconcile the final underwriting case
Create a variance table showing seller rent roll, verified current rent, collected trailing rent, and underwritten forward rent. Each adjustment should have a reason, source, owner, and resolution status. Do not bury unresolved items in a general vacancy factor.
The final case should state which tenants are excluded, discounted, marked to market, assumed to renew, or assumed to vacate. It should also show the date of the rent roll. A schedule can become stale quickly when notices, amendments, payments, or move-outs occur during a long closing process.
Red Flags That Require More Evidence
Common warning signs include recent leases with unusually favorable economics, large tenants without signed amendments, deposits that do not reconcile, repeated partial payments, undocumented side agreements, month-to-month tenants reported as long-term occupancy, rent steps beginning just before valuation, and sharp differences between billed and collected revenue.
Other issues are less obvious: leases signed with affiliates, tenants sharing ownership or guarantors, renewal assumptions without tenant contact, below-market leases that cannot be reset promptly, above-market leases supporting an aggressive valuation, and options that transfer control over future space or sale decisions.
A red flag is not necessarily a reason to reject a property. It can justify more evidence, revised underwriting, a closing condition, a remedy developed with counsel, or more capital. The response should match the potential effect and quality of the evidence.
Make the Verified Rent Roll a Monitoring Baseline
After closing, the verified rent roll should become an asset-management control. Monthly reporting should explain new leases, renewals, notices, delinquencies, concessions, collections, vacancies, and changes to the expiration schedule. Primior’s guide to real estate investor reporting describes why property-level operating facts should accompany financial results.
The control is strongest when property management, accounting, leasing, asset management, and ownership use one reconciled record with defined responsibility for updates. Primior’s discussion of property management and investment performance explains how leasing, collections, maintenance, and reporting connect daily operations to the investment case.
Commercial real estate rent roll analysis is complete only when the schedule agrees with governing documents and cash evidence, and when future expirations have been translated into realistic downtime and capital needs. Investors and owners seeking that discipline can work with Primior to evaluate property income, lease risk, capitalization, and the operating plan alongside independent legal, tax, accounting, appraisal, engineering, and other professional advisers.
This article is provided for general informational purposes only and does not constitute investment, legal, tax, accounting, appraisal, lending, property-management, or other professional advice, an offer to sell, or a solicitation of an offer to buy any security or investment product. Lease rights, accounting treatment, underwriting standards, and diligence requirements depend on the property, documents, parties, jurisdiction, and financing. All investments involve risk, including possible loss of principal.
