What Is a Rent Roll?
Rent roll analysis is the process of examining a property's unit-by-unit or tenant-by-tenant lease data to understand current income, rent upside, occupancy quality, and lease risk. In CRE underwriting, how to analyze a rent roll is one of the foundational skills that separates investors who accurately model a deal from those who overpay based on optimistic OM projections.
The rent roll is a snapshot document, not a historical one. It shows the current state of every lease in the building: who is in which unit, what they pay, when their lease started and ends, and whether they are current on rent. It is typically produced by the property management software (AppFolio, Yardi, RealPage) and reflects the most recent data at the time of the request.
Unlike the T12, which shows what happened over the trailing year, the rent roll shows what is happening right now. Both documents are required to build an accurate underwriting model. See the companion piece on what a T12 is and how to analyze one for the historical income context.
What a Rent Roll Contains
Rent roll formats vary by property management software, but a complete rent roll for a multifamily property should include all of the following columns. If any are missing, request them before proceeding with underwriting.
| Unit # | Unit Type | Sq Ft | In-Place Rent | Market Rent | Loss to Lease | Lease Start | Lease End | Status |
|---|---|---|---|---|---|---|---|---|
| 101 | 1BD/1BA | 720 | $1,450 | $1,600 | $150 | 03/01/2023 | 02/28/2025 | Occupied |
| 102 | 2BD/1BA | 960 | $1,825 | $2,050 | $225 | 07/15/2022 | 07/14/2024 | MTM |
| 103 | Studio | 490 | $0 | $1,100 | $1,100 | — | — | Vacant |
| 104 | 2BD/2BA | 1,080 | $2,100 | $2,200 | $100 | 01/01/2024 | 12/31/2024 | Occupied |
The "Status" column is particularly important. Statuses to watch for: Occupied (current lease), MTM (month-to-month, no fixed term), Notice Given (tenant has announced departure), Model (management office or staging unit), and Down (unit offline for renovation). Each requires a different treatment in your underwriting model.
Key Metrics to Calculate
Loss to Lease
Loss to lease is the difference between market rent and in-place rent for each occupied unit. A unit renting at $1,450 against a market rent of $1,600 has a $150 per month loss to lease, or $1,800 annually. Aggregated across all units, this figure represents the total revenue upside available as leases turn over. For a deeper breakdown of this metric, see the guide to what loss to lease means in CRE.
The calculation is straightforward: Loss to Lease = (Market Rent - In-Place Rent) x 12 x Number of Units. The aggregate loss to lease on a property is one of the core value-add underwriting inputs. It tells you how much additional NOI is theoretically available, and over what timeline you can capture it.
Physical Occupancy vs. Economic Occupancy
Physical occupancy is the percentage of units with a body in them, regardless of whether rent is being collected. Economic occupancy is the percentage of gross potential rent that is actually being collected. A property with 95% physical occupancy but a 12% concession rate and 3% bad debt has an economic occupancy closer to 80%.
Never underwrite based on physical occupancy alone. Economic occupancy is what drives NOI. The rent roll, combined with the T12, gives you both figures. If the rent roll shows 95% occupied but the T12 shows consistently low collections relative to GPR, you have a tenant quality problem, not a leasing problem.
Lease Expiration Schedule
Build a lease expiration matrix from the rent roll: how many leases expire in the next 12 months, 13-24 months, and 25-36 months. Express each bucket as a percentage of total units. A property with 60% of leases expiring in the next 12 months carries significant rollover risk for a buyer who plans to renovate and re-lease at market rates. That same rollover could be a value-add opportunity, depending on the spread between in-place and market rents.
Tenant Concentration (Commercial Properties)
For retail, office, and industrial properties, calculate the revenue contribution of the top three tenants as a percentage of total NOI. If one tenant represents more than 25-30% of revenue, their lease expiration date and financial health become deal-level risks. Request tenant financials or credit ratings for anchor tenants, and model a downside scenario that includes their departure.
Analyzing Rent Upside
The value-add thesis in most multifamily acquisitions rests on one central premise: in-place rents are below market, and you can close that gap through lease rollovers, unit renovations, or both. Rent upside analysis quantifies exactly how large that opportunity is and how long it will take to realize.
Calculating Aggregate Loss to Lease
Start by summing the per-unit loss to lease across all occupied units. A 100-unit property with an average loss to lease of $150 per month per occupied unit (at 95% occupancy) has a total aggregate loss to lease of approximately $171,000 annually. Capitalized at a 5.5% cap rate, that represents $3.1 million of incremental value, before renovation costs.
That is the theoretical ceiling. The practical question is how much of it you can actually capture, and when. That depends on the lease expiration schedule. If 30% of leases roll in the next 12 months, you can begin capturing that upside quickly. If 80% of leases are locked for 24+ months, the value-add timeline extends and your carry costs increase.
When High Loss to Lease Is a Red Flag, Not an Opportunity
A high loss to lease is not automatically a buying opportunity. If in-place rents are significantly below market because tenants cannot afford market rates, aggressive lease-up will produce high vacancy, not higher revenue. Look at the tenant profile. In a workforce housing property where median household incomes in the submarket are $45,000-$55,000, a 20% rent increase will trigger turnover and may not backfill at market rates on your timeline.
The same is true in softer markets where the "market rent" on the rent roll is seller-defined. Verify market rents independently against active listings and recent lease comps before accepting the loss to lease figure at face value.
Rollover Timing and the Value-Add Timeline
The lease expiration schedule directly determines when you can execute your business plan. A well-structured value-add thesis accounts for: average days vacant during unit turnover (typically 30-60 days), renovation duration per unit (30-90 days depending on scope), and lease-up velocity in the submarket. Build this schedule into your DCF model by year, not as an aggregate. A renovation plan that assumes all 100 units complete in Year 1 is not credible. A phased plan that assumes 25-30 units per year is. For a complete framework on modeling this, see the guide to how to underwrite multifamily deals.
Red Flags in a Rent Roll
The rent roll is one of the easiest documents to manipulate in the pre-sale period. Sellers have weeks or months to prepare the property's presentation, and the rent roll is often where that preparation shows up most visibly.
Units marked vacant but suspiciously clean. If multiple vacant units were recently turned and show no lease activity, ask for the lease-up history. A seller who cleaned and staged vacant units immediately before going to market is presenting a misleadingly low vacancy figure that will normalize to a higher level post-close.
Concessions not disclosed in the OM. Free rent months, move-in specials, and waived fees are standard tools to fill units quickly. If the rent roll shows recent leases signed at high rates but the T12 shows lower collections during the same period, concessions are likely the explanation. Request the actual lease agreements for any unit signed in the 90 days before the rent roll date.
Leases expiring immediately after closing. If a disproportionate number of leases expire in the 30-90 days following the projected close date, the seller may have signed short-term leases to show full occupancy at sale while knowing those units will roll immediately. Cross-reference the lease start dates. A cluster of 12-month leases all starting 11 months before the sale process began is not a coincidence.
Month-to-month tenants counted as occupied. MTM tenants are occupied but represent a fragile occupancy that can evaporate with 30 days notice. A property with 20% of units on month-to-month leases is not the same as one where 20% of leases roll in 12 months. MTM tenants can leave faster, and buyers inherit that instability. Model MTM units at a higher effective vacancy rate in your underwriting.
Rent Roll vs T12: How They Work Together
The rent roll and the T12 are complementary documents that must be reconciled, not read in isolation. The rent roll tells you the current state. The T12 tells you the operating history. Together, they tell you whether the current state is credible.
The primary reconciliation check: total scheduled rent on the rent roll should approximate GPR on the T12 at the same point in time. If the rent roll shows $125,000 in monthly scheduled rents but the T12 shows average monthly GPR of $105,000, one of two things is true: rents were recently raised (legitimate, worth verifying), or the rent roll has been inflated (requires deeper investigation).
AcquiOS processes rent rolls and T12s simultaneously, running this reconciliation automatically and flagging discrepancies before they reach your model. The platform extracts every unit row, calculates aggregate loss to lease, maps the lease expiration schedule, and highlights anomalous entries, all before populating your DCF assumptions. What requires two hours of analyst time manually runs in minutes with full source traceability.
Frequently Asked Questions
What is the difference between a rent roll and a T12?
A rent roll is a current snapshot of every lease in a property: who is occupying each unit, what they pay, and when their lease ends. A T12 is a trailing 12-month income and expense statement showing what the property actually earned and spent over the past year. The rent roll is unit-level and current. The T12 is property-level and historical. Both are required to underwrite a deal accurately.
How do you calculate economic occupancy from a rent roll?
Economic occupancy equals actual rent collected divided by gross potential rent (GPR). GPR is what every unit would collect at 100% occupancy at scheduled rates. From the rent roll, sum all in-place rents for occupied units. Divide by the sum of all units at their scheduled market rates. The resulting percentage is physical economic occupancy as of the rent roll date. For a more precise figure, use the T12 to measure actual collections against GPR over the trailing year.
What is a normal loss to lease percentage?
Loss to lease of 5-15% of market rent is common in value-add multifamily acquisitions. In core, stabilized properties, loss to lease is often 1-5%. Anything above 15% warrants close scrutiny of whether market rents are accurately stated and whether the tenant base can support rent increases. Very high loss to lease (above 20%) in a stable market usually indicates either genuine value-add opportunity or an inflated market rent assumption, and distinguishing between the two is one of the most important jobs in rent roll analysis.
How do you verify a rent roll?
Request the actual lease agreements for a sample of units, particularly any signed in the 90 days before the rent roll date. Verify in-place rents against the leases. Check that lease terms match what is shown. Cross-reference the rent roll occupancy against the T12 collections. Request a rent ledger showing the last 12 months of payment history by unit. For large acquisitions, a physical unit walk-through to confirm occupied units are actually occupied is standard practice.