Discounted Cash Flow Model (DCF) Explained: Formula, Steps, and Examples

One of the most widely used methods for valuing a business, project, or asset in finance and investment is the Discounted Cash Flow (DCF) analysis. It determines the present value of an asset based on the cash it’s expected to generate in the future, factoring in the time value of money. But how does it work, and why is it so crucial in investment analysis? This blog breaks down the Discounted Cash Flow Model, explains its components, and discusses why it’s considered one of the most reliable ways to assess the true worth of an investment.

What is the Discounted Cash Flow (DCF) Model?

The DCF model is a financial valuation method to estimate the value of an investment based on its expected future cash flows. The core idea is that the value of an asset is equal to the sum of all its future cash flows, discounted back to its present value using an appropriate discount rate.

This approach is grounded in the time value of money (TVM) principle, which states that a dollar today is worth more than a dollar in the future due to its earning potential. By discounting future cash flows, the DCF model accounts for risk, inflation, and the opportunity cost of capital.

Core Components of the DCF Model

Cash Flow Projections

The model requires an accurate forecast of future cash flows, typically over a 5 to 10-year period. These cash flows include revenues, operating expenses, taxes, and capital expenditures. For businesses, the most common cash flow metrics used are:

• Free Cash Flow to the Firm (FCFF): This represents the cash available to all investors, both equity holders and debt holders. It is calculated as operating income (EBIT) adjusted for taxes (NOPAT), capital expenditures (CAPEX), and changes in working capital.

FCFF = NOPAT + Depreciation & Amortization − Changes in Working Capital − Capex

• Free Cash Flow to Equity (FCFE): This is the cash available to equity holders after accounting for debt repayments and interest expenses.

FCFE = Net Income + Depreciation and Amortization – Change in Net Working Capital – Capex + Net Borrowing

Discount Rate

The discount rate reflects the investor’s required rate of return, accounting for the risk associated with cash flows. The Weighted Average Cost of Capital (WACC) is the most commonly used discount rate, which blends the cost of equity and debt. The WACC is often used when applying the DCF model to entire firms because it considers the capital structure (i.e., the mix of debt and equity).

The data tables compiled by NYU professor Damodaran allow a practitioner to find estimates of the WACC for US companies across several industries.

Terminal Value

Since businesses often have indefinite lifespans, a DCF model must account for cash flows beyond the forecast period. This is done through the terminal value (TV), which estimates the continuing value of the business at the end of the projection period. There are two standard methods for calculating terminal value:

• Perpetuity Growth Method (Gordon Growth Model): This method assumes that the cash flows will grow continuously. The formula for terminal value is:

• Exit Multiple Method: This approach estimates the terminal value by applying an industry-comparable multiple (such as EV/EBITDA) to a financial metric (typically EBITDA or EBIT) in the final forecast year.

Present Value of Cash Flows

After estimating future cash flows and terminal value, each value is discounted to the present using the discount rate (usually WACC). The formula for discounting a future cash flow is:

Enterprise Value and Equity Value

After calculating the present value of cash flows and terminal value, you can determine the total value of the business.

• Enterprise Value (EV): This is the sum of the present value of future free cash flows (both during the forecast period and the terminal value).

• Equity Value: To calculate the equity value, subtract the company’s net debt from the enterprise value (i.e., EV – Net Debt = Equity Value).

Steps in Building a DCF Model

1. Forecast Cash Flows: Begin by projecting the company’s future cash flows. Typically, these projections cover 5 to 10 years and should be based on realistic assumptions derived from historical performance and industry expectations.
2. Determine the Discount Rate: Calculate the WACC, which involves finding the cost of equity (using models like the Capital Asset Pricing Model, or CAPM) and the cost of debt (based on the company’s borrowing rates and tax shield).
3. Estimate the Terminal Value: Choose the perpetuity growth method or exit multiple methods to calculate the terminal value, which accounts for the company’s value beyond the projection period.
4. Discount Cash Flows: Apply the appropriate discount rate to each projected cash flow and terminal value.
5. The sum of Present Values: Add the present value of projected cash flows and terminal value to obtain the enterprise value.
6. Adjust for Net Debt: If calculating equity value, subtract the net debt from the enterprise value to obtain the final valuation for equity holders.

Advantages of the DCF Model

• Intrinsic Valuation: Unlike other models, such as relative valuation (which compares multiples like P/E ratios), the DCF model is intrinsic, focusing on the company’s fundamental financial health and future potential.
• Flexibility: The DCF model offers flexibility, allowing you to tailor it to different scenarios, such as varying cash flow growth rates, using different terminal value calculation methods, and making adjustments for risk.
• Forward-Looking: The DCF model relies on future projections, making it highly relevant for assessing the long-term prospects of a business.

Limitations and Challenges

• Sensitivity to Assumptions: The accuracy of a DCF model is highly sensitive to the inputs used, especially the discount rate and cash flow projections. Small changes in assumptions can lead to significant variations in the final valuation.
• Estimation of Cash Flows: Forecasting future cash flows precisely is tricky, particularly in industries facing high volatility or uncertainty.
• Terminal Value Reliance: A substantial portion of the value in a DCF model may come from the terminal value, which can be challenging to estimate accurately and may dominate the final valuation.
• Market Conditions: The DCF model is less effective when market conditions change rapidly, or the business operates in an unstable environment with unpredictable cash flows.

Applications of the DCF Model

• Company Valuation: Widely used in mergers and acquisitions, private equity, and venture capital to determine a company’s intrinsic value.
• Investment Appraisal: Employed by investors to assess the attractiveness of an investment by comparing the calculated intrinsic value with the market price.
• Project Valuation: In capital budgeting, analysts use DCF to evaluate the feasibility and profitability of long-term projects, especially for significant infrastructure investments.

Practical Example: Valuing a Company Using DCF

Let’s walk through a simplified example to illustrate the DCF model.

Assumptions:

• Forecast Period: 5 years
• Revenue Growth: 10% annually
• Operating Margin: 20%
• Tax Rate: 25%
• Depreciation & Amortization: 10% of revenue
• CapEx: 5% of revenue
• Change in Net Working Capital: $5M
• WACC: 8%
• Terminal Growth Rate: 3%

Step 1: Forecast FCF

Step 2: Calculate Terminal Value

We now take the FCFF at the last forcasted period and calculate the future growth using the perpetuity growth model:

Terminal Value = $24.28M×(1+3%) / (8%−3%) = $25.01M / 5% = $500.17M

Step 3: Discount Cash Flows and TV

Step 4: Sum Present Values

Enterprise Value = 13.89 + 14.57 + 15.24 + 15.89 + 16.52 + 340.41 = $416.52M

Step 5: Adjust for Net Debt

Assuming net debt of $50M:

Equity Value = 416.52−50 = $366.52M

Simplify Your DCF Analysis with SHEETS.MARKET

Building a DCF model from scratch can be time-consuming and prone to errors. That’s where SHEETS.MARKET comes in. Our professionally designed templates and tools are tailored to simplify financial modeling, ensuring accuracy and efficiency.

Why Choose SHEETS.MARKET?

• Pre-Built Templates: Save hours with ready-to-use DCF template.
• Customizable Models: Adjust inputs and assumptions to fit your specific needs.
• Error-Checking Features: Minimize mistakes with built-in validation tools.
• Step-by-Step Guidance: Follow intuitive instructions to build robust models.

Don’t forget to follow our LinkedIn profile for the latest updates, tips, and exclusive financial modeling and valuation content.