“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.”
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.
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.
You are given the following outputs from the explicit forecast period, plus the ranges you'll test.
| Line Item | Value |
|---|---|
| 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 Test | 8.0% (0.08), 9.0% (0.09), 10.0% (0.10) |
| Terminal Growth Rate Scenarios to Test | 2.0% (0.02), 2.5% (0.025), 3.0% (0.03) |
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.
PV of Terminal Value = Terminal Value / (1 + WACC)^n
Using this formula, discount each Terminal Value back to the present.
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.
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.
Try answering out loud first — then reveal the model answer and compare.
No comments yet — be the first to ask a question.