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.
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "Loss-to-lease, vacancy, concessions, bad debt." It is knowing what you would verify next.
Gross rent is the opening statement. Collected rent is the evidence.
Loss-to-lease, vacancy, concessions, and bad debt explain why those two numbers do not match. They are four different leaks with different causes, different fixes, and different documents. Underwrite them as one vague “loss factor” and you have covered four holes with one label.
Identify each leak
| Leakage | Plain-English meaning | Common trick |
|---|---|---|
| Loss-to-lease | In-place rents are below market rents | Treating “market” as already earned |
| Vacancy | Empty units | Using stabilized vacancy too early |
| Concessions | Free rent or discounts | Hiding giveaways outside the rent line |
| Bad debt | Rent billed but not collected | Pretending delinquency is temporary forever |
These are not accounting decorations. They are four places where scheduled revenue can fail to become cash. Calling all of them temporary does not make any of them temporary.
The $174,000 walk-down
Assume annual gross potential rent is $1,200,000.
| Item | Amount |
|---|---|
| Gross potential rent | $1,200,000 |
| Less loss-to-lease | -$72,000 |
| Less vacancy | -$60,000 |
| Less concessions | -$18,000 |
| Less bad debt | -$24,000 |
| Collected residential rent before other income | $1,026,000 |
The difference is $174,000. That is not a rounding error. It can be the distance between comfortable debt coverage and a lender asking why the property missed again.
The math also tells you something management language may not. Loss-to-lease is not vacancy. A concession is not bad debt. If someone uses one explanation for all four, the explanation has not met the facts.
Give every excuse its own file
A sponsor may call loss-to-lease upside, vacancy temporary, concessions strategy, and bad debt cleanup. Any one of those statements may be true. All four still require separate evidence.
Open these exhibits:
- The current rent roll and recent signed leases for loss-to-lease.
- Monthly occupancy history, leasing traffic, and the make-ready schedule for vacancy.
- The concession ledger and effective rent comps for concessions.
- Aged receivables, collections history, and resident-screening records for bad debt.
Useful documents have dull names because their job is to record what happened, not help the pitch recover from it.
Separate what management can actually fix
| Bucket | Can management fix it? | Evidence needed |
|---|---|---|
| Loss-to-lease | Maybe | Recent signed leases at higher rents |
| Vacancy | Maybe | Leasing traffic and make-ready schedule |
| Concessions | Maybe | Market comps without concessions |
| Bad debt | Sometimes | Collections history and resident screening |
Notice all four answers are not “yes.” Management can improve operations. It cannot order the market to accept a rent, make every applicant qualified, or collect every old balance because the model needs a cleaner year one.
If all four losses disappear on the same schedule, ask which exact action fixes each one and which monthly report will prove it. A turnaround without dates, owners, and evidence is an alibi drafted before the incident.
Rebuild the rent that lands
Reconcile effective rent from the rent roll to the T-12. If the model uses a cleaner loss factor than the property has earned, write down what must change, by when, who controls it, and which report will confirm it.
The last line of the exercise is collected residential rent before other income: $1,026,000. That is the number the four optimistic labels were trying to keep off the repair bill.
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.