Rent roll analysis means checking the seller's unit-by-unit income snapshot for accuracy, trends and risk before you price a deal on it. You read every column, compare the numbers to the leases and the operating statement, and look for patterns that make income look better than it is. A rent roll is a seller document. Treat it as a claim to verify, not a fact.
This guide walks through each column, then gives you a checklist of red flags. If you want a clean layout to work in, our rent roll template has one.
What a Rent Roll Shows and Why Buyers Check It
A rent roll lists each unit with its resident, lease dates, rent, deposit and status as of one date. Lenders and buyers lean on it because it is the fastest way to see what a property earns today. Buyers value the property on income, so a rent roll that is off by a little can move the price by a lot.
That is also why lenders test it. Freddie Mac's Multifamily Seller/Servicer Guide, in section 5.2(a) (dated 02/22/24), has the seller represent that any rent roll delivered states the unit count correctly and discloses gross potential rents and actual leased rents within a stated tolerance. Lenders do not take the document on faith, and you should not either.
How to Read a Rent Roll Column by Column
Here is how to read a rent roll, one column at a time. Column names vary, but most rent rolls carry these.
- Unit number. Check that every unit in the building appears once, with no gaps and no duplicates. Compare the count to the offering memorandum and the county record.
- Unit type and bedrooms. The mix drives rent. Make sure the types match the floor plans you see on site.
- Square feet. Use it to compare rent per square foot across units. A big gap between similar units needs an explanation.
- Resident name or status. Look for units marked vacant, notice, model, down, employee or month-to-month.
- Lease start and end dates. These show when leases were signed and when they roll. We come back to this below.
- Market rent. This is the rent the seller says the unit would get today. It is an opinion, so compare it to real comparable listings.
- Lease rent (in-place rent). This is what the resident owes each month under the lease.
- Concessions. Free rent or discounts. Ask whether the lease rent is shown before or after concessions.
- Deposit. Check that deposits held match the deposit liability on the balance sheet.
- Balance. What the resident owes. Positive means behind, negative means prepaid.
A rent roll tells you what the lease says. The T12 tells you what the property collected. You need both.
Rent Roll Analysis Checklist: Red Flags to Look For
Work through these in order. Each one is a place where a rent roll can look better than the building performs.
Recent Leases at Low Rents or With Concessions
Sort the rent roll by lease start date. Look at leases signed in the last three to six months. If they sit well below older leases, or carry free rent, the market may be softer than the seller says. Sellers sometimes also sign leases right before a sale to lift occupancy, offering a discount to do it. Ask for the lease files on those units and a reason for each concession.
Many Leases Expiring at Once
Count leases ending by month. If a third of the building rolls in the same two months, you take on a lot of turnover risk right after closing. That is hard on your cash flow and on your leasing team. A healthy roll shows expirations spread across the year.
Loss to Lease
Compare market rent to lease rent for each unit and add up the gap. This is loss to lease. A large gap can mean room to raise rents, or it can mean the market rent column is inflated. Check the market rent against comparable apartments before you count it as upside.
Delinquency and Balances
Total the balance column. A few small balances are normal. Large or growing balances mean collections are weaker than the rent roll suggests, and they can hide bad debt that the T12 is quietly absorbing. Ask for an aged receivables report and see how old each balance is.
Model, Down and Employee Units
Units that do not pay full rent still show up on the roll. Models, units down for repairs, and employee units reduce income. Ask how many there are, why each one is down and what it costs to bring it back. A unit that has been "down" for a year may never come back at the rent shown.
Month-to-Month Concentration
A high share of month-to-month leases means residents can leave on short notice, and it can also mean leases lapsed without renewal. Some month-to-month leases are fine, and some carry a premium. Many of them in a stable building deserve a question.
Rent Roll vs T12 Reconciliation
Multiply the rent roll's lease rent by twelve and compare it to rental income on the seller's T12, ideally in a T12 analysis template so both sit side by side. They will not match exactly, but the gap should be explained by vacancy, concessions, bad debt and timing. If collections run well below what the rent roll implies, find out why before you underwrite on the roll.
Lease Audit and Estoppels
Pick a sample of units and match the rent roll to the signed leases: rent, dates, deposit and concessions. Add units from the red flags above to the sample. Buyers also often ask for resident estoppel statements, where residents confirm their lease terms in writing, when the deal and the lender call for it. If the leases disagree with the roll, widen the sample.
Illustrative Example: Reading a Small Rent Roll
Say four units are sampled from a rent roll. These numbers are illustrative, not from a real property.
| Unit | Type | Market rent | Lease rent | Lease end | Note |
|---|---|---|---|---|---|
| 101 | 1 bed | $1,500 | $1,450 | Jun 2026 | |
| 102 | 1 bed | $1,500 | $1,350 | Jun 2026 | One month free |
| 103 | 2 bed | $1,900 | $1,900 | Jun 2026 | Balance owed |
| 104 | 2 bed | $1,900 | Model |
Three things stand out. Every lease ends in the same month. One unit has a concession, so its effective rent is lower than the lease rent. And one unit earns nothing because it is a model. A buyer using the market rent column would count $6,800 a month. The in-place total is lower once the model and the concession are counted. Scale that gap across a whole building and the price changes.
How Often to Update Your Rent Roll Analysis
A rent roll is a snapshot, and the building keeps moving. Ask for a dated rent roll at the start of due diligence and a refreshed one close to closing, then compare the two. Look for units that went from occupied to vacant, new concessions and balances that grew. Our multifamily due diligence checklist shows where the rent roll fits next to the T12, the inspection and the rest of the work.
If you want an operator to look at the numbers with you, we manage apartments in Reno, Sparks, Carson City and Lake Tahoe, and we read rent rolls the way we run buildings: unit by unit. A clear rent roll template makes it easier to compare what the seller sends against what you find.
