Case 050Valuing listed securities: IPOs, DCF and REITsCore
Build a simple DCF: free cash flow of Rs 80 crore next year growing 12% for five years, then 5% forever, discounted at 11.5%, with Rs 150 crore of net debt. What is the equity value, and which assumption moves it most?
1The situation
Nirjhara Waters bottles and distributes packaged drinking water across western India. Your case pack gives free cash flow of Rs 80 crore for next year, growing 12% a year so that year 5 is the last year of fast growth. From year 6 cash flow grows 5% a year forever. The cost of capital is 11.5% and net debt is Rs 150 crore.
You have two days to build the model and present it to a panel, who will ask what the value is and which assumption they should argue with.
2Your task
What are the enterprise and equity values, how much of the value comes from the terminal value, and which assumption moves the answer most?
Quick check
Roughly what share of enterprise value comes from the terminal value?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
Enterprise value is about Rs 1,542 crore and equity value about Rs 1,392 crore after Rs 150 crore of net debt. The five explicit years contribute only about Rs 362 crore; the terminal value contributes about Rs 1,180 crore, 77% of the total. The discount rate moves the answer most: one point either way swings equity from about Rs 1,180 crore to Rs 1,681 crore.
Step 1How do you lay out the five explicit years?
Grow the cash flow, then discount each year by 1.115 raised to the year number. Year 1 is Rs 80 crore; year 5 is 80 x 1.12 to the power 4, about Rs 125.9 crore. Each year's present value comes out near Rs 72 crore, because 12% growth roughly matches the 11.5% discount rate, so the five years together are worth about Rs 362 crore. That neat pattern is a useful check: when growth and the discount rate are close, every explicit year is worth about the same today.
| Year | Free cash flow | Discount factor at 11.5% | Present value |
|---|---|---|---|
| 1 | 80.0 | 0.8969 | 71.7 |
| 2 | 89.6 | 0.8044 | 72.1 |
| 3 | 100.4 | 0.7214 | 72.4 |
| 4 | 112.4 | 0.6470 | 72.7 |
| 5 | 125.9 | 0.5803 | 73.0 |
| Years 1 to 5 | 362.0 |
Step 2What is the terminal value, and why does it dominate?
A tenant's rent for the next five years is a small part of what a building is worth; the building's value lies in all the rent after that. The terminal value captures every year after year 5 in one number, so it carries most of the value. Year 6 cash flow is 125.9 x 1.05, about Rs 132.2 crore; divided by 11.5% less 5%, the terminal value at year 5 is about Rs 2,033 crore. Discounted five years, that is Rs 1,180 crore today, 77% of the enterprise value of Rs 1,542 crore. Less Rs 150 crore of net debt, equity is about Rs 1,392 crore.
Step 3Which assumption moves the value most?
Flex each one and compare the swing. The discount rate moves it most: at 10.5% equity is about Rs 1,681 crore and at 12.5% about Rs 1,180 crore. Terminal growth comes next, Rs 1,225 crore to Rs 1,620 crore for 4% to 6%, and the five-year growth rate matters least, Rs 1,207 crore to Rs 1,597 crore for 8% to 16%. Both of the big two act through the terminal value, through the gap between the discount rate and growth.
| Assumption flexed | Equity value, high case | Equity value, low case | Swing |
|---|---|---|---|
| Discount rate 10.5% / 12.5% | 1,681 | 1,180 | 500 |
| Terminal growth 6% / 4% | 1,620 | 1,225 | 395 |
| Five-year growth 16% / 8% | 1,597 | 1,207 | 390 |
For the panel, that tells you where to spend your defence. Show the terminal value as an implied exit multiple, so it can be compared with what similar businesses trade at, and check that 5% perpetual growth sits below long-run nominal economic growth. The limit of a simple DCF is that every year's cash flow is a single point estimate; the sensitivity table is the honest way to show the panel how much the answer depends on what you assumed.
Where candidates lose it
The common loss is discounting the terminal value by six years instead of five, or growing it from year 5 cash flow without the extra year of growth. The first slip cuts equity by about Rs 122 crore and the second by about Rs 56 crore, and a panel checks the terminal value line first.
The second miss is spending the presentation on the five-year forecast. It drives only about a quarter of the value; the discount rate and terminal growth deserve the scrutiny.
What the interviewer asks next
- What exit EV/FCF multiple does the terminal value imply, and is it reasonable?
- How would mid-year discounting change the value?
- The panel says 11.5% is too low for a regional consumer business. What do you do?
Asked at HPS Investment Partners, Asset Management, New York, 2025 (Wall Street Oasis): Then got sent the case study, very simple DCF for a fake business. Got 2 days for the case study
Company names and figures are illustrative.
