The return summary is the departure board. It tells you where everybody hopes to land.
Underwriting is the person outside with a flashlight asking why there is fluid under the left engine.
In plain English, underwriting is the act of asking: “If I buy this property, finance it this way, operate it under these assumptions, and sell or refinance it later, what has to be true for the plan to survive?” The spreadsheet records the answer. It does not create one.
That distinction matters because cells will accept facts, guesses, and salesmanship without changing font. Your money should be less accommodating.
The clipboard is not the inspection
A useful underwriting model has three jobs:
| Job | Plain-English version | Source to check |
|---|---|---|
| Measures current reality | What is the property doing now? | Rent roll, T-12, bank deposits |
| Tests the business plan | What has to improve, and who has to make it happen? | Renovation budget, rent comps, property manager feedback |
| Prices the downside | What happens if the clean story misses? | Debt quote, reserve schedule, exit-cap sensitivity |
Current operations tell you what exists. The business plan tells you what must change. The downside tells you how much room there is for bad timing, weak execution, or an unfriendly market.
If the model does not do all three, it is not cleared for takeoff. It is paperwork wearing a reflective vest.
The 60-unit gauge check
Take a hypothetical 60-unit property showing $1,000 per unit in monthly scheduled rent.
Gross potential rent:
60 units x $1,000 x 12 months = $720,000
That is the gauge at full throttle. Now open the rent roll. Three units are vacant, two residents have concessions, and last year’s bad debt was $18,000.
If collected residential income is really $648,000, then $720,000 was a ceiling, not cash flow. That gap can change debt coverage, reserve needs, and whether the value-add plan is creating value or merely raising its voice.
The formula did nothing wrong. The operator asked it the wrong question.
Tag every important input
Before trusting the output, label every major line:
- Fact: It already happened and has a source, such as repairs on the T-12.
- Contract: A signed document controls it, such as the rate and maturity in the loan terms.
- Projection: Future performance must cooperate, such as year-two rent growth or the sale cap rate.
Projections belong in a model. They just do not get to impersonate evidence.
This is where people get fooled. Rent growth, insurance renewals, lease-up speed, taxes after sale, and exit value arrive in the same tidy grid as last month’s collected rent. The formatting makes them look equally solid. They are not.
What grounds the deal
Slow down when:
- Scheduled rent is presented without a bridge to collections.
- A renovation premium has comps but no signed renovated leases.
- Taxes and insurance rise neatly without a current bill or quote.
- Debt terms in the model do not match the lender quote.
- The exit case carries the return while operations barely carry the debt.
One loose assumption may be fixable. Five loose assumptions are not diversification.
Sign the inspection card
Print the rent roll, T-12, debt quote, tax bill, insurance quote, renovation budget, and reserve schedule. Rebuild revenue, expenses, debt service, and exit value from those sources. Mark every missing source in plain language.
Then read the return summary.
It can brief the destination. It cannot stamp its own airworthiness certificate.
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.