Valuation Sensitivity Tables Explained

Key Takeaways

• A sensitivity table pairs two varying inputs, usually discount rate and terminal growth rate or exit multiple, against a valuation output in a grid format.
• It exists because DCF and similar models can be highly sensitive to small changes in these assumptions, especially in the terminal value component.
• The table's purpose is to show a range of plausible outcomes rather than present one number as if it were precise.
• A wide spread across the grid is a signal about model sensitivity, not necessarily a sign the underlying analysis is flawed.
• Sensitivity tables are a diagnostic and communication tool, not a substitute for questioning the reasonableness of the underlying assumptions themselves.

What Is a Valuation Sensitivity Table?

A valuation sensitivity table is a two-dimensional grid built around a valuation model's output, most often the implied per-share value produced by a discounted cash flow analysis. Instead of reporting a single implied price, the analyst holds most of the model constant and lets two assumptions vary in a series of steps, recalculating the output at every combination. The result is a matrix where each cell shows what the valuation would be under that specific pairing of inputs.

The two axes are commonly the discount rate, often the weighted average cost of capital (WACC) used to bring future cash flows back to present value, on one side, and either the terminal growth rate or an exit multiple on the other. These two assumptions are singled out because they typically have an outsized effect on a DCF's terminal value, which is frequently the largest single piece of a company's total estimated value. Small shifts in either input can move the terminal value, and therefore the implied share price, by a large amount.

The table format itself is simple by design: rows represent one variable's range, columns represent the other's, and the intersection of each row and column shows the model's output at that combination. This layout is a well-established convention in financial modeling and spreadsheet tools for exploring how an output responds to changes in more than one input at a time.

How a Sensitivity Table Is Built

Building a valuation sensitivity table starts with a completed base-case valuation model, for example, a DCF that has already produced one implied share price using a chosen discount rate and terminal growth rate or exit multiple. From there, the process follows a consistent structure:

1. Choose the two variables to test. The most common pairing is discount rate and terminal growth rate (or, for an exit-multiple approach, discount rate and exit multiple), because these two inputs typically drive the terminal value.
2. Set a range for each variable. Each axis is stepped across a range around the base-case assumption, for instance, a discount rate range spanning a few percentage points above and below the base case, and a terminal growth rate or exit multiple range spanning a similarly plausible band.
3. Recalculate the model at every combination. The rest of the model, projected cash flows, share count, and any other assumptions, stays fixed. Only the two chosen variables change, and the model's valuation output is recalculated for each row-and-column pairing.
4. Arrange the outputs in a grid. Each cell in the resulting table holds the implied output, such as implied share price, for that specific combination of discount rate and terminal growth rate or exit multiple.

Because the underlying calculation is the same DCF (or other model) run repeatedly, a sensitivity table does not introduce a new valuation formula of its own. It is a way of visualizing how the existing model's output responds when two of its assumptions are varied together.

Worked Example

Hypothetical example, for education only. Suppose a base-case DCF model has already produced an implied share price of $52.00 using a discount rate of 9% and a terminal growth rate of 2.5%. To build a sensitivity table, an analyst holds every other input in the model fixed and reruns the DCF across a small grid of discount rates (8%, 9%, 10%) and terminal growth rates (2.0%, 2.5%, 3.0%). The illustrative results might look like this:

Reading the table, the base case ($52.00, at a 9% discount rate and 2.5% terminal growth rate) sits in the center cell. Moving just one row up, lowering the discount rate assumption by a single percentage point to 8%, lifts the implied price to $59.90, roughly 15% higher, with terminal growth held constant. Moving one row down to a 10% discount rate drops it to $46.00, roughly 12% lower. That spread, produced by changing only one assumption within a fairly ordinary-looking range, is the kind of sensitivity the table is built to surface.

How It's Used

A sensitivity table is generally used to test how much confidence to place in a single-point valuation output rather than to produce a new, more accurate number on its own. When the grid shows relatively similar values across a reasonable range of discount rates and terminal growth or exit multiple assumptions, that consistency suggests the valuation conclusion is less dependent on any one specific assumption. When the grid shows a wide spread. That is generally read as a signal that the valuation is highly sensitive to those particular inputs, and that the base-case output should be treated as one point within a range rather than a precise target.

Analysts commonly use sensitivity tables alongside other DCF outputs, such as separately testing a range of scenarios (bull, base, bear) or presenting a range of implied values rather than a single number in a research note. Because DCF and other valuation models are widely regarded as highly sensitive to their input assumptions, this range-based presentation is a commonly cited way of communicating uncertainty rather than overstating precision. The table does not, on its own, indicate which assumptions in the range are most realistic, that judgment still depends on separate research into the company's cost of capital, growth prospects, and comparable transaction or trading multiples.

Limitations and Common Mistakes

• The table only tests what it's told to test. A grid varying discount rate and terminal growth rate says nothing about sensitivity to revenue growth, margin assumptions, or capital expenditure forecasts unless those are separately varied too.
• A narrow or unrealistic range understates true sensitivity. If the chosen range of discount rates or growth rates is too tight, or centered on an already-aggressive base case, the table can create a false sense of stability.
• A wide spread is sometimes misread as a flaw in the model rather than a property of it. DCF-style models are commonly cited as inherently sensitive to discount rate and terminal value assumptions, a wide range in the table reflects that characteristic rather than necessarily indicating an error in the analysis.
• The table does not validate the assumptions themselves. It shows how the output changes, not whether any particular discount rate or growth rate in the grid is realistic for the company being valued.
• It can be presented without context. A sensitivity table shown without explaining which assumptions are most defensible, or without a base case clearly marked, can obscure rather than clarify the valuation conclusion.

Frequently Asked Questions

Related Reading

• Valuation Models Guide
• Fundamental Analysis Guide
• Debt Analysis
• Capital Allocation
• Free Cash Flow Explained
• P/E Ratio Explained
• Company Fundamentals Comparison Tool

References

• SEC EDGAR: full-text company filings, including the projected cash flow and cost of capital disclosures analysts draw on when building DCF models.
• SEC: How to Read a 10-K: guidance on locating the financial statement line items used as DCF model inputs.
• CFA Institute Research and Policy Center: research and educational materials on discounted cash flow analysis and valuation methodology.