Published Last updated
Every private real estate deal rests on two documents. Neither is audited, both are produced by the seller, and each has three or four specific places where an ordinary presentation choice quietly improves the picture. None of what follows implies dishonesty. It implies that you should read them yourself.
What the two documents are, and why you get both
A rent roll is a snapshot: every unit in the property on one date, who is in it, what they are contracted to pay, when their lease ends, and what they actually owe. A trailing twelve, usually written T12, is a film: the last twelve months of income and expense, month by month.
You get both because neither is sufficient. The rent roll tells you what the property is contracted to earn from today forward and says nothing about whether it collected. The T12 tells you what it collected and says nothing about what happens next month when forty leases expire. Read together they answer a question neither answers alone: is the income real, and is it durable?
Everything below is what an underwriter looks for, in the order they look for it.
Start at the top, because the top line is theoretical
Gross potential rent is every unit let at market rent for a full year, occupied or not. It is a construct, not money, and it is the number a weak offering leans on hardest.
From it come a series of deductions, and the order matters because each one hides a different problem.
| Line | What it is | What a large number tells you |
|---|---|---|
| Gross potential rent | Every unit at market, fully occupied | Nothing. It is an assumption |
| Loss to lease | Gap between in-place rents and market | Upside, or an optimistic market assumption |
| Vacancy | Units with nobody in them | Demand or operations problem |
| Concessions | Free rent used to sign leases | Softening submarket, and it lags the vacancy number |
| Bad debt | Rent billed and never collected | Screening or collection problem |
| Non-revenue units | Model, staff, down units | Fine in moderation, worth counting |
| Net rental income | What the leases actually produce | The first honest number on the page |
Loss to lease is the line most often sold as upside. It is only upside if the market rent in the assumption is real. If someone has set market rent optimistically, loss to lease grows on paper and so does the apparent room to raise rents, without anything changing at the property. Check the assumed market rent against something outside the model.
Physical occupancy is not economic occupancy
This is the single most useful distinction on the page and it is routinely blurred.
Physical occupancy counts units with somebody in them. Economic occupancy measures rent actually collected against gross potential rent. A property can be ninety-five percent physically occupied and collect materially less, because concessions, bad debt and non-revenue units all sit between a warm body and a bank deposit.
A wide gap between the two is the tell. It says the property is buying occupancy rather than earning it, which is a very different asset from the one the headline number describes. Ask for both figures for each of the last twelve months, not an annual average, because an average conceals precisely the trend you are looking for.
The direction matters more than the level. Occupancy holding at ninety-two percent with concessions falling is a property strengthening. Occupancy holding at ninety-five with concessions rising is a property buying its way to a number, and the concession cost will show up later.
The lease expiration schedule is the part with a future in it
The rent roll's most valuable column is the one people skim: lease end dates. Sort by it.
Two patterns are worth finding. A cluster of expirations in a single month or quarter is concentration risk, because the property has to re-lease a large share of itself in one leasing season, and if that season is soft the whole cluster reprices downward together. A cluster falling in a slow season for that market is worse.
The second pattern is month-to-month tenancies. A meaningful share of month-to-month residents can mean a property that has stopped pushing renewals, or one that is holding occupancy by not asking for a commitment. Either way it is income with no term behind it, and it should not be underwritten as though it were.
Then compare in-place rents on recently signed leases against in-place rents on older ones. Recent signings are the market's current answer. If new leases are being signed below what long-tenured residents pay, the achievable rent is falling and the rent roll's average is a lagging indicator.
Reading the T12 for the things that do not repeat
The trailing twelve is where an operating story becomes checkable, and the main skill is separating what recurs from what does not.
Read it monthly, never as an annual total. A single month carrying an unusual repair, an insurance true-up, a tax payment or a legal cost will distort a twelve-month sum and vanish into an average. Ask what each spike was and whether it recurs.
| Line | Why it moves | The question |
|---|---|---|
| Property taxes | Sale often triggers reassessment | Does the model assume reassessment, at what basis? |
| Insurance | Renewals have repriced sharply in exposed markets | Current premium, renewal date, last two renewals? |
| Payroll | A renovation plan needs more staff, not fewer | Does staffing match the business plan? |
| Repairs and maintenance | Deferred maintenance suppresses it, then it arrives | Is anything being deferred to flatter the T12? |
| Utilities | Reimbursement structures differ by property | What is billed back, and is that assumed to continue? |
| Management fee | May be an affiliate at a non-market rate | Is the manager related to the sponsor? |
The tax line is the one that quietly breaks models. A T12 shows the seller's tax bill. In many jurisdictions a sale triggers reassessment, so the buyer's bill is different and permanently higher, and carrying the seller's number forward overstates net operating income for the entire hold and inflates the exit value too, because the overstated income is capitalized at sale.
The maintenance line is the mirror image. A seller preparing to sell has every incentive to defer, which makes the T12 look better and hands the buyer the bill. Ask what capital work has been deferred and read the property condition report against the expense line.
Checking the story against something outside the model
Both documents come from the seller. That does not make them wrong, and it does mean every load-bearing assumption should be checked against a source with no stake in the transaction. All of these are free.
For the rent level, HUD publishes Fair Market Rents by metropolitan area and bedroom count,1 which is not a market rent but is a useful floor and shows where subsidized demand sits. HUD also publishes Comprehensive Housing Market Analyses for individual metros,2 which are among the most underused free documents in this field.
For supply, the Census Bureau's Building Permits Survey gives permitted units by structure size for metros and individual jurisdictions,3 and multifamily permits lead deliveries by roughly one to two years. The Housing Vacancies and Homeownership series gives rental vacancy nationally and by region.4
For demand, BLS Economy at a Glance carries metro employment and unemployment,5 and data.census.gov carries household income, renter share and household formation.6 A rent growth assumption running materially ahead of local income growth is a bet that renters spend a rising share of income, which holds for a while and rarely for five years. General price movement sits in the Consumer Price Index.7
The delinquency report is the document nobody sends
A rent roll shows what residents are contracted to pay. An aged delinquency report shows what they have not paid and for how long. The second is where a property's real collection performance lives, and it is frequently absent from a package until it is asked for by name.
Ask for aged receivables bucketed at 0 to 30, 31 to 60, 61 to 90 and over 90 days, for each of the last twelve months. One month tells you almost nothing. Twelve months of buckets tells you whether the balance is a few hard cases working through a process or a steadily growing tail.
| Pattern across twelve months | What it usually means |
|---|---|
| Small 0 to 30 balance, almost nothing beyond 60 | Normal timing friction. Healthy |
| Growing over 90 bucket | Cases not being resolved. Collections or legal process stalled |
| Large balance that drops sharply in one month | Write-offs. Ask what was written off and when |
| Bad debt low but over 90 high | Losses not yet recognized. The T12 flatters |
That last row is the one to look for. If delinquency is aging past ninety days but bad debt in the T12 stays low, losses have been incurred and not yet written off. The expense line will catch up with reality after you own it.
Compare the residents in the over 90 bucket against the rent roll. If they are still shown as occupied and contributing to gross potential rent, the rent roll is counting income that is not arriving.
What actually looks wrong
A short list of things that should stop you, drawn from what tends to be true when a rent roll has been dressed.
Concessions rising while occupancy holds flat. Bad debt climbing across the trailing months. A large share of leases signed in the last ninety days, which can mean occupancy was bought immediately before marketing the property. Recent lease rents below older in-place rents. A cluster of expirations landing just after the projected closing. Non-revenue units growing without explanation. Repairs and maintenance falling in the final months of ownership.
None of these is disqualifying on its own. Each has an innocent explanation and a sponsor should be able to give it. Two or three together in the same file is a pattern.
The composite question worth asking: if the seller ran this property for another twenty-four months, would these numbers get better or worse? A seller's own answer to that question is why the property is for sale.
What we hand over
We give the rent roll and the trailing twelve to any investor evaluating a deal we sponsor, monthly rather than annualized, with the expense lines against our modeled year one so the differences are visible rather than reconciled out of sight.
We will also tell you which assumption in the model we are least confident about. Every model has one. A sponsor who says otherwise has either not looked or is not saying.
What none of it becomes is a projection. Depreciation and your share of the result eventually arrive on a Schedule K-1,8 the recovery periods that govern it are in Publication 946,9 and none of it is a promise about outcomes. The fuller framework for reading a model is at multifamily underwriting explained.
What to request alongside them
- The delinquency report as of the same date as the rent roll
- Concession detail by unit, not a summary percentage
- Capital expenditure detail for the same twelve months as the T-12
- A written reconciliation from annualized rent roll to trailing revenue
- Insurance quoted at the asset within the last ninety days
- The assessment history and the next scheduled revaluation date
What this is built on
- U.S. Department of Housing and Urban Development, HUD User, Fair Market Rents
- U.S. Department of Housing and Urban Development, HUD User, Comprehensive Housing Market Analyses
- U.S. Census Bureau, Building Permits Survey
- U.S. Census Bureau, Housing Vacancies and Homeownership
- U.S. Bureau of Labor Statistics, Economy at a Glance
- U.S. Census Bureau, data.census.gov
- U.S. Bureau of Labor Statistics, Consumer Price Index
- Internal Revenue Service, Schedule K-1 (Form 1065)
- Internal Revenue Service, Publication 946, How To Depreciate Property
-
No question matches that. Try another word, or ask the one that is not on this list.
Ricardo Sanabria · Grey Oaks Multifamily
Answering
Follow-up questions people ask after reading this.
Which document do you read first?
The rent roll, because it tells you what the property is today, and then the T-12 to find out what the last twelve months did to it. Reading them in the other order tends to anchor you on the seller narrative.
Ricardo Sanabria, Grey Oaks Multifamily
What is the most common flattering choice?
A non-recurring credit annualized into a trailing figure, and unusually low repairs and maintenance. Neither is dishonest on its own. Both change the picture materially and both are visible if you look for them.
Ricardo Sanabria, Grey Oaks Multifamily
Is occupancy the number to focus on?
No. Effective rent collected is. A property at ninety-six percent occupancy on heavy concessions and an active delinquency list can be performing worse than one at ninety percent with none.
Ricardo Sanabria, Grey Oaks Multifamily
Do you provide these for your own deals?
Yes, with the delinquency report, the concession detail and the capital expenditure detail alongside, because those are the documents the numbers actually rest on. Our reporting commitments are on the how to invest page.
Ricardo Sanabria, Grey Oaks Multifamily
4 questions
