Skip to main content
skill CX Codex

financial-scenario-planner — Claude Code skill: what it does

financial-scenario-planner runs a financial plan through bear, base and bull cases, then adds sensitivity tables, break-even and a runway check. Useful when the assumptions behind a model need testing.

MIT 156 installs ★ 114 updated 2026-10-25

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add travisjneuman/.claude --skill financial-scenario-planner -a claude-code
Open on GitHub

What financial-scenario-planner does

The skill is a set of planning templates you fill in yourself. The main one lays out three columns, bear, base and bull, with rows for revenue drivers (growth, new customers, churn, ARPU), cost lines (COGS, headcount, marketing, capex) and outside factors like interest rates and FX. The bottom row weights the cases into an expected revenue figure.

Then come a one-variable sensitivity table and the data for a tornado chart, which ranks variables by how far they push net income. A break-even calculator splits fixed costs from per-unit variable costs and returns units and revenue. Runway gets checked with revenue down 20% and down 50%.

Monte Carlo is written out as a procedure: choose a distribution for each input from the guide, sample the iterations, then read the percentiles and the chance of a loss. Every cell starts blank, so the answers are only as good as the figures you put in.

What it helps with

  • run a plan through bear, base and bull cases with probability weights
  • rank which inputs move net income the most
  • work out break-even in units and in revenue
  • check how many months of cash remain if revenue drops
  • pick distributions for a Monte Carlo run

Example prompts for the agent

  • Build a bear, base and bull scenario set for next year's model with probabilities and expected revenue.
  • Make a sensitivity table for net income against revenue growth and churn.
  • Recalculate runway with revenue down 20% and down 50%.

How to install financial-scenario-planner

1Skills CLI (Vercel)

npx skills add travisjneuman/.claude --skill financial-scenario-planner -a claude-code

2Manually: put the files in place

~/.claude/skills/financial-scenario-planner/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/financial-scenario-planner/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about financial-scenario-planner

How to install financial-scenario-planner in Claude Code?

One command: npx skills add travisjneuman/.claude --skill financial-scenario-planner -a claude-code. The skill file lands at ~/.claude/skills/financial-scenario-planner/SKILL.md.

What does financial-scenario-planner do?

It builds a financial plan across three cases and shows how individual assumptions move the result: sensitivity tables, break-even, and how long the cash lasts.

Which scenarios does it use?

Bear, base and bull. The template suggests weights of 20-25% for bear, 50-60% for base and 20-25% for bull.

Source text

SKILL.md · MIT
---
name: financial-scenario-planner
description: Stress-test financial plans across scenarios (bull/bear/base), sensitivity tables, and Monte Carlo-style analysis. Use when evaluating financial assumptions, modeling risk scenarios, or building scenario-based financial plans.
---

# Financial Scenario Planner

Frameworks for building multi-scenario financial models, stress testing assumptions, sensitivity analysis, and probability-weighted financial planning.

## Scenario Analysis Framework

### Three-Scenario Model

```
SCENARIO PLANNING TEMPLATE:

                    BEAR CASE        BASE CASE        BULL CASE
                    (Pessimistic)    (Expected)       (Optimistic)
Probability:        20-25%           50-60%           20-25%

REVENUE ASSUMPTIONS:
  Growth rate:      [X%]             [X%]             [X%]
  New customers:    [N]              [N]              [N]
  Churn rate:       [X%]             [X%]             [X%]
  ARPU change:      [X%]             [X%]             [X%]
  Market size:      [$ ]             [$ ]             [$ ]

COST ASSUMPTIONS:
  COGS margin:      [X%]             [X%]             [X%]
  Headcount growth: [N]              [N]              [N]
  Salary inflation: [X%]             [X%]             [X%]
  Marketing spend:  [$ ]             [$ ]             [$ ]
  Capex:            [$ ]             [$ ]             [$ ]

EXTERNAL FACTORS:
  Interest rates:   [X%]             [X%]             [X%]
  Inflation:        [X%]             [X%]             [X%]
  FX rates:         [X ]             [X ]             [X ]
  Regulatory:       [Impact]         [Impact]         [Impact]

PROJECTED OUTCOMES:
  Revenue:          [$ ]             [$ ]             [$ ]
  EBITDA:           [$ ]             [$ ]             [$ ]
  Net income:       [$ ]             [$ ]             [$ ]
  Cash position:    [$ ]             [$ ]             [$ ]
  Runway (months):  [N]              [N]              [N]

EXPECTED VALUE:
  E[Revenue] = P(bear) x Rev(bear) + P(base) x Rev(base) + P(bull) x Rev(bull)
```

### Scenario Trigger Events

| Scenario Driver | Bear Trigger | Base Assumption | Bull Trigger |
|----------------|-------------|-----------------|-------------|
| **Market demand** | Recession, -15% | Steady growth, +5% | Market expansion, +20% |
| **Competition** | New entrant takes 20% share | Stable competition | Competitor exits market |
| **Regulation** | Restrictive new regulation | Status quo | Deregulation/favorable policy |
| **Technology** | Disruption makes product obsolete | Incremental improvement | Breakthrough advantage |
| **Funding** | Cannot raise next round | Raise at expected terms | Oversubscribed round |
| **Key personnel** | Lose critical team members | Normal retention | Key strategic hires |

## Sensitivity Analysis

### One-Variable Sensitivity Table

```
REVENUE SENSITIVITY TO PRICE CHANGE:

Price Change:     -20%    -10%    Base    +10%    +20%
Volume Impact:    +10%    +5%     Base    -3%     -8%
Revenue:          [$ ]    [$ ]    [$ ]    [$ ]    [$ ]
Gross Profit:     [$ ]    [$ ]    [$ ]    [$ ]    [$ ]
Net Income:       [$ ]    [$ ]    [$ ]    [$ ]    [$ ]
```

### Two-Variable Sensitivity (Tornado Chart Data)

```
TORNADO CHART DATA — NET INCOME SENSITIVITY:

Variable            | Low Value | High Value | Low Impact  | High Impact
Revenue growth      | 5%        | 25%        | -$500K      | +$800K
Customer churn      | 8%        | 2%         | -$400K      | +$300K
COGS margin         | 45%       | 35%        | -$350K      | +$350K
Headcount           | +15       | +5         | -$300K      | +$200K
Interest rates      | 7%        | 4%         | -$150K      | +$100K
FX rates            | -10%      | +5%        | -$120K      | +$60K

INTERPRETATION:
  - Revenue growth has the highest impact on outcomes
  - Focus risk mitigation on top 3 variables
  - Variables below $100K impact are noise
```

### Break-Even Analysis

```
BREAK-EVEN CALCULATOR:

FIXED COSTS (Monthly):
  Salaries:           $______
  Rent/facilities:    $______
  SaaS/tools:         $______
  Insurance:          $______
  Other fixed:        $______
  TOTAL FIXED:        $______

VARIABLE COSTS (per unit):
  COGS:               $______
  Commission:         $______
  Payment processing: $______
  Support cost:       $______
  TOTAL VARIABLE:     $______

PRICING:
  Average selling price: $______
  Contribution margin:   $______ (price - variable cost)
  Contribution %:        _____%

BREAK-EVEN:
  Units:  Fixed costs / Contribution margin = _____ units
  Revenue: Fixed costs / Contribution % = $______

MONTHS TO BREAK-EVEN:
  At current growth rate: _____ months
  At optimistic rate:     _____ months
  At pessimistic rate:    _____ months
```

## Monte Carlo Simulation Design

### Simulation Framework

```
MONTE CARLO SETUP:

STEP 1: IDENTIFY VARIABLES
  List all uncertain inputs that affect the outcome.
  For each variable, define:
    - Distribution type (normal, uniform, triangular, lognormal)
    - Parameters (mean, std dev, min, max)

STEP 2: DEFINE DISTRIBUTIONS
  Revenue growth:   Normal(mean=15%, std=5%)
  Customer churn:   Triangular(min=2%, mode=5%, max=12%)
  COGS margin:      Uniform(min=30%, max=45%)
  Headcount growth: Discrete([5, 8, 10, 12, 15], probs=[0.1, 0.2, 0.4, 0.2, 0.1])

STEP 3: RUN SIMULATIONS
  Iterations: 10,000 (minimum for stable results)
  For each iteration:
    1. Sample random value from each distribution
    2. Calculate outcome (revenue, profit, cash flow)
    3. Store result

STEP 4: ANALYZE RESULTS
  Mean outcome:           $______
  Median outcome:         $______
  Standard deviation:     $______
  5th percentile (VaR):   $______ (worst 5% of outcomes)
  95th percentile:        $______ (best 5% of outcomes)
  Probability of loss:    _____%
  Probability of target:  _____%

STEP 5: INTERPRET
  "There is a 90% probability that net income will fall between
   $______ and $______, with an expected value of $______."
```

### Distribution Selection Guide

| Variable Type | Recommended Distribution | Parameters | When to Use |
|--------------|------------------------|------------|-------------|
| **Growth rate** | Normal | Mean, Std Dev | Symmetric uncertainty |
| **Market size** | Lognormal | Mean, Std Dev | Right-skewed, can't be negative |
| **Project cost** | Triangular | Min, Mode, Max | Expert estimates with bounds |
| **Binary events** | Bernoulli | Probability | Will/won't happen (regulation, deal) |
| **Time to event** | Exponential | Rate | Customer lifetime, time to churn |
| **Counts** | Poisson | Rate | Number of events in a period |

## Cash Flow Stress Testing

### Runway Calculator

```
CASH RUNWAY ANALYSIS:

Current cash:           $______
Monthly burn rate:      $______
Monthly revenue:        $______
Net monthly cash flow:  $______ (revenue - burn)

SCENARIO RUNWAYS:
  Current trajectory:   ______ months
  If revenue drops 20%: ______ months
  If revenue drops 50%: ______ months
  If revenue goes to 0: ______ months (pure burn runway)

TRIGGER POINTS:
  6-month runway remaining: Begin fundraise / cut costs
  3-month runway remaining: Emergency cost reduction
  1-month runway remaining: Wind-down planning

COST REDUCTION LEVERS (by impact):
  Lever                    | Monthly Savings | Feasibility
  Freeze hiring            | $______         | High
  Reduce marketing 50%     | $______         | Medium
  Renegotiate vendor terms  | $______         | Medium
  Reduce headcount 10%     | $______         | Low (last resort)
  Eliminate office space    | $______         | Medium
```

### Personal Finance Stress Test

```
PERSONAL FINANCIAL STRESS TEST:

INCOME SCENARIOS:
  Current income:          $______/month
  Reduced income (-20%):   $______/month
  Job loss (0 income):     $______/month
  Disability (partial):    $______/month

FIXED OBLIGATIONS:
  Housing (mortgage/rent): $______
  Insurance premiums:      $______
  Debt payments:           $______
  Utilities:               $______
  TOTAL FIXED:             $______

EMERGENCY RESERVES:
  Liquid savings:          $______
  Investment (accessible): $______
  Credit available:        $______
  TOTAL RESERVES:          $______

SURVIVAL METRICS:
  Months covered (fixed only):     ______
  Months covered (full spending):  ______
  Months if income drops 20%:      ______

  Target: 6+ months of full spending coverage

WHAT-IF ANALYSIS:
  "If [EVENT] happens, I can sustain for [N] months
   by cutting [EXPENSES] and drawing on [RESERVES]."
```

## Scenario Planning Process

### Workshop Format

```
SCENARIO PLANNING WORKSHOP:

PHASE 1: IDENTIFY UNCERTAINTIES (30 min)
  - List all factors that could impact the plan
  - Rate each: Impact (1-5) x Uncertainty (1-5)
  - Select top 2 with highest combined score
  - These become the axes of your scenario matrix

PHASE 2: BUILD SCENARIOS (45 min)
  Using the 2x2 matrix:

            Factor A: Low          Factor A: High
  Factor B:
  High      Scenario 1:            Scenario 2:
            [Name and narrative]    [Name and narrative]

  Factor B:
  Low       Scenario 3:            Scenario 4:
            [Name and narrative]    [Name and narrative]

PHASE 3: MODEL FINANCIALS (60 min)
  For each scenario:
  - Revenue projection (12-36 months)
  - Cost structure changes
  - Cash flow impact
  - Key metrics (CAC, LTV, margins)

PHASE 4: DEVELOP STRATEGIES (45 min)
  For each scenario:
  - What would we do differently?
  - What early warning signals would we see?
  - What decisions should we make now?
  - What options should we preserve?

PHASE 5: ACTION PLAN (30 min)
  - "No regret" moves (good in all scenarios)
  - Contingency triggers and responses
  - Monitoring dashboard design
  - Review cadence (quarterly recommended)
```

## Reporting Templates

### Scenario Summary for Stakeholders

```
FINANCIAL SCENARIO SUMMARY

Period: [Timeframe]
Prepared: [Date]
Author: [Name]

EXECUTIVE SUMMARY:
  [2-3 sentences: key finding and recommended action]

SCENARIO OUTCOMES:
                    Bear        Base        Bull
  Revenue:          $____       $____       $____
  EBITDA:           $____       $____       $____
  Cash (end):       $____       $____       $____
  Probability:      ____%       ____%       ____%
  Expected Value:   $____ (probability-weighted)

KEY RISKS:
  1. [Risk] — Impact: $____ — Mitigation: [Action]
  2. [Risk] — Impact: $____ — Mitigation: [Action]
  3. [Risk] — Impact: $____ — Mitigation: [Action]

RECOMMENDED ACTIONS:
  1. [No-regret move that's good in all scenarios]
  2. [Contingency to prepare now]
  3. [Decision to make by specific date]

MONITORING:
  KPI                  | Current | Trigger (Action Needed)
  Monthly revenue      | $____   | Below $____
  Cash runway          | ___ mo  | Below 6 months
  Customer churn       | ____%   | Above ____%
```

## See Also

- [Finance](../finance/SKILL.md)
- [Risk Management](../risk-management/SKILL.md)
- [Data Science](../data-science/SKILL.md)

© travisjneuman · MIT · travisjneuman/.claude

Similar skills

All skills for Finance and business →

From the same set117

The whole set →
rd-management This skill gives an agent R&D management frameworks for portfolios, technology roadmaps, research programs, and patent planning. CX Codex +1 157installs react-native This Claude Code skill supports React Native and Expo work on iOS and Android apps. It activates for JavaScript or TypeScript projects involving native features or mobile performance. CX Codex +1 157installs generic-fullstack-code-reviewer generic-fullstack-code-reviewer is a Claude Code skill for reviewing full-stack changes before commits and during pull request reviews. It checks Next.js and NestJS code for bugs, security issues, and project-rule mismatches. CX Codex +1 157installs seo-analytics-auditor seo-analytics-auditor — a skill that checks meta tags, structured data, analytics scripts and Core Web Vitals on a page. It reads the source HTML and walks through the SEO checklist item by item. CX Codex +1 156installs product-management product-management equips your agent with product strategy frameworks: RICE scoring, roadmap horizons, OKR setups, and PMF validation surveys. CX Codex +1 153installs agent-teams Teaches Claude how to compose agent teams: which tasks split well, how many teammates to spawn, and what goes into each spawn prompt. Active only once teams are enabled. CX Codex +1 153installs generic-fullstack-ux-designer generic-fullstack-ux-designer is a Claude Code skill that guides UX design for Next.js and NestJS apps, covering loading states, optimistic UI, forms, and SSR quirks. CX Codex +1 153installs fundraising-analyzer The fundraising-analyzer skill breaks down nonprofit fundraising with donor segments, campaign ROI, retention metrics, and trend views. Use it to review results or plan campaigns. CX Codex +1 153installs

Project sponsors

Companies that keep this analytics open