Financial Modeling & Valuation

Module 3: DCF Valuation

---

Module Overview

The Discounted Cash Flow (DCF) analysis is the gold standard of intrinsic valuation. It values a company based on the present value of its expected future cash flows. Unlike market-based methods, DCF derives value from fundamentals—what the company actually generates.

In this module, you'll learn to build a complete DCF model, from calculating free cash flow to determining terminal value and deriving enterprise and equity value.

Learning Objectives:

By the end of this module, you will be able to:

• Calculate Free Cash Flow to Firm (FCFF) and Free Cash Flow to Equity (FCFE)
• Determine the Weighted Average Cost of Capital (WACC)
• Project cash flows using multiple methodologies
• Calculate terminal value using perpetuity growth and exit multiple methods
• Discount cash flows and arrive at enterprise value
• Bridge from enterprise value to equity value per share
• Build sensitivity tables for key assumptions

Estimated Time: 5-6 hours

---

3.1 The DCF Framework

The Fundamental Principle

A company (or any asset) is worth the present value of all future cash flows it will generate.

The DCF Formula:

Why DCF?

Advantages:

• Based on intrinsic fundamentals, not market sentiment
• Forces you to think about cash flow drivers
• Not dependent on comparable companies existing
• Flexible—can model any scenario

Disadvantages:

• Highly sensitive to assumptions (especially WACC and terminal value)
• Requires forecasting the future (inherently uncertain)
• Terminal value often dominates the result
• Easy to manipulate to get any answer you want

Key Insight: DCF is powerful but dangerous. The precision of the numbers creates an illusion of accuracy. Always remember: your DCF is only as good as your assumptions.

DCF Structure

A typical DCF has these components:

1. Free cash flow projections (years 1-5 or 1-10)
2. Terminal value (value beyond the projection period)
3. Discount rate (WACC)
4. Present value calculation
5. Enterprise value
6. Bridge to equity value
7. Implied share price
8. Sensitivity analysis

---

3.2 Free Cash Flow Calculation

Free Cash Flow to Firm (FCFF)

FCFF represents cash available to all capital providers (debt and equity holders):

Why start with EBIT? We want cash available to all investors before interest payments. Starting with EBIT and taxing it directly gives us unlevered after-tax cash flow.

Alternative Formula:

Simplified:

Example FCFF Calculation

FCFF calculation ($M)

$M	2025E	2026E	2027E	2028E	2029E
EBIT (operating income)	295	345	389	420	445
× (1 - tax rate of 25%)	×0.75	×0.75	×0.75	×0.75	×0.75
NOPAT (after-tax EBIT)	221	259	292	315	334
+ Depreciation & amortization	125	137	148	155	162
- Capital expenditures	(124)	(128)	(130)	(140)	(145)
- Change in NWC	(16)	(16)	(12)	(10)	(8)
Free cash flow to firm	206	252	298	320	343

Free Cash Flow to Equity (FCFE)

FCFE represents cash available to equity holders after debt service:

When to use FCFE:

• When valuing equity directly
• Discount at cost of equity (not WACC)
• Less common in practice

When to use FCFF:

• Standard approach for most DCF analyses
• Discount at WACC
• Preferred by investment bankers and analysts

---

3.3 Weighted Average Cost of Capital (WACC)

What is WACC?

WACC is the blended cost of all capital (debt and equity) used to fund the business:

Why tax-adjust debt? Interest payments are tax-deductible, reducing the effective cost of debt.

Cost of Equity (Ke)

The cost of equity is the return shareholders require. It's typically calculated using the Capital Asset Pricing Model (CAPM):

Example:

Finding Beta

Options for Beta:

1. Levered Beta from data providers (Bloomberg, Capital IQ) - Most common

2. Unlevered Beta calculation:

   Unlevered β = Levered β / [1 + (1-T) × (D/E)]

   Then re-lever to your target capital structure

3. Industry Average Beta - Use when company-specific data is noisy

Beta Interpretation:

• β = 1.0: Moves with the market
• β > 1.0: More volatile than market (tech stocks, growth companies)
• β < 1.0: Less volatile than market (utilities, consumer staples)

Cost of Debt (Kd)

The cost of debt is the interest rate the company pays on its borrowings:

Options:

1. Current yield on existing bonds
2. Weighted average interest rate on all debt
3. Credit spread + Risk-free rate

Example:

Capital Structure Weights

Use market values, not book values:

Example WACC Calculation

Example WACC calculation

Capital structure
Market value of equity	$1,500M
Market value of debt	$300M
Total capital	$1,800M
Weights
Equity weight (E/V)	83.3%
Debt weight (D/V)	16.7%
Costs
Cost of equity (Ke)	10.0%
Pre-tax cost of debt (Kd)	6.0%
Tax rate	25%

WACC Sensitivity

WACC has an enormous impact on DCF valuation:

WACC	Enterprise Value (Example)
7%	$5,200M
8%	$4,500M
9%	$4,000M
10%	$3,600M
11%	$3,250M

A 1% change in WACC can change value by 10-20%. Be thoughtful about this assumption.

---

3.4 Terminal Value

Why Terminal Value?

You can't project cash flows forever. Terminal value captures the value of all cash flows beyond your projection period.

Typical approach:

• Project detailed cash flows for 5-10 years
• Calculate terminal value at end of projection period
• Terminal value often represents 50-80% of total value

Method 1: Perpetuity Growth Method (Gordon Growth Model)

Assume cash flows grow at a constant rate forever:

Example:

Choosing the Growth Rate:

• Should not exceed long-term GDP growth (typically 2-3%)
• Represents sustainable forever growth
• Higher than inflation, lower than current growth
• Common range: 1.5% - 3.0%

Sanity Check: The implied exit multiple from perpetuity growth should be reasonable:

Method 2: Exit Multiple Method

Apply a valuation multiple to terminal year metric:

Example:

Choosing the Exit Multiple:

• Current trading multiple of company
• Average trading multiple of peers
• Historical average multiple
• Often 1-2 turns below current multiple (conservatism)

Sanity Check: Calculate the implied perpetual growth rate:

This should be reasonable (1-3%).

Which Method to Use?

Most practitioners use both and compare results:

Method	Terminal Value	Implied Check
Perpetuity Growth (2.5%)	$5,412M	Implied multiple: 8.9×
Exit Multiple (9.0×)	$5,463M	Implied growth: 2.6%

When the methods converge, you have more confidence in the result.

---

3.5 Discounting and Enterprise Value

Present Value of Cash Flows

Each cash flow is discounted to present value:

Mid-Year Convention: Cash flows don't all arrive on December 31. The mid-year convention assumes they arrive mid-year:

This increases present values slightly (more realistic).

Example DCF Calculation

DCF valuation ($M)

$M	2025E	2026E	2027E	2028E	2029E	TV
Free cash flow	206	252	298	320	343
Terminal value						5,412
Discount period (mid-year)	0.5	1.5	2.5	3.5	4.5	4.5
Discount factor (@ 9.0%)	0.958	0.878	0.806	0.739	0.678	0.678
Present value of FCF	197	221	240	237	233
Present value of TV						3,669

From present values to enterprise value

Sum of PV of FCFs	$1,128M
PV of terminal value	$3,669M
Enterprise value	$4,797M
% from projection period	24%
% from terminal value	76%

Notice: 76% of value comes from terminal value. This is why terminal value assumptions are so critical.

---

3.6 From Enterprise Value to Share Price

The Bridge

Enterprise Value represents the value of the entire business. To get to equity value per share:

Example Bridge

Bridge to equity value ($M)

Enterprise value	$4,797
- Total debt	(300)
+ Cash	195
- Preferred stock	0
- Minority interest	0
Equity value	$4,692
Shares outstanding (M)	100
Implied share price	$46.92
Current share price	$45.00
Upside/(downside)	+4.3%

Interpreting the Result

• If Implied Price > Current Price: Stock may be undervalued
• If Implied Price < Current Price: Stock may be overvalued

But remember: Your DCF is only as good as your assumptions. The market might know something you don't.

Try It: Build the Bridge Yourself

These are the numbers from the example above. Change the debt or the cash and watch the share price move.

---

3.7 Sensitivity Analysis

Why Sensitivity Matters

DCF valuations are highly sensitive to assumptions. Professional analysts always present sensitivities to key inputs:

1. WACC - Discount rate
2. Terminal Growth Rate - Perpetual growth
3. Exit Multiple - Terminal multiple
4. Revenue Growth - Near-term driver
5. Operating Margin - Profitability assumption

Two-Way Sensitivity Table

The standard format shows how value changes with two variables:

Implied share price ($): WACC (rows) by terminal growth rate (columns)

WACC	1.5%	2.0%	2.5%	3.0%	3.5%
7.5%	$58.23	$62.15	$66.73	$72.21	$78.93
8.0%	$52.45	$55.67	$59.34	$63.63	$68.74
8.5%	$47.56	$50.25	$53.28	$56.73	$60.72
9.0%	$43.36	$45.63	$48.17	$50.58	$54.39
9.5%	$39.72	$41.65	$43.78	$46.15	$48.83
10.0%	$36.54	$38.19	$40.01	$41.88	$44.40

Highlighted: the base case (WACC 9.0%, terminal growth 2.5%).

Reading the table:

• Current assumptions: WACC 9.0%, Terminal Growth 2.5% → $48.17
• Best case: Lower WACC, higher growth → $78.93
• Worst case: Higher WACC, lower growth → $36.54

Creating Sensitivity Tables in Excel

Using Data Tables:

1. Set up your two-way table with row and column inputs
2. In the corner cell, reference your output (share price)
3. Select the entire table
4. Data → What-If Analysis → Data Table
5. Row input cell: WACC assumption
6. Column input cell: Terminal growth assumption

This automatically calculates all combinations.

Try It: A DCF You Can Play With

This calculator runs a full DCF on a simple company: free cash flow, mid-year discounting, a terminal value, and the bridge to a share price. Move one assumption at a time, and watch how much of the value comes from the terminal value. The grid underneath is the sensitivity table from this section, built live around your settings.

---

3.8 DCF Best Practices

Model Structure

Set up your DCF tab in this order:

1. Summary outputs (at top)
2. FCF calculation
3. WACC calculation
4. Terminal value (both methods)
5. Present value calculation
6. Enterprise value bridge
7. Sensitivity tables

Common Mistakes to Avoid

1. Mixing FCFF and FCFE

• FCFF is discounted at WACC → Enterprise Value
• FCFE is discounted at Ke → Equity Value
• Never mix them

2. Double-Counting Cash in Terminal Value If you're using exit multiples, make sure the multiple is applied consistently (EV/EBITDA gives EV, not Equity Value).

3. Inconsistent Assumptions

• If revenue grows at 15% but terminal growth is 2.5%, the model should show deceleration
• Sudden jumps to terminal value without transition are unrealistic

4. Unrealistic Terminal Growth

• Never exceed long-term GDP growth (2-3%)
• Higher implies the company becomes the entire economy

5. Forgetting the Mid-Year Convention Standard practice; makes valuations more accurate.

6. Not Sense-Checking Results

• Compare to current trading price
• Calculate implied multiples
• Benchmark against peers

Professional Tips

1. Show Multiple Scenarios Present base, upside, and downside cases, not just one number.

2. Weight Terminal Value Methods Some analysts average perpetuity growth and exit multiple results.

3. Use Ranges Instead of "$46.92," present "$42-52" to acknowledge uncertainty.

4. Document Assumptions Explain why you chose each assumption. "WACC of 9.0% based on peer median beta of 1.1, 10-year Treasury of 4.0%, and 5.0% ERP."

5. Sensitivity Drives Decisions The sensitivity table often tells you more than the point estimate. What assumptions would change your recommendation?

---

3.9 Practical Exercise: Build a DCF Model

Exercise Instructions

Using the 3-statement model from Module 2, build a complete DCF:

Given Assumptions:

Given assumptions

WACC inputs
Risk-free rate	4.0%
Beta	1.15
Equity risk premium	5.0%
Cost of debt	6.0%
Tax rate	25%
Target debt/total capital	15%
Terminal value
Perpetual growth rate	2.5%
Exit EV/EBITDA multiple	8.5×
Capital structure
Shares outstanding	100M
Current debt (end of FY 2024, from Module 2)	$150M
Current cash (end of FY 2024, from Module 2)	$50M

Your Task:

1. Calculate Cost of Equity using CAPM
2. Calculate WACC
3. Project Free Cash Flows for 5 years (2025E to 2029E). For 2028 and 2029, keep the Module 2 assumptions.
4. Calculate Terminal Value (both methods)
5. Discount to present value (use mid-year convention)
6. Calculate Enterprise Value
7. Bridge to Equity Value and share price
8. Build WACC vs. Terminal Growth sensitivity table

Check Your Answers

Work through the steps first. Then compare. These answers use the Module 2 model, with the same assumptions carried into 2028 and 2029. Free cash flow is EBIT × (1 - 25%) + D&A - CapEx - change in net working capital. Net working capital is receivables plus inventory, minus payables and accrued expenses.

Show the answers

1 and 2. Cost of equity and WACC

• Cost of equity = 4.0% + 1.15 × 5.0% = 9.75%
• WACC = 85% × 9.75% + 15% × 6.0% × (1 - 25%) = 8.29% + 0.68% = 8.96%

3 and 5. Free cash flow and present value ($M)

Year	Free cash flow	Discount factor (period)	Present value
2025E	128.0	0.958 (0.5)	122.6
2026E	134.1	0.879 (1.5)	117.9
2027E	147.3	0.807 (2.5)	118.8
2028E	161.9	0.741 (3.5)	119.9
2029E	177.9	0.680 (4.5)	120.9

How each year's free cash flow is built, using 2025 and 2029 as examples:

• 2025: EBIT 190.0 × 75% = 142.5, + D&A 30.0, - CapEx 44.0, - NWC increase 0.5 = 128.0
• 2029: EBIT 281.6 × 75% = 211.2, + D&A 40.5, - CapEx 64.4, - NWC increase 9.4 = 177.9

The present values add up to $600.1M.

4 to 7. Terminal value and share price ($M, except per share)

The terminal value is discounted with the 2029 factor (0.680), as in section 3.5.

	Perpetuity growth (2.5%)	Exit multiple (8.5×)
Terminal value	2,821.7	2,737.9
Present value of terminal value	1,917.6	1,860.7
Enterprise value	2,517.7	2,460.7
Terminal value share of EV	76%	76%
- Debt + cash (-150 + 50)	(100.0)	(100.0)
Equity value	2,417.7	2,360.7
Implied share price	$24.18	$23.61

The two methods agree within about 2%. The perpetuity method implies an exit multiple of 8.8× EBITDA. The exit multiple implies a growth rate of about 2.3%. Both are close to the inputs, which is a good sign.

8. Sensitivity: share price, perpetuity growth method

WACC \ growth	2.0%	2.5%	3.0%
7.96%	$26.70	$28.79	$31.30
8.96%	$22.71	$24.18	$25.89
9.96%	$19.73	$20.80	$22.03

One point of WACC moves the price by about $4. That is why your WACC inputs deserve as much care as your forecast.

---

3.10 Key Takeaways

Free Cash Flow

FCFF is discounted at WACC to get Enterprise Value.

WACC

Use market value weights and be thoughtful about each input.

Terminal Value

• Perpetuity Growth: FCF(n+1) / (WACC - g)
• Exit Multiple: Terminal EBITDA × Multiple
• Use both methods and check for convergence.

Enterprise to Equity Bridge

Sensitivity DCF is only as good as assumptions. Always show sensitivity to WACC and terminal value.

---

Looking Ahead to Module 4

DCF gives you intrinsic value—what the company should be worth based on fundamentals.

In Module 4, you'll learn Comparable Company Analysis (Trading Comps)—what the market is paying for similar companies. Together, DCF and Comps provide a comprehensive valuation picture.

---

Summary

Congratulations on completing Module 3! You can now:

• Calculate Free Cash Flow to Firm (FCFF)
• Determine WACC using CAPM and capital structure weights
• Calculate terminal value using perpetuity growth and exit multiple methods
• Discount cash flows and terminal value to present
• Bridge from Enterprise Value to Equity Value per share
• Build and interpret sensitivity tables

DCF is the most theoretically rigorous valuation method. Combined with market-based approaches, you'll have a complete valuation toolkit.

Ready for market comparisons? Proceed to Module 4: Comparable Company Analysis to learn how the market values similar companies.

---

"Valuation is not just about numbers—it's about judgment wrapped in a spreadsheet." — Anonymous Wall Street Analyst