DCF Sensitivity Analysis: Map WACC and Growth to Value

Key Takeaways

• DCF sensitivity analysis uses a two-variable Excel data table to show implied share price across a WACC and terminal growth rate grid, because those two inputs together typically drive 50 to 70 percent of DCF output.
• Shifting WACC from 8 to 7.5 percent and terminal growth from 2.5 to 3 percent tightens the Gordon growth denominator from 5.5 to 4.5 percent, a 22 percent increase in terminal value from two small assumption changes.
• Treating the corners of the grid as equally likely outcomes is the most dangerous misread; low-WACC plus high-growth is a correlated combination that demands a credible macro explanation, not just a table entry.
• Any DCF that swings more than 50 percent across a 100-basis-point WACC range is over-leveraged on its discount rate, signaling that the terminal value assumption dominates and deserves more scrutiny.

What It Is

A sensitivity analysis (also called a "what-if" table) varies one or two inputs across a range while holding everything else constant. In Excel it is usually built with a two-variable data table, with the input cells on the row and column axes and the target cell (typically implied share price or enterprise value) in the top-left corner.

The most common DCF sensitivities use WACC and terminal growth rate as the two axes, because those two assumptions together typically drive 50 to 70 percent of the valuation output. Other useful axes include exit multiple, EBITDA margin at maturity, and long-run revenue growth.

The Intuition

A single DCF number projects false precision. A share price calculation that looks like "$147.32" implies that the analyst knows WACC to three decimal places and can forecast 2030 revenue exactly. No one can.

Sensitivity analysis makes the uncertainty visible. Instead of "$147," the output becomes a grid showing $118 to $176 across a reasonable range, with the center of the grid at the base case. That grid is also the first thing investment committee members look at when deciding whether a DCF is credible. If the output swings 50 percent on a 100 basis point change in WACC, the DCF is too leveraged on its discount rate and needs wider justification.

How It Works

Three steps build the table.

1. Identify the two axes. Pick the inputs with the biggest impact per unit change. WACC and terminal growth are defaults. For asset-light businesses, EBITDA margin and revenue growth may matter more. For LBO-style models, exit multiple replaces terminal growth.

2. Pick plausible ranges. WACC sensitivities typically span 100 basis points above and below the base case in 25 basis point steps. Terminal growth ranges from about 1 percent (developed market inflation floor) to 3.5 percent (long-run GDP ceiling) in 50 basis point steps.

3. Build the data table. In Excel, use Data > What-If Analysis > Data Table. The row input cell is one assumption, the column input cell is the other, and the top-left cell references the output (usually implied share price or implied EV).

The key intuition from the Gordon growth formula explains why WACC and g matter so much:

Terminal value = FCF_n x (1 + g) / (r - g)

Small changes in the denominator (r minus g) produce large changes in value. At r = 8 percent and g = 2.5 percent, the denominator is 5.5 percent. Shifting r to 7.5 percent and g to 3.0 percent cuts the denominator to 4.5 percent, which raises terminal value by about 22 percent.

Worked Example

A hypothetical large-cap with $50 per share implied price at WACC 8.0 percent and terminal growth 2.5 percent. A two-way sensitivity across WACC and g might produce:

                Terminal growth rate
               1.5%    2.0%    2.5%    3.0%    3.5%
WACC  7.0%      54      58      63      70      80
      7.5%      49      52      56      61      68
      8.0%      44      47      50      54      59
      8.5%      40      42      45      48      52
      9.0%      36      38      41      43      47

Reading across any row shows how much value the model gives up for a half-point move in g. Reading down any column shows the same for WACC. If the stock trades at $45, the output is inside the plausible band in the bottom-left quadrant, suggesting the market is pricing the company near the conservative end of reasonable assumptions.

Common Mistakes

1. Treating any cell in the grid as equally likely. The corners of a 5x5 sensitivity grid combine worst-case assumptions with worst-case assumptions. Those joint probabilities are much lower than each cell suggests. A Monte Carlo simulation captures joint probability better than a grid, especially when inputs are correlated.

2. Picking the wrong two axes. Running sensitivity on WACC and tax rate for an asset-heavy industrial understates the real drivers (capex and EBITDA margin). The two axes should be chosen by testing which inputs produce the widest output dispersion per unit of change.

3. Using unrealistic ranges. A WACC range of 6 to 14 percent produces a meaningless grid because the extremes would not pass any committee. Keep the range to roughly plus or minus one to two standard deviations of reasonable estimates.

4. Forgetting that inputs are not independent. Higher growth often comes with higher reinvestment, higher beta, and higher WACC. A grid that lets g rise without touching WACC or capex over-values the top-right corner. Make the mechanical relationships explicit in the model or note them next to the table.

5. Not sensitizing the terminal value method. Two firms with identical discounted forecast cash flows can differ by 30 percent if one uses a growing perpetuity terminal and the other uses an exit multiple. Running the analysis under both methods is better practice than picking one.

Frequently Asked Questions

Q: What is DCF sensitivity analysis in simple terms? DCF sensitivity analysis runs the same discounted cash flow calculation across a grid of different WACC and terminal growth rate combinations, producing a table that shows how the implied share price changes with each pair of assumptions.

Q: How does DCF sensitivity analysis affect investment decisions? It converts a false-precision single price target into an honest range. If a stock trades at $45 and the sensitivity grid shows values from $36 to $63, the analyst can say with precision where the market price sits within the range of reasonable assumptions.

Q: What is a real-world example of DCF sensitivity analysis? A base-case DCF at WACC 8 percent and terminal growth 2.5 percent gives $50 per share. The two-way grid reveals that WACC 7 percent and growth 3.5 percent produces $80, while WACC 9 percent and growth 1.5 percent produces $36, a range the single number completely hides.

Q: How can investors use DCF sensitivity analysis? Investors should identify which assumption produces the widest output range per unit of change and direct their diligence work there. If the analysis is a margin story rather than a growth story, that reorients the due diligence focus entirely.

Q: How is DCF sensitivity analysis different from Monte Carlo simulation? DCF sensitivity analysis shows what happens if each input takes a specific value, one or two inputs at a time. Monte Carlo simulation draws inputs from probability distributions thousands of times to produce a full distribution of outcomes, accounting for the joint probability of correlated inputs occurring together.

Sources

1. Macabacus. "Discounted Cash Flow (DCF) Analysis, Steps, Examples, Templates." https://macabacus.com/valuation/dcf-overview
2. Wall Street Prep. "Sensitivity Analysis (What-If), Excel Tutorial Lesson." https://www.wallstreetprep.com/knowledge/financial-modeling-techniques-sensitivity-what-if-analysis-2/
3. Corporate Finance Institute. "Discounted Cash Flow DCF Formula Guide." https://corporatefinanceinstitute.com/resources/valuation/dcf-formula-guide/
4. Damodaran, A. "Discounted Cash Flow Valuation." NYU Stern. https://pages.stern.nyu.edu/~adamodar/pdfiles/eqnotes/dcfall2pgOld.pdf

Disclaimer

This article is educational content only and is not financial advice. Nothing here is a recommendation to buy, sell, or hold any security. Consult a licensed advisor before making investment decisions.