Scenario & Sensitivity Skill
Wraps any model in structured best/base/worst scenarios and sensitivity tables.
by AgentVoltv1.0.0Published 1y ago1 install
Free to sign up · every skill included with AgentVolt Pro
Before & after
Same prompt, same agent — the only difference is the skill.
Prompt“Build scenario and sensitivity analysis for our 5-year financial plan”
Beforegeneric AI agent
Scenario and sensitivity analysis is a great way to stress-test your model. You'll want to define your best, base, and worst case scenarios based on key assumptions. Then you can build out sensitivity tables to see which variables have the biggest impact on your bottom line—things like revenue growth, customer acquisition cost, churn rate. That'll help you understand what to focus on. But building all that into a spreadsheet can get complicated. What are your biggest uncertainties?
Afterwith Scenario & Sensitivity Skill
SCENARIO & SENSITIVITY ANALYSIS: 5-Year Financial Model SCENARIO MANAGER BASE CASE (probability 50%) • Revenue growth: 25% YoY • CAC payback period: 14 months • Gross margin: 78% • Operating expense ratio: 52% of revenue • Year 5 EBITDA: 12.3M BEST CASE (probability 25%) • Revenue growth: 40% YoY (viral adoption) • CAC payback: 9 months • Gross margin: 82% (scale efficiency) • OpEx ratio: 45% • Year 5 EBITDA: 22.8M WORST CASE (probability 25%) • Revenue growth: 8% YoY (market contraction) • CAC payback: 22 months • Gross margin: 71% (pricing pressure) • OpEx ratio: 60% • Year 5 EBITDA: 1.2M SENSITIVITY TABLES ONE-VARIABLE SENSITIVITY: Year 5 EBITDA by CAC Payback Period CAC payback 8m: 26.1M | 12m: 12.3M | 18m: -1.4M | 24m: -8.9M TWO-VARIABLE TORNADO CHART: Highest Impact Drivers 1. Revenue growth rate (8%-40% range impacts EBITDA by +/- 10.5M) 2. CAC payback period (8-24 month range impacts +/- 8.2M) 3. Gross margin (71%-82% range impacts +/- 4.1M) 4. OpEx ratio (45%-60% range impacts +/- 3.2M) 5. Churn rate (2%-8% annual impacts +/- 2.1M) KEY FINDINGS → Revenue growth is primary lever (fix acquisition strategy) → CAC payback has 2x sensitivity impact vs gross margin → Crossing breakeven happens in Year 4 (base case) SCENARIO PROBABILITY WEIGHTED FORECAST Expected Year 5 EBITDA: 10.8M (confidence interval: -1.4M to 22.8M)
About this skill
name: scenario-sensitivity description: Use when Wraps any model in structured best/base/worst scenarios and sensitivity tables.
Scenario & Sensitivity Skill
Takes an existing financial model and builds a clean scenario manager plus one- and two-variable sensitivity tables so you can stress-test the key drivers.
What you get
- A scenario manager and sensitivity-table layout.
Customize your output
- Adapt the assumptions, chart of accounts, and formatting to your company
- combine with other AgentVolt finance skills.
Example output
A tornado chart of the highest-impact drivers.
Best for
FP&A analysts and founders.
SKILL.md preview
SKILL.md
---
name: scenario-sensitivity
description: Use when an existing financial model needs to be wrapped in structured best/base/worst scenarios and one- and two-variable sensitivity tables to stress-test key drivers.
version: 1.0.0
category: Finance / Modeling
author: AgentVolt
license: proprietary
tags:
- finance
- modeling
- flagship
---
# Scenario & Sensitivity Skill
Wraps an existing financial model in a scenario manager plus one- and two-variable sensitivity tables, so key drivers get stress-tested instead of left as a single static case.
## When to use
… (sign up to view the full skill)Sign up to view, copy, and install the full skill
Featured in
More finance skills
View all Finance skills →Financial Statements to Model
Turns raw PDF financial statements into a full Excel model with historicals and forecasts.
Finance
Three-Statement Model Builder
Builds a fully linked income statement, balance sheet, and cash flow model from your assumptions.
Finance
Financial Forecasting Skill
Builds driver-based revenue and expense forecasts with base, bull, and bear scenarios.
Finance
Portfolio Rebalance Advisor
Drop in your current holdings and target allocation — get the exact buy/sell list, tax-loss opportunities, and drift alert.
Finance