Definition
Scenario analysis is an underwriting method that evaluates an investment under multiple coherent sets of assumptions (scenarios) to compare outcomes and understand the deal’s key risk drivers. Instead of changing one variable at a time, scenario analysis changes a bundle of related assumptions that tend to move together in the real world.
Why It Matters
Real estate is exposed to both operational risk (leasing, collections, expenses) and market risk (interest rates, cap rates, liquidity). Scenario analysis helps you:
- Compare outcomes across base, downside, and upside environments.
- Identify fragile assumptions that break the deal when stressed.
- Separate execution risk from macro/market risk.
- Make decisions anchored to durability, not optimism.
Common Scenarios
- Base Case: the most likely plan based on current facts and reasonable execution.
- Downside Case: adverse conditions (weaker demand, higher costs, slower improvements).
- Upside Case: favorable conditions (strong leasing, better rent premiums, smoother ops).
What Typically Changes by Scenario
Scenario analysis usually adjusts the assumptions that drive cash flow, timing, and exit value:
- Rent growth and effective rent: renewal increases, concessions, unit premium capture.
- Occupancy and turnover: leasing velocity, downtime, move-outs, resident retention.
- Collections: delinquency and bad debt.
- Expenses: taxes, insurance, utilities, payroll, R&M, and contract costs.
- Capex and timing: renovation pace, costs, scope creep, permitting delays.
- Financing: interest rate path, refinance proceeds, extension costs, covenant pressure.
- Exit assumptions: exit cap rate, buyer demand, disposition costs, time on market.
Scenario Analysis vs. Sensitivity Analysis
- Sensitivity analysis changes one variable at a time (e.g., vacancy +2%).
- Scenario analysis changes multiple variables together in a realistic story (e.g., vacancy up, concessions up, bad debt up, exit cap rate up).
Both are useful: sensitivity finds the “levers,†while scenario analysis shows how the deal performs in plausible worlds.
Example (Conceptual)
A value-add multifamily deal might be evaluated with three scenarios:
- Base case: moderate rent premiums, steady occupancy, normal expense growth, stable exit.
- Downside case: slower renovations, higher concessions, more bad debt, insurance/taxes higher, exit cap rate wider.
- Upside case: faster lease-up, stronger premiums, lower bad debt, tighter expense control, better exit liquidity.
The investor then compares metrics like DSCR, cash-on-cash, IRR, equity multiple, and minimum cash balance across all scenarios.
How Investors Use Scenario Analysis
- Go / no-go decisions: ensure downside outcomes are survivable.
- Leverage sizing: pick debt that still works when NOI drops or rates rise.
- Reserve planning: set operating and capex reserves based on downside timing risk.
- Business plan focus: identify the few assumptions that matter most and build operating systems around them.
- Pricing discipline: avoid paying a price that requires the upside scenario to occur.
Common Pitfalls
- “Perfect stacking†in the upside case: every variable improves simultaneously.
- Downside that isn’t real: mild stresses that don’t resemble actual bad periods.
- Ignoring timing: delays in renovations or lease-up can be more damaging than small rent changes.
- Exit-only focus: many deals fail from cash flow and debt constraints before exit assumptions matter.