DCF Valuation: The Complete Guide for Financial Analysts

The Discounted Cash Flow (DCF) method remains the most widely used valuation tool in corporate finance. Whether you are an investment banking analyst, a strategy consultant, or an investor, understanding DCF is essential.

Why is DCF so important?

Unlike relative valuation methods (comparable multiples), DCF relies on an intrinsic logic: a company's value equals the sum of its future cash flows, discounted at the cost of capital. This approach allows you to:

• Value a company independently of market conditions
• Quantify the impact of different strategic scenarios
• Identify the assumptions that most influence valuation

Step 1: Project Free Cash Flows (FCF)

Free Cash Flow represents the cash generated by operating activities, available to compensate all capital providers (shareholders and creditors).

FCF Formula

FCF = EBIT × (1 - tax rate)
    + Depreciation & Amortization
    - Change in Working Capital
    - Capital Expenditures (CAPEX)

Best Practices for Projections

Projection horizon: Typically 5 to 10 years. The more mature the company, the shorter the horizon. For a hypergrowth startup, 10 years are often necessary.

Revenue growth: Start from historical growth rates, adjust based on Total Addressable Market (TAM), competitive positioning, and sector trends.

Operating margins: Analyze historical margin trajectory. Are they converging toward a normalized level? Does operating leverage support margin expansion?

Working Capital: Express working capital components in days of revenue (accounts receivable, inventory, accounts payable). Apply these ratios to revenue projections.

CAPEX: Distinguish maintenance CAPEX (required to sustain production capacity) from growth CAPEX (expansion investments).

Step 2: Calculate the WACC

The Weighted Average Cost of Capital (WACC) is the discount rate reflecting the weighted average cost of the company's funding sources.

WACC Formula

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

Where:

• E/V = proportion of equity in the capital structure
• Ke = cost of equity (via CAPM)
• D/V = proportion of debt
• Kd = pre-tax cost of debt
• t = effective tax rate

Determining the Cost of Equity (Ke)

The CAPM (Capital Asset Pricing Model) is the standard method:

Ke = Rf + β × (Rm - Rf) + specific premium

• Rf (risk-free rate): 10-year government bond yield
• β (beta): measures the stock's sensitivity relative to the market. A β > 1 means the stock is more volatile than the market
• Rm - Rf (equity risk premium): historically between 5% and 7% depending on the market

Common Mistakes to Avoid

1. Using raw β without unlevering/relevering: If your target company has a different capital structure from comparables, you must adjust β
2. Ignoring the size premium: Small caps deserve an additional risk premium (typically 2-4%)
3. Mixing risk-free rate currency and FCF currency: Both must be consistent

Step 3: Calculate Terminal Value

Terminal Value captures the company's value beyond the explicit projection horizon. It typically represents 60% to 80% of total DCF value.

Gordon Growth Model (perpetual growth)

TV = FCF(n+1) / (WACC - g)

Where g is the perpetual growth rate (generally between 1.5% and 3%, never exceeding nominal GDP growth).

Exit Multiple Method

TV = EBITDA(n) × Exit Multiple

The exit multiple is typically based on observed transaction multiples in the sector.

Tip: Use both methods and compare results. A significant gap signals a problem in your assumptions.

Step 4: Discount and Interpret

Enterprise Value Calculation

Enterprise Value = Σ [FCF(t) / (1 + WACC)^t] + TV / (1 + WACC)^n

From Enterprise Value to Equity Value

Equity Value = Enterprise Value
             - Net Debt
             - Minority Interests
             - Pension Provisions
             + Investments in Associates

Price per Share

Implied Price = Equity Value / Diluted Share Count

Step 5: Sensitivity Analysis

A DCF without sensitivity analysis has no value. You must test your valuation's sensitivity to key assumptions:

• WACC vs. perpetual growth rate: The most classic sensitivity table
• Revenue growth vs. operating margin: Identifies which lever has the most impact
• Exit multiple vs. WACC: If using the multiple method for TV

Sensitivity Table Example

Limitations of DCF

DCF is not perfect. Its main limitations are:

1. Extreme sensitivity to assumptions: Small changes in WACC or perpetual growth rate can shift valuation by 30% or more
2. Garbage in, garbage out: If your FCF projections are unrealistic, the result will be too
3. Unsuitable for pre-revenue companies: Without near-term positive cash flows, the model is difficult to calibrate
4. Confirmation bias: It is easy to manipulate assumptions to arrive at a desired result

Conclusion

DCF remains a fundamental tool for every finance professional. Its strength lies in its analytical rigor and ability to decompose a company's value into testable assumptions. The key is to use it with discipline, documenting every assumption and systematically performing sensitivity analyses.

Our DCF Valuation Excel template integrates all these steps with pre-configured formulas, automated sensitivity analysis, and a summary dashboard.