PromptSharp › Prompt Library › Finance › Scenario & sensitivity table design
Scenario & sensitivity table design
You want a well-designed sensitivity/scenario table that shows what actually drives the outcome.
The prompt — copy and run it
You are a modeling analyst designing a scenario/sensitivity analysis for [model/decision]. I will give the model's key drivers and base-case outputs. Produce: 1. The 2 variables that should be the AXES of a sensitivity table (the ones the output is most sensitive to) and why. 2. A designed sensitivity TABLE structure (ranges, step sizes) that a reader can act on, using only my base-case inputs. 3. THREE named scenarios (e.g. base, downside, upside) with the coherent set of assumptions behind each — not just a single input flexed. 4. The interaction effects a one-variable sensitivity would miss. Do not populate outputs I can't derive from your inputs; mark those cells "model". Rules: Do not invent, estimate, or extrapolate any figure — if a number is not in what I give you, write "not provided" and flag it. Mark every claim I should verify externally before relying on it. Never use, infer, or request material non-public information (MNPI) or client-confidential data.
Why this prompt works
Most sensitivity tables flex the wrong variables one at a time; choosing the true value drivers as axes and building coherent multi-variable scenarios is what makes the analysis decision-useful.
Get a prompt like this every day
The PromptSharp Finance is live today — one desk-ready prompt per section, every weekday. Free tier: one rotating section's full prompt per day.
Subscribe free → Read a sample issueFrequently asked
When should I use this prompt?
You want a well-designed sensitivity/scenario table that shows what actually drives the outcome.
Why does this prompt work?
Most sensitivity tables flex the wrong variables one at a time; choosing the true value drivers as axes and building coherent multi-variable scenarios is what makes the analysis decision-useful.
Related Finance prompts
ROIC vs WACC value-creation check
You want to know whether a business actually creates value on the capital it deploys.…
Capex & reinvestment-runway analysis
You want to understand how much a company must reinvest and whether growth is self-funding.…
WACC build interrogation
Your discount rate drives the whole valuation and you want every component of the WACC challenged before you trust it.…
IC / investment memo first draft from a raw thesis
You have the thesis and the numbers in your head (or a messy notes doc) and need a structured first-draft memo you can edit, not a…
All Finance free prompts
The PromptSharp Finance page — five full free prompts plus the ladder status.
PromptSharp Daily — free
The cross-vertical sampler: one sharp, copy-paste prompt each day, rotating across the roster. See what each vertical is like before you commit to one.
Double-opt-in. Unsubscribe anytime. No spam, ever.
Home · Prompt Library · Pricing · Archive · Privacy · Terms · Refunds
Finance · CPG · Marketing · Sales · Consulting & Strategy · Product Management · Dev & Engineering · C-suite · Law · Personal Finance · Career & Job Search · Focus & Productivity · Learning · Health & Fitness · Parenting