CRE
How to Read a Rent Roll (with Real Examples)
By Khai Tran · · 6 min read
Most agents glance at a rent roll without truly understanding what drives value. This guide shows you how to read a rent roll with clarity so you can advise investors confidently.
Every commercial agent eventually faces the same moment: an investor sends over a rent roll, and you’re expected to analyse the deal on the spot. If you don’t know exactly what to look for, it’s easy to miss red flags or worse, misunderstand value. Reading a rent roll isn’t hard, but it does require a consistent process.
Below is the calm, simple framework I teach my agents so they can walk through any rent roll with confidence.
Start With the Story Behind the Numbers
Before digging into formulas, remember that a rent roll tells a story: Who’s paying, how much, how reliably, and for how long.
Key questions to orient yourself
- What type of asset is this? (Retail, office, industrial, multifamily)
- How many tenants?
- Is the income stable or choppy?
- Are there immediate expirations?
This context will shape every decision downstream.
Identify the Core Columns That Matter Most
Most rent rolls include 20 to 40 columns, but only a handful matter for deal evaluation.
The essential columns
- Tenant name
- Suite / unit number
- Lease start & expiration
- Base rent
- Square footage
- Rent per SF (or per unit)
- Additional charges (CAM, NNN, utilities)
- Current balance owed
- Security deposit
If one is missing, it’s worth asking the owner or broker why.
Verify Occupancy and Economic Vacancy
Physical occupancy and economic occupancy are not the same, and smart investors look at both.
Physical occupancy
Simply: How many units filled?
Economic occupancy
How much of the potential income is actually collected?
If a tenant is behind on rent, that shows up here. A building can be 100% physically occupied but only 85% economically occupied.
Understand the Lease Terms That Affect Value
A rent roll usually won’t include the entire lease, but it gives clues you need to investigate.
Look for
- Expiration cliffs (multiple leases ending within 6 to 12 months)
- Below-market rents that might be an upside story
- Above-market rents that might signal renewal risk
- Short-term leases in long-term assets
- Concessions or free rent
Any unexpected lease pattern should trigger a deeper look.
Calculate Actual Rent Per Square Foot
This is where many agents get mixed up. The rent roll often shows rent per month, but investors care about rent per square foot per year.
The simple formula
Annual Rent ÷ Square Footage = Rent per SF per Year
Example
- 1,200 SF retail suite
- Tenant pays $2,800/month base rent
Annual rent = $2,800 × 12 = $33,600 Rent per SF/year = $33,600 ÷ 1,200 = $28/SF/YR
Now you can compare that to the market.
Review Additional Income (CAM, NNN, Utilities)
In CRE, the base rent is just part of the income.
Common additional charges
- CAM reimbursements
- NNN reimbursements
- Utility pass-throughs
- Percentage rent (retail)
- Parking income
A strong rent roll clearly separates these so you can calculate true revenue.
Look for Under-Market Rents and Upside Potential
Investors love upside, but only when it’s real, not hypothetical.
Quick upside test
- Are current rents 10% to 20% below market?
- Are leases expiring soon enough to capture that?
- Are there value add opportunities (renovations, repositioning) that justify a rent increase?
If the rent roll doesn’t support the story, the upside isn’t real.
Scan for Delinquencies and Payment Patterns
A rent roll should show arrears or tenant balances. Don’t skip this.
What matters
- Chronic late payers
- Large outstanding balances
- Tenants approaching default
- Any tenant paying partial rent
Even one struggling tenant can shift NOI more than you expect.
Build a Simple Cash-on-Cash Snapshot (Real Example)
Here’s a simple CRE example you can steal for your next investor call.
Property example
- 5-tenant retail strip
- Total rentable SF: 10,000
- Annual base rent: $210,000
- Annual NNN reimbursements: $42,000
- Total income: $252,000
- Annual operating expenses (owner-paid): $48,000
- NOI: $204,000
- Asking price: $2,700,000
- Investor plans 65% LTV loan at 6.75%
Step-by-step
- Debt amount = 65% × $2,700,000 = $1,755,000
- Annual debt service (est.) = $137,000
- Cash flow = NOI − debt service = $67,000
- Cash invested = $945,000
- Cash-on-cash return = $67,000 ÷ $945,000 = 7.1%
What you’d tell the investor
"Based on the rent roll, income is stable and economically strong. At the current price, you’re looking at a 7% cash-on-cash with some upside as two units are 15% under market."
This is the kind of clarity investors trust.
What to Say When Reviewing a Rent Roll with an Investor (Script)
Use this simple script when walking an investor through a deal.
Rent Roll Review Script
“Let me walk you through the rent roll. We have ___ tenants with leases running through ___. Current rent averages ___ per SF, and market is around ___. Additional income from NNN/CAM adds ___. No major delinquency concerns except ___. The biggest thing to note is ___. Based on these numbers, the asset is generating a stabilized NOI of ___. If you’re evaluating this from a cash-on-cash angle, here’s how it looks…”
This keeps your calm, clear, and credible.
Final Check: Does the Rent Roll Match the OM and P&L?
Before giving the “green light,” confirm consistency.
Your quick checklist
- Does the rent roll match the offering memorandum?
- Does the P&L match the rent roll?
- Are lease expiration dates consistent across documents?
- Are any leases missing or miscategorized?
When documents disagree, the rent roll usually reveals the truth.
Wrap-Up: Become the Agent Who Can Interpret Income Instantly
Most agents skim rent rolls. Great agents read them like an investor. When you can walk through income, occupancy, stability, and upside quickly, you become the agent investors trust first.
Download my free 10 CRE Terms Guide to strengthen your investor and client conversations.
Khai Tran, Licensed Real Estate Agent in Texas. Brokered By eXp Realty.