DCF Sensitivity Table: The Two Key Assumptions That Move Everything
- Sanzhi Kobzhan
- Dec 18, 2025
- 5 min read
Updated: Apr 6
Table of Contents:
Discounted Cash Flow (DCF) analysis is a powerful way to estimate a stock’s intrinsic value (fair value) by forecasting future free cash flows and discounting them to today.
However, DCF is famously highly sensitive to just a few inputs. In fact, even a 1% tweak in the discount rate or a small shift in long-term growth assumptions can change the outcome by tens of percents. This means a DCF output isn’t a single precise number but rather a range of plausible values.
Analysts overcome this by stress‑testing the model: building sensitivity tables to see how valuation swings under different assumptions.
Two Key Drivers: Discount Rate vs. Growth Rate
In practice, two assumptions dominate a DCF: the discount rate (WACC) and the long-term growth rate (often in the terminal value). All other inputs (like profit margins or capex) matter, but these two usually “move everything”.
For clarity, think of them in turn:
Discount Rate (WACC)
This is the “required return” blending equity and debt costs. A higher WACC means future cash flows are discounted more steeply, shrinking present value. In fact, analysts note that “a mere 1% alteration in WACC can influence firm value by up to 20%”. Even a single percentage-point change can swing enterprise value by double-digit percentages. (For example, raising WACC from 8% to 9% might cut a DCF value by ~15–20%.) Because WACC multiplies over all cash flows, it has an outsized effect on the output.
Growth Rate (Terminal & Forecast Growth)
This captures how fast cash flows grow in the future. In a perpetual-growth terminal model, even tiny changes in the assumed growth rate (often tied to inflation or GDP) have large effects, since the terminal value often dwarfs the explicit forecast.
One analysis shows that bumping the terminal growth from 1.5% to 2.5% shifts equity value by 15–30%. And in a real Amazon DCF model, for example, about 78% of the total present value came from the terminal value. This means any tweak to the long-term growth assumption instantly multiplies through that massive chunk of value. (In short, higher growth ≈ higher value – but even a 0.5–1% difference can change the DCF price dramatically.)
Because WACC and long-term growth dominate, practitioners almost always highlight them in sensitivity analyses. Financial training sites advise building “data tables” around WACC vs. growth to see the range of possible valuations. In essence, the DCF model should be “sensitized” so you get a valuation range instead of one flat number.
How to Build a DCF Sensitivity Table
To capture this uncertainty, analysts create an Excel-style DCF sensitivity table (often called a “data table”). The idea is simple: pick a range of values for each key assumption and compute the implied value for every combination. For example:
List a range of discount rates (e.g. 6%, 7%, 8%, 9%) down the rows.
List a range of long-term growth rates (e.g. 1.5%, 2.0%, 2.5%, 3.0%) across the columns.
Fill each cell with the model’s output (enterprise or equity value) under that pair of assumptions.
Try my Free DCF Calculator that also includes Sensitivity Table.
This can also be done manually or using Excel’s built-in What-If Analysis > Data Table feature. The result is a matrix that instantly shows how valuation changes. This visual “Excel table” makes it clear which scenarios produce higher or lower prices.
A few guidelines help ensure the table is correct and interpretable:
Stay Focused: Only vary one assumption per axis (usually WACC on one axis, growth on the other) so it’s easy to read.
Use Realistic Ranges: Pick a plausible high/low range for each input. For example, if WACC is 8% in the base case, try 7%–9%; if growth is 2%, try 1.5%–3%. (Sometimes analysts add one extreme scenario like “negative growth.”)
Recalculate Everything: Make sure all cash flows and intermediate values update when the inputs change. Sensitivity only works if the model is dynamic.
Check for Errors: Common pitfalls (like linking table inputs to other sheets) can break the table, so build it on the same sheet or hard-code the central values.
When done correctly, the table will display a range of DCF values. We can then report a valuation spectrum or highlight the mid-point and range as our “fair value” estimate. In fact, the Stocks2Buy Fundamentals Analyzer app automates this: it shows each stock’s DCF-based target price (intrinsic value) along with other key indicators for multiple scenarios.
Examples of Sensitivity in Action
Real-world cases illustrate why this matters. Consider these examples:
Amazon (Tech/Cloud) – One DCF model of Amazon found that the 5-year cash flows only contribute ~$463B to PV, while the terminal value contributes ~$1.4T (out of ~$1.8T total). In other words, ~78% of the firm’s value comes from the far future. That means if Amazon’s assumed growth or WACC changes, it moves that $1.4T big piece of the pie. A +0.5% cut in WACC or a +0.5% bump in growth would spike the DCF value by dozens of billions.
High-Growth Tech – Companies like Tesla or Netflix are known examples: their entire valuation often hinges on strong growth projections. Any analyst using DCF on a fast-grower will find a wide range of valuations depending on whether you assume “sky’s-the-limit” growth or more modest trends. (One popular analysis noted that for NVIDIA, the implied 10-year FCF growth needed to justify its price was extremely high, illustrating there was “probably no margin of safety” in the base assumptions.)
These cases underline a key point: small assumption changes ➔ big swings in value. That’s why using sensitivity tables (or at least showing “best case / worst case”) is standard practice. For investors, it means never trusting a single DCF output in isolation. Instead, always ask: How would the target price change if WACC or growth were slightly different?
DCF is powerful but only as good as its assumptions. By focusing on the two main drivers (discount rate and growth), analysts can reveal the range of plausible target prices for any stock. Sensitivity tables help make this transparent: they show, in an “Excel-style” matrix, exactly how valuation shifts under alternate scenarios. This disciplined approach gives traders and investors a more realistic view of a company’s worth and risk.
FAQ — DCF Valuation, Discount Rate, and Sensitivity Analysis
What is a DCF valuation in stock analysis?
Discounted Cash Flow (DCF) analysis estimates a stock’s intrinsic value by forecasting future free cash flows and discounting them back to present value. It helps investors determine whether a stock may be overvalued or undervalued.
Why is DCF analysis sensitive to assumptions?
Small changes in key inputs like the discount rate (WACC) or long-term growth rate can significantly alter valuation results. Because much of a company’s value often comes from future cash flows, even minor tweaks can cause large swings in estimated fair value.
What is the discount rate (WACC) in a DCF model?
The Weighted Average Cost of Capital (WACC) represents the required return investors expect for providing capital. A higher discount rate reduces present value estimates, while a lower rate increases calculated intrinsic value.
How does the terminal growth rate affect DCF valuation?
The terminal growth rate reflects expected long-term expansion beyond the forecast period. Since terminal value can represent most of a company’s valuation, even small changes in this assumption can materially impact the final DCF price target.
What is a DCF sensitivity analysis table?
A sensitivity table shows how intrinsic value changes under different combinations of discount rates and growth assumptions. It helps investors understand valuation ranges rather than relying on a single estimate.
Should investors rely solely on DCF valuation?
No, DCF is a useful valuation tool but should be combined with other metrics like earnings growth, profitability, debt levels, and market comparisons. Using multiple methods provides a more balanced investment decision.
Comments