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.
Translate the claim into normal language.
Find the source, control point, and downside.
Ask whether the answer changes a decision.
Evidence What proves it?
Control Who owns it?
Limit What makes it a no?
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "Deal analysis, start to finish." It is knowing what you would verify next.
Deal analysis should not begin with the IRR. Starting there is like reading the expected arrival time before checking whether the aircraft has fuel.
The useful order is property, price, debt, business plan, exit, returns. Each step clears the next one. Skip the sequence and a polished output gets to smuggle weak assumptions past you in first class.
The checklist has an order for a reason
| Step | Question | Primary source |
|---|---|---|
| 1. Current operations | What does the property actually collect and spend? | Rent roll, T-12 |
| 2. Purchase math | What price is being paid for the current income? | Purchase price, current NOI |
| 3. Debt | How much time and flexibility does the loan allow? | Lender quote, term sheet |
| 4. Business plan | What has to change after closing? | Capex budget, rent comps, manager input |
| 5. Exit | What value is assumed later, and why? | Exit cap sensitivity, sales comps |
This is deal analysis in plain English: verify what the property does now, measure what you are paying for it, understand the loan clock, test the operational changes, and challenge the assumed sale. Returns are the receipt for those inputs.
If the deal needs you to read backward, it probably needs you not to notice something.
The 20-minute instrument check
Take a hypothetical 96-unit deal with a $14,400,000 purchase price and $820,000 of current NOI.
Going-in cap rate:
$820,000 / $14,400,000 = 5.69%
Now open the debt quote. If annual debt service is $690,000, current DSCR is:
$820,000 / $690,000 = 1.19x
That does not automatically kill the deal. It does tell you the current income does not leave much room above debt service. Add an aggressive renovation schedule, slower collections, or a cost overrun, and the margin starts looking less like a cushion and more like upholstery.
Inspect the quiet lines
The weak spots usually sit where the presentation lowers its voice:
- A rent premium copied from the nicest comp instead of the closest one.
- A tax line that ignores reassessment after sale.
- Insurance carried forward without a current quote.
- Payroll that promises better service with fewer people.
- Exit value doing more work than operations.
For each item, write the source beside the assumption. “Market” is not a source. Neither is a broker saying, “We see it all the time.”
Build the one-page discrepancy log
Before reading the investment summary again, put the sponsor case beside your checked case:
| Line | Base case | Your checked case | Difference |
|---|---|---|---|
| Current NOI | $820,000 | $790,000 | -$30,000 |
| Stabilized NOI | $1,050,000 | $970,000 | -$80,000 |
| Annual debt service | $690,000 | $715,000 | +$25,000 |
| Exit cap | 5.50% | 6.00% | +0.50% |
You are not pretending your checked case can predict the future to the dollar. You are identifying which dials control the answer and whether the evidence supports their settings.
Returns are the final sign-off
Read the rent roll, T-12, purchase price, debt quote, capex plan, rent comps, manager input, sales comps, and exit sensitivity. Then open the return summary.
Ask three questions before signing off:
- Which current number is least supported?
- Which operational change requires the most execution?
- Which debt or exit assumption gives the plan the least time to recover?
The checklist is not bureaucracy. It is how you stop a beautiful destination from distracting you from an unairworthy route.
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.