Case 46 / 183 Analyst

Sensitivity Analysis: WACC vs. Terminal Growth Rate

Valuation & DCF

The prompt

“You've just finished building a DCF valuation and your MD asks how confident you are in the output. Build a sensitivity table that varies both your discount rate (WACC) and your terminal growth rate assumption, and tell her which of the two assumptions moves Enterprise Value more.”

📋 What you're given

You've just finished building a DCF valuation and your MD asks how confident you are in the output. Build a sensitivity table that varies both your discount rate (WACC) and your terminal growth rate assumption, and tell her which of the two assumptions moves Enterprise Value more.

1. Task Overview

Task: build a two-way sensitivity table for Enterprise Value across a range of WACC and terminal growth rate assumptions, then determine which assumption the valuation is more sensitive to.

Step 1: Given Data — Base Case DCF Outputs and Sensitivity Ranges

You are given the following outputs from the explicit forecast period, plus the ranges you'll test.

Line ItemValue
PV of Explicit-Period FCFs (Years 1–5)$150.0m
Year 5 (Terminal Year) FCF$100.0m
Discount Period (n)5 years
WACC Scenarios to Test8.0% (0.08), 9.0% (0.09), 10.0% (0.10)
Terminal Growth Rate Scenarios to Test2.0% (0.02), 2.5% (0.025), 3.0% (0.03)

Step 2: Terminal Value

Show Terminal Value Formula

Terminal Value = FCFₙ × (1 + g) / (WACC − g)

Using this formula, compute Terminal Value for each of the nine combinations of WACC and terminal growth rate.

Step 3: Present Value of Terminal Value

Show PV of Terminal Value Formula

PV of Terminal Value = Terminal Value / (1 + WACC)^n

Using this formula, discount each Terminal Value back to the present.

Step 4: Enterprise Value

Show Enterprise Value Formula

Enterprise Value = PV of Explicit-Period FCFs + PV of Terminal Value

Using this formula, compute Enterprise Value for each of the nine WACC/terminal growth combinations.

Step 5: Comparing the Two Sensitivities

Once you have all nine Enterprise Value outputs, hold the terminal growth rate constant and measure the spread in Enterprise Value across the three WACC scenarios. Then hold WACC constant and measure the spread across the three terminal growth scenarios.

💡 Model answer

Try answering out loud first — then reveal the model answer and compare.

⚠️ Common mistakes

  • Building a one-way sensitivity table (only varying WACC or only g) when the question asks for a two-way grid
  • Forgetting that the (WACC − g) denominator shrinks as g approaches WACC, causing Terminal Value to explode nonlinearly rather than move proportionally
  • Discounting Terminal Value using the wrong number of periods (n should match the last explicit forecast year, not n+1)
  • Concluding "WACC and growth matter equally" without actually measuring the range each one produces
  • Ignoring that a growth rate set above the long-run GDP/inflation rate makes the terminal value economically unrealistic, regardless of what the math produces

🔁 Follow-up questions

➡️ Related cases

Previous Case 45: Diluted Share Count Next Case 47: Full EV-to-Equity Bridge

⭐ Rate this case

0 ratings

💬 Comments (0)

No comments yet — be the first to ask a question.

Part of a 183-case learning path. Create a free account to save progress & unlock follow-up answers.
Create free account