DCF Model Audit Checklist

Checklist • Intermediate • 4 min read

Audience: Auditors • Model Developers • Investment Committees • Lenders
Last Reviewed: July 2026
Updated: Version 1.0

Executive Summary

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.

Key Takeaways

✓ Every check on this list maps to one or more of FMAE's existing 26 structural rules, making it a testable audit checklist rather than a general best-practice guide.
✓ Discount rate, terminal value, and the EV-to-equity bridge are the three areas of highest audit priority in a DCF model, given their outsized effect on total value.
✓ A structural audit confirms the model is well-formed and internally consistent; it does not confirm the underlying growth, margin, or multiple assumptions are commercially reasonable.
✓ This checklist is designed to be used alongside, not instead of, the broader Financial Model Audit Checklist family for non-DCF-specific structural risks.

Purpose¶

This checklist sets out the structural checks a DCF model should pass before its output is relied upon for an investment decision, lender submission, or board approval. Every item below maps to one or more of FMAE's existing 26 structural audit rules — this is a testable checklist, not a general list of modelling preferences.

1. Discount Rate Construction¶

[ ] Risk-free rate, beta, equity risk premium, and cost of debt are each traceable to a labelled, sourced assumption cell — not hardcoded inside the WACC formula (R012, R001)
[ ] Capital structure weights are based on market values or a stated target structure, not book values
[ ] Capital structure weights are consistent with the structure modelled in the debt schedule and balance sheet elsewhere in the model
[ ] Any circular reference between WACC, enterprise value, and capital structure weights is either eliminated (fixed target weights) or controlled with documented convergence settings (R003)
[ ] The tax rate used in the after-tax cost of debt matches the rate used in the NOPAT/FCFF build
[ ] Beta source is disclosed: observed (listed company) or derived from comparables with unlevering/relevering shown

2. Free Cash Flow Construction¶

[ ] The cash flow basis (FCFF or FCFE) is stated explicitly and matches the discount rate applied (WACC for FCFF, cost of equity for FCFE) — a mismatch is one of the most consequential possible errors
[ ] Non-cash add-backs (D&A) link to the depreciation schedule, not a disconnected hardcoded figure (R011, R024)
[ ] Capital expenditure links to the capex schedule, not a standalone assumption
[ ] Working capital movements derive from the balance sheet, not an isolated percentage-of-revenue assumption disconnected from the balance sheet build
[ ] Formulas are consistent across the full forecast row, with no silent divergence in the terminal or final column (R004, R011)

3. Terminal Value¶

[ ] The terminal-year cash flow used is normalized, with any one-off item (capex spike, working capital swing) removed before the terminal value calculation
[ ] If perpetuity growth is used, the growth rate is strictly below the discount rate, with input validation preventing g ≥ WACC (R026)
[ ] The perpetuity growth rate is benchmarked against long-run GDP or inflation expectations, with the benchmark and source disclosed
[ ] If the exit multiple method is used, the multiple is sourced from current, comparable trading or transaction data, with the source and date disclosed
[ ] The implied exit multiple (from the perpetuity method) or implied growth rate (from the exit multiple method) has been cross-checked against the alternate method
[ ] Terminal value's share of total enterprise value is calculated and disclosed

4. Enterprise-to-Equity Bridge¶

[ ] Net debt, minority interests, and preferred stock are each deducted, sourced from the balance sheet at the correct valuation date (R021, if dependent on a hidden sheet without a visible trace)
[ ] Non-operating assets (excess cash, non-core investments) are added where applicable
[ ] Diluted share count (not basic) is used to calculate value per share, with dilutive securities (options, converts, warrants) reflected via an appropriate method (e.g. treasury stock method)

5. Structural Hygiene¶

[ ] No volatile functions (OFFSET/INDIRECT) are used inside the discounting or terminal value formulas in a way that risks silent breakage (R005)
[ ] No IFERROR wraps mask a broken terminal value or EV bridge calculation (R013)
[ ] Discount factor and terminal value formulas are not overly complex or nested to the point of being unauditable (R014)
[ ] No repeated hardcoded literals (e.g., the same WACC value pasted into multiple cells instead of referencing one assumption cell) (R019)
[ ] Row/column insertion has not broken anchor references in the discounting or terminal value formula (R020)
[ ] Named ranges used for WACC or terminal growth are not orphaned or pointing to the wrong cell (R025)
[ ] No merged cells exist in the sensitivity table's data region, which would break data-table mechanics (R022)

6. Sensitivity and Disclosure¶

[ ] A two-way sensitivity table of enterprise value (or equity value) against WACC and growth rate (or exit multiple) exists
[ ] The discount rate build-up is disclosed line by line (risk-free rate, ERP, beta source, cost of debt, tax rate, gearing)
[ ] Real vs. nominal basis and mid-year convention usage (if applicable) are explicitly stated

What This Checklist Does Not Cover¶

Passing every item above confirms the model is structurally sound: internally consistent, free of the formula-level defects this checklist tests for, and transparent about its key assumptions. It does not confirm that the underlying commercial assumptions — the specific revenue growth rate, margin trajectory, discount rate level, or exit multiple chosen — are themselves reasonable for the business being valued. That determination is a matter of commercial and methodological judgement, addressed through triangulation against comparables and precedent transactions, not through structural checklisting.

Continue Reading¶

Prerequisites¶

Discounted Cash Flow (DCF) Valuation — the parent pillar

Financial Model Audit Engine (FMAE) — deterministic structural auditing referenced throughout this checklist

How OXXON tests thisRun a free structural check with FMAE

Frequently Asked Questions

What does this checklist cover that a general model audit checklist doesn't?

This checklist isolates the checks specific to DCF mechanics — discount rate construction, terminal value calculation, and the enterprise-to-equity bridge — each mapped explicitly to the existing structural rule that detects it. General structural risks (broken links, inconsistent formulas elsewhere in the model) are covered by the broader Financial Model Audit Checklist family.

Can this checklist be used for both FCFF and FCFE-based DCF models?

Yes. Most checks apply to either approach; where a check is specific to one method (such as the discount rate matching the cash flow basis), both variants are addressed explicitly.

Does passing every check on this list mean the valuation conclusion is correct?

No. Passing this checklist confirms the model is structurally sound — internally consistent, free of the formula-level errors it tests for, with transparent and traceable assumptions. It does not confirm that the growth rate, margin trajectory, discount rate level, or multiple chosen are themselves commercially reasonable, which is a matter of methodology and judgement, not structural testing.

Who should use this checklist?

Model auditors and reviewers performing a structural review of a DCF model, investment committee members assessing whether a submitted DCF model has been independently checked, and model developers self-reviewing before submission.

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.

How to Build WACC (Step-by-Step)

Building WACC correctly requires three separate sub-builds — cost of equity via CAPM, after-tax cost of debt, and capital structure weights — combined into a single weighted average. Each sub-build has its own inputs, sources, and common errors, and the overall WACC figure is only as reliable as the weakest of its components. This guide walks through each step in order, the capital structure weighting convention (market values, not book values), and the structural checks that confirm the build is internally consistent with the rest of the model, including the circularity that arises when capital structure weights depend on a total value that itself depends on WACC.

How to Build Unlevered Free Cash Flow (FCFF)

Building unlevered free cash flow (FCFF) correctly is the first mechanical step of an FCFF-based DCF valuation. FCFF starts from NOPAT — operating profit adjusted for a hypothetical unlevered tax charge — and is adjusted for non-cash charges, capital expenditure, and working capital movements to arrive at the actual cash generated by the business, available to all capital providers before financing effects. This guide walks through the build line by line, the two equivalent construction methods (from NOPAT and from cash flow from operations), and the structural checks that confirm each line is properly linked to the rest of the model rather than entered as a disconnected assumption.