Reading the Rent Roll: Five Red Flags Brokers Don't Highlight

The Offering Memorandum is marketing. The rent roll is a primary document. If you have to pick one to study, study the rent roll — every time. The OM is what the seller wrote about the property. The rent roll is what the property wrote about itself.

After running structured analysis on a few hundred multifamily rent rolls, five patterns have emerged that we now actively look for. None of them are dishonest on the seller's part. All of them are easy to miss if you're skimming. Each one can change the math on a deal materially.

1. Concentrated lease expirations

Look at the next 90 days of lease expirations. Then the next 180. Then the next 365.

A healthy rent roll has roughly even distribution — call it 7-9% expiring per month, smoothed across the year. What you don't want to see:

• 20%+ of leases expiring in the same 90-day window. This is concentration risk that doesn't show up in headline occupancy. If 60 units come available in Q3 and your market is soft, you're discounting rents on 60 units simultaneously. This destroys NOI for 18 months.
• A "bow wave" of expirations 60-120 days after closing. This is the classic ownership-handoff problem. Tenants don't renew with a new owner they don't know, especially if rent push is anticipated. We've seen 25% post-acquisition turnover where the trailing trend was 11%.
• Most leases on month-to-month. Sometimes flexibility — usually a sign the current owner stopped renewing leases as they prepared to sell, which means every tenant is technically a 30-day liability.

The pro forma will model stabilized vacancy at 5%. The actual transitional period can hit 12-18% for two quarters if the lease ladder is bad.

2. Vacant units that have been vacant a long time

Most rent rolls flag vacant units. Fewer flag how long they've been vacant. The signal is in the duration.

If a unit has been vacant 30 days, that's market-rate turn time. If it's been vacant 90 days, the leasing team has tried and failed at the listed rent. If it's been vacant 180 days, there's a structural problem — usually one of:

• The unit is unrentable in current condition. Hidden capex.
• The unit is reserved. Often models, employee housing, or a unit held for the management office. These are excluded from the rentable count in honest pro formas and included in dishonest ones.
• The asking rent is materially above market for the unit type. This is the most insidious one. The pro forma uses the asking rent as "market." But the unit has been sitting empty at that rent for 6 months. Either the rent is wrong or the unit is wrong.

Action: pull rent roll history if you can get it (sometimes available; sometimes you ask). Anything vacant 90+ days needs an explanation in the data room or it's a deduction.

3. The "loss to lease" that doesn't exist

Sellers love to highlight "loss to lease" — the gap between in-place rents and pro forma market rents. The pitch is that you, the new owner, get to push rents to market over the next 12-24 months.

The math only works if four things are true:

1. The "market" rent is actually market. Often it's an aspiration, not a comparable.
2. The leases are actually rolling. A 24-month lease ladder means you don't get to push for two years on most units.
3. The submarket supports the push. If three new construction projects are leasing up with concessions in your submarket, your in-place tenants have alternatives.
4. Your operator can execute the renewals. Push rents 8% on a 70%-occupied asset in a soft market and you'll see higher vacancy, not the same vacancy at higher rents.

The diagnostic question: how much of the loss-to-lease is executable in the first 12 months? Pull the lease expiration ladder, multiply by the per-unit push, and that's your year-one upside. The other two-thirds of loss-to-lease lives in years two and three, where your assumptions are softer and your hold-period IRR is more sensitive to exit cap than to NOI growth.

We've found the median executable loss-to-lease in year one is 25-40% of the broker's stated loss-to-lease. The rest is real but slower than presented.

4. Unit-level rent compression that signals operational issues

Look at rents within the same unit type. In a healthy property, the spread between the highest and lowest rent on, say, 1BR/1BA units of the same square footage is 8-12% — explained by floor level, view, recent renovation, length of tenancy.

A spread of 25%+ is a flag. It usually means one of:

• Concession-loaded leases burning off. The "$1,200 rent" is actually $1,350 with a $150 month-long concession across a 12-month lease. The "market" rent is the gross number; the actual cash is the net. When the lease renews, the tenant pays the net or leaves.
• Long-tenured tenants on legacy pricing. A unit at $950 next to identical units at $1,400 means a tenant who's been there nine years. Pushing this tenant to $1,400 may produce a vacancy you didn't model.
• Renovation churn. Some units have been renovated and bumped, others haven't. The pro forma assumes everything gets bumped; the reality is the unrenovated units have tenants paying legacy rates who won't renew at the new rate.

For each unit type, we compute the rent dispersion and require an explanation of any spread over 15%. If the answer is "long-tenured tenant," that's a hidden vacancy risk. If the answer is "renovated vs. unrenovated," that's hidden capex.

5. Income-to-rent ratios that don't support the rent push

Most rent rolls include either tenant income at move-in or rent-to-income ratio. If they don't, ask for them — sophisticated PMCs track this, and the data exists.

The healthy benchmark is rent-to-income of 25-30%. At 33%, you're starting to see delinquency. At 40%+, you're in fragile territory — any economic stress (job loss, medical bill, divorce) sends the tenant into nonpayment.

If your value-add thesis is to push rents 12% over the next 18 months, and the current tenant base is at 35% rent-to-income, the math doesn't work. You can't push rents on tenants who are already stretched. Either rents stay where they are or the tenants leave. The pro forma assumes neither.

This is the variable most consistently absent from broker OMs. It's the variable most predictive of how the value-add will actually go.

Why the rent roll matters more than the cap rate

The cap rate is a number derived from numbers. Each input — NOI, market value, expense ratio — is interpreted, estimated, or asserted. The rent roll is the closest thing to ground truth that exists at this stage of diligence.

When we see a property where:

• Lease ladder is concentrated in the next 90 days
• Several units have been vacant 90+ days
• Most of the loss-to-lease is in years two and three
• Rent dispersion within unit types is wide
• Current rent-to-income is above 33%

...the cap rate is approximately fictional, no matter what the seller's pro forma says. The actual cap rate after the inevitable turnover, vacancy, and concession activity is 80-150 basis points lower than the printed number.

The good news: all five of these red flags are detectable in 30 minutes of structured rent roll analysis. AI tools make this faster — extract the rent roll into structured fields, compute the diagnostics, flag the outliers. The work is mechanical. What it surfaces is consequential.

The best investors we know look at the rent roll first and the OM last. They're trying to figure out what's actually happening at the property before they read what the broker says is happening. The OM tells you a story. The rent roll tells you the truth.