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 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 can rapidly generate first-draft deal execution documents—LOIs, purchase agreements, and closing checklists—while Claude maintains consistency across all exhibits, schedules, and legal definitions. The skill cross-references conditions and dependencies across documents, flags gaps or circular logic before legal review, and tracks completion status against your deal timeline to surface execution risk early.
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 construct earnings narratives that translate complex financial results into compelling business stories while maintaining strict SEC compliance. This skill helps you connect quarterly performance to long-term strategy, highlight operational drivers, address headwinds with transparency, and align messaging across press releases, earnings call scripts, and investor Q&A prep—preventing reactive defensiveness and enabling confident proactive storytelling.
by fastclaw-ai
Get structured, comprehensive analysis of any franchise opportunity covering financials, legal risks, operational requirements, and market viability. You receive a detailed evaluation report with scoring matrices, profitability projections, and a clear yes/no recommendation based on your investment criteria and risk tolerance.
by fastclaw-ai
You can generate detailed integration playbooks that map functional workstreams, synergy realization timelines, and critical dependencies across acquired and acquiring organizations. The skill creates role-specific integration blueprints that identify quick wins versus foundational changes, establish governance structures, and define integration KPIs—transforming deal strategy into an operational execution roadmap for your integration management office.
by fastclaw-ai
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 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