# Run a sensitivity analysis on my financial model's key drivers

A sensitivity and break-even analysis that shows which assumptions really move the outcome and by how much.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Finance, Analyze, Brainstorm, Fill-in Template, Interactive
- Source: https://www.thinkwithprompt.com/prompts/run-a-sensitivity-analysis-on-my-financial-model-s-key-drivers

## Prompt

```text
Help me run a sensitivity analysis on my financial model.

**What the model calculates:** [e.g. "FY EBITDA", "12-month cash runway", "project NPV"]
**Base case output:** [VALUE]
**Key drivers and base values:** [LIST - e.g. "price $49", "churn 2%/month", "conversion 3%", "salary inflation 4%"]
**Realistic ranges for each driver:** [LOW / HIGH - or ask me to suggest ranges and justify them]
**How drivers connect to the output:** [PASTE formulas or describe the logic]

Steps:
1. Flex each driver one at a time across its range, holding others at base.
2. Rank drivers by impact (a tornado-chart ordering).
3. For the top 3 drivers, calculate the break-even value where the output hits [THRESHOLD - e.g. "zero cash", "covenant limit", "target EBITDA"].
4. Build a two-way table for the two most important drivers.
5. Note any drivers that are correlated, where one-at-a-time flexing understates risk.

Return:
- A ranked table: Driver | Low | High | Output at low | Output at high | Swing.
- The break-even values and how far each is from today.
- The two-way table.
- 4-5 bullets explaining what this means for decisions and what to monitor monthly.
- Instructions for building the same tables in Excel or Google Sheets (data tables or formulas).

Use my numbers; if logic is unclear, ask or mark [CONFIRM] rather than assume.
```

## What to fill in

- e.g. "FY EBITDA", "12-month cash runway", "project NPV"
- VALUE
- LOW / HIGH - or ask me to suggest ranges and justify them
- PASTE formulas or describe the logic
- CONFIRM

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.