Discounted Cash Flow (DCF) modelling is one of the most widely used methods for valuing companies, as it provides an estimate of the company’s intrinsic value based on its future cash flow projections. While we previously discussed the DCF analysis setup, this chapter will focus on the practical implementation of a DCF model in valuing a company, providing an in-depth example to demonstrate the entire process.
In DCF modelling, the value of a company is calculated by forecasting its future free cash flows (FCFs) and then discounting them back to the present value using a discount rate, typically the company’s Weighted Average Cost of Capital (WACC). The model also accounts for the Terminal Value (TV), which captures the company's value beyond the forecasted period.
Key Components:
Forecasting Free Cash Flow (FCF)
Choosing a Discount Rate (WACC)
Calculating Terminal Value (TV)
Summing the Present Values of FCF and TV
Step 1: Forecast Free Cash Flows (FCF)
Let’s assume we are valuing a company with the following projected financials for the next five years. Free cash flow is calculated as: FCF = Operating Cash Flows - Capital Expenditures
Year | Revenue | Operating Cash Flow | Capital Expenditures | FCF |
---|---|---|---|---|
2024 | ₹100M | ₹15M | ₹5M | ₹10M |
2025 | ₹110M | ₹18M | ₹6M | ₹12M |
2026 | ₹125M | ₹22M | ₹7M | ₹15M |
2027 | ₹135M | ₹25M | ₹8M | ₹17M |
2028 | ₹150M | ₹28M | ₹10M | ₹18M |
Step 2: Choose a Discount Rate (WACC)
The discount rate typically used in DCF modelling is the Weighted Average Cost of Capital (WACC), which reflects the company’s cost of equity and debt.
Let’s assume the WACC for this company is 10%.
Step 3: Calculate Terminal Value (TV)
To capture the company's value beyond the forecast period, we calculate the terminal value using the Gordon Growth Model:
TV = FCF_(n+1) / (WACC - g)
Where:
FCFₙ₊₁ = Free cash flow in the year after the forecast period (2029).
g =Long-term growth rate (let’s assume 3%).
First, calculate the FCF in 2029 by assuming it grows at the long-term rate:
FCF₍₂₀₂₉₎ = FCF₍₂₀₂₈₎× (1 + g) = 18M × (1 + 0.03) = 18.54M
Now, calculate the terminal value:
TV = 18.54M / (0.10 - 0.03) = 264.86M
Step 4: Calculate the Present Value of Free Cash Flows and Terminal Value
Now, we will discount the FCFs and terminal value back to their present value using the WACC of 10%.
PV = FCFₜ / (1 + WACC)^t
Year | FCF | Discount Factor (10%) | Present Value of FCF |
---|---|---|---|
2024 | ₹10M | 0.909 | ₹9.09M |
2025 | ₹12M | 0.826 | ₹9.91M |
2026 | ₹15M | 0.751 | ₹11.27M |
2027 | ₹17M | 0.683 | ₹11.61M |
2028 | ₹18M | 0.621 | ₹11.18M |
Now, for the terminal value:
PV₍TV₎ = 264.86M / (1 + 0.10)^5 = 164.47M
Step 5: Sum the Present Values
To arrive at the enterprise value (EV) of the company, sum the present values of all FCFs and the terminal value:
EV = 9.09M + 9.91M + 11.27M + 11.61M + 11.18M + 164.47M = 217.53M
Thus, the company's estimated enterprise value using the DCF model is ₹217.53 million.
Revenue Growth: Assumed based on historical trends or market analysis.
WACC: Reflects the company's risk and capital structure.
Terminal Growth Rate (g): Should be conservative, typically in line with GDP growth.
Capital Expenditures: Projected based on the company’s future investment needs.
DCF modelling requires careful forecasting of free cash flows and an appropriate discount rate.
The Terminal Value is crucial, as it often represents the majority of a company’s valuation.
A company's enterprise value is the sum of discounted cash flows and the discounted terminal value.
DCF modelling is a powerful tool for valuing companies, offering an intrinsic value based on future cash flow projections. While assumptions in the model are critical, they provide a clear framework for assessing investment opportunities and company valuations.
Next Chapter Preview: In the next chapter, we will explore Building a Sensitivity Analysis Model in Excel, where we will analyse how changes in key assumptions such as growth rates, WACC, or terminal value affect the overall valuation. Stay tuned for detailed insights into performing sensitivity analysis to assess risk and uncertainty in financial models!
Disclaimer: This article is for informational purposes only and does not constitute financial advice. It is not produced by the desk of the Kotak Securities Research Team, nor is it a report published by the Kotak Securities Research Team. The information presented is compiled from several secondary sources available on the internet and may change over time. Investors should conduct their own research and consult with financial professionals before making any investment decisions. Read the full disclaimer here.
Investments in securities market are subject to market risks, read all the related documents carefully before investing. Brokerage will not exceed SEBI prescribed limit. The securities are quoted as an example and not as a recommendation. SEBI Registration No-INZ000200137 Member Id NSE-08081; BSE-673; MSE-1024, MCX-56285, NCDEX-1262.
Disclaimer: This article is for informational purposes only and does not constitute financial advice. It is not produced by the desk of the Kotak Securities Research Team, nor is it a report published by the Kotak Securities Research Team. The information presented is compiled from several secondary sources available on the internet and may change over time. Investors should conduct their own research and consult with financial professionals before making any investment decisions. Read the full disclaimer here.
Investments in securities market are subject to market risks, read all the related documents carefully before investing. Brokerage will not exceed SEBI prescribed limit. The securities are quoted as an example and not as a recommendation. SEBI Registration No-INZ000200137 Member Id NSE-08081; BSE-673; MSE-1024, MCX-56285, NCDEX-1262.
Explore our comprehensive video library that blends expert market insights with Kotak's innovative financial solutions to support your goals.