--- # === IDENTITY === id: finance/modeling/scenario-analysis-framework/2026 canonical_question: "How do I build financial scenario analysis (base, bull, bear cases)?" aliases: - "scenario analysis" - "base bull bear case analysis" - "financial scenario modeling" - "what-if scenario analysis" entity_type: concept domain: finance > modeling > Scenario Analysis Framework region: global jurisdiction: global temporal_scope: 1960-2026 # === VERIFICATION === last_verified: 2026-02-28 confidence: 0.92 version: 1.0 first_published: 2026-02-28 # === TEMPORAL VALIDITY === temporal_validity: status: stable last_breaking_change: null next_review: 2026-08-27 change_sensitivity: low # === CONSTRAINTS === constraints: - "Scenarios must be internally consistent — a bear case cannot combine pessimistic revenue with optimistic cost assumptions" - "Three scenarios (base/bull/bear) are the minimum; they may miss compound risks that require more granular scenario trees" - "Probability weighting is subjective — assigning 60%/25%/15% probabilities creates false precision unless backed by historical frequency data" - "Scenarios test discrete states, not continuous variable ranges — use sensitivity analysis for input-by-input range testing" - "Prerequisite: must have a working base-case financial model before layering scenarios on top" skip_this_unit_if: - condition: "User needs to test how individual variables affect output one at a time" use_instead: "finance/modeling/sensitivity-analysis/2026" - condition: "User needs probability distributions across thousands of random trials" use_instead: "finance/modeling/monte-carlo-simulation/2026" - condition: "User needs to build the base financial model first" use_instead: "finance/modeling/startup-financial-model/2026" inputs_needed: - key: "scenario_purpose" question: "What is the user's scenario analysis goal?" type: choice options: - "Board presentation with upside/downside cases" - "Investment memo with probability-weighted valuation" - "Strategic planning with multiple market states" - "Stress-testing a model for fundraising or lending" # === DISTRIBUTION === canonical_source: "https://knowledgelib.io/finance/modeling/scenario-analysis-framework/2026" suggested_citation: "Source: knowledgelib.io — AI Knowledge Library (verified 2026-02-28)" # === RELATED UNITS === related_kos: related_to: - id: "finance/modeling/sensitivity-analysis/2026" label: "Sensitivity Analysis" - id: "finance/modeling/monte-carlo-simulation/2026" label: "Monte Carlo Simulation" - id: "finance/modeling/startup-financial-model/2026" label: "Startup Financial Model" often_confused_with: - id: "finance/modeling/sensitivity-analysis/2026" label: "Sensitivity Analysis (tests variables individually, not whole scenarios)" - id: "finance/modeling/monte-carlo-simulation/2026" label: "Monte Carlo Simulation (probabilistic, not discrete scenarios)" depends_on: [] solves: [] alternative_to: [] # === SOURCES === sources: - id: src1 title: "Scenario Analysis" author: Corporate Finance Institute url: https://corporatefinanceinstitute.com/resources/financial-modeling/scenario-analysis/ type: technical_blog published: 2025-01-01 reliability: high - id: src2 title: "Financial Modeling Techniques: Selecting Operating and Financing Scenarios" author: Wall Street Prep url: https://www.wallstreetprep.com/knowledge/financial-modeling-techniques-selecting-operating-and-financing-scenarios/ type: technical_blog published: 2025-01-01 reliability: high - id: src3 title: "Scenario Analysis of Financial Models" author: Magnimetrics url: https://magnimetrics.com/scenario-analysis-financial-models/ type: technical_blog published: 2024-01-01 reliability: moderate_high - id: src4 title: "The Ultimate Guide to Scenario Analysis" author: Ventura Securities url: https://www.venturasecurities.com/share-market-guide/all-about-share-stock-market/fundamental-analysis/scenario-analysis-best-case-base-case-worst-case-explained/ type: technical_blog published: 2025-01-01 reliability: moderate_high --- # Scenario Analysis Framework ## Definition Scenario analysis is a structured method for evaluating how different sets of assumptions — representing distinct future states of the world — affect a financial model's outputs. Unlike sensitivity analysis (which varies one input at a time), scenario analysis changes multiple correlated assumptions simultaneously to model coherent alternative futures, typically organized as base case (most likely), bull case (optimistic), and bear case (pessimistic). [src1] ## Key Properties - **Standard structure**: Three scenarios — base (50-60% probability), bull (20-30%), bear (15-25%) — though more complex models use 5+ scenarios [src1] - **Implementation**: Scenario manager/toggle cell that changes all assumptions simultaneously via INDEX/MATCH, OFFSET, or CHOOSE functions [src2] - **Scope of variation**: Revenue growth, margins, customer metrics, pricing, market conditions, and macro assumptions all change together within each scenario [src3] - **Output**: Scenario-specific financial statements plus probability-weighted expected values for valuation or decision-making [src1] - **Internal consistency requirement**: Each scenario must represent a plausible, self-consistent world state, not a random mix of optimistic and pessimistic inputs [src2] ## Constraints - **Internal consistency is mandatory**: A bear case with pessimistic revenue but optimistic headcount costs is not a scenario — it is a modeling error. Each scenario must tell a coherent story. [src2] - **Three scenarios may be insufficient**: For complex businesses, three scenarios miss compound risks (e.g., "slow growth AND rising costs AND regulatory change"). Consider scenario trees for multi-dimensional uncertainty. [src3] - **Probability weights are subjective**: Assigning precise probabilities (e.g., 60%/25%/15%) to scenarios creates a veneer of precision. Document the reasoning behind weights and present them as estimates, not facts. [src1] - **Scenarios are discrete, not continuous**: Scenario analysis tests specific states, not the full range of outcomes. Use sensitivity analysis or Monte Carlo simulation for continuous variable testing. [src4] - **Requires a working base model**: Scenario analysis is a layer on top of an existing financial model, not a standalone framework. Build the base model first. [src2] ## Framework Selection Decision Tree ``` START — User needs to test financial model under different conditions ├── What kind of uncertainty? │ ├── Multiple correlated assumptions changing together │ │ └── ✅ Scenario Analysis (this unit) │ ├── Individual variables one at a time │ │ └── → Sensitivity Analysis │ ├── Probability distributions across many random trials │ │ └── → Monte Carlo Simulation │ └── Binary risk events (happens or doesn't) │ └── → Stress Testing (scenario variant) ├── How many scenarios needed? │ ├── 2-5 discrete states → Standard scenario analysis │ ├── 10+ scenarios with probability weighting → Scenario tree │ └── Continuous distribution → Monte Carlo Simulation └── Does a base financial model exist? ├── YES → Layer scenarios on top └── NO → Build Startup Financial Model or Three-Statement Model first ``` ## Application Checklist ### Step 1: Define scenario narratives - **Inputs needed**: Key uncertainties facing the business (market growth, competitive dynamics, regulatory environment, macro conditions) - **Output**: 3-5 named scenarios, each with a 1-2 sentence narrative describing the world state (e.g., "Bear: recession, 2x churn, 50% slower growth, customer downgrades") - **Constraint**: Each narrative must be internally consistent — all assumptions must follow logically from the same world state [src2] ### Step 2: Map assumptions to each scenario - **Inputs needed**: Base case assumptions, narrative-driven adjustments for each scenario - **Output**: Assumption matrix (rows = variables, columns = scenarios) with specific values for revenue growth, margins, churn, headcount, capex, etc. - **Constraint**: Do not change only revenue — costs, churn, and capital needs must also shift consistently with the scenario narrative [src1] ### Step 3: Build the scenario toggle mechanism - **Inputs needed**: Assumption matrix, base financial model - **Output**: A single toggle cell (dropdown or number) that switches all assumptions simultaneously using INDEX, OFFSET, or CHOOSE - **Constraint**: The toggle must change every linked assumption — partial switches (changing revenue but not costs) break internal consistency [src2] ### Step 4: Generate outputs and probability-weighted values - **Inputs needed**: Scenario-specific financial statements, probability weights - **Output**: Summary table showing key metrics (revenue, EBITDA, cash balance, runway) per scenario plus probability-weighted expected value - **Constraint**: If probability-weighted output differs from base case by more than 20%, the implied skew must be addressed in presentation — it signals asymmetric risk [src1] ## Anti-Patterns ### Wrong: Bear case is "base case minus 10%" Analysts mechanically reduce base case revenue by 10% and call it a bear case, without adjusting costs, churn, or customer behavior — producing an unrealistically mild downside. [src1] ### Correct: Bear case tells a coherent downside story Start with a narrative ("recession causes 2x churn, 50% slower new sales, customers demand discounts") and derive all assumptions from that story. Costs may rise (layoff costs) while revenue falls. [src2] ### Wrong: Only varying revenue across scenarios Changing only the top line while holding all other assumptions constant is sensitivity analysis on one variable, not scenario analysis. It misses the correlated effects that define real scenarios. [src3] ### Correct: Varying all correlated assumptions together In a recession scenario, adjust revenue AND churn AND sales cycle length AND payment terms AND hiring plan simultaneously. These variables are correlated in practice. [src2] ### Wrong: Presenting probability-weighted values as predictions Analysts calculate a probability-weighted average valuation and present it as "the expected value," obscuring the wide range of outcomes and the subjectivity of the weights. [src4] ### Correct: Presenting the range alongside the weighted average Show the full range (bear to bull) with the probability-weighted average as one reference point. Emphasize the range and key assumptions, not the single number. [src1] ## Common Misconceptions - **Misconception**: Scenario analysis and sensitivity analysis are the same thing. **Reality**: Sensitivity analysis varies one input at a time to measure its isolated impact on output. Scenario analysis changes multiple correlated inputs simultaneously to model coherent alternative futures. They are complementary, not interchangeable. [src1] - **Misconception**: Three scenarios are always sufficient. **Reality**: Three scenarios work for simple models, but complex businesses with multiple independent uncertainties may need scenario trees or Monte Carlo simulation to capture compound risks. A startup facing both market risk and regulatory risk may need 3x3 = 9 scenarios. [src3] - **Misconception**: The base case is the "most likely" outcome. **Reality**: The base case should represent the central expectation, but most likely is a misleading label — any single scenario has a low probability of occurring exactly as modeled. The base case is a reference point for comparison, not a prediction. [src2] ## Comparison with Similar Concepts | Concept | Key Difference | When to Use | |---|---|---| | Scenario Analysis | Changes multiple correlated assumptions together | Modeling coherent alternative futures (recession, expansion, etc.) | | Sensitivity Analysis | Varies one input at a time | Identifying which single inputs drive the most output variance | | Monte Carlo Simulation | Runs thousands of randomized trials | Generating probability distributions of outcomes | ## When This Matters Fetch this when a user asks about building financial scenarios, creating base/bull/bear cases, presenting scenario-based projections to investors or boards, or structuring a scenario manager in a financial model. Also relevant when someone needs to stress-test a model or calculate probability-weighted expected values. ## Related Units - [Sensitivity Analysis](/finance/modeling/sensitivity-analysis/2026) - [Monte Carlo Simulation](/finance/modeling/monte-carlo-simulation/2026) - [Startup Financial Model](/finance/modeling/startup-financial-model/2026)