Sensitivity Analysis and Scenario Modeling in a DCF

Introduction

A DCF model that produces a single implied enterprise value is not a complete analysis. Given the sensitivity of the output to key assumptions (particularly WACC and the terminal value), presenting one number implies a level of precision that the methodology cannot deliver. Sensitivity analysis and scenario modeling are the tools that transform the DCF from a point estimate into a defensible range.

Every DCF presented in a pitchbook, fairness opinion, or board presentation includes sensitivity analysis. It is not optional.

Sensitivity Table (Data Table)

A grid in a DCF model that displays the implied valuation output across a range of values for two key input assumptions. In Excel, this is built using the Data Table function (What-If Analysis), which recalculates the model output for every combination of the two input variables. The standard format places one variable on the horizontal axis and the other on the vertical axis, with the base case highlighted in the center. Sensitivity tables are the primary tool for communicating the range of DCF outcomes and are a required component of every investment banking pitchbook and fairness opinion.

The standard sensitivity output shows the implied enterprise value (or equity value per share) across a grid of two key variables. The most common pairings:

WACC vs. Terminal Growth Rate

Used when the terminal value is calculated via the perpetuity growth method. The table shows how the output changes as WACC varies (typically in 0.5% increments) and the terminal growth rate varies (in 0.25% increments).

WACC vs. Exit Multiple

Used when the terminal value is calculated via the exit multiple method. The table shows WACC on one axis and the exit EV/EBITDA multiple on the other (in 0.5x increments).

Reading a Sensitivity Table

Consider a sensitivity table showing implied share price across WACC (8.0-10.0%) and exit multiple (9.0-12.0x):

If the base case is 9.0% WACC and 10.5x exit multiple (implying approximately $24.40 per share), the table shows the reader that the implied value could range from $17.10 (high WACC, low multiple) to $33.30 (low WACC, high multiple). The width of this range is itself informative: a narrow range suggests robust valuation; a wide range signals high assumption sensitivity.

While sensitivity analysis varies one or two inputs mechanically, scenario analysis builds distinct cases with internally consistent assumption sets:

Each scenario adjusts multiple assumptions simultaneously to create a coherent picture. The downside case does not just lower revenue; it also adjusts margins (which may compress under pressure), capex (which may increase or decrease depending on the scenario), and possibly the WACC (if the company becomes riskier).

In the Football Field Chart

The DCF bar on the football field chart typically shows the range from the 25th percentile to the 75th percentile of the sensitivity table, or the range from the downside to the upside scenario. The midpoint corresponds to the base case.

In the Sensitivity Table Exhibit

The sensitivity table itself appears as a standalone exhibit in most pitchbooks and fairness opinions. The base case cell is typically highlighted or bolded, and the range of "reasonable" outcomes (within the light blue or gray shaded area) is visually distinguished from extreme scenarios at the corners of the table.

In the Narrative

The banker does not just present the numbers. They provide context: "The DCF analysis implies an enterprise value range of $4.5-5.8 billion, with a base case of $5.1 billion. The range is driven primarily by assumptions around revenue growth (7-12% over the projection period) and the exit multiple (9-11x), with WACC sensitivity of approximately $300 million per 50 basis points." This narrative helps the client understand what drives the range and where the key judgment calls lie.