Common Mistakes in DCF Valuation
Executive Summary
Key Takeaways
- ✓ DCF errors fall into five broad categories - conceptual, accounting, Excel/modelling, terminal value/discount rate judgement, and presentation.
- ✓ Confusing enterprise value with equity value is the most common conceptual error, and mixing FCFF with the wrong discount rate is its most common technical counterpart.
- ✓ Every Excel/modelling-layer mistake in this guide maps to one or more of FMAE's existing structural audit rules, making it directly testable rather than only a matter of reviewer judgement.
- ✓ Terminal value concentration means errors in its assumptions or method carry a disproportionately large effect on the final valuation conclusion relative to most explicit-period errors.
- ✓ Presenting a DCF conclusion without disclosing its underlying sensitivity range and terminal value share is itself classified here as a mistake, not merely a stylistic choice.
Institutional Definition¶
DCF valuation mistakes fall into five recognizable categories: conceptual confusion, accounting errors in the cash flow build, Excel/modelling errors detectable by structural audit, terminal value and discount rate judgement errors, and presentation errors that omit required disclosure. This guide catalogs each category, cross-referenced to the technical guide covering correct construction and, for modelling-layer errors, the FMAE structural rule that detects it.
Category 1: Conceptual Errors¶
Confusing enterprise value with equity value. Treating an FCFF-derived enterprise value as if it were directly comparable to a per-share price, without applying the enterprise-to-equity bridge, is the most common conceptual error in DCF practice.
Mismatched cash flow basis and discount rate. Discounting FCFF at the cost of equity, or FCFE at WACC, is a direct technical consequence of the enterprise/equity confusion above, and produces an output that is neither correctly stated enterprise nor equity value.
Treating DCF as a single, precise point estimate. A DCF's precision of calculation is not the same as precision of estimate — presenting a single output figure with no disclosed range misrepresents the underlying uncertainty in the discount rate and growth assumptions.
Category 2: Accounting Errors in the Cash Flow Build¶
Using net income instead of free cash flow. Ignores non-cash charges, capital expenditure, and working capital investment — see Free Cash Flow.
Disconnected non-cash add-backs and capex lines. D&A add-backs or capex figures entered as standalone assumptions rather than linked to the depreciation schedule or capex schedule elsewhere in the model — see How to Build FCFF.
Inconsistent tax rate. The tax rate used in NOPAT differs from the rate used in the after-tax cost of debt calculation within WACC, producing an internally inconsistent model.
Category 3: Excel / Modelling Errors (Structurally Testable)¶
| Mistake | Maps to Structural Rule |
|---|---|
| Discount rate hardcoded inside the discounting formula | R012 (Hardcoded Rate Constant), R001 (Hardcoded Cells) |
| Unmanaged circular reference between WACC and enterprise value | R003 (Circular References) — see Resolving WACC Circularity |
| Terminal-value column formula silently inconsistent with the rest of the forecast row | R004 (Formula Inconsistency), R011 (Cross-Sheet Pattern Drift) |
| No dedicated, visible assumptions tab for WACC and growth rate | R016 (Missing Assumptions Tab) |
| No input validation preventing growth rate ≥ WACC | R026 (Missing Input Validation) |
| Sensitivity table converted to static values or excluded from automatic calculation | Addressed in full on Sensitivity Table Integrity |
The full mapping of DCF-specific structural checks to FMAE's rule taxonomy is set out in the DCF Model Audit Checklist.
Category 4: Terminal Value and Discount Rate Judgement Errors¶
Terminal value calculated on a distorted final year. A one-off capex spike or working capital swing in the final explicit forecast year, carried unnormalized into the terminal value calculation.
Growth rate too close to or above the discount rate. Beyond the mathematical constraint that g must be strictly below WACC, a growth rate near the top of what long-run GDP or inflation can plausibly sustain, with no disclosed justification.
No cross-check between terminal value methods. Calculating terminal value using only the perpetuity growth method (or only the exit multiple method), with no cross-check of the implied exit multiple (or implied growth rate) against the alternate method — see Terminal Value: Perpetuity Growth vs. Exit Multiple.
Undisclosed WACC inputs. Risk-free rate, beta source, or equity risk premium used without disclosing their source and date, preventing independent replication of the discount rate.
Category 5: Presentation Errors¶
No sensitivity table. Presenting a DCF conclusion as a single output figure without the WACC-and-growth-rate sensitivity grid that shows how concentrated the value is in those assumptions — see Sensitivity Analysis for DCF Valuation.
Terminal value share not disclosed. Omitting the percentage of total value represented by terminal value, obscuring how much of the conclusion rests on the terminal assumption rather than the explicit forecast.
No triangulation against relative valuation. Presenting DCF as the sole valuation method with no cross-check against comparable company multiples or precedent transactions — see DCF vs. Comparable Company Analysis.
Continue Reading¶
Prerequisites¶
- Discounted Cash Flow (DCF) Valuation — the parent pillar
Related Technical Guides¶
- DCF Valuation Best Practices
- How to Build Unlevered Free Cash Flow (FCFF)
- How to Build WACC (Step-by-Step)
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the most common DCF valuation mistake?
Discounting the wrong cash flow basis at the wrong rate — most commonly, treating unlevered free cash flow (FCFF) and enterprise value output as if they were levered free cash flow (FCFE) and equity value, or vice versa, without applying the correct discount rate or bridge for the basis actually used.
What Excel-specific mistakes are common in DCF models?
Hardcoding the discount rate inside the discounting formula rather than referencing a labelled assumption cell, leaving an unmanaged circular reference between WACC and enterprise value, and formula inconsistency in the terminal-value column relative to the rest of the forecast row.
What terminal value mistakes are most consequential?
Calculating terminal value from a distorted, non-normalized final forecast year, using a perpetuity growth rate too close to or above the discount rate, and failing to cross-check the perpetuity method's implied exit multiple against observed market multiples.
Is presenting a DCF without a sensitivity table considered a mistake?
Yes, in this guide's taxonomy. Given how concentrated DCF value typically is in the discount rate and terminal value assumptions, omitting the sensitivity disclosure that shows this concentration is treated as a presentation-layer mistake, not a neutral stylistic choice.
Do these mistakes apply equally to FCFF and FCFE-based DCFs?
Most apply to both, though some are specific to one basis — for example, an unmanaged WACC circularity is specific to FCFF/WACC valuations, while a mismatch between FCFE and its correct discount rate (cost of equity, not WACC) is specific to the levered approach.
Related Articles
Discounted Cash Flow (DCF) Valuation
Discounted cash flow (DCF) valuation values a business, project, or asset as the present value of the cash flows it is expected to generate in the future. It is the most theoretically grounded of the major valuation methodologies, resting directly on the principle that a dollar of cash flow is worth more today than the same dollar received in the future, and that value is created when future cash flows exceed what capital providers require as compensation for the time value of money and risk. This page is the hub for the Knowledge Centre's DCF content: what DCF is and why it works, how free cash flow and discount rates are built, how terminal value is calculated and stress-tested, the method variants practitioners choose between, and — distinctively — how DCF failure modes map onto FMAE's existing structural audit rule taxonomy, since no generic valuation resource ties DCF mechanics to a named, testable audit standard.
WACC (Weighted Average Cost of Capital)
WACC (Weighted Average Cost of Capital) is the rate of return that a company must earn on its existing assets to maintain the value of its equity and satisfy both its debt holders and equity investors. It is calculated as the weighted average of the after-tax cost of debt and the cost of equity, with the weights determined by the proportion of each in the total capital structure. WACC is used primarily as the discount rate in a discounted cash flow (DCF) valuation, where it converts projected free cash flows into present value. It is also used as a return hurdle: a project or investment is value-creating if its expected return exceeds the WACC.
Terminal Value
Terminal value (TV) is the estimated value, at the end of a financial model's explicit forecast period, of all cash flows that the asset or business is expected to generate beyond that period. In a discounted cash flow (DCF) analysis, the terminal value represents the present value of the perpetuity of cash flows from the terminal period onwards, discounted back to the valuation date. Terminal value is the single largest component of total enterprise value in most DCF analyses. It is typically significant because a business or asset's cash flow-generating life extends far beyond a practical explicit forecast period of 5 to 10 years.
FCFF (Unlevered Free Cash Flow)
FCFF (Free Cash Flow to Firm), also called unlevered free cash flow, is the cash a business generates that is available to all of its capital providers — both debt and equity holders — before any financing effects such as interest payments or debt repayment. FCFF is built from NOPAT by adding back non-cash charges and deducting capital expenditure and working capital investment. Because FCFF is calculated independent of capital structure, it is discounted at the weighted average cost of capital (WACC), and the resulting present value is enterprise value — the value of the operating business before deducting net debt to arrive at equity value.
DCF Model Audit Checklist
This checklist sets out the structural checks a DCF model should pass before being relied upon for an investment committee submission, lender review, or transaction decision. Each check maps to one or more of FMAE's existing 26 structural audit rules, distinguishing this checklist from a generic modelling best-practice list: every item here is something a deterministic structural audit engine can actually test, not a matter of methodology judgement.
DCF Valuation Best Practices
This guide synthesizes the construction and disclosure disciplines addressed throughout this Knowledge Centre's DCF coverage into a single, stage-by-stage best-practice reference: how to build free cash flow and the discount rate so every input is traceable, how to calculate and cross-check terminal value, how to disclose sensitivity so the concentration of value in a small number of assumptions is visible, and how to triangulate the DCF conclusion against other valuation methods rather than presenting it in isolation.