A single-point DCF valuation is dangerous. It creates false precision and ignores the reality that every assumption is a range, not a fixed number. Scenario analysis solves this by modeling multiple outcomes—bear, base, and bull cases—so you can see how the valuation changes when your assumptions shift. This is the difference between a model that looks good on paper and a model that holds up under pressure.
The Three Scenarios
In the Institutional-Grade DCF Valuation Model, three scenarios are fully linked through the 10-year projection engine. The pre-loaded Microsoft example produces these outputs:
| Output | Bear Case | Base Case | Bull Case |
|---|---|---|---|
| Implied Share Price | $248 | $370 | $549 |
| Enterprise Value | $1,980B | $2,697B | $3,410B |
| Revenue Growth (Year 1) | 10% | 14% | 18% |
| Operating Margin | 40% | 44% | 48% |
| Terminal Growth Rate | 2.0% | 2.5% | 3.0% |
The spread from bear to bull is over 120%—which is exactly why presenting a single number without context is a red flag to any investment committee.
What Drives the Scenarios
Each scenario adjusts a consistent set of assumptions across the full 10-year projection:
Base Case (the anchor)
The base case represents your best estimate using current market data and management guidance. For Microsoft, this means mid-teens revenue growth, stable operating margins around 44%, and a disciplined terminal growth rate of 2.5%. This produces an implied share price of $369.74 and an Enterprise Value of $2,697B—every number sourced and documented inside the model. The WACC of 9.00% is held constant across all three scenarios so the output differences are driven by operating assumptions, not the discount rate.
Bear Case (the floor)
The bear case asks: what if growth slows, margins compress, and the market matures faster than expected? Revenue growth drops to 10%, operating margin contracts to 40%, and terminal growth falls to 2.0%. The implied share price of $248 represents approximately 33% downside from the base case—a material gap that any investor needs to understand before committing capital. In the model, the ±15% threshold flagging automatically highlights when assumptions deviate from the base case.
Bull Case (the ceiling)
The bull case tests the upside: stronger revenue growth (18%), margin expansion to 48%, and a terminal growth rate of 3.0%. The $549 implied share price represents roughly 48% upside from base. The bull case is not a target—it is a boundary condition that tells you how much optimism is already priced into your assumptions.
Why Scenario Analysis Matters for Investors
A single DCF output tells you what the model says. Scenario analysis tells you how much to trust it. If the bear-to-bull spread is narrow, your assumptions are clustered and the valuation is relatively stable. If the spread is wide, small changes in inputs produce large swings in outputs—and you should demand a higher margin of safety before investing.
For Microsoft specifically, the 2.2x spread between bear and bull reflects a mature company with predictable cash flows. A high-growth company might show a 5x+ spread, which is not a weakness of the model—it is an honest representation of the uncertainty.
The Institutional-Grade model automatically flags when any scenario deviates more than ±15% from base case, with an explainable gap analysis that traces the divergence to the specific input driver. This turns a sensitivity exercise into a defensible narrative for committees or client presentations.
Sensitivity Analysis: WACC vs Terminal Growth
Beyond the three scenarios, a rigorous DCF includes a two-dimensional sensitivity table that shows how implied share price changes as WACC and terminal growth rate move together. In the model, this grid is computed automatically—no manual formula copying required. You can see at a glance that the Microsoft output ranges from approximately $290 at a 10.0% WACC and 2.0% terminal growth to $480 at 8.0% WACC and 3.0% terminal growth. This is the kind of analysis that separates institutional-grade tooling from free templates.
How to Use Scenario Outputs in Investment Decisions
The current Microsoft share price trades somewhere within the bear-to-base range. A disciplined investor would ask: what assumptions would need to be true for the stock to reach the base case? And what would have to go wrong for it to hit the bear case? Scenario analysis does not tell you which outcome will occur. It tells you the range of plausible outcomes so you can size your position accordingly. That is the difference between speculation and valuation.
For a complete walkthrough of how the discount rate is built, see our WACC Calculator guide. For a foundational explanation of DCF methodology, start with What Is a DCF Valuation Model.