The Ultimate Guide to DCF Financial Modeling featuring a finance professional analyzing financial charts and business valuation reports on a laptop.
Financial Modeling

DCF Financial Modeling: A Complete Guide With an Indian Example

Written by
Varun Chopra
Published2026-11-10
Updated2026-11-18

DCF financial modeling is a way to value a business by forecasting the cash it will generate in the future and converting that cash into today's money using a discount rate. The discount rate is usually the weighted average cost of capital (WACC). The result is the company's intrinsic value: what it is worth based on its own cash flows, not on what the market is paying today.

Investment bankers, equity research analysts, private equity teams, CFOs and registered valuers in India all use discounted cash flow (DCF) models. This guide explains every part of a DCF model in plain English, shows you how to build one in Excel, and walks through a full worked example of an Indian company using inputs current as of November 2026.

Key takeaways

  • A DCF model values a company as the present value of its future free cash flows, plus a terminal value for the years beyond the forecast.
  • The three inputs that matter most are the free cash flow forecast, the discount rate (WACC) and the terminal growth rate.
  • For Indian companies in late 2026, a typical cost of equity starts from the 10-year G-Sec yield (about 7.2%) plus an equity risk premium of about 7% times beta.
  • Terminal value often makes up 60% to 80% of the total value, so always test it with a sensitivity table and an exit-multiple cross-check.
  • DCF works best for stable, cash-generating businesses. It needs adjustments for banks, early-stage startups and highly cyclical companies.

What Is DCF Financial Modeling?

DCF financial modeling is the process of building a spreadsheet model that estimates a company's value from its expected future free cash flows. The model rests on one idea: a business is worth the cash it can return to its investors over its life, adjusted for when that cash arrives and how risky it is.

A DCF model is called an intrinsic or absolute valuation method. It does not depend on what similar companies trade at. That makes it different from relative valuation methods such as comparable company analysis, which value a business by looking at its peers.

The DCF Formula

Enterprise value in a standard DCF model is the sum of the discounted free cash flows for each forecast year plus the discounted terminal value:

  • EV is enterprise value, the value of the whole business to all capital providers.
  • FCFFₜ is the unlevered free cash flow (free cash flow to the firm) in year t.
  • WACC is the weighted average cost of capital, the blended return lenders and shareholders expect.
  • n is the last year of the explicit forecast period, often year 5.
  • TVₙ is the terminal value, the value of all cash flows after year n.

DCF vs NPV vs IRR: What Is the Difference?

These three terms are related but not the same. DCF is the overall method. NPV and IRR are outputs you can calculate with discounted cash flows.

Term

What it is

What it answers

Typical use

DCF (discounted cash flow)

A valuation method that discounts future cash flows to today

What is this business or asset worth?

Company valuation, M&A, equity research

NPV (net present value)

Present value of future cash flows minus the upfront investment

Does this project create value at my required return?

Capital budgeting, project appraisal

IRR (internal rate of return)

The discount rate at which NPV equals zero

What return does this investment earn?

Private equity, project finance, LBO returns

In short, a DCF valuation of a company gives you its present value. If you subtract the price you would pay for it, you get the NPV of buying it. If you solve for the discount rate that makes that NPV zero, you get the IRR.

Why Are Cash Flows Discounted in a DCF Model?

Cash flows are discounted because money received in the future is worth less than the same amount today. This is the time value of money. A rupee today can be invested to earn a return, while a rupee promised in five years carries both waiting time and risk.

Three reasons drive the discount:

  • Opportunity cost: investors could put their money in other assets with similar risk. The discount rate is the return they give up.
  • Risk: future cash flows are uncertain. Riskier businesses get a higher discount rate, which lowers their present value.
  • Inflation: rising prices reduce what a future rupee can buy.

WACC as the Hurdle Rate

In a DCF model, WACC acts as the company's hurdle rate. If a company earns returns on its invested capital above its WACC, it creates value for shareholders. If it earns less than its WACC, it destroys value even when it reports profits. A business stuck below its cost of capital is often better off returning cash to shareholders through dividends or buybacks than reinvesting it in low-return projects.

Why DCF Uses Cash Flow, Not Net Income

Net income includes non-cash items such as depreciation and leaves out cash spent on new assets and working capital. A company can report rising profits while its cash shrinks, for example when its customers delay payments and receivables pile up. Investors can only be paid from cash, so a DCF model values the cash a business actually generates.

Key Components of a DCF Model

Every DCF model has five building blocks: free cash flow, the discount rate, the forecast period, the terminal value and the bridge from enterprise value to equity value. Getting each one right matters more than any Excel trick.

1. Unlevered Free Cash Flow (FCFF)

Unlevered free cash flow, also called free cash flow to the firm (FCFF), is the cash a business generates from its operations after paying taxes and reinvesting in fixed assets and working capital, but before any payments to lenders or shareholders.

FCFF = EBIT \times (1 - t) + D\&A - Capex - \Delta NWC
  • EBIT × (1 − t) is operating profit after tax, also called NOPAT.
  • D&A (depreciation and amortisation) is added back because it is a non-cash expense.
  • Capex is cash spent on new plant, equipment and technology.
  • ΔNWC is the increase in net working capital, such as more inventory or receivables as sales grow.

It is called "unlevered" because it ignores how the company is financed. Interest is left out, so the cash flow belongs to all capital providers, both debt and equity.

2. Discount Rate: Weighted Average Cost of Capital (WACC)

WACC is the average return that lenders and shareholders require, weighted by how much of each the company uses. It is the right discount rate for unlevered free cash flow because that cash belongs to both groups.

WACC = \frac{E}{D + E} \times K_e + \frac{D}{D + E} \times K_d \times (1 - t)

Cost of Equity (Using CAPM)

Most analysts estimate the cost of equity (Kₑ) with the capital asset pricing model:

K_e = R_f + \beta \times ERP
  • Rƒ (risk-free rate): for a rupee-based model, use the 10-year Government of India bond yield.
  • β (beta): how much the stock moves relative to the market. A beta above 1 means more risk than the market.
  • ERP (equity risk premium): the extra return investors demand for holding equities over government bonds. For India, it includes a country risk premium.

Cost of Debt

The cost of debt (Kd) is the interest rate the company would pay on new long-term borrowing. Use the after-tax figure, because interest is tax-deductible in India: Kd × (1 − tax rate).

Capital Structure Weights

Use market values, not book values, for equity and debt where possible. For a listed company, equity value is its market capitalisation. If the company plans to change its debt levels, use its target capital structure.

3. Forecast Period

The forecast period (or explicit forecast period) is the number of years you project cash flows in detail before switching to a terminal value. Most DCF models use five years. Use a longer period, often 7 to 10 years, when a company is still growing fast and will take longer to reach a steady state.

Based on Company Maturity

A mature company with stable margins, such as a large FMCG or utility business, can be forecast for about five years. A young, fast-growing company needs a longer forecast so its growth can slow down to a sustainable rate before the terminal value starts.

Based on Exit Strategy

Private equity investors often match the forecast period to their expected holding period, which is commonly 3 to 7 years. The terminal value then reflects the expected sale price at exit.

Based on Market Characteristics

In industries with long contracts or long asset lives, such as infrastructure, power or toll roads, analysts often forecast for the full concession period. In fast-changing sectors such as technology, forecasts beyond five years carry much more uncertainty.

Company type

Typical forecast period

Why

Mature, stable (FMCG, utilities)

5 years

Growth and margins are already steady

High-growth (tech, new-age consumer)

7 to 10 years

Needs time for growth to slow to a steady rate

Project or concession assets

Full contract life

Cash flows end when the contract ends

PE buyout target

Holding period, 3 to 7 years

Value is realised at exit

4. Terminal Value

Terminal value (TV) captures the value of all cash flows after the forecast period. Because a company is usually assumed to operate indefinitely, terminal value is often the largest part of a DCF valuation. There are two standard methods, and good analysts calculate both and compare them.

Perpetuity Growth Method (Gordon Growth Model)

This method assumes free cash flow keeps growing at a constant rate (g) forever:

TV_n = \frac{FCFF_n \times (1 + g)}{WACC - g}

The growth rate must be lower than WACC, or the formula breaks. It should also be at or below the long-term nominal growth rate of the economy, because no company can outgrow the economy forever.

Exit Multiple Method

This method assumes the business is sold at the end of the forecast period at a multiple of a financial metric, usually EBITDA:

TV_n = EBITDA_n \times \text{Exit EV/EBITDA multiple}

The multiple is taken from comparable companies or recent transactions in the same sector.

Feature

Perpetuity growth method

Exit multiple method

Main assumption

Cash flows grow at a steady rate forever

Business is sold at a market multiple

Key input

Long-term growth rate (g)

EV/EBITDA or similar multiple

Strength

Grounded in the company's own cash flows

Reflects how the market prices similar companies

Weakness

Very sensitive to small changes in g and WACC

Brings market mispricing into an intrinsic valuation

Best used for

Stable businesses with predictable cash flows

Deal work, sectors with reliable trading multiples

A quick cross-check: convert your perpetuity-growth terminal value into an implied EV/EBITDA multiple, and convert your exit multiple into an implied growth rate. If either implied number looks unrealistic for the sector, revisit your assumptions.

5. From Enterprise Value to Equity Value

The DCF gives you enterprise value, which belongs to all capital providers. To find what shareholders own, build the equity bridge:

\text{Equity value} = EV + \text{Cash and non-operating assets} - \text{Debt} - \text{Preference capital} - \text{Minority interest}

Then divide equity value by the diluted number of shares, which includes the effect of ESOPs and convertible instruments, to get the intrinsic value per share. Compare that with the current share price to judge whether the stock looks undervalued or overvalued.

How to Build a DCF Model in Excel: 7 Steps

You can build a working DCF model in Excel in seven steps, moving from historical numbers to a value per share and a sensitivity table. Keep inputs, calculations and outputs on separate, clearly labelled sections or sheets so anyone can audit the model.

Step 1: Collect and Clean Historical Financials

Pull three to five years of income statements, balance sheets and cash flow statements. For listed Indian companies, use annual reports and quarterly results filed on BSE and NSE. Remove one-off items such as asset sale gains or exceptional write-offs so the base year reflects normal operations.

Step 2: Forecast Revenue and Operating Drivers

Project revenue first, then link costs, margins, capex and working capital to it. For a quick model, use a growth rate and margins as a percentage of revenue. For a detailed model, build revenue from drivers such as volume × price, stores × revenue per store, or users × average revenue per user. A fully linked three-statement financial model is the most reliable base for these forecasts.

Step 3: Calculate Unlevered Free Cash Flow

For each forecast year, compute EBIT, subtract tax to get NOPAT, add back D&A, then subtract capex and the increase in net working capital. That gives FCFF.

Step 4: Estimate the Discount Rate (WACC)

Calculate the cost of equity with CAPM, the after-tax cost of debt, and the market-value weights of debt and equity. Use a beta from listed peers in the same industry, re-levered to the company's own debt level, rather than a single noisy regression beta.

Step 5: Calculate the Terminal Value

Apply the perpetuity growth formula to the final year's FCFF. Then calculate an exit multiple terminal value as a cross-check. If the two are far apart, find out why before moving on.

Step 6: Discount Cash Flows and Bridge to Equity Value

Discount each year's FCFF and the terminal value back to today, add them to get enterprise value, then add cash and subtract debt and other claims to reach equity value. Divide by diluted shares for the value per share.

Step 7: Run Sensitivity and Scenario Analysis

Build a two-way data table (Excel's Data → What-If Analysis → Data Table) showing value per share across a range of WACC and terminal growth rates. Add base, bull and bear scenarios for revenue growth and margins. A DCF should give you a value range, not a single magic number.

Useful Excel Functions for DCF Modeling

Function

What it does

Watch out for

=NPV(rate, values)

Discounts a series of evenly spaced cash flows

Assumes the first cash flow arrives at the end of period 1

=XNPV(rate, values, dates)

Discounts cash flows on actual dates

Best choice when cash flows are not exactly one year apart

=IRR(values)

Return at which NPV equals zero for evenly spaced flows

Needs at least one negative and one positive cash flow

=XIRR(values, dates)

IRR for cash flows on actual dates

Standard in PE and VC return analysis

Data Table (What-If Analysis)

Builds a sensitivity grid from two inputs

Set calculation to automatic, and keep tables small to avoid slowing the file

Mid-Year Convention and Stub Periods

The standard formula assumes each year's cash arrives on the last day of the year. In reality, cash comes in throughout the year. The mid-year convention discounts each cash flow by (t − 0.5) years instead of t, which raises the value slightly. In the worked example below, it lifts enterprise value by about 1.9%. If your valuation date falls partway through a financial year, use a stub period for the remaining months so the first cash flow is not over-counted.

DCF Example: Valuing an Indian Company Step by Step

The two examples below show DCF in action. The first is a simple present value calculation. The second is a full five-year DCF of a fictional Indian company, using real market inputs as of November 2026. All company figures are illustrative.

Simple DCF Example: ₹10 Lakh a Year for 5 Years

Suppose an investment pays ₹10,00,000 at the end of each year for five years, and your required return is 10%. Each year's cash flow is divided by (1.10) raised to the power of the year number.

Year

Cash flow (₹)

Discount factor at 10%

Present value (₹)

1

10,00,000

0.9091

9,09,091

2

10,00,000

0.8264

8,26,446

3

10,00,000

0.7513

7,51,315

4

10,00,000

0.6830

6,83,013

5

10,00,000

0.6209

6,20,921

Total

50,00,000

37,90,787

The investment pays ₹50 lakh in total, but it is worth only about ₹37.9 lakh today at a 10% required return. If it costs less than ₹37.9 lakh, its NPV is positive and it is worth considering.

Full DCF Example: Sahyadri Foods Ltd (Illustrative)

Sahyadri Foods Ltd is a fictional listed Indian packaged-foods company. Its revenue for FY2026 (April 2025 to March 2026) was ₹500 crore. We forecast FY2027 to FY2031 and value the company as of today.

Assumptions

Input

Value

Basis

Revenue growth, FY27 to FY31

15%, 14%, 12%, 10%, 8%

Growth slows as the company matures

EBITDA margin

18% of revenue

Steady for a mid-sized FMCG company

Depreciation and amortisation

3% of revenue

Based on historical asset base

Capex

5% of revenue

Capacity expansion plus maintenance

Net working capital

10% of the change in revenue

Extra inventory and receivables as sales grow

Tax rate

25.17%

22% concessional rate plus surcharge and cess

Risk-free rate

7.20%

10-year G-Sec yield, rounded (7.22% on 11 Nov 2026)

Equity risk premium (India)

7.08%

Damodaran, January 2026

Beta

1.10

Re-levered peer beta (illustrative)

Pre-tax cost of debt

9.5%

Typical for an A-rated mid-size borrower (illustrative)

Capital weights

80% equity, 20% debt

Target capital structure

Terminal growth rate

5.0%

Below long-run nominal GDP growth

Net debt

₹150 crore

Debt minus cash

Diluted shares

5 crore

Including ESOPs

Step 1: Forecast Free Cash Flow to the Firm (₹ crore)

Line item

FY27

FY28

FY29

FY30

FY31

Revenue

575.0

655.5

734.2

807.6

872.2

EBITDA (18%)

103.5

118.0

132.1

145.4

157.0

Less: D&A

17.3

19.7

22.0

24.2

26.2

EBIT

86.3

98.3

110.1

121.1

130.8

Less: Tax at 25.17%

21.7

24.7

27.7

30.5

32.9

NOPAT

64.5

73.6

82.4

90.6

97.9

Add: D&A

17.3

19.7

22.0

24.2

26.2

Less: Capex

28.8

32.8

36.7

40.4

43.6

Less: Increase in NWC

7.5

8.1

7.9

7.3

6.5

FCFF

45.5

52.4

59.9

67.2

74.0

Figures are rounded to one decimal, so some columns may not add exactly.

Step 2: Calculate WACC

  • Cost of equity = 7.20% + 1.10 × 7.08% = 14.99%
  • After-tax cost of debt = 9.5% × (1 − 0.2517) = 7.11%
  • WACC = 80% × 14.99% + 20% × 7.11% = 13.41%, rounded to 13.4%

Step 3: Calculate Terminal Value

Terminal value at the end of FY31 = 74.0 × (1 + 5%) ÷ (13.4% − 5%) = ₹924.9 crore.

Step 4: Discount to Present Value

Year

FCFF (₹ cr)

Discount factor at 13.4%

Present value (₹ cr)

FY27

45.5

0.8818

40.2

FY28

52.4

0.7776

40.8

FY29

59.9

0.6857

41.0

FY30

67.2

0.6047

40.6

FY31

74.0

0.5333

39.5

Terminal value

924.9

0.5333

493.2

Enterprise value

695.3

Step 5: From Enterprise Value to Value per Share

  • Enterprise value: ₹695.3 crore
  • Less net debt: ₹150.0 crore
  • Equity value: ₹545.3 crore
  • Divided by 5 crore diluted shares = ₹109 per share

If Sahyadri Foods trades at ₹85, the DCF suggests it may be undervalued. If it trades at ₹140, the market is pricing in more growth or less risk than this model assumes.

Step 6: Sensitivity Analysis (Value per Share, ₹)

WACC ↓ / Terminal growth →

4.0%

4.5%

5.0%

5.5%

6.0%

12.4%

114

121

129

138

148

12.9%

105

111

118

126

135

13.4%

98

103

109

116

123

13.9%

91

96

101

107

113

14.4%

85

89

94

99

105

At 5% growth, moving WACC one point either way, from 12.4% to 14.4%, swings the value between ₹129 and ₹94 per share. That range, not the single ₹109 figure, is the honest answer a DCF gives.

Step 7: Sanity Checks

  • Terminal value share: the discounted terminal value (₹493.2 crore) is about 71% of enterprise value. That is normal for a DCF, but it shows how much rides on the terminal assumptions.
  • Implied exit multiple: the terminal value equals about 5.9x FY31 EBITDA. If listed Indian food companies trade at much higher multiples, your growth or WACC assumptions may be too conservative, or the market may be too optimistic.
  • Implied growth from an exit multiple: if you used a 10x exit multiple instead, the value would rise to about ₹178 per share, but that multiple implies perpetual cash flow growth of about 8.3% a year. That is close to India's nominal GDP growth forever, which is aggressive for a single company.
  • Mid-year convention: discounting at mid-year raises enterprise value from ₹695.3 crore to about ₹708.4 crore, or about ₹112 per share.

India-Specific DCF Inputs for 2026-27

For a rupee-based DCF built in late 2026, start with a risk-free rate of about 7.2% and an India equity risk premium of about 7%. These inputs move with markets, so check the latest figures on the day you build your model.

Input

Current value

Source and date

How to use it

Risk-free rate (10-year G-Sec yield)

7.22%

RBI data for 11 Nov 2026, via Clarity UPSC

Use the benchmark 10-year yield on your valuation date

India equity risk premium

7.08% (4.23% mature market + 2.85% country risk premium)

Damodaran, NYU Stern, January 2026 update

Multiply by beta in CAPM

RBI policy repo rate

5.50%

RBI Monetary Policy Statement, 7 Oct 2026

Signals the direction of borrowing costs

Corporate tax rate (concessional regime)

22% base, about 25.17% effective

Section 200, Income-tax Act 2025, per SetIndiaBiz

Use for NOPAT and the debt tax shield

Real GDP growth projection, 2026-27

7.1%

RBI, 7 Oct 2026

Context for long-run growth assumptions

CPI inflation projection, 2026-27

5.2%

RBI, 7 Oct 2026

Keep cash flows and discount rate both in nominal terms

A few practical points for Indian models in 2027:

  • The risk-free rate has moved a lot this year. The 10-year yield traded around 6.7% to 6.8% in August 2026 and touched about 7.47% in late October 2026, its highest level since March 2023, according to Trading Economics. A 0.5-point swing in the risk-free rate changes most valuations noticeably.
  • Rates are rising, not falling. On 7 October 2026, the RBI raised the repo rate by 25 basis points to 5.50% and changed its stance to "calibrated tightening". Expect higher costs of debt in 2027 refinancing.
  • Choose the tax regime the company actually uses. Companies under the old regime pay a 25% or 30% base rate plus surcharge and cess. The new Income-tax Act, 2025 applies to income earned from 1 April 2026, but the 22% concessional regime continues under it.
  • Keep the terminal growth rate below the risk-free rate. Many analysts use 4% to 6% in rupee terms for mature Indian companies. A rate above the 10-year bond yield implies the company outgrows the whole economy forever.

Unlevered vs Levered DCF: FCFF vs FCFE

An unlevered DCF discounts free cash flow to the firm (FCFF) at WACC and gives enterprise value. A levered DCF discounts free cash flow to equity (FCFE) at the cost of equity and gives equity value directly. Both should reach similar answers if the assumptions are consistent.

Feature

Unlevered DCF (FCFF)

Levered DCF (FCFE)

Cash flow used

Before interest and debt repayments

After interest and net borrowing

Discount rate

WACC

Cost of equity

Direct output

Enterprise value

Equity value

Formula

EBIT × (1 − t) + D&A − Capex − ΔNWC

FCFF − Interest × (1 − t) + Net borrowing

Best for

Most companies, especially when debt levels may change

Banks, NBFCs and insurers, where debt is part of operations

Used most in

Investment banking, equity research, M&A

Financial-sector research, dividend-focused analysis

The unlevered approach is far more common because it separates the business's operating performance from how it is financed.

DCF vs Relative Valuation Methods

DCF tells you what a business should be worth based on its own cash flows. Relative valuation tells you what the market is paying for similar businesses. Professionals use both and show the results side by side on a football field chart. Read more about the main valuation methods in finance.

Method

How it works

Main strength

Main weakness

DCF analysis

Discounts forecast cash flows at a risk-adjusted rate

Based on fundamentals; not swayed by market moods

Highly sensitive to assumptions

Comparable company analysis

Applies peer multiples such as EV/EBITDA or P/E

Quick, market-based, easy to explain

Peers can all be overvalued at the same time

Precedent transactions

Applies multiples paid in past acquisitions

Captures control premiums paid in deals

Old deals may not reflect today's market

Asset-based (NAV) valuation

Values assets minus liabilities

Useful for holding companies, real estate, liquidation

Ignores future earning power

For a full comparison of model types, see our guide to the types of financial models.

Advantages and Limitations of DCF Analysis

DCF is the most complete valuation method because it forces you to think through every driver of value, but its output is only as good as its assumptions.

Advantages of DCF Analysis

  • Measures intrinsic value: it values a company on its own cash flows, independent of market sentiment.
  • Works without close peers: useful for unique businesses where good comparable companies do not exist.
  • Makes assumptions visible: every growth, margin and capex assumption sits in the model, where others can test and challenge it.
  • Supports decisions beyond valuation: the same framework appraises projects, acquisitions, capacity expansions and buy-versus-lease choices.
  • Shows what drives value: sensitivity and scenario tables reveal which inputs matter most.
  • Long-term view: it focuses on cash generation over many years rather than one quarter's earnings.

Limitations of DCF Analysis

  • Sensitive to small changes: in the example above, raising WACC by one point (13.4% to 14.4%) cut the value per share by about 14%.
  • Terminal value dominates: most of the value usually sits in years you cannot forecast with confidence.
  • WACC is an estimate: beta, the equity risk premium and capital weights all involve judgement.
  • Needs good data: reliable forecasts are hard for startups, turnarounds and companies with little history.
  • Can look more precise than it is: a value to the last rupee hides wide uncertainty.
  • Time-consuming: a full DCF linked to three statements takes far longer than a multiples-based valuation.

Common DCF Mistakes and How to Fix Them

Mistake

Why it is a problem

How to fix it

Terminal growth rate above the risk-free rate

Implies the company outgrows the economy forever

Keep g below the 10-year G-Sec yield; 4% to 6% is common in rupee models

Mixing FCFF with the cost of equity

Gives an inflated value

Pair FCFF with WACC and FCFE with cost of equity

Using book values for WACC weights

Misstates the real cost of capital

Use market capitalisation and market or fair value of debt

Forgetting working capital

Overstates cash flow for growing firms

Model receivables, inventory and payables as days or % of revenue

Capex lower than depreciation forever

Assumes assets never need replacing

Let capex at least match D&A in the terminal year for a growing company

Ignoring ESOPs and convertibles

Overstates value per share

Use diluted shares (treasury stock method)

Mixing real and nominal numbers

Inconsistent results

Keep cash flows and discount rate both nominal and in the same currency

Skipping sensitivity analysis

Hides how fragile the answer is

Always show a WACC × growth grid and scenarios

What Does a DCF Model Not Include?

A standard DCF values the business as it stands under your forecast. It usually leaves out:

  • Synergies a buyer could gain from merging with another company, which are valued separately in M&A.
  • Control premium that an acquirer might pay to take charge of strategy.
  • Real options, such as the right to expand, delay or abandon a project.
  • Liquidity discounts for unlisted or thinly traded shares.
  • Market sentiment and short-term price momentum, which affect the share price but not intrinsic value.
  • Non-operating assets and contingent liabilities, unless you add them explicitly in the equity bridge.

How DCF Is Used in India: Regulation, Uses and Careers

In India, DCF is not only an analyst's tool. It is a recognised valuation method under the country's valuation standards and company law, and a core skill in most finance jobs.

Where DCF Is Used

  • Equity research: brokerages publish target prices for listed companies based on DCF and multiples.
  • IPOs and fundraising: merchant bankers and startups use DCF to support issue prices and pre-money valuations.
  • Mergers and acquisitions: buyers value targets and synergies with DCF before bidding.
  • Private equity and venture capital: funds test entry prices against expected cash flows and exit values.
  • Financial reporting: fair value measurement under Ind AS 113 and impairment testing under Ind AS 36 often rely on discounted cash flows.
  • Corporate finance: CFOs use DCF to approve capex, new plants and new product lines.

Regulatory Framework for DCF Valuation in India

  • Registered valuers: Section 247 of the Companies Act, 2013, in force since 18 October 2017, requires valuations of shares, securities, goodwill and net worth under the Act to be done by a registered valuer. The Insolvency and Bankruptcy Board of India (IBBI) regulates registered valuers.
  • Valuation standards: ICAI Valuation Standard 103 sets out three approaches: market, income and cost. The DCF method sits under the income approach.
  • Income-tax valuations: under the Income-tax Act, 1961 rules, a DCF-based fair market value of shares had to come from a merchant banker, as the ICAI Valuation Standards Board explains in its published guidance. Check the matching rules under the Income-tax Act, 2025 for income earned from 1 April 2026.

Careers That Use DCF Modeling

Role

How DCF is used

Learn more

Investment banking analyst

Values companies for M&A, IPOs and fundraising pitch books

Investment banking financial modeling

Equity research analyst

Sets target prices and buy, hold or sell calls

Financial modeling interview questions

Private equity and VC associate

Tests entry valuation and exit returns

Types of financial models

Corporate finance and FP&A

Appraises projects and capex plans

Components of financial modeling

Valuation and transaction advisory

Prepares valuation reports for deals and compliance

Valuation methods in finance

Financial advisor and wealth manager

Assesses whether stocks look under- or overvalued

Who is a financial advisor?

What to Include in a DCF Model Template

A good DCF template in Excel has a fixed structure, so every user knows where to find inputs and outputs. Include these sheets or sections:

  1. Cover and assumptions: valuation date, currency, units, and every key input in one place, colour-coded (blue for inputs, black for formulas).
  2. Historical financials: three to five years of income statement, balance sheet and cash flow data.
  3. Forecast: revenue drivers, margins, capex, D&A and working capital schedules.
  4. Free cash flow build: EBIT to NOPAT to FCFF for each year.
  5. WACC calculation: risk-free rate, beta, equity risk premium, cost of debt and weights, each with its source and date.
  6. Terminal value: both perpetuity growth and exit multiple, with implied cross-checks.
  7. Valuation summary: enterprise value, equity bridge, diluted shares and value per share.
  8. Sensitivity and scenarios: WACC × growth grid, plus bull, base and bear cases.
  9. Checks: balance sheet balances, cash flow ties out, no hard-coded numbers inside formulas.

How to Learn DCF Financial Modeling

The fastest way to learn DCF is to build models of real listed companies from a blank Excel sheet, then compare your value with the market price and with analyst reports. Start with the basics:

  1. Get comfortable with accounting: understand how the income statement, balance sheet and cash flow statement link together. Our guide to financial modeling terms is a good starting point.
  2. Build a three-statement model first: follow our step-by-step guide to creating a three-statement model.
  3. Practise Excel for finance: learn NPV, XNPV, XIRR, INDEX-MATCH and data tables.
  4. Value three to five real companies: pick businesses in different sectors and compare your DCF with comparable company multiples.
  5. Get feedback: have an experienced modeller review your assumptions and structure.

If you want to learn by yourself, see our guide on how to learn financial modeling on your own. For structured, mentor-led training, the IIM SKILLS Financial Modelling Course is a 5-month live online programme with weekend classes. Its valuation module covers DCF, FCFF vs FCFE, WACC and CAPM, beta, terminal value, comparable companies, precedent transactions and football field charts, and learners build 12+ models from a blank sheet.

Frequently Asked Questions About DCF Financial Modeling

What is a DCF financial model in simple words?

A DCF financial model is a spreadsheet that estimates what a business is worth today by adding up the cash it is expected to generate in the future, after converting each future rupee into today's value with a discount rate. If the value per share is above the market price, the stock may be undervalued.

Is NPV the same as DCF?

No. DCF is the valuation method of discounting future cash flows. NPV is one result of that method: the present value of future cash flows minus the initial investment. A DCF valuation of a company gives its present value; subtracting the purchase price gives the NPV of buying it.

What discount rate should I use for an Indian company in 2027?

For most mid-sized Indian companies, WACC in rupee terms falls roughly between 11% and 15% at today's rates. Build it from the 10-year G-Sec yield (7.22% on 11 November 2026), an India equity risk premium of about 7.08% (Damodaran, January 2026), the company's beta and its after-tax cost of debt.

What terminal growth rate is reasonable for Indian companies?

Most analysts use 4% to 6% in nominal rupee terms for mature Indian companies. The rate should stay below both the WACC and the 10-year government bond yield, and should not exceed India's long-run nominal GDP growth.

How many years should a DCF forecast cover?

Five years is standard for stable companies. Use 7 to 10 years for fast-growing businesses so their growth can slow to a sustainable rate before the terminal value begins.

What percentage of DCF value usually comes from terminal value?

Terminal value commonly makes up 60% to 80% of enterprise value. In the Sahyadri Foods example in this guide, it is about 71%. A share above 85% suggests the forecast period may be too short.

How do you forecast revenue growth in a DCF?

Start with historical growth, calculated as (current year revenue − previous year revenue) ÷ previous year revenue. Then adjust it for industry growth, market share, pricing and capacity. For detailed models, build revenue from drivers such as volume × price instead of a single growth rate.

Can you use DCF to value a startup or a loss-making company?

Yes, but with care. Forecast until the business reaches steady, positive cash flow, often 10 years or more, and use scenarios to reflect the chance that it fails. Many investors combine DCF with venture capital and multiples methods for early-stage companies.

Does DCF work for banks and NBFCs?

A standard FCFF-based DCF does not suit banks and NBFCs, because borrowing is part of their operations rather than just financing. Analysts usually use a free cash flow to equity model, a dividend discount model or an excess return model, with the cost of equity as the discount rate.

How do you answer "walk me through a DCF" in an interview?

Say that you forecast unlevered free cash flow for about five years, calculate a terminal value with the perpetuity growth or exit multiple method, discount both to today at WACC to get enterprise value, then subtract net debt and divide by diluted shares to reach value per share. Mention that you would test the result with a sensitivity table.

Can AI tools build a DCF model?

AI tools can speed up formula writing, data collection and formatting. They cannot replace the judgement behind growth, margin, WACC and terminal assumptions, which is where most of a DCF's value and risk lie. Always check every formula and source yourself.

Conclusion

DCF financial modeling turns a company's future cash flows into a single estimate of its value today. The method itself is simple: forecast free cash flow, choose a discount rate, estimate terminal value, discount everything and bridge to equity. The real skill lies in making realistic assumptions, keeping them consistent, and testing how much the answer changes when they move.

For 2027, use current Indian inputs such as a risk-free rate near 7.2% and an equity risk premium near 7%, and update them each time you build a model. Pair every DCF with a sensitivity table and a relative valuation cross-check. With practice on real companies, DCF becomes one of the most valuable skills for careers in investment banking, equity research, private equity and corporate finance.

Varun Chopra
Written by

Varun Chopra

Founder, The Algebra Group · Ex-PwC, TresVista & Moody's

Seasoned valuation specialist with 10+ years across PwC, TresVista, and Moody's Analytics. Focuses on building institutional-grade models completely from a blank sheet.

Raj Arora, CFA
Reviewed by

Raj Arora, CFA

M&A Professional, Wodehouse Capital Advisors · FMVA

Chartered Financial Analyst (CFA) and FMVA certified expert. Leads transaction mandates at Wodehouse Capital Advisors, with prior research tenure at SG Analytics.

Tushar Bharadwaj
Reviewed by

Tushar Bharadwaj

Senior M&A & Infrastructure Investments Specialist, Cube Highways

Over a decade of hands-on transaction advisory experience with Cube Highways, EY, and Macquarie. Expert in complex multi-currency cash flow forecasting and project feasibility.

Free Download

Get Course Brochure

Detailed curriculum, placement report & fee structure.

Phone

100% Privacy Protected. No Spam Guarantee.

phone
Call
WhatsApp
We are here to help you.
phone
Call
WhatsApp
We are here to help you.