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 "The numbers sponsors hope you won't check." It is knowing what you would verify next.
The numbers most likely to hurt you are rarely hidden in a secret tab. They sit in plain sight, formatted politely, surrounded by larger numbers that are more fun to discuss.
Rent growth. Exit cap. Taxes. Insurance. Bad debt. Renovation cost. Debt maturity. Reserves.
Plain inputs. Expensive authority.
In plain English, these are the numbers that determine whether the property collects enough, keeps enough, survives the loan, and sells for what the model assumes. Check them before you spend an afternoon debating a return metric built on top of them.
Put a torque wrench on the shortlist
| Number | Why it may get a quick explanation | What to open |
|---|---|---|
| Rent premium | Makes value-add look easy | Rent comps and signed renovated leases |
| Exit cap | Creates sale value | Sales comps and sensitivity table |
| Tax reassessment | Can crush NOI | Tax bill and local reassessment method |
| Insurance | Often rising faster than models admit | Current quote and coverage detail |
| Bad debt | Makes revenue look clean | Aged receivables and write-offs |
| Renovation budget | Controls value-add execution | Contractor bids and contingency |
| Debt maturity | Controls time | Term sheet and extension tests |
| Reserves | Controls survival | Reserve schedule and lender requirements |
An important number without support is not a rounding issue. It is a fastener someone tightened by feel and buried under the panel.
The title says sponsors hope you will not check. A careful sponsor will hand over the support and discuss the downside. The concern is not the person with an answer. It is the presentation that treats a material assumption like asking about it would be rude.
Watch one tax line change jobs
Consider this hypothetical. The model uses $140,000 of property taxes. After sale, reassessed taxes may be closer to $190,000.
NOI hit:
$190,000 - $140,000 = $50,000
At a 6.0% cap rate, that $50,000 NOI miss affects value by:
$50,000 / 0.06 = $833,333
One $50,000 expense miss just became an $833,333 valuation problem. That is not because the cap-rate formula is dramatic. It is because every recurring dollar of NOI is capitalized into value.
Translate claims into inspections
| Sentence | Translation to test |
|---|---|
| ”We are using conservative rents” | Show the signed leases and concessions |
| ”Insurance is in line with market” | Show the current quote |
| ”Taxes are standard” | Show the reassessment math |
| ”Exit assumptions are reasonable” | Show the wider-cap case |
| ”Capex is fully budgeted” | Show scope, bids, and contingency |
Words can explain the evidence. They cannot substitute for it.
Listen for answers that change the subject from the number to the team’s experience, the market’s attractiveness, or the beauty of the broader thesis. The loose bolt does not become tight because the mechanic has a good résumé.
Rank what can hurt you fastest
Force the largest value drivers into one table:
| Assumption | Base case | Checked case | Value impact |
|---|---|---|---|
| Taxes | $140k | $190k | -$833k at 6.0% cap |
| Exit cap | 5.50% | 6.25% | Model sensitivity |
| Rent premium | $200/mo | $150/mo | NOI bridge |
Then ask:
- Which current document supports the base case?
- What would make the checked case wrong fastest?
- How does the change affect NOI, debt coverage, reserves, or exit value?
- Who owns the miss if the assumption fails?
Do not check every cell with equal energy. Inspection time belongs first to the assumptions with the most leverage.
Mark the settings
Take the five inputs with the largest value impact. Record the source, date, base case, checked case, and model effect for each. Keep that sheet beside the investment summary.
A torque stripe does not guarantee a fastener will hold. It tells you whether somebody checked—and whether the setting moved after they did.
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.