Key Takeaways
- Scenarios are coherent narratives with correlated assumption changes—not just single-variable stress tests.
- The decision framework: Conservative must meet minimums, Stress must preserve capital, Base must justify effort.
- Probability-weighted returns force explicit risk assessment and enable comparison across different risk profiles.
- Four scenarios (Stress, Conservative, Base, Optimistic) provide the most complete risk picture for acquisition decisions.
While sensitivity analysis varies one or two inputs mechanically, scenario analysis constructs complete, internally consistent narratives about how the future might unfold. Each scenario represents a coherent story—not just a change in one variable but a set of correlated assumption changes that would occur together. This lesson teaches you to build, compare, and use scenarios for decision-making.
Constructing Coherent Scenarios
A well-constructed scenario changes multiple correlated assumptions simultaneously to tell a consistent story. A "Recession" scenario does not just increase vacancy—it also reduces rent growth (or models rent declines), slows absorption for new leases, increases bad debt, extends time to sell at exit, and may expand exit cap rates. A "Strong Market" scenario increases rent growth AND reduces vacancy AND compresses exit cap rates—these moves are correlated in reality and should be correlated in your model. The standard three-scenario framework includes Conservative (pessimistic but plausible), Base (most likely outcome), and Optimistic (favorable but achievable). Some professionals add a fourth "Stress" scenario representing a severe but possible outcome.
| Assumption | Stress | Conservative | Base | Optimistic |
|---|---|---|---|---|
| Rent Growth | -3% | 0% | 2.5% | 4% |
| Vacancy Rate | 12% | 8% | 5% | 3% |
| Expense Growth | 5% | 4% | 3% | 2% |
| Exit Cap Rate | 8.50% | 7.75% | 7.25% | 6.75% |
| Hold Period | 7 years | 6 years | 5 years | 4 years |
Four-scenario assumption matrix for a multifamily acquisition
Why it matters: Understanding this concept is essential for making informed investment decisions.
Comparing Scenario Outcomes
Present scenario outcomes side-by-side with the same metrics for each: Year 1 Cash-on-Cash, average annual DSCR, IRR, equity multiple, and maximum cash deficit (if any). The decision framework is: (1) Does the Conservative scenario meet minimum return thresholds? If not, the deal is too risky. (2) Does the Stress scenario result in a loss of capital? If so, the downside risk is unacceptable. (3) Is the Base case return attractive relative to the risk revealed by the Conservative and Stress scenarios? (4) Does the Optimistic scenario justify the effort and complexity of the deal? If the Conservative case meets minimums and the Stress case preserves capital, the deal has adequate margin of safety.
Why it matters: Understanding this concept is essential for making informed investment decisions.
Probability-Weighted Returns
An advanced technique assigns probability weights to each scenario and calculates a probability-weighted expected return. For example: Stress (5% probability, 2% IRR), Conservative (25% probability, 10% IRR), Base (45% probability, 18% IRR), Optimistic (25% probability, 24% IRR). Expected IRR = 0.05(2%) + 0.25(10%) + 0.45(18%) + 0.25(24%) = 0.1% + 2.5% + 8.1% + 6.0% = 16.7%. While the probability assignments are subjective, this technique forces explicit thinking about the likelihood of different outcomes and produces a single expected return figure that incorporates risk. It is particularly useful when comparing multiple investment opportunities with different risk profiles.
Why it matters: E[IRR] = P(Stress) x IRR(Stress) + P(Conservative) x IRR(Conservative) + P(Base) x IRR(Base) + P(Optimistic) x IRR(Optimistic) Example: E[IRR] = 0.05(2%) + 0.25(10%) + 0.45(18%) + 0.25(24%) = 16.7%
Key Takeaways
- ✓Scenarios are coherent narratives with correlated assumption changes—not just single-variable stress tests.
- ✓The decision framework: Conservative must meet minimums, Stress must preserve capital, Base must justify effort.
- ✓Probability-weighted returns force explicit risk assessment and enable comparison across different risk profiles.
- ✓Four scenarios (Stress, Conservative, Base, Optimistic) provide the most complete risk picture for acquisition decisions.
Sources
Common Mistakes to Avoid
Creating scenarios that are too similar to each other (e.g., 2%, 2.5%, 3% rent growth)
Consequence: Narrowly spaced scenarios fail to capture meaningful differences in outcomes and provide false comfort
Correction: Ensure scenarios represent distinctly different market conditions with materially different assumptions across multiple variables
Assigning unrealistic probability weights to favor the optimistic scenario
Consequence: Biased probability weighting inflates expected returns and understates risk
Correction: Use equal or pessimistically-skewed probability weights unless specific market evidence supports higher optimistic probability
Test Your Knowledge
1.What is the difference between scenario analysis and sensitivity analysis?
2.How are probability weights used in scenario comparison?
3.What defines a "pessimistic" scenario in real estate modeling?