DCF Valuation: Complete Guide with Examples

What Is Discounted Cash Flow (DCF)?

Discounted cash flow (DCF) is a valuation method that estimates the intrinsic value of an investment, business, or project by forecasting its future free cash flows and discounting them back to their present value using a rate that reflects the risk and cost of capital involved. The sum of those discounted cash flows — plus a terminal value representing everything beyond the explicit forecast period — is the DCF value.

DCF is the foundation of intrinsic valuation in corporate finance. Unlike market-based approaches (which value a business relative to comparable companies), DCF asks: what is this business worth based on the cash flows it is expected to generate, independent of what the market is currently paying for similar businesses?

DCF is used across investment banking (M&A transaction pricing, fairness opinions), corporate finance (major capex decisions, acquisition appraisal), private equity (LBO entry and exit valuations), and equity research (public company intrinsic value assessment). It is the primary valuation methodology tested in ACCA AFM, CFA Level 2, and most MBA corporate finance courses.

The DCF Formula

Free Cash Flow to the Firm (FCFF) — How to Calculate It

FCFF is the cash the business generates from operations after capital investment and tax — but before any payments to debt or equity providers. It is the correct cash flow to discount at WACC, because WACC already incorporates the cost of both debt and equity. Including interest in FCFF and then discounting at WACC would count the cost of debt twice.

Terminal Value — The Most Sensitive Part of Any DCF

The terminal value captures the value of all cash flows beyond the explicit forecast period. In most DCF models, it represents 60–80% of total enterprise value — making it the single most influential component of the valuation. The Gordon Growth Model (perpetuity growth method) is the most widely used approach.

Exit multiple method — an alternative to Gordon Growth

The exit multiple approach calculates terminal value by applying an EV/EBITDA multiple to the final forecast year's EBITDA, rather than using a perpetuity formula. It is less theoretically rigorous (since multiples embed market sentiment) but widely used as a cross-check. A DCF analysis should ideally present both methods — if they produce materially different results, the assumptions need examination.

Choosing the Right Discount Rate

WACC is the appropriate discount rate for FCFF-based DCF when the business maintains a roughly constant capital structure and when the project or business being valued has risk characteristics similar to the firm's existing operations. It blends the after-tax cost of debt and the required return on equity, weighted by their respective market-value proportions.

When the capital structure changes significantly over the projection period — as in leveraged buyouts or highly geared project finance — the adjusted present value (APV) method is more appropriate. APV discounts FCFF at the ungeared cost of equity (removing the financing benefit) and adds the present value of financing side effects (primarily the interest tax shield) separately.

DCF Valuation — Full Worked Example

This example walks through a complete five-year DCF business valuation — FCFF projection, terminal value, WACC discounting, and the enterprise-to-equity bridge.

DCF in Excel: =XNPV() and =NPV()

Most DCF models are built in Excel. Two functions handle the discounting — and they behave differently in ways that matter.

=NPV() — common but limited

=NPV(rate, value1, value2, ...) — then subtract the Year 0 investment separately
Example: =NPV(0.09, C2:C6)  [where C2:C6 = Years 1–5 FCFFs]
Then add terminal value: + TV_PV cell

Critical limitation: =NPV() assumes cash flows arrive at equal annual intervals and starts discounting from period 1. It excludes Year 0 from its range. For a DCF valuation where Year 0 is the valuation date (not an investment outflow), this is manageable — but it requires care to avoid including Year 0 in the range or forgetting to handle it separately.

=XNPV() — the professional standard

=XNPV(rate, values, dates)
Example: =XNPV(0.09, B2:B7, A2:A7)
Where column A = actual dates for each cash flow, column B = FCFF values

=XNPV() uses actual calendar dates for each cash flow — essential when: the forecast period does not start on a clean year-end boundary; cash flows arrive at different points within the year; or the model uses quarterly or semi-annual projections. Finance teams building M&A models, LBO analyses, and project finance DCFs use =XNPV() as standard.

Building a DCF model in Excel — structure that works

• Separate input tab — WACC, growth rate, tax rate, capex assumptions. Every sensitivity test changes these inputs, not the model structure itself.
• FCFF projection tab — Revenue → EBIT → NOPAT → add depreciation → subtract capex → adjust for working capital. One row per line item, one column per year.
• Valuation tab — XNPV of explicit FCFFs + discounted terminal value = enterprise value. Then the bridge to equity value in clearly labelled rows.
• Sensitivity table — WACC on one axis, terminal growth rate on the other. Most DCF models in practice include a two-variable data table showing equity value across a WACC range of ±2% and growth rate range of ±1%.

Sensitivity Analysis and Scenario Testing

A DCF without sensitivity analysis is not analysis — it is a single-point estimate presented as fact. Every significant assumption in a DCF carries uncertainty; understanding how sensitive the valuation is to each assumption is what makes the model useful for decision-making.

Which assumptions to stress-test first

• Terminal growth rate: The highest-leverage assumption in any DCF. A 1% change in g typically moves enterprise value by 10–20% for a mature business, more for high-growth businesses. Always present a range.
• WACC: A 1% change in WACC typically moves enterprise value by 8–15%. WACC itself depends on beta, risk premium, and capital structure assumptions — each of which carries its own uncertainty.
• Revenue growth rate in the explicit period: For businesses with uncertain top-line trajectory, this is often the first driver to test. What does equity value look like if growth is 2% lower than the base case?
• Operating margin: Particularly relevant for businesses with operating leverage — where small revenue changes produce large EBIT and FCFF changes.
• Capex intensity: High-capex businesses are very sensitive to capex assumptions. A 10% increase in annual capex can reduce FCFFs significantly, compounding over the forecast period.

DCF vs Comparable Company Multiples

In practice, investment banks present a "football field" chart — a horizontal bar chart showing the valuation range from each method (DCF, comparable companies, precedent transactions, LBO analysis). This gives decision-makers a visual sense of the valuation range and the uncertainty in each approach rather than a single point estimate.

How Finance Professionals Use DCF

The Most Common DCF Errors

• 🏦
  Not deducting debt to find equity value

  Enterprise value is not equity value. DCF of FCFF at WACC gives what is attributable to all capital providers — debt holders and equity holders. Deduct net debt (at market value) to find equity value. This error appears in ACCA AFM exam scripts, in student models, and occasionally in real-world presentations by junior analysts.

• 💰
  Deducting interest when calculating FCFF

  WACC already incorporates the cost of debt. Deducting interest from operating cash flows before discounting at WACC double-counts the cost of debt and understates enterprise value. FCFF is calculated from EBIT × (1 − t) — always pre-interest.

• 📈
  Terminal growth rate set too high

  Setting g above long-term GDP growth implies the business will eventually outgrow the entire economy. Even a terminal growth rate that seems modest (4–5%) produces enormous terminal values that dominate the DCF. Mature businesses should use terminal growth rates of 1–3%. Any higher requires explicit justification.

• 🔄
  Inconsistent assumptions between explicit period and terminal value

  A DCF model that projects 15% revenue growth for five years and then assumes 2% in perpetuity contains a cliff that the model doesn't explain. The transition from high-growth explicit period to steady-state perpetuity should be smooth — either through a fade period or through explicit justification of why growth normalises suddenly at year five.

• 📐
  Using book value of debt instead of market value in the bridge

  The enterprise-to-equity bridge should use market value of debt. For listed debt, this is available. For bank loans or private debt, book value is used as an approximation — but in high-interest-rate environments where book and market value of debt diverge significantly, this can materially affect equity value.

• 📊
  No sensitivity analysis presented

  A single-point DCF value without sensitivity analysis misrepresents the precision of the model. Given that terminal value typically represents 70–80% of enterprise value and depends on assumptions that are inherently uncertain, presenting only a base case is misleading. At minimum, present equity value under base, optimistic, and pessimistic assumptions for the terminal growth rate and WACC.

• 🌍
  Using today's exchange rate for all years in a multi-currency DCF

  For businesses with foreign currency cash flows, each year's FCFF must be converted at the appropriate forecast exchange rate — derived using purchasing power parity or interest rate parity for each individual year. Using today's spot rate for all years ignores the time value of exchange rate differences and produces an incorrect valuation. This is a specific and frequently cited error in ACCA AFM overseas investment appraisal questions.

Real Questions People Ask About DCF

DCF Interview Questions — Investment Banking and Corporate Finance

• Q: Walk me through a DCF.

  Strong answer: Project free cash flows to the firm (FCFF = NOPAT + D&A − Capex ± ΔWC) for 5–10 years. Choose a discount rate (WACC for FCFF). Calculate terminal value using Gordon Growth Model (FCFFₙ₊₁ ÷ (WACC − g)) or exit multiple. Discount all cash flows and the terminal value to today. Sum to get enterprise value. Subtract net debt and add cash to get equity value. Divide by shares outstanding for per-share intrinsic value. Anchor with a real-world example if possible.

• Q: What are the main limitations of a DCF?

  Strong answer: The terminal value dominates (typically 70–80% of EV) and depends on a growth rate assumption that is inherently uncertain. WACC is built on beta, which is backward-looking and market-dependent. Small changes in terminal growth rate or WACC produce large value swings — the model is precise but not necessarily accurate. DCF also ignores real options (the value of flexibility to expand, delay, or abandon). For this reason, DCF is always used alongside comparable company multiples, not in isolation.

• Q: How does WACC affect a DCF, and what would make you use a higher WACC?

  Strong answer: WACC is the hurdle rate — a higher WACC discounts future cash flows more aggressively, reducing DCF value. It embeds both the risk of the business (through beta in the cost of equity) and the financing structure (through the debt/equity blend). You would use a higher WACC for: businesses in higher-risk markets or industries, companies with volatile earnings, emerging-market operations, or projects that are riskier than the firm's core business. You should never use the firm's standard WACC for a diversification acquisition with materially different risk characteristics.

• Q: Why is terminal value such a large proportion of DCF value?

  Strong answer: The explicit forecast period captures only a finite number of years — typically 5–10. Most businesses are expected to continue generating cash flows well beyond this period. The terminal value, calculated as a perpetuity, captures all of those infinite future cash flows in a single discounted figure. Because those perpetual cash flows are summed mathematically and then discounted back a relatively short number of years, the present value is substantial. The practical implication is that any DCF analysis is highly sensitive to the perpetual growth rate assumption, which should always be stress-tested.

• Q: If you could only use one valuation method, would you use DCF or multiples?

  Strong answer: DCF — because it measures intrinsic value based on the business's own fundamentals, not what the market is currently paying for comparable businesses. Multiples embed market sentiment: if the entire sector is overvalued, multiples-based valuation will overpay. DCF is theoretically grounded. That said, in practice you would never rely on one method alone — the real skill is triangulating DCF, trading multiples, and transaction multiples to understand the valuation range and where the points of uncertainty lie.

Related Guides on Eduyush

• NPV complete guide — formula, step-by-step calculation, Excel functions, real jobs, and interview questions
• AFM business valuation methods — P/E, FCFF, dividend growth model, and when to apply each
• ACCA AFM mistakes guide — all recurring failure patterns with fixes across calculations and discussion
• AFM hedging guide — collars, futures, options, FRAs fully worked through
• Browse all AFM articles on Eduyush

More Finance Reading on Eduyush

• All 13 ACCA subjects explained
• What is the hardest ACCA paper?
• How to pass ACCA AFM — study plan, topic priorities, exam technique
• ACCA exam dates 2026

Frequently Asked Questions