A rent roll is not an income statement. It is a risk schedule wearing the costume of one. The bottom line tells you what the property collects today; everything above it tells you whether that number survives the next five years. Learning how to read a rent roll means refusing to stop at the total — and reading the columns that decide whether a clean income stream is actually a contingent one.
Most rent rolls arrive as a single spreadsheet tab: tenant names, suite numbers, square footage, monthly rent, lease dates. That is the raw material. The analysis is what you build on top of it — and it is the difference between buying a stabilized asset and buying a rollover problem at a stabilized price.
The mechanical fields — what every rent roll states
Start with the fields that are simply present and need verification, not interpretation. These are the bones. If any are missing, the rent roll is incomplete and you should ask for a corrected version before you model anything.
- Tenant and suite — who occupies what, and which legal entity actually signs (the guarantor question starts here).
- Square footage — leased SF per suite, and whether it reconciles to the building's rentable area. Phantom SF inflates everything downstream.
- Base rent — current monthly or annual, and the rate per SF so you can compare across suites and against market.
- Lease commencement and expiration — the dates that drive the entire rollover schedule.
- Security deposit — cash, LOC, or none. Thin deposits on weak tenants are a tell.
- Occupancy status — occupied, vacant, holdover, or month-to-month. Month-to-month income is not the same quality as contractual income.
These fields you confirm. The next ones you interrogate.
WALT and the rollover schedule — where the income gets tested
The single most important number a rent roll doesn't print is WALT — weighted average lease term. WALT measures the income-weighted average time until your leases expire. A property at 95% occupancy with a 1.8-year WALT is not stable; it is a re-leasing project with a deceptively clean snapshot. Weight by income, not by count — a 40,000 SF anchor expiring next year matters more than three small suites expiring in year seven.
Build the rollover schedule by stacking expirations year by year, as a percentage of both income and SF. This is where lease rollover risk becomes visible. A schedule that drops 45% of income into a single year is a concentration event — re-leasing costs, downtime, tenant improvement allowances, and leasing commissions all land at once, and they land in the year your loan may be maturing too. Reading the rollover schedule is the core of any honest net-lease acquisition underwriting, and it is the first thing our underwriting work reconstructs from a raw rent roll.
Escalations and the lease structure — what the base rent omits
Base rent is a starting point, not a trajectory. Two suites at the same current rate can have entirely different value depending on what happens next. The rent roll often buries escalations in a footnote or omits them entirely, so you pull them from the leases themselves — the same discipline that drives a proper commercial lease abstract.
- Escalation type — fixed annual bumps, CPI-indexed, or flat. Flat rent over a ten-year term loses real value every year.
- Escalation amount — 3% fixed reads very differently from a 10%-every-five-years step.
- Expense structure — NNN, gross, or modified gross. This decides who absorbs taxes, insurance, and maintenance, and it makes per-SF rents non-comparable until you normalize them.
- Recovery and reconciliation — under NNN, confirm what's actually recoverable and whether there are caps or gross-ups.
- Options — renewal, termination, expansion, and right of first refusal. A below-market renewal option is a ceiling on your upside; an early-termination right is a hole in your WALT.
The expense structure matters enough to isolate. A $20/SF gross rent and a $20/SF NNN rent describe completely different economics, and treating them as equal is one of the most common rent-roll reading errors.
| Feature | NNN | Gross |
|---|---|---|
| Who pays taxes, insurance, CAM | Tenant (reimbursed) | Landlord (in base rent) |
| Rent comparability | Lower headline, net to owner | Higher headline, pre-expense |
| Expense inflation risk | Tenant bears it | Landlord bears it |
| What to verify | Recoverability, caps, gross-ups | Expense stops, base-year |
If you want the full decision framework behind these columns, the NNN vs. gross vs. modified gross breakdown walks through which structure shifts which risk.
Tenant credit and concentration — the risk the totals hide
A rent roll prints names, not creditworthiness. The same $50,000 monthly rent is worth far more from an investment-grade national tenant on a corporate guaranty than from a single-location franchisee with a personal guaranty and a thin deposit. The rent roll won't tell you which is which — you bring that judgment to it.
Then layer concentration on top. Tenant concentration is the quiet killer of net-lease and small-multitenant deals. If one tenant is 60% of income, your property's cap rate is really that tenant's credit spread in disguise. The rent roll looks diversified across six suites; the income tells you it's a single-tenant deal with five rounding errors. Map concentration three ways:
- By tenant — what share of income does the largest tenant carry, and the top three combined?
- By industry — three tenants in the same sector fail together in a downturn, no matter how the suites are split.
- By expiration timing — concentration in when leases roll is as dangerous as concentration in who pays.
A rent roll's total income tells you what the property earns today. WALT, the rollover schedule, and tenant concentration tell you whether it still earns that in year three. Buy the second number, not the first.
The compounding payoff of reading it the same way every time
The value of a disciplined rent-roll read is not any single deal — it's that a 47-suite portfolio and a single-tenant box get run through the identical field set, so you can compare them on the same axes and spot the outlier instantly. When every rent roll is abstracted into the same schema — WALT, rollover by year, normalized rent, expense structure, credit, concentration — the analysis stops being re-investigation and becomes pattern recognition. The deal that looks cheap because of its rollover cliff stops fooling you. That consistency is what separates a rent roll you read once from a rent roll that feeds your proforma and your investment memo without a single re-keyed number. Do it the same way every time, and the rent roll stops being a snapshot and becomes a forecast you can trust.
Need this on a live deal? Capistrano produces underwriting, lease abstracts, investment memos, and capital-raise materials — AI-leveraged, principal-reviewed.