✅ Before You Begin: Build One Clean Base Case First
Before you create bull/base/bear cases, you need a clean base-case model with clear value drivers. Decide your primary valuation lens (DCF, earnings power, or a hybrid). Then gather the inputs you’ll flex: revenue growth, margins, reinvestment (capex + working capital), discount rate (WACC/cost of equity), and terminal value assumptions. Also, prepare your share count and dilution approach up front-scenario outputs get misleading fast if your fully diluted shares are inconsistent across cases.
Next, define what each scenario represents in plain language. A “bull case” should not be “everything goes right”; it should be “the specific upside thesis plays out.” A “bear case” should not be “the world ends”; it should be “the key downside risks materialise.” If you’re working with market multiples as a secondary check, decide which stock valuation ratios will serve as sanity checks (e.g., implied EV/EBITDA, implied P/E) so each case produces outputs you can interpret.
In Model Reef, scenario work is often cleaner because cases can be toggled and compared without duplicating spreadsheets-helpful when stakeholders want to see exactly which assumptions moved and why.
🛠️ Step-by-step implementation
Step 1: Build a Base Case That Is Coherent and Auditable
Start with a base case that you’d be comfortable defending on its own. That means: assumptions are explicit, formulas are stable, and the model ties out mechanically (cash flows reconcile, key schedules behave logically). Don’t overfit-use a small set of drivers that explain most of the value. A base case is not “management guidance copy/paste”; it’s your best unbiased view using consistent logic.
Anchor your method selection: if you’re using DCF, define the forecast horizon, the free cash flow definition, and the terminal value approach. If you’re using an earnings-based approach, define the earnings metric and the multiple logic. Your base case becomes the reference point for every scenario change, so clarity beats complexity.
If you need a simple starting map of intrinsic vs market approaches, align the base case to the broader stock valuation methods framework so the scenario story stays structured.
Step 2: Identify the 6-10 Drivers That Actually Move Value
A scenario framework works when it flexes the right levers. Identify the drivers that explain most of the valuation outcome: revenue growth rate, long-run margin level, reinvestment intensity (capex as % of revenue, working capital drag), discount rate, terminal value (growth or exit multiple), and dilution. For certain businesses, add one or two more that genuinely matter (churn, pricing, volume, commodity price, regulatory rate case).
Then define “base driver levels” and decide how each driver can plausibly move in bull and bear markets. Keep it realistic and evidence-based. For example, in high-growth names, the major swing is often growth fade and margin normalisation. In cyclicals, the major swing is mid-cycle earnings power vs peak/trough distortion.
This step transforms your stock valuation analysis from “three numbers” into an explainable driver narrative that stakeholders can challenge constructively.
Step 3: Quantify Bull and Bear Cases (No Hand-Waving)
Now convert narratives into numbers. For the bull case, flex the drivers that directly represent your upside thesis (e.g., faster growth for longer, operating leverage driving higher margins, lower reinvestment drag due to scale). For the bear case, flex the drivers that represent the downside thesis (e.g., pricing pressure reduces margin, growth slows sooner, working capital absorbs more cash, terminal value assumptions compress).
Avoid double-counting risk. If your bear case already assumes lower revenue growth, don’t also assume a dramatically higher discount rate unless you can justify that both fundamentals and risk premium change independently. Keep each scenario internally consistent-drivers should move together in a way that matches a real-world story.
Use a simple checkpoint: if someone reads only your assumptions, they should understand why each case differs. That’s how a scenario-based stock valuation model stays credible, not performative.
Step 4: Run Outputs and Compare the “Meaning” of Each Scenario
Run each case and capture a consistent output set: enterprise value, equity value, per-share value, and a small group of implied market checks (implied EV/EBITDA, implied P/E, implied EV/Revenue where relevant). This is where your stock valuation formula becomes a decision tool: the per-share output is what you compare to the market, while the implied multiples tell you if the scenario is internally reasonable.
If your bull case implies multiples that exceed anything plausible for the peer set, the scenario may be internally inconsistent-even if the DCF math “works.”Pair this with a quick comparable range so the intrinsic story is anchored to market regimes.
For stakeholder communication, focus on what changed and what it drove. In Model Reef, teams often present scenario deltas using consistent dashboards and scenario comparisons, which makes valuation conversations faster and less political.
Step 5: Add Probabilities and Decision Rules (So It’s Actionable)
A scenario range becomes decision-grade when you add probability thinking and rules. Assign probabilities (even rough ones) to bull/base/bear and compute an expected value. Then define “what would change my mind” triggers: which metrics must improve for bull to become more likely, and which warning signs make bear more likely. This turns valuation into an operating monitoring system rather than a one-off spreadsheet.
Also define refresh cadence: what events cause you to rerun the cases (earnings updates, guidance changes, macro shocks, major product launches). Keep dilution consistent across cases and updated when the equity plan or convertibles change, otherwise your per-share stock valuation signal becomes noisy.
Finally, document the story in a short memo format: base thesis, bull thesis, bear thesis, key drivers, and next checkpoints. This is how scenario valuation integrates cleanly into investment processes and makes your stock valuation analysis reusable over time.
🧩 Tips, Edge Cases & Gotchas
The biggest pitfall is making scenarios “too correlated” (everything up in bull, everything down in bear) without causal logic. Keep scenarios thesis-driven, not mood-driven. Another pitfall is hiding assumptions in the terminal value. If the terminal value drives most of your output, your scenario story may be thin. Make the terminal value explicit and keep it consistent with the company’s maturity and reinvestment needs.
Watch the discount rate lever. Changing WACC/cost of equity can be valid, but it’s easy to use as a shortcut for uncertainty. If your bear case already embeds worse fundamentals,you may not need an aggressive discount rate hike unless risk truly changes.
Finally, avoid treating a single-point output like a stock valuation calculator result. The point of bull/base/bear is to show what must be true-not to pretend the world can be summarised in one number. If you want a quick quality check, compare your scenario outputs to implied multiples and a comps range so the result stays grounded.
🧪 Example: A Simple Bull/Base/Bear Range With Probabilities
Assume your base-case intrinsic value is $100 per share. Your bull thesis is “growth persists 2 years longer and margins expand,” producing a bull value of $130. Your bear thesis is “growth fades sooner and margins compress,” producing a bear value of $70.
Now assign probabilities: Base 50%, Bull 25%, Bear 25%. Expected value = (100 × 0.50) + (130 × 0.25) + (70 × 0.25) = 50 + 32.5 + 17.5 = $100.
This creates a decision-ready stock valuation example: not only a range ($70–$130), but a structured view of what drives each outcome. If the stock trades at $85, your base case suggests upside, but your bear case clarifies what could go wrong-and what signals you’ll monitor.
🚀 Next Steps
You now have a scenario-driven stock valuation range that explains what must be true for upside and what breaks the thesis in downside. The next step is to anchor that intrinsic range to market reality using a quick comps range-so your stock valuation analysis covers both intrinsic and relative perspectives.
To keep the workflow scalable, treat scenarios as a governed asset: clear assumptions, consistent dilution, and version history. Many finance teams use Model Reef to maintain base/bull/bear toggles without duplicating spreadsheets, making it easier to review changes and keep valuation outputs aligned with the underlying model logic over time.
Back