Toolkit Store Courses Take Assessment About Blog
Take Assessment

Stress-Test Any Model Now

Sensitivity Analysis Generator

Upload model, get full sensitivity output

Get the T&E Policy Architect

Sensitivity Analysis Generator: Full Walkthrough

 
 

How to Upload a Claude Skill

Features List

6

One-Way Sensitivity Tables

13

Output Tabs Generated

1

Upload to Full Analysis

Why Finance Teams Run Every Model Through This Skill

Tornado Chart Included

The skill ranks every variable by its total swing impact and produces a tornado chart showing which assumptions matter most. You see your top value drivers ranked in one visual before you walk into any presentation.

6 One-Way Tables, Automated

Upload your model and the skill generates individual sensitivity tables for up to six variables: revenue growth, operating margin, WACC, terminal growth rate, tax rate, CapEx, or any labeled assumption you specify. Each table shows the output at five test points with delta vs. base and percentage change.

Two-Way Matrix Built In

The skill produces a two-way sensitivity matrix for any pair of variables you choose — WACC vs. terminal growth, revenue growth vs. COGS, or any other combination. The matrix shows the output across the full grid with conditional formatting to highlight the risk zone.

Breakeven Analysis

For each key variable, the skill finds the value at which your output hits a defined threshold: net income to zero, DSCR below covenant, FCF below floor. The Breakeven tab shows the base value, the breakeven point, and the cushion as both an absolute and a percentage.

Value Driver Narrative

The Value Drivers tab produces a written summary of the top five to ten variables ranked by swing, with a plain-language explanation of each driver, the range tested, and the approximate sensitivity per 1% change. Ready to paste directly into a board memo or investor presentation.

Everything Inside AICFO-030

  • Sensitivity Analysis Generator Skill (.skill file)

    The core Claude Custom Skill. Upload once to Claude and run a full sensitivity analysis on any financial model by attaching the .xlsx in chat.

  • Sample Input Model (Excel)

    The PepsiCo financial forecast used as the product demo input. Shows exactly how to structure your model before running the skill — labeled assumptions, clearly identified output metrics, and no formula errors.

  • Sample Output Report (Excel, 13 tabs)

    The completed PepsiCo sensitivity analysis the skill produces. All 13 tabs included: Summary, Tornado Data, Tornado Chart, 6 one-way tables (WACC, Beta, Revenue Growth, Operating Margin, Terminal Growth, Tax Rate), two-way matrix (WACC x Terminal Growth), Breakeven, and Value Drivers.

  • Quick-Start Guide (PDF)

    Setup guide covering skill installation, how to label assumptions in your model, how to specify variables and ranges, and how to read each output tab.

Five Situations Where Sensitivity Analysis Changes the Answer

Board and Investment Committee Prep

Leadership wants to understand the range of outcomes, not just the base case. Upload your financial model and the skill produces a tornado chart showing which three variables account for most of the risk. You walk into the room with ranked answers, not a spreadsheet.

DCF and Valuation Stress-Testing

Your DCF valuation is sensitive to WACC and terminal growth, but you haven't quantified how sensitive. The skill produces a two-way matrix across your WACC and terminal growth range, so you can show the board the full valuation range in a single table.

M&A and Deal Model Diligence

You've built a deal model and need to show the investment committee how the IRR holds up under adverse conditions. The breakeven tab shows exactly where EBITDA margin or revenue growth has to land for the deal to hit the return hurdle.

Budget and Forecast Review

Your budget model has 15 assumptions but you don't know which ones actually move the needle. Run the tornado analysis and focus your planning discussions on the variables that account for more than 80% of the variance.

Lender and Covenant Sensitivity

Your bank covenants require DSCR above 1.2x. The skill finds the exact EBITDA level at which you breach that threshold, and shows how much cushion you have at your current base case. Attach the breakeven tab to your next lender update.

What Each Tab in the Sensitivity Report Does

Tab Name What It Shows
1 Summary Model overview: source file, output metric, base case value, analysis date, and a key findings section. Start here to orient any reader.
2 Tornado Data The ranked data table behind the tornado chart. Each variable shows its low value, high value, low output, high output, delta vs. base (both directions), and total swing. Sorted by swing descending.
3 Tornado Chart Visual horizontal bar chart showing upside and downside impact per variable. Downside bars extend left (red), upside bars extend right (green). Variables ranked largest to smallest by total swing.
4 1W — WACC One-way sensitivity: Enterprise Value at 5 WACC test points from 6.5% to 9.0%. Includes base case row, delta vs. base ($M), and percentage change column.
5 1W — Beta One-way sensitivity: Enterprise Value across the Beta range. Shows the EV impact of changes in market risk perception or capital structure assumptions.
6 1W — Revenue Growth One-way sensitivity: Enterprise Value across the revenue growth rate range. The skill tests the full range and calculates the approximate EV change per 1% growth point.
7 1W — Operating Margin One-way sensitivity: Enterprise Value across the operating margin range. Connects directly to the EBITDA sensitivity in the tornado chart.
8 1W — Terminal Growth One-way sensitivity: Enterprise Value across terminal growth rate assumptions. Combined with WACC in the two-way matrix.
9 1W — Tax Rate One-way sensitivity: Enterprise Value across the tax rate range. Useful for post-tax reform or multi-jurisdiction scenarios.
10 2W — WACC x TG Two-way matrix: Enterprise Value grid with WACC on one axis and terminal growth rate on the other. Each cell shows the EV at that combination of assumptions. Cells below the hurdle rate highlighted.
11 Breakeven For each key variable: base value, breakeven point, absolute cushion, and cushion as a percentage. Target metric shown at the top of the tab.
12 Value Drivers Narrative summary of the top value drivers ranked by swing. Each driver includes the base case, range tested, sensitivity per 1% change, and key risk or opportunity associated with that variable.
13 1W — CapEx % Revenue One-way sensitivity for capital expenditure as a percentage of revenue. Shows the EV impact of CapEx intensity assumptions across the tested range.

Common Questions

Know Which Assumptions Drive Your Model Before the Board Does.

Updated for 2026. Tornado chart, 6 one-way tables, two-way matrix, breakeven, and value drivers — in one upload.

Get the Sensitivity Analysis Generator