FA-301h · Module 2
Sensitivity and Risk Analysis
3 min read
Every business case has assumptions. The sensitivity analysis tells you which assumptions matter most and the risk analysis tells you what happens when they break. A business case without these sections is asking the CFO to trust your numbers without testing them. The CFO will test them anyway — in their head, with worse assumptions than yours. Providing the sensitivity and risk analysis yourself is both more accurate and more credible than letting the CFO improvise.
Sensitivity — Key Assumptions:
──────────────────────────────────────────────────────
Assumption Pessimistic Base Optimistic
──────────────────────────────────────────────────────
Adoption rate 60% 80% 95%
Productivity gain 22% 34% 42%
Time to full value 9 months 6 mo. 4 months
──────────────────────────────────────────────────────
NPV by Scenario:
Pessimistic: ($12,400) ← Slightly negative
Base: $43,300
Optimistic: $89,700
Breakeven by Scenario:
Pessimistic: Month 14
Base: Month 10
Optimistic: Month 7
Key Finding: The business case is positive
in all scenarios except pessimistic.
Adoption rate is the swing variable —
if adoption reaches 70%+, the case is solid.
- Identify the Swing Variables Which 2-3 assumptions have the largest impact on the outcome? Run each independently through pessimistic/base/optimistic values while holding others constant. The variable that swings NPV from positive to negative is the one the CFO will focus on. Have a credible answer for why the base case is realistic.
- Quantify the Downside The pessimistic case is the one that matters most for approval. If the pessimistic case is still positive, the investment is low-risk. If it is slightly negative, the risk is manageable. If it is deeply negative, the investment is a bet — and the CFO needs to decide whether the potential upside justifies the downside exposure.