Scenario Analysis

What Is Scenario Analysis?

Every deal you underwrite sits on a stack of assumptions: what vacancy will run, how fast rents will grow, where interest rates land at refinance, what cap rate a buyer will pay when you sell. Change any one of those inputs and the return changes dramatically. Scenario analysis forces you to test those assumptions by running three versions of the same deal. The base case uses your most realistic projections. The best case assumes strong rent growth, low vacancy, and cap rate compression at exit. The worst case stress-tests the deal: higher vacancy, flat rents, rising rates, and cap rate expansion. The critical question isn't whether the best case looks amazing—it always does. The question is whether the worst case is survivable. If your worst-case scenario shows negative cash flow in Year 2 and a loss at exit in Year 5, the deal has too little margin. If the worst case still generates a 4% cash-on-cash return and breaks even at sale, the deal is resilient enough to pursue.

Scenario analysis is the practice of modeling multiple outcome paths—typically best-case, base-case, and worst-case—for a real estate investment by varying key assumptions like vacancy, rent growth, interest rates, and exit cap rates.

At a Glance

Three scenarios: Best case, base case, worst case
Key variables: Vacancy rate, rent growth, interest rate (at refinance), exit cap rate, renovation costs
Decision rule: Buy only if the worst case is survivable—not just if the base case looks good
Sensitivity ranking: Exit cap rate and vacancy rate typically have the largest impact on returns
Tools: Excel/Google Sheets, real estate financial modeling software (REFM, A.CRE)
Time investment: 1–2 additional hours per deal beyond base-case underwriting

How It Works

Building the three scenarios. Start with your base case—the outcome you believe is most likely given current market conditions. For a 24-unit apartment complex in Columbus, Ohio, your base case might assume: 7% vacancy, 3% annual rent growth, 7.0% interest rate at Year 5 refinance, and a 7.0% exit cap rate in Year 7. Now build the bookends.

Best case: 4% vacancy (market tightens), 5% annual rent growth (demand surge from new employers), 6.0% refinance rate (rates decline), 6.5% exit cap rate (cap compression from institutional buyer interest). Worst case: 12% vacancy (new supply floods the submarket), 0% rent growth (recession or overbuilding), 8.0% refinance rate (rates stay elevated or rise), 7.5% exit cap rate (buyer demand softens).

Running the numbers. Take a $2.4 million purchase with $600,000 equity and $1.8 million debt at 7.25%. Current NOI: $180,000 (7.5% cap rate). Annual debt service: $147,240.

Base case Year 5: NOI grows to $208,000 with 3% rent growth and 7% vacancy. Cash flow: $60,760/year. Exit at 7.0% cap: $2.97 million. Net equity after loan payoff: $1.26 million. IRR: 16.2%.

Best case Year 5: NOI reaches $235,000 with 5% rent growth and 4% vacancy. Cash flow: $87,760/year. Exit at 6.5% cap: $3.62 million. Net equity: $1.91 million. IRR: 23.8%.

Worst case Year 5: NOI stalls at $162,000 with 0% rent growth and 12% vacancy. Cash flow: $14,760/year—thin but positive. Exit at 7.5% cap: $2.16 million. Net equity: $450,000. IRR: 5.1%.

Interpreting results. The base case IRR of 16.2% is attractive. The worst case IRR of 5.1% is low but positive—you don't lose money. The property still cash-flows in the worst case, meaning you can hold through a downturn without reaching into your pocket. This deal passes the scenario analysis test. If the worst case showed negative cash flow or a loss at exit, you'd either negotiate a lower purchase price or walk.

Which variables matter most. Run a sensitivity analysis by changing one variable at a time. Typically, exit cap rate has the single largest impact on total return—a 50-basis-point swing changes equity by $200,000–$400,000 on a $2.5 million property. Vacancy rate hits cash flow hardest during the hold period. Rent growth compounds over time and matters more on longer holds (7–10 years) than short ones (3–5 years). Interest rate at refinance matters most for floating-rate debt or value-add deals planning a refi.

Real-World Example

Nadia in Phoenix. In early 2024, Nadia was underwriting a 40-unit apartment complex listed at $4.8 million in Tempe, near Arizona State University. In-place NOI was $336,000 (7.0% cap rate). She planned to invest $400,000 in unit renovations over 18 months to push rents from $1,050 to $1,300/month.

Base case: Post-renovation NOI of $432,000, 6% vacancy, 3% annual rent growth. Year 5 exit at 6.5% cap rate: $7.6 million. IRR: 24.1%.

Best case: Rents reach $1,400 (ASU enrollment surge, limited new supply), 4% vacancy. Year 5 exit at 6.0% cap: $9.2 million. IRR: 32.6%.

Worst case: Renovations run 25% over budget ($500,000 total). Only 28 of 40 units accept renovated rent levels—12 units stay at $1,050. Vacancy spikes to 10% during the renovation period. Post-stabilization NOI: $372,000. Year 5 exit at 7.0% cap: $5.31 million. IRR: 11.4%.

The worst case still delivered double-digit returns because Nadia bought at a low basis ($4.8 million) in a market with structural demand (50,000+ ASU students). She stress-tested a fourth scenario—"disaster case"—where rents fell 5% market-wide, vacancy hit 15%, and exit cap rates blew out to 7.5%. IRR: 3.8%. She'd still get her capital back. No scenario showed a loss.

Nadia made the offer. During due diligence, she discovered the HVAC systems needed replacement ($160,000), which she hadn't modeled. She re-ran all four scenarios with the added cost. Worst case IRR dropped to 8.2%, disaster case to 1.1%. Still positive. She negotiated a $120,000 price reduction and closed at $4.68 million.

Pros & Cons

Advantages

Forces you to confront downside risk before committing capital, not after
Identifies which assumptions carry the most risk—so you can mitigate or hedge them
Provides a framework for comparing deals: the one with the best worst case often beats the one with the best best case
Builds credibility with partners and lenders who want to see you've stress-tested the deal
Creates decision rules ("I only buy deals where the worst case still cash-flows") that prevent emotional buying

Drawbacks

Garbage assumptions produce garbage scenarios—the analysis is only as good as your inputs
Can lead to analysis paralysis if you model too many variables and never reach a decision
Worst-case scenarios are always worse than your worst case—true black swans aren't modelable
Takes additional time (1–2 hours per deal) that feels wasteful when you're analyzing 10 deals a week
Beginners tend to make all three scenarios look good, defeating the purpose of stress testing

Watch Out

Make the worst case actually bad. If your "worst case" still shows a 12% IRR, you haven't stress-tested the deal—you've modeled three versions of optimism. A real worst case includes: rent declines (not just flat growth), vacancy 50–100% above market norms, renovation cost overruns of 20–30%, and a refinance rate 200 basis points above today's rate.
Don't average the three scenarios. The purpose isn't to blend outcomes into an "expected return." The purpose is to test whether you can survive the worst case. If the worst case bankrupts you, it doesn't matter that the best case is spectacular—one bad outcome and you lose everything.
Exit cap rate is not the same as entry cap rate. Many investors assume they'll sell at the same cap rate they bought. In a rising-rate environment, exit cap rates expand. Model your exit cap rate 50–100 basis points above your entry cap rate as a baseline, then stress-test at 150 basis points above.
Model the refinance explicitly. If you're buying with a 5-year ARM or bridge loan, your Year 5 refinance is not optional—it's a hard deadline. Stress-test the refinance at current rates + 150 basis points. If the property doesn't qualify for a new loan at that rate (because the DSCR or debt yield fails), you'll face a maturity default regardless of cash flow.

Ask an Investor

The Takeaway

Scenario analysis is the difference between hoping a deal works and knowing it survives adversity. Run three scenarios on every deal—best, base, and worst—and make your buy/no-buy decision based on the worst case, not the base case. If the worst case still generates positive cash flow and returns your capital at exit, the deal has enough margin to absorb the inevitable surprises. If the worst case shows negative cash flow or a loss, either negotiate a lower price or walk. The 1–2 extra hours of modeling can save you from the one deal that wipes out years of gains.