The model is confessing. Read it that way.
Every spreadsheet has one or two numbers quietly carrying the sales pitch. Find them before they start carrying your money.
Say the concept without hiding behind jargon.
Tie the answer to a document, data source, or operating fact.
Name the person or entity with control.
Know the point where the answer is not good enough.
If you cannot say it plainly, you do not own it yet.
The deck is allowed to be pretty. It still has to prove itself.
Use the answer to change a real yes, no, or wait.
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "Gross potential rent and the rent roll." It is knowing what you would verify next.
Gross potential rent is what the property would collect if every unit paid full scheduled rent for the full period.
Read the definition carefully. It says would, not did. Gross potential rent is the ceiling of the revenue math, built in a world with no empty units, no concessions, and no collection problems. That makes it useful. It does not make it cash.
The rent roll is the first document I put under oath. If the ceiling is real, the unit-level evidence should hold it up.
What the rent roll has to establish
The rent roll is the property’s live roster: unit, tenant, lease dates, current rent, market rent, deposits, balances, and vacancy status. One total at the bottom is not evidence. It is a claim with excellent formatting.
For underwriting, I want it to answer four questions:
| Question | Why it matters |
|---|---|
| Which units are occupied? | Vacant units do not pay debt service |
| What rent is actually contracted? | Market rent is not the same as lease rent |
| When do leases expire? | Rollover risk can hit in bunches |
| Who is not paying cleanly? | Delinquency turns scheduled rent into hope |
If the rent roll is stale, the model is already giving yesterday an alibi.
Exhibit A: twenty-four units
Say a 24-unit property has:
| Unit type | Units | Scheduled rent |
|---|---|---|
| One-bedroom | 12 | $1,050 |
| Two-bedroom | 12 | $1,300 |
Monthly gross potential rent:
(12 x $1,050) + (12 x $1,300) = $28,200
Annual gross potential rent:
$28,200 x 12 = $338,400
That arithmetic is clean. The property is not. The rent roll shows two vacant two-bedrooms and one one-bedroom with a $200 monthly concession.
None of that changes gross potential rent. It changes how much of gross potential rent can reach the bank. Confusing those two is how a theoretical maximum gets introduced to investors as operating income.
Make the fields produce witnesses
Do not accept the rent roll total. Rebuild it, then make each important field answer to a second record:
- Match current rent to the signed lease or property management system.
- Match deposits to the security deposit ledger.
- Match delinquency to the aged receivables report.
- Match vacancy to the unit status report.
- Match market rent to actual nearby comps, not a broker whisper.
The rent roll is often where the business plan first gets cute because current rent and market rent sit beside each other looking equally collectible. They are not. One belongs to a signed agreement. The other still has to win a tenant.
Cross-examine five leases
Pick five leases at random. Confirm that the rent roll matches the signed rent amount, lease dates, deposit, and balance owed. Do not let anyone choose the five cleanest files for you. That is not sampling. That is casting.
Then compare total scheduled rent from the rent roll with residential income on the T-12. If scheduled rent says $338,400 and collected residential income is $304,000, your next question is not “what is the IRR?” It is “where did $34,400 go?”
That missing $34,400 has a name somewhere: vacancy, concessions, bad debt, timing, or a bad record. Make the documents name it.
Start at the ceiling, then descend
Calculate gross potential rent yourself from the unit-level rent roll. Then subtract vacancy, concessions, bad debt, and loss-to-lease before the model gets to call anything income.
Gross potential rent can tell the truth and still mislead you. The trick is not in the definition. The trick is letting a ceiling testify as though it were a bank deposit.
PR Steinfurth Equity provides educational information only. Nothing on this website is an offer to sell or a solicitation of an offer to buy any security, nor investment, legal, or tax advice. Any securities offering is made only to qualified investors through official offering documents. Real estate investments involve risk, including possible loss of principal. Past performance is not indicative of future results.