financial-scenario-planner

What this skill does

# 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