A rent roll is one of the best places to analyze value-add potential because it shows the deal at the unit level, where the value-add plan actually happens.
A T12 tells you what the property produced historically. A broker pro forma tells you what someone hopes it can produce. The rent roll sits between those two: it shows who is paying what, for which unit, under which lease, and when that rent can realistically change.
If you want to start analyzing deals in a better way, check out this robust multifamily underwriting template for acquisitions.
Why the rent roll is so valuable for value-add underwriting
Value-add is usually based on the idea that you can increase NOI by improving units, raising rents, reducing loss-to-lease, improving occupancy, adding utility reimbursements, or tightening operations. The rent roll helps you test whether that story is real.
The key reason is this:
Value-add potential is not just “current rent versus market rent.” It is current rent versus achievable rent, multiplied by the number of units that can actually be moved to that rent, on a realistic timeline, after accounting for downtime, capex, concessions, vacancy, and tenant turnover.
The rent roll is where all of those assumptions become visible.
1. It shows embedded rent upside
The most obvious value-add analysis is the spread between in-place rent and market rent.
For example:
| Unit Type | Units | Avg. In-Place Rent | Classic Market Rent | Market Renovated Rent |
|---|---|---|---|---|
| 1BR Classic | 40 | $1,250 | $1,375 | $1,575 |
| 2BR Classic | 30 | $1,600 | $1,725 | $1,950 |
| 1BR Renovated | 15 | $1,525 | $1,575 | $1,575 |
| 2BR Renovated | 15 | $1,900 | $1,950 | $1,950 |
This immediately separates two types of upside:
Loss-to-lease: Existing units are below current market rent even without renovations.
Renovation premium: Renovated units can command a higher rent than classic units.
That distinction matters a lot. Loss-to-lease may be captured through renewals or new leases with limited capex. Renovation premium usually requires spending money, creating vacancy downtime, and executing a construction plan.
A sloppy model may just say, “Rents are $250 below market.” A better model asks:
Is that $250 from simple mark-to-market, or does it require a renovation?
Those are very different risk profiles.
2. It identifies which units actually have value-add potential
Not every unit is a candidate for the same rent increase. The rent roll lets you segment the property by:
| Category | Why It Matters |
|---|---|
| Unit type | 1BR, 2BR, 3BR units may have different premiums |
| Square footage | Larger units may deserve higher rents even within same floor plan |
| Renovation status | Classic, partially renovated, fully renovated |
| Lease expiration | Determines when upside can be captured |
| Current rent | Reveals which units are most underpriced |
| Vacancy status | Vacant units can be improved or repriced immediately |
| Tenant status | Delinquent, subsidized, employee, month-to-month, bad debt risk |
| Concessions | Advertised rent may overstate true effective rent |
This is where the model becomes more precise. Instead of assuming “100 units get a $200 rent bump,” you may find that only 42 units are true classic-value-add candidates, 18 are already renovated, 12 are under affordable restrictions, 10 have below-market long-term tenants, and 8 have lease expirations too far out to affect year-one NOI.
That changes the deal.
3. It shows timing, which is critical
Value-add upside does not happen on day one unless the units are vacant or month-to-month. The rent roll gives you the lease expiration schedule, which should drive the timing of rent growth in the model.
A common mistake is underwriting stabilized renovated rents too quickly.
For example, suppose a property has 100 units and 60 classic units that could be renovated. That sounds like a big value-add opportunity. But the lease expiration schedule may look like this:
| Period | Classic Units Expiring |
|---|---|
| Months 1–3 | 6 |
| Months 4–6 | 8 |
| Months 7–12 | 14 |
| Year 2 | 20 |
| Year 3 | 12 |
Now the upside has a timeline. You cannot renovate all 60 units immediately unless tenants move out or you force turnover, which may increase vacancy, leasing costs, concessions, and reputational risk.
In a good model, the rent roll should feed a monthly or quarterly schedule:
Current rent until lease expiration → tenant renews or moves out → unit is renovated if it turns → downtime occurs → new rent begins.
That flow is much more realistic than simply applying a blanket rent increase.
4. It helps separate renewal upside from turnover upside
This is one of the most important distinctions in value-add underwriting.
When a lease expires, two different things can happen:
Renewal path
The existing tenant stays. You may increase rent, but usually not all the way to the fully renovated market rent. The tenant may resist a large increase, and the unit may not be renovated while occupied.
Example:
Current rent: $1,300
Classic market rent: $1,425
Renovated market rent: $1,650
If the tenant renews, maybe the new rent is $1,400.
Turnover path
The tenant leaves. You renovate the unit, lose some rent during downtime, spend capex, and then lease it at the renovated rent.
Example:
Current rent: $1,300
Renovated rent: $1,650
Renovation cost: $12,000
Downtime: 30 days
New lease begins after renovation
The turnover path creates more upside, but it also creates more cost and execution risk.
The rent roll helps you model both paths instead of assuming every expiring lease automatically becomes a renovated premium lease.
5. It lets you build a realistic renovation schedule
A value-add model should not just have a renovation budget. It should have a renovation schedule.
The rent roll helps answer:
How many units expire each month?
How many of those tenants are likely to renew?
How many turns can management actually renovate per month?
How much downtime is required per renovation?
How much rent is lost during renovation?
How much capex is spent per unit?
When does the new rent start?
For example:
| Assumption | Example |
|---|---|
| Classic units available for renovation | 60 |
| Average renovation cost | $12,000/unit |
| Monthly renovation capacity | 4 units |
| Downtime per renovation | 1 month |
| Rent premium after renovation | $250/month |
| Annual premium per unit | $3,000 |
| Simple yield on cost | 25% |
That 25% simple yield looks attractive:
$3,000 annual rent premium / $12,000 renovation cost = 25%
But the rent roll helps you test whether you can actually get those 60 units renovated quickly enough to matter. If lease expirations are slow, renewal rates are high, or downtime is longer than expected, the realized yield is delayed.
6. It prevents double-counting upside
This is a major underwriting issue.
A broker may present:
Current rent: $1,300
Market rent: $1,450
Renovated rent: $1,650
The underwriter may be tempted to model both:
$150 loss-to-lease capture
plus
$350 renovation premium
But the true total upside from current to renovated rent is only:
$1,650 - $1,300 = $350
Not $500.
The rent roll allows you to clearly define:
Current in-place rent
Current classic market rent
Renovated market rent
Total rent upside
Portion achievable without capex
Portion requiring capex
That prevents the model from layering assumptions on top of each other.
7. It reveals whether the owner has already proven the value-add plan
One of the best things to look for is whether the property already has a sample of renovated units.
For example:
| Unit Status | Avg. Rent |
|---|---|
| Classic 1BR | $1,250 |
| Renovated 1BR | $1,575 |
| Classic 2BR | $1,600 |
| Renovated 2BR | $1,950 |
If renovated units at the subject property are actually achieving those rents, the business plan is more credible.
But if the rent roll shows this:
| Unit Status | Avg. Rent |
|---|---|
| Classic 1BR | $1,250 |
| Renovated 1BR | $1,350 |
Then the claimed $1,575 renovated rent may be based on external comps, not actual execution at the property.
That does not mean it is impossible. But it means the model should treat the assumption as less proven.
The best evidence is usually:
Recently leased renovated units at the subject property, with little or no concession, at the rent you are underwriting.
8. It shows whether rent upside is broad or concentrated
Averages can be misleading.
Suppose a property has an average in-place rent of $1,450 and average market rent of $1,600. That looks like $200 of upside across the property.
But the rent roll may show this:
| Group | Units | Rent Upside |
|---|---|---|
| Severely under-market legacy tenants | 10 | $500/unit |
| Moderately under-market tenants | 25 | $150/unit |
| At-market tenants | 45 | $0/unit |
| Already above market | 20 | -$50/unit |
The average upside may look attractive, but the real opportunity is concentrated in a small number of units. That affects timing, risk, and probability of capture. You'll notice in the above the actual upside is only $77/unit.
A strong model should not rely only on the average. It should show the distribution of rent upside.
9. It connects rent growth to tenant behavior
Rent roll analysis is partly financial and partly behavioral.
If many tenants are paying far below market, the underwriter should ask why. Possible explanations include:
The prior owner was under-managing the asset.
The tenants are long-term residents with below-market leases.
The units are physically inferior.
The tenant base cannot afford higher rents.
The property has service issues or reputation problems.
The submarket rent comp is too aggressive.
The rent roll includes concessions that are not obvious in stated rent.
This matters because value-add execution often depends on turnover. But turnover is not always good. High turnover creates renovation opportunities, but it also creates vacancy, make-ready costs, leasing costs, and operational drag.
Low turnover can be good for stability but bad for rapid value-add execution.
The rent roll helps you understand that tradeoff.
10. It improves the revenue model from “static” to “unit-by-unit”
A basic model may do this:
Year 1 rent = current rent × 3% growth
Year 2 rent = Year 1 rent × 3% growth
Year 3 rent = Year 2 rent × 3% growth
That is not really a value-add model. That is just a rent growth model.
A better value-add model uses the rent roll as the starting point and creates a unit-level revenue schedule.
For each unit, the model should know:
| Field | Purpose |
|---|---|
| Unit number | Tracks each unit individually |
| Unit type | Applies correct market rent |
| Current rent | Establishes in-place revenue |
| Lease expiration | Determines timing |
| Renovation status | Determines current condition |
| Target rent | Establishes future achievable rent |
| Renovation cost | Calculates capex |
| Downtime | Calculates vacancy loss |
| Renewal/turnover assumption | Determines path |
| New rent start date | Drives actual revenue timing |
The model can then roll up all units into:
Gross potential rent
Vacancy loss
Concessions
Bad debt
Effective rental income
Other income
NOI
Cash flow after capex
Yield on cost
Stabilized value
This is why the rent roll is such a powerful underwriting tool. It turns a broad business plan into a specific operating plan.
Simple example
Assume a classic 2BR unit has:
Current rent: $1,600
Classic market rent: $1,725
Renovated market rent: $1,950
Renovation cost: $14,000
Lease expiration: Month 6
Downtime: 1 month
There are three possible model treatments.
Weak model
“Rent goes to $1,950 immediately.”
This overstates near-term NOI.
Better model
“Rent stays at $1,600 until Month 6, then goes to $1,950.”
This is better, but still ignores downtime and capex.
Stronger model
“Rent stays at $1,600 through Month 6. Tenant turns. Unit is down for Month 7. Renovation capex of $14,000 is spent. New lease begins Month 8 at $1,950.”
That is how value-add should be modeled.
The model captures:
Lost rent during downtime
Capital cost
Delayed rent premium
Actual timing of NOI growth
True return on renovation capital
The best rent roll questions for value-add
When reviewing a rent roll, I would focus on these questions:
How many units are truly classic or unrenovated?
This defines the remaining renovation opportunity.
What rents are renovated units actually achieving today?
This tests whether the premium is proven.
Are current rents below market because of under-management or because the asset has real limitations?
This separates opportunity from fantasy.
When do leases expire?
This determines how fast the upside can be captured.
How many units are vacant or month-to-month?
These may represent immediate value-add opportunities.
Are concessions being used?
A $1,600 rent with one month free is not the same as a clean $1,600 rent.
Are any units delinquent, employee-occupied, down, or restricted?
These can distort the rent roll.
Is upside spread across many units or concentrated in a few?
Broad upside is usually more durable than upside concentrated in a small number of outlier units.
Does the rent premium justify the renovation cost?
A $200 monthly premium equals $2,400 per year. If the renovation costs $20,000, that is a 12% simple yield before vacancy, downtime, and execution risk. That may or may not be enough depending on the business plan.
The key takeaway
The rent roll is the best place to analyze value-add because it answers the most important question:
Where, exactly, is the upside coming from?
Not in theory. Not at the property-average level. But unit by unit.
A good value-add model should use the rent roll to determine:
Which units can be upgraded
What rent premium is realistic
When each unit can be repriced
How much capex is required
How much downtime occurs
How quickly NOI can grow
Whether the exit value is based on real stabilized income or hopeful assumptions
In other words, the rent roll is where the value-add story either becomes credible or falls apart.
For more, check out all these real estate analysis templates and if you want a custom template built by me, go here.
Article found in Real Estate.
