Instant PDF download after payment11 Shelves, 11 books in each, ₹699 a ShelfIndian companies, Indian rupeesWorksheets and Excel templates includedFree Chapter 1 from every ShelfQuestions? support@proshelf.in
0
Home/Blog/How-to
How-to · Corporate Finance

How to build a DCF valuation, and stress-test it

A discounted cash flow valuation step by step, with a worked example and the checks that keep it honest.

What It's Worth cover
A DCF adds up the present value of a few forecast years and of everything after them; most of the value usually sits in the second part.
The idea

The DCF in five steps

  1. Forecast free cash flow for five to ten years, until the business reaches a steady state (Chapter 3).
  2. Choose the discount rate (Chapter 4).
  3. Discount each year's cash flow back to the valuation date.
  4. Add a terminal value for all years after the forecast, also discounted.
  5. Bridge to equity value by subtracting net debt and other claims (Chapter 2).

FCFF Years 3–7 → Discount at 12.5% → + Terminal value → = Enterprise value → − Net debt → = Equity value

Vardhan's forecast covers five years (Years 3–7). By Year 7 growth has slowed to 8%, so the terminal value at 5% growth is a small further step, not a cliff.

Vardhan's DCF at a glanceChoice
Valuation dateEnd of Year 2
ForecastFive years, Years 3–7 (Book 4 base case, extended)
Cash flowFCFF, year-end convention
Discount rateWACC 12.5%
Terminal valueGrowth 5%; return on new capital 20%
The method

Discounting the forecast years

Each year's free cash flow is divided by (1 + WACC) raised to the number of years from the valuation date. This book assumes cash arrives at the end of each year; some valuers use mid-year, which raises value slightly.

₹ croreYear 3Year 4Year 5Year 6Year 7Total
Free cash flow to the firm28.744.348.756.463.9
Years from valuation date12345
Discount factor at 12.5%0.8890.7900.7020.6240.555
Present value25.535.034.235.235.4165.4
PV figures are from unrounded numbers, so the row may not add exactly.

In Excel: =FCFF/(1+WACC)^year, or NPV(WACC, range) for the whole row, which assumes year-end cash flows.

The method

The terminal value

The business doesn't stop after Year 7. The terminal value (TV) captures all later years in one number, usually with a constant-growth formula.

Terminal value at end of Year 7 = FCFF in Year 8 ÷ (WACC − long-term growth)Vardhan: 66.8 ÷ (12.5% − 5.0%) = ₹890.7 crore
StepVardhan
NOPAT in Year 8 = Year 7 NOPAT × (1 + 5%)84.8 × 1.05 = 89.1
Reinvestment rate = growth ÷ ROIC on new capital5% ÷ 20% = 25%
FCFF in Year 8 = NOPAT × (1 − reinvestment rate)89.1 × 75% = 66.8
Terminal value at end of Year 766.8 ÷ 0.075 = 890.7
Present value (× Year 7 discount factor 0.555)494.3

An alternative is an exit multiple (say, EV/EBITDA at the end of Year 7), but it brings today's market mood into a long-term value. Use it as a cross-check.

Example

Vardhan's DCF

₹ croreAmountShare of EV
Present value of FCFF, Years 3–7165.425%
Present value of terminal value494.375%
Enterprise value659.7100%
Less: net debt (₹90.0 cr borrowings − ₹45.0 cr cash)−45.0
Equity value614.7
Per share (2.0 crore shares)₹307
₹659.7 crenterprise value
₹614.7 crequity value
75%of value after Year 7

Book value of Vardhan's equity is ₹240 crore, so the DCF values the shares at about 2.6 times book: the market for the business, not its balance sheet, drives the value.

The method

How sensitive is it?

Show how value per share changes with the two inputs that matter most: the WACC and the long-term growth rate. Every serious DCF includes a table like this.

Value per share (₹)Growth 4%Growth 5%Growth 6%
WACC 11.5%336361395
WACC 12.5% (base)291307329
WACC 13.5%255267281
Equity value (₹ crore)Growth 4%Growth 5%Growth 6%
WACC 11.5%671721789
WACC 12.5% (base)581615658
WACC 13.5%510533562
Reinvestment rises with growth (growth ÷ 20%) in every cell, so higher growth is not free.
Try it yourself

Questions from the worksheet: DCF summary

Summarise the DCF of the business you are valuing on one page.

  1. Forecast years and FCFF in each
  2. WACC and its main inputs
  3. Terminal value: growth, reinvestment, implied exit multiple
  4. Enterprise value; share from the terminal value
  5. Bridge to equity value and per share
  6. Sensitivity: value at WACC ±1 and growth ±1
  7. Sanity checks passed or failed
In three lines

What to remember

  1. A DCF = present value of forecast free cash flows + present value of the terminal value.
  2. Make terminal growth modest and reinvestment consistent with it; check the implied multiple.
  3. Always show a WACC × growth sensitivity table and run sanity checks.
Terminal value
The value of all cash flows beyond the forecast period.
Discount factor
1 ÷ (1 + rate)^years; converts future cash to today's value.
Reverse DCF
Working out what assumptions a given price implies.

This article is adapted from the book. Examples marked “Example” use invented names and numbers; company stories are based on public sources listed in the book. Education only: not investment, tax or legal advice.