- Home
- Skills
- Finance & Accounting
- scenario sensitivity analyzer
Works with the AI Agents you already use
scenario sensitivity analyzer
Financial models are often brittle spreadsheets where changing one assumption requires manual updates across multiple tabs.
$10
scenario sensitivity analyzer
Example session with this skill installed
Analyze our Q3 profit. Price is $50, volume 1000 units, unit cost $20, fixed costs $15k. Run a downside scenario with 20% lower volume and an upside with 10% higher price. Show break-even.
- Read your context and instructions
- Compiled the scenario sensitivity analyzer
I have processed the Q3 profit model using the price_volume_unit_cost formula. The deterministic engine has evaluated the base, downside, and upside scenarios.
Scenario and Sensitivity Analysis — Internal, 2023-10-27
1. Scope, sources and assumptions
The model uses the price_volume_unit_cost formula in USD.
| Driver | Value | Behavior | Treatment | Origin |
|---|---|---|---|---|
| price | 50.00 | revenue | variable | user_supplied |
| volume | 1000.00 | variable | variable | user_supplied |
| unit_variable_cost | 20.00 | variable_cost | variable | user_supplied |
| fixed_costs | 15000.00 | fixed_cost | fixed | user_supplied |
2. Scenario table
| Scenario | Kind | Revenue | Variable costs | Fixed costs | Profit | Profit margin | Change vs base | Material |
|---|---|---|---|---|---|---|---|---|
| Base | base | 50000.00 | 20000.00 | 15000.00 | 15000.00 | 0.30 | 0.00 | - |
| Downside | downside | 40000.00 | 16000.00 | 15000.00 | 9000.00 | 0.225 | -6000.00 | true |
| Upside | upside | 55000.00 | 20000.00 | 15000.00 | 20000.00 | 0.363 | +5000.00 | true |
3. Sensitivities
One-way Sensitivity: Price on Profit
| Price | Profit |
|---|---|
| 40.00 | 5000.00 |
| 50.00 | 15000.00 |
| 60.00 | 25000.00 |
4. Break-even thresholds
| Driver | Target | Threshold | Base | Break-even Value | Headroom |
|---|---|---|---|---|---|
| volume | 0.00 | 500.00 | 1000.00 | 500.00 | 500.00 |
| price | 0.00 | 35.00 | 50.00 | 35.00 | 15.00 |
5. Driver ranking
| Driver | Impact | % Change |
|---|---|---|
| price | 5000.00 | 33.3% |
| volume | 3000.00 | 20.0% |
Note: Mechanical effect based on a 10% shock to drivers.
6. Uncertainty narrative
The profit range across scenarios is $9,000.00 to $20,000.00. The lowest outcome occurs in the Downside volume shock.
Analytical estimate — validation required.
7. Warnings and items for human review
No warnings reported by the execution engine.
"This analysis supports, and does not replace, professional judgment and management's decision."
Management decision required.
Next steps
- Validate the 20% volume drop assumption against Q3 pipeline data.
- Review fixed cost allocations to ensure no hidden variable components.
- Use the break-even price of $35.00 to set the floor for upcoming discount negotiations.
Connects securely to your tools. The creator never sees your data.
About this skill
Financial models are often brittle spreadsheets where changing one assumption requires manual updates across multiple tabs. This skill provides a deterministic engine to evaluate profit models under stress, running base, upside, and downside scenarios without manual calculation errors.
What it does
- Scenario execution runs base, upside, downside, and custom what-if cases on declared profit models.
- Sensitivity mapping generates one-way and two-way sensitivity tables to visualize how specific drivers move the bottom line.
- Break-even analysis identifies the exact thresholds for price, volume, or costs required to reach target profit margins.
- Mechanical driver ranking sorts assumptions by their impact on results to highlight which variables matter most.
- Probability weighting computes weighted outcomes only when evidence-based probabilities are provided.
How it works
- Model declaration where you define the formula (e.g., price-volume-unit-cost) and provide the required drivers like revenue, fixed costs, and variable costs.
- Scenario configuration where you specify shocks—percentage or absolute changes—to the drivers for different cases.
- Automated execution via a self-contained Python script that processes the
request.jsonagainst the schema. - Structured reporting where the agent interprets the script output into a standardized Markdown report including uncertainty narratives and warning flags.
Frameworks & tools
This skill uses a deterministic Python engine (scripts/run.py) and JSON Schema validation (input.schema.json) to ensure mathematical accuracy and decimal precision.
Why this beats prompting it yourself
Standard LLM prompting often leads to hallucinated math or inconsistent rounding when handling multi-variable sensitivities. This skill offloads the computation to a script, ensuring every scenario, break-even, and ranking is mathematically sound and follows strict sign conventions.
Use cases
- Evaluate the impact of a 10% raw material cost increase on net profit margins.
- Determine the minimum sales volume needed to stay cash-flow positive after a rent hike.
- Compare upside and downside revenue scenarios to prepare for quarterly board meetings.
- Identify which single variable (price vs. volume) has the highest mechanical impact on contribution.
Known limitations
Does not support multi-period forecasts, tax, financing, interest, or FX modeling. Evaluation is limited to built-in profit formulas and does not support arbitrary mathematical expressions.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
No support for multi-period forecasts, tax, or FX. Limited to built-in formulas; no arbitrary expressions. No valuation or trading advice.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 5 days ago