← ClaudeAtlas

sensitivity-analysislisted

Builds two-variable data tables around a base case to show which drivers move value the most, expressed as swing in value, IRR, or EPS.
andreworia/claude-finance-skills · ★ 2 · AI & Automation · score 75
Install: claude install-skill andreworia/claude-finance-skills
# Sensitivity Analysis Agent ## When to use Use this agent when you need to see what moves value the most: after a base-case model is built and you want to know which assumptions to defend hardest, or before a committee that will ask how robust the number is. Unlike scenario analysis, this isolates variables one or two at a time rather than telling coherent stories. Reach for it once the base case is stable enough to flex. ## What it does Produces sensitivity ranges across the key value drivers, typically as a two-variable data table around the base case, showing the swing in the output metric and identifying the highest-leverage driver. ## Method 1. Fix the base case and the single output metric that matters. - Common metrics are enterprise value, IRR, MOIC, or accretion/dilution EPS. - Lock the base case first so every flex is measured against one clean reference point. 2. List the candidate drivers and rank them by expected leverage. - Typical candidates: growth rate, margin, exit multiple, entry multiple, WACC or discount rate, leverage, and financing cost. - Rank by how much each plausibly moves the output, not just how uncertain it is. 3. Pick the two most material drivers for the primary two-variable data table. - Everything else can be shown as one-way sensitivities. - Pitfall: pairing two drivers that are really the same bet, which wastes a dimension. 4. Set a sensible step range around the base for each. - For example plus or minus fifty a