Learning how to build a DCF model is one of the most valuable skills you can develop as an investor. A Discounted Cash Flow (DCF) model allows you to estimate the intrinsic value of a company based on the cash it will generate in the future, rather than relying solely on market sentiment or relative valuation metrics like the P/E ratio.
While the math might seem intimidating, the core concept is straightforward: a business is worth the sum of all its future cash flows, discounted back to today's dollars. In this guide, we will walk through the step-by-step process of building a DCF model, using Apple Inc. (AAPL) as a practical example.
Step 1: Forecast Free Cash Flow
The foundation of any DCF model is the company's Free Cash Flow (FCF). This is the cash a business generates after accounting for cash outflows to support operations and maintain its capital assets.
To project future cash flows, you first look at historical financial data. For our Apple example, let's assume the company generated approximately $100 billion in free cash flow over the trailing twelve months. Your job is to estimate how fast this cash flow will grow over a specific projection period, typically five to ten years.
If you believe Apple's services segment will drive steady growth, you might project a 6% annual growth rate for the next five years. Applying this growth rate to our $100 billion base gives us the projected cash flows for years one through five.
While you can build these projections manually, modern investors often use AI-powered platforms like Atlantis to instantly pull historical financial data and generate baseline growth projections based on consensus analyst estimates.
Step 2: Determine the Discount Rate (WACC)
Because a dollar today is worth more than a dollar tomorrow, we cannot simply add up the future cash flows. We must discount them back to their present value. The rate we use is called the discount rate, and analysts typically use the Weighted Average Cost of Capital (WACC).
The WACC represents the blended cost of a company's equity and debt. For a mature, highly profitable company like Apple, the WACC is relatively low—often around 8% to 9%. A higher-risk startup would require a much higher discount rate, perhaps 12% to 15%, reflecting greater uncertainty.
For our Apple DCF model, we will use a 9% discount rate. We will apply this rate to each of our projected cash flows from Step 1 to determine their present value.
Step 3: Calculate the Terminal Value
A company does not cease to exist after your five-year projection period. To account for all cash flows generated from year six into perpetuity, we must calculate a Terminal Value. There are two common methods: the Exit Multiple Method and the Perpetuity Growth Method.
For this tutorial, we will use the Perpetuity Growth Method. This assumes the company will continue to grow its cash flows at a steady, conservative rate forever. This rate should roughly match the long-term growth rate of the overall economy, typically 2% to 3%.
If we assume Apple will grow at 2.5% perpetually after year five, we use a specific formula to find the Terminal Value. Just like the cash flows in Step 1, this Terminal Value must also be discounted back to its present value using our 9% WACC.
Step 4: Calculate Enterprise Value and Equity Value
Once you have the present value of your projected cash flows and the present value of your Terminal Value, you add them together. The resulting number is the Enterprise Value, which represents the total value of the company's core operations.
However, as a stock investor, you are buying equity, not the entire enterprise. To bridge the gap from Enterprise Value to Equity Value, you must make two adjustments:
- Add the company's cash and cash equivalents.
- Subtract the company's total debt.
Apple is famous for its massive cash pile, which significantly boosts its Equity Value. Once you have made these adjustments, you arrive at the total intrinsic value of the company's equity.
Step 5: Find the Intrinsic Value Per Share
The final step in building a discounted cash flow model is the easiest. Take the total Equity Value you calculated in Step 4 and divide it by the company's total number of shares outstanding.
For example, if your calculated Equity Value for Apple is $3.2 trillion, and the company has roughly 15.1 billion shares outstanding, your intrinsic value per share would be approximately $211.
You can then compare this intrinsic value to the current market price of the stock. If the market price is significantly lower than your calculated value, the stock may be undervalued, offering a margin of safety. If the market price is higher, the stock may be overvalued.
Automating Your DCF Valuation Workflow
Building a DCF model from scratch in Excel is an excellent educational exercise, but it is incredibly time-consuming. Gathering the data, calculating the WACC, and running sensitivity analyses can take hours.
This is where AI investing tools are changing the landscape. By using Atlantis, you can generate a complete, customizable DCF model in seconds. The platform automatically handles the data gathering and complex calculations, allowing you to focus on adjusting the growth assumptions and analyzing the results.
To see how this fits into a broader research strategy, check out our guide on how to build an AI stock research workflow or explore other valuation methods on our blog. Ready to start valuing stocks faster? Sign up today.
Frequently Asked Questions
Q: What is the biggest risk when building a DCF model?A: The biggest risk is "garbage in, garbage out." A DCF model is highly sensitive to your assumptions, particularly the growth rate and the discount rate. A small change in the WACC or terminal growth rate can drastically alter the final intrinsic value. This is why it is crucial to run a sensitivity analysis and model different scenarios.
Q: Should I use a DCF model for every type of stock?A: No. DCF models work best for companies with predictable, positive, and stable cash flows, such as mature tech companies or consumer staples. They are generally ineffective for early-stage startups with negative cash flows, highly cyclical commodity businesses, or financial institutions like banks.
Q: How do I know if my discount rate (WACC) is correct?A: Calculating a precise WACC involves complex formulas including the Capital Asset Pricing Model (CAPM) and the cost of debt. However, for retail investors, a practical shortcut is to use a standard range based on company size and risk: 7-9% for large mega-caps, 9-11% for average mid-caps, and 12% or higher for smaller, riskier growth stocks.