How to Present Sensitivity Tables in IB Without Losing the Audience

Sensitivity tables are everywhere in investment banking pitches. They're supposed to show investors how valuation or returns change when key assumptions shift. In theory, they're invaluable. In practice, many sensitivity tables are dense, confusing, and barely glanced at by the audience.

The problem isn't the concept—it's the execution. A table crammed with twelve assumptions, five output metrics, and a color gradient that's hard to read fails its core purpose: helping investors understand the robustness of your thesis. A well-designed sensitivity table, by contrast, instantly communicates which assumptions matter most and builds confidence that your valuation or return story is defensible across reasonable scenarios.

This guide breaks down the design principles, structural choices, and presentation techniques that separate effective sensitivity tables from those that get ignored.

---

Why Sensitivity Analysis Matters in Investment Banking

In investment banking, you're making a thesis-driven argument. Maybe you're arguing that a company is worth $500M despite investor skepticism. Maybe you're claiming that a leveraged structure can generate 25% IRR. These claims rest on a series of assumptions about revenue growth, margin expansion, exit multiples, and market conditions.

Sophisticated investors know that assumptions matter. They also know that the future is uncertain. A sensitivity analysis shows what happens to your conclusion if your assumptions are wrong. It answers the question every investor is thinking: "What if you're wrong about X?"

A strong sensitivity analysis doesn't weaken your pitch; it strengthens it. By showing that your valuation or returns are robust across a range of scenarios, you demonstrate that you've thought through the risks and that your thesis isn't dependent on unrealistic perfection. Conversely, if your sensitivity analysis shows that valuation or returns collapse if key assumptions move modestly, you've just identified a problem that needs addressing.

The challenge is that sensitivity analysis produces a lot of data. A sensitivity table with six input assumptions and four output metrics can easily contain 80+ data points. If these points aren't visualized and organized carefully, the audience will mentally check out and move to the next slide.

---

Choosing Your Sensitivity Dimensions

The first critical choice is which assumptions to sensitivity-test. Don't test everything. Test the assumptions that matter most to your thesis and that are most uncertain.

Revenue Growth: If your valuation hinges on revenue growth, sensitivity to this assumption is essential. Show how value changes if growth is 1-2% lower or higher than your base case.

EBITDA Margins: If your story involves margin expansion (operational improvements, scale benefits), test how margin assumptions impact valuation. Show base case, upside (expansion as you expect), and downside (margins remain flat).

Exit Multiple: In M&A and LBO scenarios, exit multiple is often highly uncertain. Show valuation across a range of plausible exit EBITDA multiples. This is especially important in cyclical industries where exit multiple can vary significantly.

CapEx Intensity or Working Capital: In some businesses, capital efficiency is the key variable. Test how changes in CapEx as a percentage of revenue or working capital requirements impact valuation or returns.

Discount Rate (WACC): For DCF-based valuations, WACC is often the subject of debate. Show how valuation changes across a reasonable range of WACC assumptions.

Debt Paydown Rate: In leveraged transactions, debt reduction speed affects equity returns significantly. Test how variations in debt paydown assumptions impact IRR.

Terminal Value Assumption: For terminal value calculations, test both the growth rate assumption and the WACC/exit multiple assumption that determines the terminal value.

The key is focus. Choose 2-3 variables that are both material and uncertain. A sensitivity table with eight variables looks thorough, but it's often confusing. A table with two well-chosen variables that clearly shows how they impact your investment thesis is far more powerful.

---

The Two-Dimensional Sensitivity Table Format

The most effective format for sensitivity analysis in investment banking is a two-dimensional table: one variable on the rows, one on the columns. This creates a matrix where each cell shows the output (valuation, IRR, multiple, etc.) for that specific combination of assumptions.

Template Structure:

Use the left column for one variable (typically the one that investors debate most) and the top row for a second variable. For example, rows might show exit EBITDA multiples ranging from 8.0x to 12.0x, and columns might show revenue CAGR ranging from 3% to 8%. Each cell shows the resulting implied valuation or IRR.

Example:

Exit Multiple →    5.0x    5.5x    6.0x    6.5x    7.0x
Revenue CAGR ↓
6%                 $420M   $455M   $490M   $525M   $560M
7%                 $460M   $500M   $540M   $580M   $620M
8%                 $505M   $550M   $595M   $640M   $685M
9%                 $550M   $600M   $650M   $700M   $750M
10%                $600M   $655M   $710M   $765M   $820M

Ranges and Granularity: Your ranges should be realistic. If your base case is 8% revenue growth, showing sensitivity to 2% or 15% growth stretches credibility. Instead, show 6-10% (a reasonable range around your base case). For exit multiples, if you're pitching a company in a 6-7x multiple range, test 5.5-7.5x.

Use 5-7 rows and 5-7 columns. More than that becomes visually overwhelming. Fewer than that limits the insight.

Clearly Label Your Base Case: Your base case assumptions (the combination you actually believe in) should be visually distinct. Many pitches highlight the base case cell with a border or highlight color. This ensures the audience knows which scenario you're actually projecting.

---

Color Coding and Visual Clarity

The right color scheme makes or breaks a sensitivity table. Poor color choices can render a table nearly unreadable.

Gradient Coloring: Use a color gradient (often from red for low values to green for high values, or from light to dark) that helps the audience quickly identify which scenarios are most favorable. This is especially effective in a valuation table where higher values are better. A glance at the table immediately shows that high revenue growth + high exit multiple = maximum value, which is intuitively obvious but visually powerful.

Important Caveat: If you're showing results that don't have a clear "good/bad" direction (e.g., debt paydown schedules where too much paydown might signal over-conservatism), a neutral gradient is safer. But in most valuation scenarios, a "low-to-high" gradient works well.

Contrast and Legibility: Make sure numbers are legible. Dark text on a colored background can be hard to read. Consider using white or black text depending on the background color intensity. Your base case should be visually distinct—either a thicker border, a different highlight color, or bold text.

Avoid Over-Complication: Don't use more than one color scheme per slide. If you have two sensitivity tables on a slide, use the same color scheme for both. Consistency helps the audience process the information faster.

---

Multi-Output Sensitivity Tables

Sometimes you need to show how multiple outputs respond to sensitivity variations. This is common in LBO analysis where you might want to show impact on both valuation and IRR, or in M&A where you show impact on both EV/EBITDA and implied return.

Side-by-Side Tables: The cleanest approach is to show two sensitivity tables side by side, each with the same dimensions but different outputs. The audience can quickly compare how the same assumption changes affect different metrics.

Stacked Tables: Alternatively, you can stack them vertically. Make sure the second table is clearly labeled and uses the same input dimensions as the first.

Avoid Hybrid Tables: Don't try to cram multiple outputs into a single matrix. A table showing both IRR and MoIC (multiple on invested capital) with different color schemes is confusing.

---

Waterfall Sensitivity Analysis

For some analyses, a sensitivity table alone isn't enough. You might want to show how the output changes as you move one assumption at a time, starting from a base case.

A waterfall sensitivity (also called tornado chart when visualized as a horizontal bar chart) shows the impact of each assumption independently. Start with your base case output (e.g., $500M valuation). Then, move Assumption A from base to pessimistic, and show the new valuation ($480M, a $20M impact). Keep all other assumptions at base. Then reset, move Assumption B from base to pessimistic, and show its impact. Repeat for each assumption.

The result is a waterfall that shows the magnitude of each assumption's impact. You might discover that your valuation is highly sensitive to exit multiple but relatively insensitive to revenue growth. This insight is invaluable for framing your investment thesis and identifying key risks.

When to Use Waterfall Sensitivity: This format is excellent when one or two assumptions completely dominate the outcome. It's also useful in risk management contexts where you want investors to understand which assumptions they should worry about.

---

Presenting Sensitivity Tables to Different Audiences

Your sensitivity analysis should adapt based on your audience's sophistication and concerns.

To Sponsors (PE Investors): Sponsors care about downside protection and base case robustness. Show sensitivity to exit multiples (their main market risk) and EBITDA margins or leverage metrics (operational risks). Sponsors also care about base case IRR, so show how IRR changes with different exit multiples and debt paydown speeds.

To Lenders: Lenders care about covenant compliance and debt service coverage. Show sensitivity to EBITDA (since leverage is typically calculated as Net Debt/EBITDA) and FCF generation (since coverage ratios depend on FCF). Lenders want to see that leverage stays within covenant ranges even in downside scenarios.

To Strategic Acquirers: Acquirers care about accretion and fit. Show sensitivity to purchase price, acquisition costs, and synergy realization. Show how different purchase prices impact accretion to EPS and returns.

To Board Members: Boards care about strategic fit and downside scenarios. Show sensitivity to revenue growth (if the acquisition is growth-driven) and to integration risks (CapEx requirements, margin assumptions). Also show a true downside scenario where growth doesn't materialize.

---

Realistic Assumptions and Investor Trust

The most sophisticated investors can spot unrealistic sensitivity ranges instantly. If your base case shows 12% growth but your sensitivity goes down to 8% growth, investors will wonder: "Why does the downside start at 8%? That's still healthy growth."

Your sensitivity ranges should be grounded in historical performance, market research, or explicit risk factors. For example:

"Our base case assumes 8% revenue CAGR. We've sensitized this to 5-10% to reflect potential variance based on: (a) historical growth has ranged from 4-11% depending on macro environment, and (b) our downside assumes only traction in three of four planned geographies, yielding ~5% growth. Our upside assumes accelerated international expansion, yielding ~10% growth."

This kind of explicit reasoning builds credibility. It shows you've thought about what scenarios are actually plausible and why.

Downside Scenarios: Make sure your downside scenarios are genuinely adverse, not just "slightly below base case." A true downside might combine lower revenue growth, flat margins, and a lower exit multiple. Show what happens in that scenario. This demonstrates you've stress-tested your thesis and aren't blindly betting on everything working perfectly.

---

Waterfall vs. Matrix: Which Format to Use

Both formats have merit. Here's how to choose:

Use a Matrix Sensitivity Table When:

• You want to show a range of outcomes across two dimensions
• Your audience cares about the magnitude of impact across different scenarios
• You need to show detail across many combinations of assumptions
• Color-coding helps the audience quickly grasp the range

Use a Waterfall/Tornado Chart When:

• You want to isolate the impact of individual assumptions
• You need to show which assumptions matter most
• Your analysis involves many variables and you want to prioritize what matters
• You're trying to communicate a simple insight ("Outcome depends mostly on X")

In many pitches, you'll use both. A matrix sensitivity table shows the range of outcomes. A waterfall sensitivity shows which assumptions drive that range.

---

Common Mistakes in Sensitivity Analysis

Overly Wide Ranges: A sensitivity showing outcomes across an unrealistically wide range of assumptions (e.g., 0% to 20% growth) makes the base case seem less robust. Stick to realistic scenarios.

Hidden Base Case: If your base case isn't visually distinct, investors might not recognize which scenario you actually believe in. Clearly label it.

Too Many Dimensions: A table with six input variables is incomprehensible. Limit to 2-3 dimensions, or break into multiple, simpler tables.

Inconsistent Assumptions: Don't show a sensitivity where revenue grows but margins stay flat when historically they're correlated. Show scenarios that are internally consistent.

Ignoring Downside Implications: Some pitches show upside and base case but avoid showing what happens in a real downside scenario. Address the downside explicitly. It builds confidence that you're not sugar-coating risks.

Failure to Explain Ranges: Investors want to understand why your ranges are what they are. Explain the basis for your sensitivity ranges, not just the numbers themselves.

---

Tools and Execution

Building sensitivity tables in Excel is straightforward: use formulas to link outputs to input assumptions, then create tables that vary inputs systematically. However, formatting these for presentation-ready layouts—with color gradients, clear labeling, and professional design—requires significant manual work.

Modern presentation tools like Poesius automate much of this. You can input your assumptions and output metrics, and the tool handles color-coding, layout, and formatting automatically. This saves time and ensures consistency across multiple sensitivity tables and presentations.

Whatever tool you use, ensure your sensitivity table is readable on a large screen. Text should be legible from the back of a boardroom. Color gradients should be clear and not strained to interpret.

---

Conclusion

Sensitivity analysis is one of the most important components of a credible investment banking pitch. But only if it's done right. A sensitivity table that's unclear, uses unrealistic ranges, or hides important assumptions actually undermines your credibility.

Focus on clarity and realism. Choose 2-3 assumptions that are both material and uncertain. Show realistic ranges grounded in historical data or explicit risk factors. Use color-coding and clear labeling to make the table easy to read. Most importantly, link your sensitivity analysis to your investment thesis. What do these sensitivities tell us about risk? Why do these assumptions matter?

A well-designed sensitivity table doesn't weaken your pitch—it strengthens it by demonstrating that you've stress-tested your assumptions and that your thesis is robust across reasonable scenarios. That's what builds investor confidence and separates strong pitches from weak ones.