Rent roll analysis
How to analyze a multifamily rent roll
A rent roll is not just a list of tenants. It is the unit-level bridge between the property you were marketed and the revenue you can responsibly underwrite.
Direct answer
Start by proving that the file is complete, then standardize every unit and lease field. Reconcile physical and economic occupancy, isolate concessions and delinquency, compare in-place rents with a defensible market set, and only then build the forward revenue schedule.
The process
A repeatable way to do the work
- 01
Prove the unit count
Match rent-roll rows to the OM, unit mix, and stated property total; explain duplicates, employee units, models, and down units.
- 02
Normalize lease fields
Standardize unit types, dates, rent periods, vacancy labels, concessions, balances, and recurring charges before calculating metrics.
- 03
Measure occupancy two ways
Calculate physical occupancy from occupied units and economic occupancy from collectible potential rent after vacancy, concessions, and bad debt.
- 04
Test in-place rent
Compare current rent by unit type and lease cohort with signed new leases, renewals, and relevant market comparables.
- 05
Build the revenue bridge
Show how gross potential rent becomes effective rental income, with every adjustment visible instead of buried in one growth rate.
First, audit the rent roll itself
Before calculating a single return, ask whether the rows describe the same property as the OM and operating statement. The stated unit count should reconcile to the unit mix and to distinct rentable units in the source file. A mismatch can be harmless, but it cannot be ignored: model units, employee units, offline units, duplicates, and commercial spaces all change how occupancy and rent-per-unit should be interpreted.
Then check the as-of date. A rent roll without a clear effective date cannot be aligned confidently with a T12 or compared with current leasing conditions. Preserve the original values, but create normalized fields for dates, monthly rent, unit type, occupancy status, and lease status so the calculations are repeatable.
- Count distinct units and flag repeated unit identifiers.
- Separate vacant, occupied, notice, model, employee, and down units.
- Find missing start dates, end dates, rent values, and inconsistent billing periods.
- Tie unit types and square footage back to the marketed unit mix.
Physical occupancy is not economic occupancy
Physical occupancy answers how many rentable units are occupied. Economic occupancy asks how much of potential revenue is actually being collected. A property can look full while suffering from concessions, delinquency, bad debt, or below-market leases. Calculate both and explain the gap.
Loss-to-lease also needs a named benchmark. Comparing in-place rent with an OM's pro forma proves only that the seller's target is higher. A credible mark-to-market case uses signed leases, current asking rents adjusted for concessions, renewal performance, and truly comparable properties. Report the benchmark and date beside the result.
| Metric | Basic calculation | What to investigate |
|---|---|---|
| Physical occupancy | Occupied rentable units ÷ rentable units | Down units, notices, preleases |
| Economic occupancy | Collected residential revenue ÷ gross potential rent | Concessions, bad debt, delinquency |
| Loss-to-lease | Benchmark market rent − in-place rent | Benchmark quality and lease cohorts |
| Lease exposure | Leases expiring by month ÷ occupied leases | Seasonality and renewal capacity |
Translate rows into a defensible year-one forecast
Project each material revenue adjustment separately: current contractual rent, near-term expirations, renewal assumptions, vacancy, concessions, bad debt, and other recurring charges. This produces a revenue bridge that an investment committee can challenge line by line.
Keep facts and assumptions distinct. Lease dates and in-place rent come from the source. Renewal probability, market-rent growth, downtime, and bad-debt improvement are underwriting decisions. Labeling that boundary makes the model easier to revise when diligence changes the story.
- Use lease-level timing for near-term rollover instead of an annual average.
- Do not count utility or amenity charges twice between the rent roll and T12.
- Run downside cases for slower renewals, higher concessions, and extended downtime.
- Retain the source row or document reference behind each material input.
FAQ
Frequently asked questions
What should I check first on a multifamily rent roll?
Confirm the as-of date, reconcile the total unit count, identify duplicate or non-rentable units, and standardize occupancy and lease-status fields before calculating performance.
How do you calculate economic occupancy from a rent roll?
The rent roll provides the unit and lease detail, but economic occupancy normally requires collections or operating-statement data too. Compare collectible or collected residential revenue with gross potential rent for the same period.
Is loss-to-lease the same as rent upside?
No. Loss-to-lease is the difference between a chosen market benchmark and in-place rent. Realizable upside must also account for lease timing, renewal behavior, concessions, vacancy, renovation cost, and market evidence.
Continue the workflow
How to read a T12
Normalize trailing operations before treating them as a forward run rate.
Read guideT12 vs. pro forma
Separate observed performance from an assumption-driven forecast.
Read guideMultifamily underwriting model guide
Build an Excel model whose assumptions, formulas, and outputs can be audited.
Read guide