Rent Roll Analysis: What Investors Should Check Before Making an Offer

A rent roll is one of the most important documents to review before buying a multifamily property. It shows who is renting each unit, how much they are paying, which units are vacant, when leases expire, and whether the property has rental upside or hidden income risk.

If the T12 shows what the property collected in the past, the rent roll shows what the property is supposed to collect today.

That difference matters.

A clean rent roll can support the seller's income claims. A messy rent roll can expose vacancy problems, delinquency, short-term lease risk, concessions, and overstated rent growth assumptions.

Before you make an offer, you need to understand what the rent roll is really telling you.

What Is a Rent Roll?

A rent roll is a property-level report that lists every unit in a rental property and the income tied to each unit.

For a multifamily property, a rent roll usually includes:

• Unit number
• Unit type
• Square footage
• Tenant name
• Current rent
• Market rent
• Lease start date
• Lease expiration date
• Move-in date
• Security deposit
• Balance owed
• Vacancy status
• Concessions
• Notes about delinquency or non-payment

A rent roll is not just a tenant list. It is the income engine of the property.

If the rent roll is wrong, your underwriting will probably be wrong too.

Why Rent Roll Analysis Matters

Rent roll analysis helps investors answer several key questions:

• Is the property actually occupied?
• Are tenants paying what the seller claims?
• How much rent is below market?
• How many leases expire soon?
• Are there delinquent tenants?
• Are there concessions or discounts?
• Is there real value-add upside?
• Is the seller overstating income?
• Does the rent roll match the T12?
• Can the property support the loan?

A broker may tell you there is $300 of rent upside per unit. That sounds good. But if leases are locked for another 10 months, tenants are already delinquent, and nearby properties are not actually achieving those rents, the upside is not immediate.

Rent roll analysis keeps you from buying the dream instead of the deal. It is one of the core documents in a complete multifamily underwriting process, alongside the T12 and loan quote.

Rent Roll vs T12: What's the Difference?

You need all three, but the rent roll and T12 are the most important before making an offer.

The rent roll tells you what should be happening today.

The T12 tells you what actually happened over the last year.

The pro forma tells you what someone hopes will happen next.

Step 1: Confirm Unit Count and Unit Mix

Start with the basics.

Verify:

• Total number of units
• Unit types
• Bedroom and bathroom mix
• Square footage
• Occupied units
• Vacant units
• Down units
• Model units
• Employee units

Example unit mix:

If the offering memorandum says 100 units but the rent roll only shows 96 rentable units, you need to know why.

Missing units could be:

• Down units
• Non-revenue units
• Combined units
• Storage or office space counted incorrectly
• Data entry errors
• Misleading marketing

Small differences can change the income projection.

Step 2: Compare Current Rent to Market Rent

One of the biggest reasons investors buy multifamily properties is rent upside.

To measure that upside, compare current rent against market rent.

Example:

This gap is often called loss-to-lease.

Loss-to-Lease = Market Rent − Current Rent

If a unit rents for $1,350 but similar units in the market rent for $1,475, the loss-to-lease is $125 per month.

Annualized:

$125 × 12 months = $1,500 annual upside per unit

Across many units, that can be meaningful.

But do not assume all rent gaps are immediately collectible. You need to confirm whether the market rent is realistic.

Step 3: Verify Market Rent Assumptions

Market rent is where sellers and brokers often get aggressive.

Before accepting market rent assumptions, check:

• Comparable nearby properties
• Unit size and layout
• Renovation level
• Amenities
• Property condition
• Neighborhood quality
• School district
• Parking
• Washer/dryer availability
• Utility structure
• Concessions at competing properties

A renovated 2-bedroom unit with in-unit laundry is not the same as an outdated 2-bedroom unit with older finishes and no amenities.

If the seller claims market rent is $1,850, find evidence.

If the evidence is weak, lower the assumption.

Step 4: Review Occupancy and Vacancy

Next, calculate occupancy.

Occupancy Rate = Occupied Units ÷ Total Rentable Units

Example:

94 occupied units ÷ 100 rentable units = 94% occupancy

A 94% occupancy rate may be fine depending on the market, but you need to review the trend.

Ask:

• How long have units been vacant?
• Are vacant units rent-ready?
• Are any units down due to repairs?
• Is vacancy seasonal?
• Is vacancy caused by poor management?
• Is vacancy caused by weak market demand?
• Are vacant units being advertised at unrealistic rents?

Vacancy is not always bad. Sometimes it creates upside. But if vacancy is high because demand is weak, that is a warning sign.

Step 5: Check Delinquency and Tenant Balances

Do not confuse occupied units with paying tenants.

A unit can be occupied and still not generate income.

Review:

• Past-due tenant balances
• Tenants on payment plans
• Eviction status
• Chronic late payments
• Bad debt write-offs
• Non-paying tenants listed as occupied

Example:

The property may appear 94% occupied, but if 6 occupied tenants are delinquent, the economic occupancy is weaker.

That matters for cash flow, lender underwriting, and your first 90 days of ownership.

Step 6: Review Lease Expiration Risk

Lease expiration dates matter.

If too many leases expire in the same month, you may face sudden turnover, leasing costs, concessions, or vacancy.

Example:

If 47% of units expire in the next 6 months, you need a plan.

That could be good if rents are below market and tenants can be renewed at higher rents. It could be bad if many tenants leave and the property needs heavy turns.

Lease expiration risk affects:

• Renovation timing
• Cash flow
• Vacancy
• Turnover costs
• Rent growth execution
• Staffing needs

Step 7: Identify Concessions and Discounts

Concessions reduce real income.

Common concessions include:

• One month free
• Reduced rent
• Waived application fees
• Waived parking fees
• Move-in credits
• Employee discounts
• Renewal discounts

If the rent roll shows a tenant paying $1,500, but they received one month free on a 12-month lease, the effective rent is lower.

Effective Rent = Total Rent Collected During Lease ÷ Lease Term

Example:

$1,500 rent × 11 paid months = $16,500. $16,500 ÷ 12 months = $1,375 effective monthly rent.

That means the advertised rent is $1,500, but the actual economic rent is $1,375.

This is where weak underwriting gets exposed.

Step 8: Compare the Rent Roll to the T12

The rent roll should support the T12.

If the rent roll says the property should collect $150,000 per month, annual rent should be around $1,800,000 before vacancy, concessions, and bad debt.

Example:

A gap is not automatically a deal killer, but you need to explain it.

Possible explanations:

• Vacancy
• Concessions
• Bad debt
• Recent rent increases
• Lease-up period
• Delinquency
• Poor collections
• Non-recurring adjustments
• Timing differences

If the seller cannot explain the gap clearly, be careful.

Step 9: Calculate Loss-to-Lease

Loss-to-lease measures the gap between current rent and market rent.

Loss-to-Lease = Market Rent − Current Rent

Portfolio-level example:

Annual upside:

$12,875 × 12 = $154,500

At a 6.25% cap rate, that rent upside could represent:

$154,500 ÷ 0.0625 = $2,472,000 of potential value

But only if the rent growth is achievable.

Do not pay full price for upside that still requires capital, time, and execution risk.

Step 10: Watch for Rent Roll Red Flags

Here are the biggest rent roll red flags:

• Large number of vacant units
• Occupied units with unpaid balances
• Missing lease expiration dates
• Many leases expiring soon
• Market rents with no support
• Current rents far below market without explanation
• Employee or model units counted as income-producing units
• Down units not clearly identified
• Concessions hidden in notes
• Tenant balances not disclosed
• Rent roll does not match the T12
• Unit count does not match the offering memorandum
• Multiple tenants paying unusually low rent
• Month-to-month leases not flagged

One or two issues may be manageable. A pattern of unclear data is a problem.

Messy rent roll, messy deal.

Step 11: Use the Rent Roll to Build Your Underwriting Assumptions

After reviewing the rent roll, use it to build your income assumptions.

You should use the rent roll to estimate:

• Gross scheduled rent
• Current occupancy
• Economic occupancy
• Vacancy loss
• Loss-to-lease
• Renewal rent growth
• New lease rent growth
• Concession loss
• Bad debt
• Turnover risk
• Renovation timing

This is where your underwriting becomes more realistic.

Instead of guessing rent growth, you can tie your assumptions to unit-level data.

How DealWorthIt Helps With Rent Roll Analysis

Manually analyzing rent rolls can be painful, especially when every seller sends a different format.

DealWorthIt helps investors move faster by importing rent roll data and connecting it directly to the underwriting process.

With DealWorthIt, you can:

• Import rent roll documents
• Review unit mix
• Compare current rent to market rent
• Estimate loss-to-lease
• Analyze vacancy and occupancy
• Compare rent roll income against T12 actuals
• Build rent assumptions into your pro forma
• Run base, upside, and downside scenarios
• Generate investor-ready reports

The goal is not just to organize the rent roll. The goal is to decide whether the income story is believable.

Rent Roll Analysis Example

Here is a simplified example for a 100-unit multifamily property.

At first glance, the property has upside.

But before underwriting the full $154,500 as future income, you need to ask:

• How quickly can rents increase?
• How many leases expire soon?
• Are current tenants already delinquent?
• Are renovations required?
• Are comparable properties truly achieving market rent?
• Will higher rents increase vacancy?
• How much will turnover cost?

If the answers are weak, the upside is not as strong as it looks.

Frequently Asked Questions

What is a rent roll in real estate?

A rent roll is a report that lists each rental unit, tenant, current rent, lease dates, occupancy status, and other unit-level income details.

Why is rent roll analysis important?

Rent roll analysis helps investors verify current income, review occupancy, identify rent upside, spot delinquency, and compare current rent against market rent before making an offer.

What is loss-to-lease?

Loss-to-lease is the difference between current rent and market rent. It shows how much rental upside may exist if rents can be increased to market levels.

Is high loss-to-lease always good?

No. High loss-to-lease can signal upside, but it can also mean current rents are below market for a reason, such as poor condition, weak demand, tenant quality issues, or unrealistic market rent assumptions.

Should the rent roll match the T12?

The rent roll and T12 should generally support each other. If annualized rent roll income is much higher than T12 rental income, you need to understand the difference.

What are the biggest rent roll red flags?

Major red flags include high vacancy, delinquent tenants, missing lease dates, unsupported market rents, large concessions, down units, and rent roll income that does not match the T12.

Final Takeaway

The rent roll is where multifamily income underwriting starts.

It shows what tenants are paying, which units are vacant, when leases expire, and whether the property's income is stable or risky.

Do not just glance at the rent roll and move on. Compare it to the T12. Verify market rent. Check delinquency. Review lease expirations. Question the upside.

A strong rent roll can support a strong deal.

A weak rent roll can expose a bad one before you waste time, money, and energy chasing it.

Want to analyze rent rolls faster? DealWorthIt helps you import rent roll data, compare current rent to market rent, estimate loss-to-lease, review occupancy, and connect the numbers directly to your underwriting.