• Products
    Investment Suite
    Stocks
    Mutual Funds
    Future and Options
    IPO
    Exchange Traded Funds
    Commodity
    Stockcase (Stock Baskets)
    Non Convertible Debentures
    Sovereign Gold Bond
    Exclusive
    NRI Account
    Corporate/HUF Trading Account
    Private Client Group
    Features
    SipIt
    MTF
    Investment Suite
    Exclusive
    Features
  • Platform
    Trading Platforms
    Kotak Neo App & Web
    Nest Trading Terminal
    NEO Trade APIs
    Features and Tools
    MTF
    Securities Accepted as Collateral
    Margin Requirements
    Equity Screeners
    Payoff Analyzer
    Calculators
    SIP Calculator
    Lumpsum Calculator
    Brokerage Calculator
    Margin Calculator
    MTF Calculator
    SWP Calculator
    CAGR Calculator
    Simple Interest Calculator
    ELSS Calculator
    Step up SIP Calculator
    All Calculators
    Trading Platforms
    Features and Tools
    Calculators
  • Pricing
  • Research
    Research Calls
    Long Term calls
    Short Term calls
    Intraday calls
    Derivatives calls
    Pick of the week
    Top Monthly Picks
    Research Reports
    Fundamental Research Report
    Technical Research Report
    Derivative Research Report
    Research Calls
    Research Reports
  • Market
    Market Movers
    Share Market Today
    Top Gainers
    Top Losers
    Stocks
    Large Cap
    Mid Cap
    Small Cap
    Indices
    Nifty 50
    Bank Nifty
    FinNifty
    Nifty Midcap India
    VIX
    All Indian Indices
    Mutual Funds
    SBI Mutual Funds
    HDFC Mutual Funds
    Axis Mutual Funds
    ICICI Prudential Mutual Funds
    Nippon India Mutual Funds
    All AMC's
    IPO
    Upcoming IPO
    Current IPO
    Closed IPO
    Recently Listed IPO
    Quarterly Results
    Reliance Industries Quarterly Results
    TCS Quarterly Results
    HDFC Bank Quarterly Results
    All Financial Results
    Market Movers
    Stocks
    Indices
    Mutual Funds
    IPO
    Quarterly Results
  • Learn
    Stockshaala
    Basics of Stock Market
    Introduction to Fundamental Analysis
    Introduction to Technical Analysis
    Derivatives, Risk management & Option Trading Strategies
    Personal Finance
    Resource
    Market Ready
    Kotak Insights
    Infographic
    Podcast
    Webinars
    Youtube Channel
    Investing Guide
    Demat Account
    Trading Account
    Share Market
    Intraday Trading
    IPO
    Mutual Funds
    Events
    Budget 2025
    Muhurat Trading
    Share Market Holiday
    Market Outlook 2025
    Stockshaala
    Resource
    Investing Guide
    Events
  • Partner
    Business Associates
    Kotak Connect Plus
    Startup connect
  • Support
    FAQs
    Circulars
    Bulletins
    Contact Us
    Forms Download
    Get your Statement

logo
Financial Calculations & Excel
9 Modules | 51 Chapters
Module 7
Advanced Financial Modeling Techniques
Course Index
Read in
English
हिंदी

Discounted Cash Flow (DCF)

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:

  1. Forecasting Free Cash Flow (FCF)

  2. Choosing a Discount Rate (WACC)

  3. Calculating Terminal Value (TV)

  4. 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.

  1. Revenue Growth: Assumed based on historical trends or market analysis.

  2. WACC: Reflects the company's risk and capital structure.

  3. Terminal Growth Rate (g): Should be conservative, typically in line with GDP growth.

  4. Capital Expenditures: Projected based on the company’s future investment needs.

Key Takeaways:

  • 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.

Conclusion:

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!

Is this chapter helpful?
Share
What could we have done to make this article better?

Building a 3-Statement Financial Model
Building a Sensitivity Analysis Model in Excel

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.

Building a 3-Statement Financial Model
Building a Sensitivity Analysis Model in Excel

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.

Beyond Stockshaala

Discover our extensive knowledge center

Kotak Insights

An insightful weekend read on market trends, company stories, and historical events.

Neo Shorts

A visual spotlight on buzzing sectors and rising stars of the Indian stock market.

Investing Guide

Comprehensive library of blogs focussed to build your financial confidence.

Market Ready

Stay ahead of the game with daily market trends, global insights, and key investment updates.

Webinars

Live sessions with industry leaders for in-depth market knowledge.

Podcast

Latest trends, strategies, and market updates with our seasoned experts.