Discounted Cash Flow Calculator DFC Template

In plain language: Identifies the parties relying on the DCF analysis — typically the buyer, seller, or both — and defines the specific asset or business being valued.

Common mistake: Failing to name the specific legal entity being valued. Using a trade name instead of the registered entity creates ambiguity when the analysis is referenced in a binding purchase agreement.

In plain language: States the explicit forecast horizon (typically 5 or 10 years) and the valuation date from which all cash flows are discounted.

Common mistake: Using a valuation date that does not match the transaction's effective date. Even a 30-day mismatch can materially change NPV and create disputes if one party argues the value should be recalculated.

In plain language: Sets out the projected annual free cash flows for each year of the explicit forecast period, showing operating income, tax, depreciation, capex, and working capital changes.

Common mistake: Projecting revenue growth without tying it to a specific operational assumption. An unsupported 20% annual growth rate is the single most common trigger for DCF disputes in transaction due diligence.

In plain language: Documents the calculation of the discount rate used, including the cost of equity (CAPM inputs), cost of debt, tax rate, and capital structure weights.

Common mistake: Using a single-point discount rate without documenting each CAPM input or data source. Courts and arbitrators reviewing disputed valuations routinely reject conclusions where the rate cannot be independently reconstructed.

In plain language: Specifies whether the terminal value is calculated using the perpetuity growth model or an exit multiple, and states the specific rate or multiple applied.

Common mistake: Applying a perpetuity growth rate that exceeds the long-run GDP growth forecast for the relevant economy. A terminal growth rate above 3–4% for a mature business implies the company will eventually grow larger than the entire economy, which undermines credibility.

In plain language: Presents the total NPV of projected cash flows plus terminal value, then deducts net debt to arrive at the implied equity value and per-share or percentage price.

Common mistake: Omitting net debt adjustment and presenting enterprise value as equity value. For leveraged companies, this can overstate equity value by 30–60%, directly misleading the buyer or investor.

In plain language: Provides a matrix showing how implied value changes across a range of discount rates and perpetuity growth rates, allowing both parties to understand the value's sensitivity to key assumptions.

Common mistake: Presenting only the single-point base case without a sensitivity table. A standalone NPV figure invites dispute the moment any assumption changes; a sensitivity range sets realistic negotiation boundaries for both parties.

In plain language: States that the projections reflect management's good-faith best estimates, based on information available as of the valuation date, and that no material facts have been withheld.

Common mistake: Using generic 'forward-looking statements' boilerplate without party-specific representations. Generic language provides no meaningful protection in litigation — named parties making named representations with a specific date are what courts enforce.

In plain language: Defines who may rely on the analysis, limits the preparer's liability for errors outside the defined scope, and states that the analysis is not a guarantee of future results.

Common mistake: No reliance limitation at all, or one that attempts to exclude all liability regardless of negligence. Courts regularly pierce over-broad exclusion clauses; a clearly scoped reliance clause is far more defensible.

In plain language: Both parties sign to acknowledge they have reviewed and agreed upon the valuation methodology, projection inputs, and discount rate, and that the output may be referenced in the binding transaction agreement.

Common mistake: Omitting signatures and treating the DCF as an informal spreadsheet attachment. An unsigned analysis attached to a purchase agreement creates uncertainty about whether the parties actually agreed to the methodology — which is the most common source of post-closing valuation disputes.

A discounted cash flow analysis is a valuation method that estimates the present value of a business, asset, or investment by projecting its future free cash flows and discounting them back to today's dollars using a rate that reflects the time value of money and the investment's risk. The result — net present value — tells you what those future cash flows are worth right now. DCF is one of the two most widely used business valuation methods, alongside comparable company analysis.

A DCF analysis is used whenever a transaction price is linked to the intrinsic value of future cash flows — including business acquisitions, private equity investments, earn-out disputes, joint venture equity splits, and capital project approvals. When the DCF output is referenced in a binding agreement — such as a purchase price clause or earn-out threshold — the analysis itself becomes a legally significant document that both parties should review and sign.

For a business valuation, the discount rate is typically the weighted average cost of capital (WACC) — a blended rate reflecting the after-tax cost of debt and the required return on equity, weighted by their share of the capital structure. For a project-level NPV, use a project-specific discount rate adjusted for the project's risk relative to the company's overall operations. Typical WACC ranges for private companies run from 10–20%, depending on size, industry, and leverage. Always document each CAPM input and its source.

Terminal value represents the present value of all cash flows beyond the explicit projection period, assuming the business continues operating indefinitely at a steady-state growth rate. It typically accounts for 60–80% of total enterprise value in a DCF, which means small changes in the terminal growth rate or discount rate have an outsized effect on the final valuation. Always present terminal value with a sensitivity analysis to show the plausible range of outcomes.

Enterprise value is the total value of the business attributable to all capital providers — debt and equity combined. Equity value is what shareholders own after deducting net debt (total debt minus cash). For a company with significant debt, the two figures can differ substantially. Always deduct net debt from enterprise value before presenting an equity value to buyers or investors, and define exactly what is included in net debt within the document.

A DCF analysis on its own is a financial model, not a contract. However, when the output is referenced in a binding agreement — for example, as the basis for a purchase price or earn-out calculation — and both parties sign an acknowledgment confirming they agree to the methodology and outputs, the analysis becomes a legally significant document that can be enforced or used as evidence in a dispute. An unsigned DCF attached to a purchase agreement provides much weaker protection.

For internal capital project approvals or preliminary investment screening, a well-structured template is usually sufficient. For transactions where the DCF output drives a binding purchase price, earn-out formula, or equity split, engaging a qualified financial advisor or business appraiser — and having a lawyer review how the analysis is referenced in the main agreement — is generally advisable. The cost of a professional review ($1,000–$5,000) is modest relative to the transaction values typically at stake.

The perpetuity growth model (Gordon Growth Model) is theoretically grounded and preferred when the business is expected to operate indefinitely with relatively stable long-run cash flows. The exit multiple method applies an industry EV/EBITDA multiple to terminal-year EBITDA and is easier to benchmark against comparable transactions. Many practitioners calculate both and use the results as a cross-check — if the two methods produce enterprise values within 10–15% of each other, the base-case assumptions are internally consistent.

In the United States, DCF analysis is the primary method required by Delaware courts for appraisal proceedings and is referenced in SEC fairness opinion guidance. In Canada, the Canadian Institute of Chartered Business Valuators (CICBV) sets professional standards for valuations used in litigation or regulated transactions. In the UK, the RICS Red Book and IVSC standards govern property and business valuations. In the EU, the International Valuation Standards (IVS) are increasingly referenced in cross-border M&A. A signed DCF document using recognized methodology strengthens enforceability in all of these contexts.