Discounted Cash Flow (DCF) Analysis: Step-by-Step Guide

The discounted cash flow model is the gold standard of intrinsic valuation. Unlike relative methods such as trading comps or precedent transactions, DCF values a business based on its own projected cash generation rather than what the market is paying for similar companies. That independence makes DCF indispensable in M&A, but it also means the output is only as reliable as the assumptions you feed into it. This guide walks through every step of a rigorous DCF, from revenue projection through sensitivity analysis, with the formulas, frameworks, and practical tips you need to build a defensible model.

What Is a DCF Analysis?

A discounted cash flow analysis estimates the present value of a business by forecasting the cash it will generate in the future and then discounting those cash flows back to today at an appropriate rate. The core principle is simple: a dollar received next year is worth less than a dollar received today, because of inflation, opportunity cost, and risk. DCF quantifies that difference.

The fundamental equation is:

Enterprise Value = Σ [FCFₜ / (1 + WACC)ₜ] + Terminal Value / (1 + WACC)ⁿ

Where FCFₜ is the unlevered free cash flow in year t, WACC is the weighted average cost of capital, and the terminal value captures all cash flows beyond the explicit forecast period.

When to Use DCF in M&A

DCF is most powerful when you can build a credible forecast. It excels in situations where the target has stable or predictable cash flows, where you need to model specific synergies or restructuring scenarios, and where comparable companies are scarce or fundamentally different. Investment banks use DCF as the anchor valuation in virtually every fairness opinion and acquisition model.

DCF is less useful for early-stage companies with negative cash flows and uncertain paths to profitability, for highly cyclical businesses where five-year projections are speculative, and for financial institutions where cash flow definitions differ materially from industrial companies. Even in those cases, a modified DCF (such as a dividend discount model for banks) is often employed alongside other valuation methods.

The Five-Step DCF Process

Step 1: Project Free Cash Flows

The forecast period typically spans five to ten years, depending on the business’s maturity and the visibility of its revenue drivers. For stable, mature businesses, five years is standard. For high-growth companies or businesses undergoing transformation, seven to ten years may be required to reach a normalized state.

Revenue Projection

Start with the top line. Analyze historical revenue growth rates, market size and growth, competitive positioning, pricing power, and customer pipeline. For each year of the projection, estimate revenue using a combination of top-down (market share x market size) and bottom-up (unit volume x price) approaches. Year-one projections should tie closely to management budgets and recent run rates. Growth rates should converge toward industry averages or GDP growth by the end of the forecast period.

Margin Assumptions

Project EBITDA margins based on historical trends, industry benchmarks, and specific operational improvements. Key drivers include gross margin trajectory (input cost trends, pricing power, product mix), operating leverage (fixed vs. variable cost structure), SG&A as a percentage of revenue (with adjustments for EBITDA normalization), and the impact of any planned synergies in an M&A context.

Capital Expenditures

Separate maintenance capex (required to sustain current operations) from growth capex (investments to expand capacity or enter new markets). Maintenance capex typically runs at 50-80% of depreciation for asset-light businesses and 80-120% for capital-intensive industries. Growth capex should correlate with revenue growth assumptions.

Working Capital

Model changes in net working capital as a percentage of revenue or revenue growth. Key components include days sales outstanding (DSO), days inventory outstanding (DIO), and days payable outstanding (DPO). For most businesses, working capital consumes cash as revenue grows. Calculate the cash conversion cycle (DSO + DIO - DPO) and project it forward. Seasonal businesses require more granular quarterly modeling.

The unlevered free cash flow formula is:

UFCF = EBIT × (1 - Tax Rate) + D&A - Capex - ΔNWC

Step 2: Determine the Discount Rate (WACC)

The weighted average cost of capital blends the cost of equity and the after-tax cost of debt, weighted by their proportions in the target capital structure. WACC represents the minimum return that investors -- both equity holders and lenders -- require for providing capital to the business.

WACC = (E/V) × Ke + (D/V) × Kd × (1 - T)

Where E is equity value, D is debt value, V = E + D, Ke is cost of equity, Kd is pre-tax cost of debt, and T is the marginal tax rate.

Cost of Equity via CAPM

The Capital Asset Pricing Model remains the most widely used framework for estimating the cost of equity:

Ke = Rf + β × (Rm - Rf) + Size Premium + Company-Specific Premium

The risk-free rate should match the currency and duration of the cash flows (typically a 10-year government bond). Beta measures the stock’s sensitivity to market movements. For private companies, use the unlevered beta of comparable public companies, then relever it at the target capital structure using the Hamada equation:

βₗ = βₘ × [1 + (1 - T) × (D/E)]

Size premiums compensate for the higher risk of smaller companies. Kroll’s Cost of Capital Navigator provides empirical size premiums ranging from near zero for mega-caps to 5-6% for micro-caps. A company-specific risk premium of 1-3% is sometimes added for private company risks such as key-person dependency, customer concentration, or limited financial reporting.

Cost of Debt

The pre-tax cost of debt reflects the yield lenders require on comparable-rated corporate bonds. For private companies without a credit rating, estimate the synthetic rating using interest coverage ratios (EBITDA / Interest Expense). A coverage ratio of 3-4x implies a BBB-equivalent rating with spreads of 150-250 bps over the risk-free rate. Always use after-tax cost of debt in the WACC formula, since interest payments are tax-deductible.

For a typical mid-market M&A target with Ke = 12%, Kd = 6%, T = 25%, and a 30/70 debt/equity split, WACC calculates as:

WACC = 0.70 × 12% + 0.30 × 6% × (1 - 0.25) = 8.4% + 1.35% = 9.75%

Step 3: Calculate Terminal Value

Terminal value captures the value of all cash flows beyond the explicit forecast period. In most DCFs, terminal value represents 60-80% of total enterprise value, which underscores why getting this step right is critical. There are two standard approaches.

Consider a company with Year 7 FCF of $23.1 million, Year 7 EBITDA of $32 million, WACC of 9.75%, and a perpetuity growth rate of 2.5%:

• Gordon Growth: TV = $23.1M × (1.025) / (0.0975 - 0.025) = $23.68M / 0.0725 = $326.6M
• Exit Multiple (10x EBITDA): TV = $32M × 10 = $320.0M

The convergence of these two approaches (within 2%) provides confidence in the terminal value estimate. A divergence of more than 10-15% signals that your growth rate or exit multiple assumptions are inconsistent and need reconciliation.

Step 4: Discount to Present Value

Each projected free cash flow is discounted back to the present using the mid-year convention, which assumes cash flows are received evenly throughout the year rather than at year-end. The mid-year convention increases enterprise value by approximately 3-5% compared to year-end discounting and better reflects the economic reality of ongoing cash generation.

PV(FCFₜ) = FCFₜ / (1 + WACC)^(t - 0.5)   [mid-year convention]

The terminal value is discounted at the full final year:

PV(TV) = TV / (1 + WACC)^n

Enterprise value equals the sum of all discounted FCFs plus the discounted terminal value. To arrive at equity value, subtract net debt, minority interests, and preferred stock, then add any non-operating assets (excess cash, equity investments). For a thorough explanation of these adjustments, see our guide on valuation multiples and enterprise value.

Step 5: Sensitivity Analysis

A single-point DCF output is meaningless without understanding how it changes with different assumptions. Sensitivity analysis tests the impact of varying key inputs on the final enterprise value. The two most common sensitivity tables are:

• WACC vs. Terminal Growth Rate: The primary sensitivity. Small changes in either can swing enterprise value by 20-30%.
• Revenue Growth vs. EBITDA Margin: Tests operating assumptions. Helps identify the break-even point for the investment.

Additional sensitivity dimensions include: exit multiple (if using the exit multiple method for terminal value), capex as a percentage of revenue, customer churn rate (for subscription businesses), and acquisition synergies (run the DCF with and without synergies to isolate synergy value).

Monte Carlo simulation takes sensitivity analysis a step further by assigning probability distributions to key inputs and running thousands of scenarios. The output is a probability distribution of enterprise values rather than a simple range. While computationally intensive, Monte Carlo analysis is increasingly standard in large transactions where the stakes justify the additional rigor.

DCF Pros and Cons

Advantages:

• Intrinsic valuation: Not dependent on market sentiment or comparable transactions, which may be influenced by market cycles.
• Flexibility: Can model any scenario -- synergies, restructuring, growth acceleration, cost reduction -- making it the primary tool for strategic and LBO analysis.
• Granularity: Forces the analyst to think through every driver of value, which deepens understanding of the business.
• Forward-looking: Captures future growth and margin expansion that backward-looking multiples miss.

Disadvantages:

• Assumption-sensitive: Small changes in growth rates, margins, or discount rates produce large swings in output.
• Terminal value dominance: 60-80% of value comes from cash flows you cannot see, making the model vulnerable to terminal value manipulation.
• Complexity: Requires deep understanding of accounting, finance, and the specific business to build correctly.
• False precision: A model with 200 line items and 10-year projections can create a false sense of accuracy.

Common DCF Mistakes

Even experienced analysts fall into these traps:

• Perpetuity growth rate exceeds GDP: A company cannot grow faster than the economy forever. Growth rates above 3% in the terminal value are almost always unjustifiable.
• Inconsistent assumptions: Revenue growth of 15% but margin expansion driven by operating leverage implies a specific cost structure. Every line item must be internally consistent.
• Ignoring working capital: Growing companies consume working capital. Omitting the change in NWC overstates free cash flow.
• Using book value capital structure for WACC: WACC should use market values of debt and equity, not book values.
• Currency mismatch: Cash flows denominated in euros must be discounted at a euro-denominated WACC. Mixing currencies produces nonsensical results.
• Double-counting synergies: If synergies are included in the cash flow projections, they should not also inflate the exit multiple.
• No sanity check: The implied exit multiple from a Gordon Growth terminal value should be calculated and compared against current market multiples. If your DCF implies a 25x EBITDA exit multiple for a manufacturing company, something is wrong.

DCF vs. Comparable Methods

In practice, no serious valuation relies on a single method. Investment banks and advisory firms present a “football field” chart showing the valuation range from each methodology, with the final negotiated price typically falling within the overlapping zone. DCF provides the intrinsic anchor, trading comps provide the market reality check, and precedent transactions provide the deal-specific benchmark.

Excel Model Tips

Building a clean, auditable DCF model requires discipline. Here are the conventions used by top investment banks and advisory firms:

• Blue for inputs, black for formulas: This universal color convention makes it instantly clear which cells contain assumptions that can be changed.
• One row, one formula: Every cell in a row should use the same formula, differing only by the column reference. This ensures consistency and makes auditing efficient.
• Separate assumptions from calculations: Place all key assumptions (growth rates, margins, capex %, WACC inputs) on a dedicated assumptions tab. Reference these cells in the calculation tabs.
• Build toggle switches: Create scenario switches (base case, upside, downside) using CHOOSE or IF functions that allow one-click scenario analysis.
• Data tables for sensitivity: Use Excel’s two-variable data table function (What-If Analysis) to automate sensitivity tables for WACC vs. growth rate and revenue growth vs. margin.
• Implied checks: Calculate the implied exit multiple from your Gordon Growth terminal value and display it prominently. If it looks unreasonable, revisit your assumptions.
• Version control: Save model versions with dates and initials. M&A processes involve multiple iterations, and being able to trace changes is essential for audit trails and regulatory compliance.

Conclusion

A well-constructed DCF is the most rigorous tool in the M&A valuation toolkit. It forces you to articulate every assumption about a business’s future, quantify those assumptions in dollar terms, and stress-test them through sensitivity analysis. The output is not a single “correct” valuation but a range that, when combined with comparable company analysis and precedent transactions, provides a comprehensive picture of what a business is worth.

The key to a credible DCF is intellectual honesty. Be conservative with terminal growth rates, rigorous with your WACC calculation, and transparent about which assumptions drive the most value. Present your sensitivity tables prominently, and always cross-check your DCF-implied multiples against market data. A DCF that produces a valuation wildly different from what the market would pay deserves scrutiny -- either you have identified genuine mispricing, or your assumptions need revision. The best analysts hold both possibilities in mind and use the tension between intrinsic and relative valuation to arrive at the truth.