Valuation under Discounted cash flow

chhedaamit's picture
Rank: Chimp | 8

I am little confused on DCF Valuation. I did a valuation of a cash inflow for 2 years and terminal value cash flow at the end of 2nd year. I arrived at "x" value. Now by just increasing forecast period from 2 years to 5 years (assuming growth at equal to Cost of capital) and keeping all other assumption constant, I get higher value.

Now, I think this is against basic principal. By just increasing the forecast period how can we increase value of organisation.

The increase in value is equal to PV of cash flow of additional 3 years.

Not vary sure, is this correct way to value.

Comments (11)

Apr 18, 2017

I'd really need to see your model in order to understand, BUT:

1- if you set rev growth to +5% over 2 years and then extend it for another 3 years (5 years in total), then you will see an increase in value because the numerator in your dcf calc is rising (sum of future cash flows)

2- what's the difference in value between a 2 year annuity paying 5% and a 5 year annuity paying 5%? equal to cash flows generated in the additional time periods...

Hope this helps.

Apr 19, 2017

This is not correct. It's not arbitrarily +5% -- it depends on what the discount rate is, etc.

But the premise is correct -- if you achieve great enough growth over a longer discount period, presumably you might capture some value that wasn't included in your prior terminal value calc -- either not baked into the terminal growth rate or not baked into the terminal multiple. The calculation sounds fine; this is just a result of your assumptions.

Remember: a DCF can say whatever you want it to say.

Apr 18, 2017

You need to make assumptions around reinvestment rate, ROIC and long-term growth rate relative to risk free rate (in real terms). If there are inconsistencies across any of these assumptions then increasing the projection period will impact firm value. Illustrative DCF posted at link below.

As an aside, there really should be functionality for people to respond with uploaded files rather than having to create a new thread. It could vastly improve the quality of content posted to answer technical questions.

https://www.wallstreetoasis.com/forums/dcf-illustr...

Apr 19, 2017

Ah perhaps my question is too dumb to be worth the attention!

Apr 18, 2017

Are you using a perpetuity growth calculation for TV or a multiple or fixed number?

If using perpetuity growth method with a consistent growth rate and cost of capital (growth rate input must be less than cost of capital), you'll see that the valuation doesn't change with projection period.

If you're using a multiple or fixed number, then you will see that "distorted" result. This is because you're viewing the organization as a finite-life business and aren't decreasing the terminal value to account for 3 years of age. The reason that most people wouldn't do this, though, and are okay with assigning additional value after 3 years is because in those 3 years, you have grown the business beyond the t=0 cash flow and thus, it should be more valuable.

    • 1
Apr 19, 2017

I would emphasize that if you are doing a perpetual growth formula you are implicitly assuming reinvestment in excess of maintenance capital. By growing FCF without reinvestment and subtracting the growth rate from your WACC you will overstate firm value.

Either you should assume (i) no growth for both the numerator (CY+1 FCF) and the denominator (WACC less growth) or (ii) impute the same statistics including reinvestment required to bring on that incremental FCF in perpetuity. Reinvestment rate as a % of CY+1 FCF can be estimated using the ratio of the long term growth rate divided by WACC.
Consider the companies with negative long-term growth rates...these businesses are spending less than maintenance capex which is effectively a source of cash to stakeholders as invested capital decreases over time.

If this doesn't make intuitive sense, try doing a DCF in excel, calculating the perpetual growth firm value then compare that to a DCF with the same assumptions that goes out 100 years. The DCF terminal value will be significantly lower.

Apr 19, 2017

Can you post a bigger version of what you were trying to post? I can't read it.

I get to $2,707 which is pretty dang close. A few reasons you might be off:
- the implicit reinvestment rate (g/ROIC) is 36%; make sure you deduct reinvestment from earnings to get to free cash flow.
- I'm using a midyear discount, which appears to be what he is doing also. For the terminal free cash flow, I'm using 15 years of discounting, not 14.5
- Your terminal multiple is wrong. The formula for the terminal NOPAT multiple is (1-g/ROIC / WACC - g). You apply this multiple to forward NOPAT, i.e. year 15 NOPAT * 1.045

I would have to see his numbers to know why I'm slightly off. It could be that he rounded down too for simplicity.

Apr 19, 2017

Hi There,

Thank you for your help.

I have been through your points, but couldn't quite arrive at the same figures as you have.

The screen shot of the book has now been added to my original post as an attachment, along with what my spreadsheet looks like.

Once again, thanks for your help!

Apr 19, 2017
Comment