Top Tier Investment FirmTOP TIER INVESTMENT FIRM
How to Read a Rent Roll Like an Asset Manager
Asset Management

How to Read a Rent Roll Like an Asset Manager

March 11, 2026

|

By Tanner Sherman, Managing Broker

A rent roll is one page. Maybe two. It's the most important document in multifamily investing, and most owners read it wrong.

Here's how I know. I ask every new client the same question: "Walk me through your rent roll." Almost every time, they tell me the same things. Unit numbers. Tenant names. Rent amounts. Lease dates.

That's reading a rent roll like a landlord. An asset manager reads the same document and sees six figures of opportunity hiding in plain sight.

Let me show you the difference.

What Most Owners See

A standard rent roll has columns you're familiar with:

Unit number

Tenant name

Lease start date

Lease end date

Monthly rent

Deposit amount

Move-in date

Most owners look at this and see occupancy. "All 12 units are filled. Good." Maybe they scan the rent amounts and confirm the total matches what's hitting their bank account. Then they put the rent roll down and move on.

That's like looking at a blood test and only checking whether you're alive. Technically useful. Completely insufficient.

What an Asset Manager Sees

When I open a rent roll, I'm not looking at what's. I'm looking at what should be, and measuring the distance between the two.

Every column tells a story. Here's how to read each one.

Column 1: Current Rent vs. Market Rent (The Gap)

This is the single most valuable analysis you can do on a rent roll. And it requires one thing the rent roll doesn't give you: market data.

Pull comps for your submarket. What are comparable units renting for right now? Not last year. Right now. Use Zillow, Apartments.com, Rentometer, or better yet, call a local PM and ask what they're leasing comparable units at.

Then add a column to your rent roll: market rent. Right next to current rent.

The gap between those two numbers is money you're not collecting. Every month. For as long as the gap exists.

Here's a real example. A 12-unit building I reviewed last quarter:

| Unit | Current Rent | Market Rent | Monthly Gap | |------|-------------|-------------|-------------| | 1 | $900 | $1,050 | $150 | | 2 | $925 | $1,050 | $125 | | 3 | $1,000 | $1,050 | $50 | | 4 | $900 | $1,050 | $150 | | 5 | $1,025 | $1,075 | $50 | | 6 | $950 | $1,075 | $125 | | 7 | $1,050 | $1,075 | $25 | | 8 | $975 | $1,050 | $75 | | 9 | $900 | $1,050 | $150 | | 10 | $1,000 | $1,050 | $50 | | 11 | $925 | $1,075 | $150 | | 12 | $1,050 | $1,075 | $25 |

Total monthly gap: $1,125. Annual gap: $13,500.

That's $13,500 per year in revenue this owner wasn't collecting. Not because the market wouldn't support it. Because nobody had done the analysis.

Four of those units were at $900 in a $1,050 market. That's a 14% discount the owner was giving away for free. Those tenants weren't on a sweetheart deal. Nobody had raised their rent in two years because "they're good tenants and they always pay on time."

Good tenants who pay on time will also pay market rent. Most of them, anyway. The ones who won't were never going to stay long-term regardless.

Column 2: Lease Expiration Timing

Pull every lease end date and plot them on a calendar. What do you see?

If seven of your twelve leases expire between November and February, you have a problem. Winter lease expirations in the Midwest mean winter turns. Winter turns mean slower fill times, fewer prospects, and higher vacancy loss.

The ideal lease expiration schedule staggers renewals across spring and summer months, with heavy concentration in May through August when the rental market is most active.

Here's the fix. It's free. When you renew a lease, adjust the term length to push the next expiration into a summer month. If a lease expires in January and the tenant renews, offer a 17-month lease instead of 12. That moves the next expiration to June. Do this systematically across your portfolio and within two years, you'll have a staggered schedule that maximizes your leasing leverage.

Column 3: Time in Unit

How long has each tenant been in their unit? This number correlates directly with how far below market they're probably paying.

A tenant who's been in the unit for four years and received $25 annual increases is now $100 below a tenant who moved in last month at market rate. Same unit. Same building. Hundred-dollar spread.

Long-term tenants are valuable. They reduce turnover cost, they take care of the unit (usually), and they provide stable cash flow. But long-term tenants at significantly below-market rents are costing you real money.

The play isn't to jack their rent to market overnight. It's to build a phased adjustment plan. Bring them up $40-75 per renewal cycle until the gap closes. Most long-term tenants absorb moderate increases without blinking. They know moving costs more than $50 a month.

Column 4: Deposit Amounts

This one is simple and almost universally overlooked.

When a tenant moved in three years ago, their deposit was set to match their rent at the time: $850. Their rent is now $1,000. Their deposit is still $850.

That's a $150 gap in your risk coverage. If that tenant damages the unit and you need to make a claim against the deposit, you're starting $150 in the hole before you even assess the damage.

In Nebraska, you can adjust the deposit amount at lease renewal. Not every landlord does. Most don't even think about it. Add a deposit column to your rent roll, compare it to current rent, and flag every unit where the deposit is more than $50 below rent. Adjust at the next renewal.

Column 5: Late Payment Patterns

Your rent roll may or may not show payment history. If it doesn't, pull it from your PM software. What you're looking for: tenants who pay late consistently.

I don't mean the tenant who was late once in three years because they were on vacation. I mean the tenant who pays on the 8th every month. Or the 12th. Or the 15th.

Chronic late payers signal two things. First, they may be financially stressed, which increases your default risk. Second, if you're not enforcing late fees, you're training them to pay late. And you're leaving money on the table.

On a 20-unit building with five chronic late payers and a $50 late fee, unenforced late fees cost you $3,000 per year. That's money your lease entitles you to collect. Collect it.

Column 6: Unit Mix and Pricing Strategy

Zoom out from individual units and look at your rent roll as a pricing matrix. What's your spread between your cheapest and most expensive unit?

If your cheapest 2-bedroom is at $950 and your most expensive is at $1,100, ask why. Is the $1,100 unit renovated? Different floor plan? Better location in the building? Or is it just that one tenant negotiated harder than the other?

Your unit mix should have a pricing logic. Renovated units command a premium. Upper-floor units command a premium. End units, corner units, units with extra storage, all of these have pricing power that should be reflected in your rent roll.

If your pricing is random, you're not optimizing. You're guessing.

Build Your Own Rent Gap Analysis

Here's the exercise. You can do this in 30 minutes with a spreadsheet.

1. Export your current rent roll 2. Add a "Market Rent" column using current comp data 3. Add a "Monthly Gap" column (Market Rent minus Current Rent) 4. Add a "Lease Expiration Month" column 5. Add a "Months in Unit" column 6. Add a "Deposit vs. Rent Gap" column 7. Sort by Monthly Gap, largest to smallest

The top of that list is where your money is hiding. Those are your first rent adjustments. Those are the units that move your NOI most with the least effort.

Now total the Monthly Gap column and multiply by 12. That's your annual revenue opportunity. The number you've been leaving on the table.

I've never done this exercise with an owner and found less than $5,000 per year in opportunity. On most portfolios, it's $10,000 to $30,000. On a 20-unit building, I've seen gaps north of $40,000 annually.

Why This Matters Beyond Cash Flow

The rent gap doesn't just affect your monthly check. It affects your property value.

Multifamily properties are valued on NOI. Every dollar of rent you're not collecting compresses your NOI, which compresses your value.

At a 7 cap, that $13,500 annual rent gap on the 12-unit example above represents $192,857 in unrealized property value. You're not just losing $13,500 a year in cash flow. You're losing nearly $200,000 in equity.

That's the difference between reading a rent roll like a landlord and reading it like an asset manager. The landlord sees occupied units. The asset manager sees a six-figure opportunity.

The Offer

Send us your rent roll. Seriously. We'll run a full gap analysis, compare your rents to current market data in your submarket, flag lease expiration clustering, and identify the top three moves that would improve your NOI the fastest.

No charge. No obligation. Just the analysis.

Why? Because every owner we've done this for has been surprised by the number. And surprised owners become engaged owners. Engaged owners are the kind of people we want to work with.

If you own rental properties and you're not sure they're hitting their ceiling, let's talk. Reach out at Tanner@TopTierInvestmentFirm.com.

Tanner Sherman is the Principal and Managing Broker of Top Tier Investment Firm in Omaha, Nebraska. He co-hosts the Freedom Fighter Podcast with Ryan of Avara Investments.

Related Reading

The Insurance Claim That Almost Bankrupted a 20-Unit Building

The Owner Report You Should Be Getting Every Month

The Annual Budget Process for a Multifamily Building

The Difference Between Asset Management and Property Management

How to Fire Your Property Manager Without Losing Tenants

Want More Insights Like This?

Get market intelligence, acquisition strategies, and operational updates delivered to you.