Sensitivity Analysis: Testing Financial Assumptions

What Is Financial Sensitivity Analysis?

Sensitivity analysis is a technique that tests how changes in individual assumptions affect your financial outcomes. By systematically varying one input at a time while holding others constant, you identify which variables have the greatest impact on your bottom line.

Think of it as asking what-if questions in a structured way. What if revenue grows at 10 percent instead of 20 percent? What if customer acquisition costs double? Sensitivity analysis answers these questions with concrete numbers.

Why Sensitivity Analysis Matters for Business Planning

Every financial forecast contains uncertainty. The question is not whether your assumptions will be wrong, but which wrong assumptions will hurt the most. Sensitivity analysis focuses your attention and risk management efforts on the variables that truly matter.

It also builds stakeholder confidence. When you can articulate which assumptions drive results under different conditions, you demonstrate sophistication and rigor.

How to Perform a Sensitivity Analysis

Step 1: Identify Key Variables

List the primary assumptions underlying your forecast. Aim for 8 to 12 key variables including revenue growth rate, pricing, churn, COGS percentage, and customer acquisition cost.

Step 2: Define the Range of Variation

For each variable, establish a realistic range. Use plus and minus 10 to 25 percent from your base case as a starting point, adjusting based on actual uncertainty.

Step 3: Test One Variable at a Time

Change each variable individually while holding all others at base-case values. Record the impact on your key output metrics: net income, cash flow, and runway.

Step 4: Rank by Impact

Sort results to see which variables produce the largest swings in your output metrics.

Advanced Sensitivity Techniques

• Two-way sensitivity: Vary two variables simultaneously to capture combined effects.
• Monte Carlo simulation: Run thousands of scenarios with all variables randomly varying to produce probability distributions.
• Break-even analysis: Determine exactly what value for each variable would cause your business to break even or run out of cash.

Using Sensitivity Analysis to Improve Decisions

If sensitivity analysis reveals that customer churn is your highest-impact variable, invest in retention programs. If pricing sensitivity dominates, consider pricing experiments. The goal is using risk understanding to make better decisions.

Finntree supports this analysis by providing the historical data and trend analysis needed to define realistic ranges for your variables.