Scenario Analysis Framework for Strategic Planning
Build multi-scenario financial models with sensitivity analysis for board-ready strategic plans
What You Can Do
You construct economically coherent scenario models (base, bull, bear) that translate strategic decisions into quantified financial outcomes under different market conditions. The framework guides you through assumption documentation, waterfall analysis, and sensitivity testing to reveal which variables drive material variance—enabling you to stress-test M&A integration, market expansion, product launches, and cost restructuring programs with documented rigor.
Features
Define and model base, bull, and bear cases with economically coherent macro-to-micro variable linkages
Document interdependent operational assumptions (pricing, volume, cost, margin) that drive P&L outcomes across scenarios
Isolate and quantify impact of individual strategic initiatives or market variables on EBIT, cash flow, or shareholder value
Identify key value drivers through one-way and two-way sensitivity analysis showing which assumptions create material outcome variance
Structure outputs as board-ready decks with scenario summaries, downside quantification, and confidence narratives
Model downside tail risks and capital requirements under stressed scenarios for financial resilience testing
Build 3-5 year financial projections with scenario-specific growth, margin, and capital assumptions
Example Output
Scenario Comparison Table:
| Metric | Bear Case | Base Case | Bull Case |
|---|---|---|---|
| Year 1 Revenue | $45M | $52M | $58M |
| EBIT Margin | 8% | 12% | 15% |
| Free Cash Flow | $2.1M | $4.8M | $7.2M |
| ROIC | 6.2% | 9.8% | 12.1% |
Sensitivity Analysis: Year 3 EBIT impact of ±10% variance in key drivers:
- Customer Acquisition Cost: ±$1.2M
- Average Selling Price: ±$2.8M
- Operating Expense Leverage: ±$0.9M
Waterfall Bridge (Base to Bull): Revenue growth (+$6M) → Gross margin expansion (+$1.2M) → Operating leverage (+$0.8M) → EBIT improvement (+$2.0M)
What's Included
- Scenario Analysis Framework SKILL.md: Core instruction file with methodology and best practices
- Scenario Template: Pre-structured Excel/spreadsheet template with assumption matrices and scenario tabs
- Waterfall Analysis Checklist: Step-by-step guide for isolating and quantifying initiative impacts
- Sensitivity Analysis Workbook: One-way and two-way sensitivity table templates with formula guidance
- Executive Summary Template: Board-ready slide format for scenario comparison, downside quantification, and strategic narratives
- Assumption Documentation Workbook: Structured log for linking macro conditions to operational metrics with sensitivity flags
Who It's For
- FP&A Analysts — Building multi-scenario financial models and stress tests for strategic capital allocation decisions
- CFOs and Corporate Finance Leaders — Developing board-presentable strategic plans with quantified risk and defensible assumptions
- Strategic Planners — Translating business initiatives (M&A, market entry, restructuring) into rigorous financial projections under uncertainty
- Investment Analysts — Modeling portfolio company or target company valuation scenarios with sensitivity analysis
- Corporate Development Teams — Evaluating acquisition integration scenarios and synergy realization risk
Best For
- M&A integration financial planning and synergy quantification
- Multi-year strategic plan development requiring board or investor approval
- Capital allocation decisions between competing strategic initiatives
- Market expansion or new product launch financial feasibility analysis
- Financial resilience testing under recession, competitive, or market disruption scenarios
- Investor or analyst meeting preparation with detailed assumption documentation
You might also like
You'll construct defensible, driver-based revenue forecasts that link operational metrics (customer count, contract value, churn, win rates) directly to revenue outcomes. Claude helps you build base, upside, and downside scenarios with transparent assumptions, perform sensitivity analysis to quantify business variable impacts, and automatically document variance explanations—enabling you to respond confidently to CFO and board-level scrutiny.
by fastclaw-ai
You systematically evaluate bank proposals against standardized criteria, uncovering pricing structures and covenant terms that impact your treasury strategy. The framework helps you compare commitment fees, arrangement fees, and facility structures across multiple term sheets, then generates data-backed talking points for renegotiating existing arrangements and consolidating redundant banking relationships.
by fastclaw-ai
You'll build comprehensive DCF models that automate explicit forecast periods, terminal value calculations, and weighted average cost of capital derivation. The skill produces audit-ready assumption documentation, multi-scenario sensitivity tables, and valuation ranges across bear/base/bull cases—all formatted for board presentations and fairness opinions. You'll stress-test equity value assumptions and compare DCF outputs to trading multiples and M&A precedent data.
by fastclaw-ai
You can conduct multi-scenario covenant stress testing to quantify financial headroom between current metrics and covenant thresholds, identify which covenants are most vulnerable to market downturns, and calculate the cost-benefit of proactive amendments versus reactive refinancing. This enables you to report covenant health to leadership with actionable mitigation strategies before breach risk materializes.
by fastclaw-ai
You can build 12-month rolling forecast models that automatically drop the oldest completed month and add a new forward month as actuals close each period. The skill calculates budget variances (favorable/unfavorable) with root cause drivers, reforecasts remaining quarters based on current spending patterns and run-rate assumptions, and generates executive dashboards highlighting key budget risks and opportunities before they become serious overruns.
by fastclaw-ai
You can generate a focused, investor-ready one-page startup plan that captures your business model, target market, revenue streams, and competitive advantage. Claude asks clarifying questions about your idea, validates key assumptions, and produces a structured document you can use for pitches, investor meetings, or internal alignment.
by fastclaw-ai
This skill converts unstructured cash position data—bank balances, payables, receivables, and scheduled transactions—into structured liquidity analysis with clear decision frameworks. You'll identify liquidity gaps before they create operational friction, distinguish between structural and transactional funding needs, and receive specific recommendations for cash movements, investment opportunities, and contingency planning across multiple currencies and operational time zones.
by fastclaw-ai
Create a structured one-page business model that captures your core value proposition, revenue model, and key partnerships. You will define your riskiest assumptions, design an MVP with prioritized features, and build a customer discovery roadmap with interview templates and validation experiments. This approach helps you move from theory to validated learning before investing significant resources.
by fastclaw-ai