Library / Underwriting & Deal Analysis Wing 03 · Lesson 34 · ~3 min

The numbers sponsors hope you won't check

The dangerous inputs look ordinary. Check the few numbers that can quietly move NOI, debt survival, or exit value.

Check the assumption → Wing index →
Read with a pencil

Circle the assumption doing the most work. That is usually where the deal is asking for trust.

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

NumberWhy it may get a quick explanationWhat to open
Rent premiumMakes value-add look easyRent comps and signed renovated leases
Exit capCreates sale valueSales comps and sensitivity table
Tax reassessmentCan crush NOITax bill and local reassessment method
InsuranceOften rising faster than models admitCurrent quote and coverage detail
Bad debtMakes revenue look cleanAged receivables and write-offs
Renovation budgetControls value-add executionContractor bids and contingency
Debt maturityControls timeTerm sheet and extension tests
ReservesControls survivalReserve 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

SentenceTranslation 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:

AssumptionBase caseChecked caseValue impact
Taxes$140k$190k-$833k at 6.0% cap
Exit cap5.50%6.25%Model sensitivity
Rent premium$200/mo$150/moNOI 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.

Math notes PRSE / GUIDE

Get better at finding the assumption doing too much work.

New underwriting checks, model notes, and the free guide when they are useful.

Educational only. Not an offer to invest. Email is optional for updates; public resources stay public.