Definition
Sensitivity analysis is an underwriting tool that shows how investment outcomes change when one or more assumptions move up or down. Instead of relying on a single “base case,†sensitivity analysis helps investors understand what really drives returns and how much margin of safety exists if the market or operations don’t cooperate.
What It Tests
Most real estate models are highly sensitive to a small set of variables. Common sensitivity inputs include:
- Exit cap rate: the valuation multiple at sale (often the biggest driver of IRR).
- Rent growth: market rent increases and the pace of mark-to-market.
- Occupancy / economic vacancy: lease-up speed, bad debt, concessions, and churn.
- Expense growth: payroll, repairs, insurance, utilities, taxes.
- Interest rates / debt terms: floating rate exposure, rate caps, amortization, DSCR constraints.
- Capex timing and cost: renovation overruns, delays, and unit turn cadence.
- Hold period: shorter or longer exits can change IRR dramatically.
Why It Matters
Real estate underwriting is built on assumptions. Sensitivity analysis forces clarity about which assumptions are fragile and which ones are resilient. It can reveal when a deal “works†only in a narrow band of outcomes—often a sign the price is too high, the leverage is too aggressive, or the business plan is too optimistic.
Common Outputs
- IRR sensitivity: how internal rate of return changes across scenarios.
- Equity multiple sensitivity: total cash returned per dollar invested.
- Cash-on-cash sensitivity: ongoing yield during the hold.
- DSCR / debt yield sensitivity: ability to service debt and refinance.
- Breakeven analysis: the minimum occupancy or NOI needed to cover expenses and debt service.
How It’s Built
Sensitivity analysis is often displayed as a table (one-variable or two-variable) where each cell shows the resulting return metric.
Typical formats
- One-variable: change one assumption (e.g., exit cap rate) while holding others constant.
- Two-variable: change two assumptions at once (e.g., exit cap rate and rent growth) to see a grid of outcomes.
- Scenario set: “downside / base / upside†with a coherent bundle of linked assumptions.
Example
A value-add multifamily deal underwrites a 5-year hold. You run a two-variable sensitivity on exit cap rate and rent growth:
- Exit cap rate: 5.00%, 5.25%, 5.50%
- Annual rent growth: 1.0%, 2.0%, 3.0%
If IRR drops below your required return whenever the exit cap expands to 5.50% unless rent growth stays at 3.0%, the deal may be over-reliant on a favorable market. That’s a signal to renegotiate price, reduce leverage, increase reserves, or pass.
Investor Uses
- Price discipline: identify what you can pay while still meeting return floors in downside cases.
- Risk budgeting: decide where to add reserves, rate caps, or contingency.
- Strategy selection: compare two deals by how wide their “works†range is, not just base-case IRR.
- Capital structure: test how leverage changes downside protection and refinance risk.
- Business plan clarity: see whether operations or the market is doing most of the return work.
Common Pitfalls
- Changing too many inputs at once: makes it hard to see what actually drives outcomes.
- Unrealistic ranges: sensitivities should reflect plausible downside and upside, not wishful thinking.
- Ignoring linked variables: vacancy, concessions, and rent growth often move together in real markets.
- Focusing only on IRR: include cash flow stability, DSCR, and refinance risk.
- False precision: a sensitivity table is only as good as the model’s structure and assumptions.