Scenario Analysis Framework for Strategic Planning
Build multi-scenario financial models with sensitivity analysis for strategic decisions
What You Can Do
You construct comprehensive multi-scenario financial models (base, upside, downside, tail-risk) complete with explicit assumptions, probability weightings, and sensitivity drivers. Claude helps you stress-test strategic initiatives like M&A, market entry, or product launches by quantifying key value drivers, calculating probability-weighted expected values, and generating transparent variance analysis that withstands executive and board-level scrutiny.
Features
build base, upside, downside, and tail-risk cases with explicit documented assumptions
identify and quantify key drivers (price, volume, COGS, capex) and their impact on outcomes
calculate expected values and risk-adjusted returns across all scenarios
model financial impact of M&A, market entry, product launch, or divestiture decisions
document logic and calculation methodology for audit trails and stakeholder confidence
generate pivot tables and waterfall breakdowns showing scenario performance drivers
challenge your assumptions and identify blind spots in scenario construction
create board-ready summaries with downside/upside ranges and confidence metrics
Example Output
Scenario Summary Output:
- Base Case: $150M revenue, 22% EBITDA margin, $8.2M free cash flow
- Upside (30% probability): $180M revenue, 25% EBITDA margin, $12.5M FCF
- Downside (20% probability): $120M revenue, 18% EBITDA margin, $2.1M FCF
- Expected Value: $147M revenue, 21.4% EBITDA margin, $7.8M FCF
Sensitivity Table:
- ±10% volume swing: ±$18M revenue impact
- ±5% pricing: ±$7.5M revenue impact
- ±200bps COGS: ±$3M EBITDA impact
Strategic Initiative Analysis (New Market Entry):
- Year 1 investment: $5M capex + $2M operating losses
- Breakeven: Year 3 with 60% probability of target market share
- Probability-weighted NPV: $22M (vs. $18M base case)
What's Included
- SKILL.md instruction file with scenario framework methodology:
- Multi-scenario model template (Excel-ready structure with formula guidance):
- Sensitivity driver checklist (revenue, cost, capital, and operational variables):
- Assumption documentation template (transparent mapping of inputs to scenarios):
- Probability weighting calculator and expected value framework:
- Strategic initiative stress-test workbook (M&A, market entry, product launch scenarios):
Who It's For
- Financial Analysts (FP&A) — building strategic plans and annual guidance with risk-adjusted scenarios
- Corporate Finance professionals — evaluating major capital allocation and M&A decisions
- CFOs and Finance Directors — preparing executive summaries and board presentations with defensible scenarios
- Business strategists — modeling financial impact of strategic initiatives and market opportunities
- Investment and corporate development teams — stress-testing acquisition or divestiture scenarios
Best For
- 3–5 year strategic planning and guidance framework development
- Major capital allocation decisions (capex, M&A, R&D investment)
- Market entry and new product launch financial modeling
- Strategic risk assessment and scenario stress-testing
- Board presentation preparation with risk-adjusted analysis
- Sensitivity analysis on key value drivers (CAC, churn, margin expansion)
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'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'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 build comprehensive deal execution timelines that map interdependencies across all workstreams—legal, regulatory, financing, and operations—and automatically flag risks that could delay closing. The skill identifies which delays actually impact your close date versus minor slippage, creates decision trees for contingency scenarios, and generates stakeholder-ready reports for boards, lenders, and sponsors. You turn raw deal data into a living, weekly-updated source of truth for deal execution status.
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
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