Syndication
Sensitivity Analysis: How Sponsors Stress-Test a Deal Before Investors Do
A sensitivity analysis takes the single set of assumptions in a pro forma and asks the only question that matters: what happens when they're wrong? Flex the exit cap rate, rent growth, construction costs, and interest rate one at a time — and in combination — and the model stops being a prediction and becomes a map of the deal's risk. Every institutional underwriting includes one; many first-time sponsor decks don't, and experienced LPs notice.
By One Million Media4 min read
This guide is for sponsors and GPs who want to stress-test a deal the way a credit committee would — which variables to flex, how far, how to read the output, and why showing investors the downside is one of the strongest fundraising moves available.
What a sensitivity analysis is
The base-case pro forma is one scenario dressed up as the future. A sensitivity analysis surrounds it: change one input, hold the rest, and record how the outputs — IRR, equity multiple, cash-on-cash, DSCR — respond. The point isn't to predict which scenario happens; it's to learn which assumptions the deal can survive being wrong about, and which ones it can't.
The one-line definition
Sensitivity analysis = systematically flexing the model's key assumptions to see how returns and debt covenants respond. It converts 'trust my projections' into 'here is exactly how wrong my projections can be before you lose money.'
The output distinguishes fragile deals from robust ones. Two deals can show the same 17% base-case IRR while one still returns capital with the exit cap 100 bps wide and rents flat, and the other goes to zero on either miss alone. No single-number metric reveals that difference; sensitivity tables exist to.
The variables worth stressing (and how far)
| Variable | Typical stress range | What it exposes |
|---|---|---|
| Exit cap rate | +25 / +50 / +100 bps | Dependence on the market at sale — the #1 driver |
| Rent growth | Base minus 1–2%/yr, and flat | Whether returns come from the plan or the trend |
| Vacancy / economic loss | +200–500 bps | Margin of safety in the income line |
| Renovation or construction cost | +10% / +20% | Budget realism and contingency adequacy |
| Interest rate at refi/exit | +100–200 bps | Refinance risk and floating-rate exposure |
| Lease-up pace | 3–6 months slower | Carry cost and covenant pressure on transitional deals |
| Hold period | ±1–2 years | Whether the IRR is real or just early-exit arithmetic |
Two disciplines make the exercise honest. First, stress the outputs that break deals, not just the ones that dent returns — track DSCR and loan covenants under each scenario, because a deal that still shows a 9% IRR but trips its debt covenant in year two is a deal that dies in year two. Second, run combined downside cases: bad things correlate. The scenario where the exit cap widens is often the same scenario where rent growth stalls and the refi rate is higher.
Building the tables: a working method
- Build the model so every key assumption is a single driver cell — sensitivity analysis is impossible in a spreadsheet where rent growth is hard-coded in twelve places.
- Produce the classic two-way grid first: exit cap rate across the top, rent growth down the side, IRR (or equity multiple) in the cells. This one table answers most investor questions.
- Add a covenant table: DSCR and, if relevant, debt yield under each scenario — flag every cell that breaches the loan terms.
- Define three named cases — base, downside, severe — with every changed assumption listed. Vague 'conservative case' labels without stated inputs are marketing, not analysis.
- Find the break-evens: the exact exit cap, vacancy, and cost overrun at which the deal returns exactly 1.0x. Knowing your cliff edge is the entire point.
- Re-run after every material model change — a sensitivity table computed on last month's budget is a stale screenshot, not a control.
A note on what sensitivity analysis is not: flexing assumptions until the downside still looks good, then presenting that as stress-testing. If your 'severe case' still shows a 14% IRR, you haven't stressed the model — you've stress-tested the audience.
The sensitivity table as a fundraising asset
Counterintuitively, the downside case is one of the best-performing pages in a pitch deck. Sophisticated LPs don't expect deals without risk; they screen for sponsors who understand their own risk. A sponsor who volunteers 'at a 6% exit cap and flat rents, you get your capital back plus a small return; here's why we still like the deal' has answered the question every investor was going to ask anyway — and signaled they'll be equally straight when things go sideways post-closing.
- Put the two-way IRR grid and the named downside case in the deck; put the full scenario set in the data room.
- State the break-even exit cap explicitly — it's the single most credibility-building number a sponsor can publish.
- In the PPM, sensitivity scenarios support the risk-factor disclosures: projections are forward-looking statements, and showing a reasonable range is both better disclosure and better marketing than a single rosy line.
Frequently asked questions
What is a sensitivity analysis in real estate?
It's the practice of systematically changing a deal's key assumptions — exit cap rate, rent growth, vacancy, costs, interest rates — and recording how returns and debt coverage respond. Instead of one projected outcome, it shows the range of outcomes and identifies which assumptions the deal cannot survive being wrong about.
Which variables matter most in a real estate sensitivity analysis?
The exit cap rate is almost always the dominant driver, followed by rent growth, vacancy/economic loss, construction or renovation costs, and the interest rate at refinance. The classic presentation is a two-way grid of exit cap versus rent growth with IRR in each cell.
What's the difference between sensitivity analysis and scenario analysis?
Sensitivity analysis flexes one variable at a time to isolate its impact; scenario analysis changes several together to model coherent futures (a recession case, a delayed lease-up case). Good underwriting uses both — one-way tables to find the drivers, combined scenarios because real downsides arrive together.
What is a break-even exit cap rate?
The exit cap rate at which the deal returns exactly investors' capital (a 1.0x equity multiple). It marks the cliff edge of the deal: if market cap rates at sale stay inside it, investors are whole. Publishing it is a strong credibility signal because it quantifies the margin of safety in one number.
Should sponsors show sensitivity tables to investors?
Yes. Experienced LPs expect them, and a visible downside case answers the risk question before it's asked. It also supports honest forward-looking-statement disclosure in the offering documents — a single-point projection with no range is weaker both as marketing and as compliance.
Keep reading
This article is for educational purposes only and is not legal, investment, tax, or securities advice. Securities offerings are regulated; always work with your securities attorney to structure and run your offering. One Million Media is a marketing and lead-generation provider — not a broker-dealer, investment adviser, or law firm.
