Building a Two-Stage DCF Model

The Architecture of a Two-Stage DCF

A company's life, for valuation purposes, can be split into two distinct periods. A two-stage DCF model reflects this reality.

1. The Explicit Forecast Period (Stage 1): This is a high-growth phase, typically lasting 5 to 10 years. During this time, we have some degree of visibility into the company's prospects, allowing us to build a detailed, year-by-year forecast of its free cash flows. For a young, fast-growing company, this period might be longer; for a mature business, it could be shorter.

2. The Terminal Period (Stage 2): Beyond the explicit forecast, it's impossible to predict year-by-year performance. Instead, we assume the company matures and settles into a stable state, growing at a constant, perpetual rate. We capture the entire value of the company from this point to infinity in a single number: the Terminal Value.

The diagram below from Professor Damodaran's notes illustrates this structure perfectly.

Building the Model: A Practical Walkthrough

Theory is one thing; execution is another. The best way to understand the DCF process is to build one. The following video provides an excellent step-by-step guide to constructing a full DCF model in Excel. It covers every stage, from projecting cash flows to arriving at an implied share price.

Let's now break down the most critical and assumption-driven parts of this process: calculating Terminal Value and bridging to Equity Value.

Terminal Value: The Engine of the DCF

In most DCF models, the Terminal Value (TV) can account for 70% or more of the total Enterprise Value. This makes the assumptions behind it incredibly important. An analyst who gets the TV wrong gets the valuation wrong. There are two primary methods for calculating it, and a smart analyst uses both to cross-check their work.

1. Perpetuity Growth Method (Gordon Growth Model)

This method assumes the company's free cash flows will grow at a constant, stable rate (g) forever, starting the year after the explicit forecast period ends.

The formula is:
$\text{Terminal Value}=\frac{{\text{FCFF}}_n\times (1+g)}{\text{WACC}-g}$

• ${\text{FCFF}}_n$ is the free cash flow in the last year of your explicit forecast.
• g is the perpetual growth rate.
• WACC is your weighted average cost of capital.

The most critical assumption here is g. It cannot be higher than the long-term growth rate of the economy in which the company operates (e.g., nominal GDP growth). If a company grew faster than the economy forever, it would eventually become the economy. A reasonable g is often in the 2-3% range for a developed market.

2. Exit Multiple Method

This method assumes you sell the business at the end of the forecast period for a certain multiple of a financial metric, typically EBITDA.

The formula is:
$\text{Terminal Value}={\text{EBITDA}}_n\times \text{Exit Multiple}$

• ${\text{EBITDA}}_n$ is the EBITDA in the last year of your explicit forecast.
• The Exit Multiple is usually based on the current trading multiples of comparable public companies.

The Analyst's Sanity Check

Relying on only one method is a rookie mistake. A professional analyst calculates TV using both methods as a sanity check. You can derive an implied growth rate from an exit multiple, and an implied exit multiple from a growth rate. If the implied growth rate from your chosen exit multiple is 8%, you know something is wrong. Likewise, if your perpetuity growth assumption implies an EV/EBITDA multiple of 30x for a stable, mature company, your g is likely too high.

From Enterprise Value to Equity Value Per Share

After discounting all the projected FCFFs and the Terminal Value and summing them up, you arrive at the Implied Enterprise Value (EV). This is the value of the company's core business operations attributable to all capital providers (debt and equity holders).

However, as a stock market investor, you care about the value belonging only to the common shareholders. To get there, we must cross the "bridge" from Enterprise Value to Equity Value.

The calculation is as follows:

Equity Value = Enterprise Value - Total Debt - Preferred Stock - Non-controlling Interests + Cash and Cash Equivalents

Let's quickly review the logic for these adjustments.

Once you have the Implied Equity Value, the final step is simple:

Implied Share Price = Implied Equity Value / Fully Diluted Shares Outstanding

This gives you the intrinsic value per share according to your DCF model, which you can then compare to the current market price.

The Complete Picture: A Professional Example

To see how all these components come together in a professional format, look at this one-page DCF summary for Heineken from Professor Damodaran.

This example encapsulates the entire process we've learned today, demonstrating how assumptions flow through the model to produce a final valuation.

Conclusion

You have now built a complete Discounted Cash Flow model, the cornerstone of intrinsic valuation. This tool, when used with discipline, allows you to look past market narratives and develop your own independent assessment of a company's worth.

Key Takeaways:

• A DCF model is built in two stages: an explicit forecast period of high growth and a terminal period of stable growth.
• Terminal Value is a critical, highly sensitive component. You must use both the Perpetuity Growth and Exit Multiple methods as a sanity check on your assumptions.
• The DCF directly calculates a company's Implied Enterprise Value. You must "bridge" this to Implied Equity Value by adjusting for cash, debt, and other non-equity claims.
• The final output—the implied share price—is only as good as the assumptions you feed into the model. The model's real power lies in its ability to test these assumptions.

In our next lesson, we will explore Multiples Valuation. While DCF tells us what a company should be worth based on its fundamentals (intrinsic value), multiples tell us what the market is willing to pay for similar companies right now (relative value). Comparing these two perspectives is essential for identifying true market mispricings.