← Back to articles

Sensitivity Analysis: Testing Assumptions and Business Levers

What Is Sensitivity Analysis and Why It Matters

Sensitivity analysis tests how financial projections change when you vary underlying assumptions. Instead of projecting a single "most likely" scenario, you ask: what if CAC is 20% higher? What if churn is 1% higher? What if we hire sales reps 25% faster? Sensitivity analysis reveals which assumptions most impact your path to profitability and cash runway.

This exercise serves multiple purposes: (1) It identifies your most critical assumptions—the ones that truly matter, (2) It quantifies downside risk—what's the worst-case scenario, (3) It reveals which levers you should pull—what if we optimized pricing or reduced churn by 10%, (4) It demonstrates rigor to investors—you've thought through failure scenarios, not just success scenarios.

Most founders assume their projections are relatively accurate. Sensitivity analysis quickly reveals how wrong small changes make them. A 20% increase in CAC might reduce profitability timeline from month 36 to month 48. A 1% improvement in monthly churn might increase profitability timeline by 6 months. Understanding these relationships is invaluable.

Identifying Your Critical Assumptions

Not all assumptions matter equally. A 10% change in office rent (small impact) is less critical than a 10% change in CAC (large impact). Identify your top 5-10 assumptions that drive profitability and cash runway. For most SaaS, these are: CAC, ARPU, monthly churn, revenue growth rate, and operating expense growth.

To identify critical assumptions, build a baseline model (most likely case) and then vary one assumption at a time 20% in both directions. Which assumptions create the largest change to key outputs (profitability date, cash runway, required capital)? Those are your critical assumptions.

Common critical assumptions for SaaS: (1) Customer Acquisition Cost (CAC)—how much do you spend to acquire each customer? (2) Average Revenue Per User (ARPU)—what's the average customer value? (3) Monthly Churn Rate—what percentage of customers cancel monthly? (4) Sales Hiring Plan—how many sales reps do you hire and when? (5) COGS as % of Revenue—how much does product delivery cost?

Building Single-Variable Sensitivity Tables

Create a table where one variable (e.g., monthly churn) varies from -30% to +30% from baseline, and key outputs (profitability date, cash runway, required capital) are recalculated for each scenario. This shows the relationship between one assumption and multiple outcomes.

Example sensitivity table: Baseline monthly churn is 2%. Show outcomes at 1.4%, 1.7%, 2.0%, 2.3%, and 2.6% churn. For each churn rate, calculate profitability date. Most likely, profitability dates shift 6-12 months per 0.3% churn change. This quantifies how sensitive your model is to churn assumptions.

Create these single-variable tables for your five most critical assumptions. Present them to investors; they'll instantly see which variables you should focus on. If profitability date is incredibly sensitive to CAC but insensitive to office rent, you know where to focus.

Two-Variable Sensitivity Matrices

More sophisticated models vary two variables simultaneously to show interaction effects. Create a matrix where one variable (e.g., CAC) is columns and another (e.g., monthly churn) is rows. Each cell shows profitability date or cash runway for that combination.

Example matrix: CAC ranges from $400 to $600 (columns), monthly churn ranges from 1.5% to 2.5% (rows). A cell shows profitability date for ($500 CAC, 2.0% churn). This reveals not just individual sensitivity but also interaction effects: maybe high CAC + high churn is catastrophic while high CAC + low churn is manageable.

Two-variable matrices are especially useful for critical variable combinations. If sales hiring pace and gross margin are both critical, create a matrix showing outcomes across combinations. This reveals whether strong gross margin (supporting more sales hiring) compensates for slow hiring, or vice versa.

Scenario Modeling: Best Case, Base Case, Worst Case

Instead of varying variables individually, model comprehensive scenarios: (1) Optimistic case—assumes you hit all targets, maybe exceed some. CAC is 15% lower than expected, churn is 20% lower, sales reps are 10% more productive. (2) Base case—assumes your most likely trajectory based on current traction. (3) Pessimistic case—assumes execution challenges. CAC is 20% higher, churn is 25% higher, revenue growth is 30% slower.

Show all three scenarios to investors. The base case is "our best guess." The optimistic case is "best plausible scenario if everything goes right." The pessimistic case is "what happens if we hit execution challenges." Most investors focus more on pessimistic case than optimistic; they want to know you survive downside scenarios.

Quantify scenario probability if you're comfortable doing so. "We're 50% confidence in base case, 25% optimistic, 25% pessimistic." This weighting helps investors evaluate expected value. Some investors will focus on pessimistic case as their downside protection; others will focus on base case as representative.

Testing Pricing Assumptions

Pricing is often underestimated in its sensitivity impact. Test what happens if you increase ARPU 20% (through pricing increase, customer upselling, or mix shift). Most likely, customer acquisition decreases slightly (higher price means fewer conversions) but profitability improves significantly (revenue increase exceeds customer loss).

Pricing sensitivity often reveals opportunities. Many SaaS companies underprice—they could raise prices 20-30% with minimal customer loss and dramatically improve profitability. Sensitivity analysis quantifies the tradeoff: "If we raise prices 25%, we lose 10% of customers but improve profitability 40%." This might be a smart move.

Create a pricing sensitivity matrix: rows are price points (from -30% to +30%), columns are conversion impact (from -5% to -25%), cells show profitability/revenue impact. This reveals the pricing elasticity sweet spot for your business.

Testing Growth Rate Assumptions

Revenue growth assumptions are foundational. Test what happens if you achieve 50% annual growth instead of 100%. Most likely, burn rate improves significantly (slower headcount hiring) and cash runway extends. But profitability date might also extend 6-12 months (slower revenue growth delays breakeven).

Growth rate sensitivity reveals whether slower growth is actually better for cash preservation. Some founders are growth-focused without considering cash implications. If slower growth extends cash runway significantly with minimal profitability date delay, that's a valuable tradeoff.

Model growth scenarios: (1) Accelerating growth—start 30% quarterly, improve to 40-50% quarterly by year 3. (2) Decelerating growth—start 50% quarterly, slow to 20% by year 3 (market saturation). (3) Flat growth—10% quarterly throughout (mature market or limited TAM). Each scenario has different profitability and capital implications.

Testing Hiring Plans and Operating Leverage

Hiring plan is a critical assumption. Test what happens if you hire 25% slower. Most likely, revenue growth slows (fewer salespeople) but burn rate decreases significantly. You might reach profitability faster and require less capital, even though absolute revenue is lower.

This reveals a crucial tradeoff: growth vs. profitability. Aggressive hiring prioritizes growth (higher revenue, delayed profitability); conservative hiring prioritizes profitability (lower revenue, earlier breakeven). Neither is inherently right; depends on market opportunity and investor preferences. Sensitivity analysis quantifies the tradeoff.

Test operating expense ratios: what if we achieve 25% OpEx/Revenue by year 3 instead of 35%? That aggressive operating leverage improves profitability date 6-12 months and might reduce required capital 30%. Sensitivity analysis shows you which efficiency improvements matter most.

Modeling Capital Requirements Sensitivity

Calculate required capital for each scenario. Base case might require $10M total capital to reach profitability. Optimistic case might require $6M (faster growth supports faster profitability). Pessimistic case might require $15M (slower growth delays profitability, requiring more runway).

This reveals capital efficiency of different scenarios. Optimistic case might reach $10M ARR with $6M capital (1.67x capital efficiency). Pessimistic might reach $5M ARR with $15M capital (0.33x capital efficiency). This shows how critical hitting growth targets is for capital efficiency and investor returns.

Required capital also reveals which variables most impact fundraising needs. If sensitivity shows that 2% difference in monthly churn changes required capital by $5M, churn reduction is a major priority. Conversely, if office rent variance doesn't materially change required capital, it's not worth obsessing over.

Dashboard Presentation of Sensitivity

Create a one-page sensitivity dashboard for investors showing: (1) Base case profitability date and cash runway, (2) Optimistic case outcomes, (3) Pessimistic case outcomes, (4) Key variable sensitivity: profitability dates across CAC, churn, and growth assumptions, (5) Critical variable: which single variable has largest impact on profitability.

Color-code outcomes: green for profitability by 48 months, yellow for 48-60 months, red for beyond 60 months. This visual instantly communicates risk. If most scenarios are red, you have significant execution challenges. If most are green, you're in good shape.

Investors will ask: "What's your downside case?" and "What are you most uncertain about?" Sensitivity analysis answers both questions credibly. You're demonstrating that you've thought through failure scenarios and identified which variables truly matter.

Linking Sensitivity to Company Strategy

Use sensitivity analysis to inform strategy. If sensitivity shows churn is most critical assumption, prioritize customer retention. If CAC sensitivity is huge, focus on sales efficiency and CAC reduction. If gross margin sensitivity is large, invest in product development to reduce COGS.

Sensitivity analysis also informs investor conversation. "Our model is most sensitive to CAC assumptions. We've demonstrated $300 CAC in initial cohorts; if we maintain that as we scale, profitability is month 40. If CAC increases 30%, profitability delays to month 48. We're confident in CAC trajectory based on [specific data]."

Use sensitivity to manage board expectations. "Our base case shows profitability in month 42. But we've stress-tested the model; even if growth slows 25% and churn increases 50%, we're profitably at month 56 with manageable capital requirements. We have downside protection."

Common Mistakes in Sensitivity Analysis

Many founders only model optimistic and base cases, ignoring pessimistic case. Investors want to see you've thought through failure. Always show downside.

Another mistake: sensitivity ranges that are unrealistic. Testing 100% CAC increase is probably unrealistic if you've proven $300 CAC. Test realistic ranges: ±20% around current assumption. This is more credible.

Some founders miss interaction effects. Testing CAC and churn independently might show both are manageable, but combined they're catastrophic. Two-variable matrices catch these interactions.

Key Takeaways

• Identify your 5-10 critical assumptions: those that most impact profitability and cash runway. Focus sensitivity analysis here.
• Create single-variable sensitivity tables showing how key outputs change as one assumption varies ±20% from baseline.
• Build two-variable sensitivity matrices for critical assumption pairs to reveal interaction effects.
• Model three scenarios: optimistic (everything goes right), base case (most likely), pessimistic (execution challenges). Show all to investors.
• Quantify key tradeoffs: growth vs. profitability, price increases vs. customer losses, faster hiring vs. burn rate.
• Calculate required capital for each scenario. Shows how critical hitting growth targets is for capital efficiency.
• Use sensitivity insights to inform strategy. Focus on assumptions with largest impact on outcomes.
• Present sensitivity dashboard to investors showing base case, optimistic, pessimistic, and critical variables. Demonstrates rigor and addresses downside risk.

FAQ

What's a reasonable sensitivity range to test?

±20% from baseline is standard for most assumptions. If you're very confident in an assumption, test ±10%. If you're uncertain, test ±30%. The range should reflect your confidence level. For brand new assumptions (new market, new pricing), test wider ranges.

Should we present all scenarios to investors or just base case?

Present base case as your primary projection, but be prepared to defend it. Investors will ask about upside and downside. Showing you've modeled them (even if not formally presented) is credible. Some investors prefer seeing all three scenarios upfront; others prefer base case with follow-up on scenarios.

How do we know if our assumptions are realistic?

Ground assumptions in data. "We've acquired 100 customers at $300 CAC average." That's data, not assumption. "We assume CAC stays at $300 as we scale to 1,000 customers." That's an assumption based on data. Always distinguish between measured and extrapolated assumptions.

What if sensitivity shows we can't reach profitability in 60 months?

That's valuable information. Either your assumptions are wrong (revisit them), or your unit economics don't work at scale. Test alternative business models: higher pricing, lower churn, lower CAC. If no model works, you might not have a viable business. Better to find that through sensitivity analysis than by burning $50M.

How often should we update sensitivity analysis?

Quarterly as you get new data. If actual CAC is 20% lower than assumed, update sensitivity ranges. As you improve certain metrics, sensitivity ranges narrow (higher confidence). As you encounter new challenges, ranges might widen (lower confidence). Sensitivity analysis should evolve with your understanding.