Valuation Tutorials

- Valuation Basics
- Discounted Cash Flows
- Dividend Discount Model (DDM)
- Gordon Growth Model
- Discounted Cash Flow Analysis (DCF)
- Free Cash Flow to Firm (FCFF)
- Free Cash Flow to Equity (FCFE)
- Terminal Value
- Cost of Equity
- CAPM Beta
- Calculate Beta Coefficient
- Market Risk Premium
- Weighted Average Cost of Capital (WACC)
- Security Market Line (SML)
- Free Cash Flow (FCF)
- Free Cash Flow Yield (FCFY)
- Mistakes in DCF
- Treasury Stock Method
- CAPM Formula
- Cash Flow vs Free Cash Flow

- Valuation Multiples
- Equity Value vs Enterprise Value
- Trading Multiples
- Comparable Company Analysis
- Transaction Multiples
- (Price Earning Ratio (P/E)
- Price to Cash Flow (P/CF)
- Price to Book Value Ratio (P/B)
- Price Earning Growth Ratio (PEG)
- Trailing PE vs Forward PE
- Forward PE
- EV to EBITDA Multiple
- EV to EBIT Ratio
- EV to Sales Ratio
- EV to Assets

- Other Valuation Tools
- Valuation Interview Prep

**YES!**Yes, we make Valuation models, but are we 100% correct? Even small mistakes can hugely affect your analysis.

So let’s try to decode some major mistakes in discounted cash flow analysis. In this article we discuss the following –

- Infographics: Snapshot of Steps to DCF Analysis
- Impact of DCF Mistakes
- Mistake#1-Forecast Horizon: Too Much or Too Less!
- Mistake#2-Cost of Capital: A Challenge?
- MIstake#3-Growth Rate Assumptions: Extreme?
- Other Errors

**Recommended Courses**

Before directly jumping to the list of mistakes, following is the infographics that highlights all important steps to DCF Analysis. This is just to brush up some important terms in DCF analysis. This will help you while we are looking at the mistakes in the further part.

**DCF Infographics: Steps by Step Analysis**

Ok, so moving forward to our main topic of discussion.

**What can be the impact of mistakes in discounted cash flow analysis?**

To know this, I have performed “Two” DCF analysis on a same company.

**Analysis 1:**No Mistakes in Discounted Cash Flow**Analysis 2:**Mistakes in Discounted Cash Flow

If you compare these two analysis, there are small changes deliberately made in certain values. This will help us to know the impact of Mistakes on the **Intrinsic share price** and **BUY/SELL recommendation**

Following is my final output from the Discounted Free Cash Flow Analysis. Check out the difference in the share price.

You can download the excel sheet containing formulas and calculations for with and without mistakes discounted cash flow analysis.

**#1 No Mistakes in Discounted Cash Flow**

**#2 Mistakes in Discounted Cash Flow**

**#Mistake: ****Getting a Sell recommendation inspite of a strong Buy!**

This is how the recommendation analysis works.

- It’s a BUY Recommendation, when: Intrinsic Share Price > Current Market Price (is Greater than)
- It’s a SELL Recommendation, when: Intrinsic Share Price < Current Market Price (is Less than)

In our case, Results were as follows:

**No Mistakes in Discounted Cash Flow**gave a**BUY**Recommendation as: = Intrinsic Share Price > Current Market Price, as 1505 > 1153

**Mistakes in Discounted Cash Flow**gave a**SELL**Recommendation as: Intrinsic Share Price < Current Market Price, as 418 < 1153.

You must be curious which mistakes did I make? How are the Intrinsic Values differing so much? Now, presenting the mistakes that I deliberately made in the Discounted Cash Flow Analysis. Let’s analyze them one by one.

**Forecast Horizon: Too Much or Too Less!****Cost of Capital: A Challenge?****Growth Rate Assumptions: Extreme?**

**DCF Mistake#1 – Forecast Horizon: Too Much or Too Less!**

Consider that you are valuing a FMCG based company. But you perform financial projections for only two years. Do you think that it is a right approach? Definitely not!

A time frame of atleast five to seven years needs to be considered while performing DCF analysis. But this does not mean that you consider the time frame of 50 years, that would be absolutely wrong.

Imagine the interest rates, economic factors, inflation after 50 years! And we do not have any financial super power to predict the same. So from now on, for each of the mistake we will list down specific values taken for:

##### Forecast Horizon – Without Mistakes

We have considered the forecast period of **5 years** for the analysis.

**Forecast Horizon – With Mistakes**

- Forecasting is done only for the period of
**2 years**.

Considering a short forecast period does not give you the effect of different parameters in the coming years. It largely affects the intrinsic share price.

Hence it is essential to take a proper explicit period that is not too short or not too long.

**DCF Mistake#2 – Cost of Capital: A Challenge?**

Many DCF modes are built on non-sensible cost of capital. This is one of the major mistakes in Discounted Cash Flow.

Here is the reason why.

- Most companies use either debt or equity for financing their operations.
- The cost of debt part for large companies is usually transparent as they have to make contractual obligations by the way of coupon payments.
- But estimating the cost of equity is more challenging.
- Because unlike debt’s explicit cost, cost of equity is implicit.
- Also, cost of equity is usually higher than the cost of debt as equity’s claim is junior. And no simple method exists to estimate the most accurate cost of equity.
- By far the most common and used approach for estimating the cost of equity is the capital asset pricing model (CAPM).
- According to CAPM, company’s cost of equity is equal to the risk-free rate plus the product of the equity risk premium and beta.
- Government-issued bonds generally provide a good representation for the risk-free rate. But estimating the equity risk premium and beta proves to be much more challenging.

We will now analyze the effect of two important considerations of the CAPM, in our analysis: **Beta & ****Equity Risk Premium**

**#1 Beta:**

This is what Beta is:

- Beta reflects the sensitivity of a stock’s price movement relative to the broader market.
- A beta of 1 suggests that the stock tends to move in line with the market.
- A beta below 1 means that the stock moves less than the market.
- A beta above 1 implies that the stock moves greater than the market.
- Beta, though it sounds wonderful in theory, it fails practically and empirically.
- Ideally, we want forward-looking betas, which is difficult to estimate reliably.
- Beta’s empirical failure shows how beta does a poor job explaining returns.

**Beta Value – ****Without Mistakes:**

- We have taken the Beta value from a trusted source reuters.com.
- In our case, the beta value fetched from Reuters for the company is
**0.89**

**Beta Value With Mistakes:**

**#2 Equity Risk Premium:**

- The second important input of CAPM which can cause errors is the equity risk premium.
- As like the Beta, equity risk premium is a forward looking estimate.
- Relying on past equity risk premium values, may not give a reasonable sense of the return outlook.
- Research also suggests that the equity risk premium is possibly non-stationary.
- Thus using past average values can be very misleading.

**Equity Risk Premium – Without Mistakes:**

Understand the following:

- Risk free rate is the rate of return on your investment with no risk and no loss.
- Generally, the Government Bond rate is considered in this case.
- Search and you will easily get the risk free rate value for the Government bond.
- The Indian Government Bond rate that I fetched was 7.72%.
- As an investor in Stock Market the general expectation is to get more returns than the risk free rate.
- Let’s consider the return expectations between 10%-15%.

According to the Capital Asset Pricing Model, the Formula for calculating required rate of return is:

=Rf + β(Rm-Rf), Where,

- Rf is the risk free rate
- β is the Beta Value
- (Rm-Rf) is the equity risk premium

So if the investor is expecting 12% returns, let’s see how the values will fit in our formula:

To make the LHS equal to RHS:

12%= 7.72%+0.89*(?)

(?)= 4.81

Thus the equity risk premium in this case is 4.81

Assuming a percentage in the range of 4.5%-5.5% may give you the proper value.

In our correct analysis I have taken the equity risk premium of **5%.**

**Equity Risk Premium – With Mistakes:**

- Equity risk premium is randomly considered.
- Thus the Value in this case is
**8%.**

**Growth Rate Assumptions: Extreme?**

- Consider yourself as an insurance agent. You are able to get many customers; you have over achieved your targets. But how?
- By promising the clients aggressive returns of 30%, with a surety of cumulative increase each year.
- You were able to fool the clients but can you fool yourself?
- You cannot guarantee your clients with some extreme growth figures. Things do not work like that.
- You have to take into account all the possible factors that affect the growth rate.

Same is the case when you build your DCF model.

Generally, the long term growth rate assumptions are taken wrong. These assumptions are taken to determine the terminal value component of the DCF valuation.

You have to bear in mind that, long-term rate of growth should not exceed the sum of inflation and real GDP growth at the most.

**Growth Rate – Without Mistakes:**

- Growth rate assumptions should always be considered less than the country’s GDP.
- Taking this into consideration, I have taken the growth rate as
**5%.**(Less than India’s GDP, which is in the range of 7%)

**Growth Rate – With Mistakes:**

Extreme Growth percentage of **8%** assumed. (More than the GDP growth rate).

These are some common mistakes made in the discounted cash flow analysis. This will help us to analyze the extent of differences in the values. So let’s sum up the differences in our Analysis. These are the results that we got:

**Intrinsic share price**

- With Mistakes: 418
- Without Mistakes: 1505

**BUY/SELL recommendation **

- With Mistakes: SELL
- Without Mistakes: BUY

**Difference in the values from the actual analysis**

=(1505-418)/1505 = 72% (HUGE!)

Apart from these above stated mistakes, we have some other common errors as listed below:

**Unbalanced assumed investment and earnings growth.****Other liabilities: Inappropriate considerations****Changes in Numbers****Double counting the values****Real and Nominal Cash Flows****Understanding the Market Conditions****Tax rate errors**

The above list is taken from http://www3.nd.edu/

**#1 Unbalanced assumed investment and earnings growth.**

- Companies invest in the business via working capital, capital expenditure, acquisitions, R&D, etc.
- All this steps are taken in order to grow over an extended period.
- Return on investment (ROI) helps in determining the efficiency with which a company translates its investments into earnings growth.
- Since ROI is linked to investment and growth, investors must treat the relationship between investment and growth carefully.
- DCF models can sometimes underestimate the investment necessary to achieve an assumed growth rate.

The source of this mistake is as follows:

- For Companies that have been highly acquisitive in the past, Analysts consider the same growth rate now, even if the company is not that much into acquisitions.
- One can overcome this mistake by carefully considering the growth rate that is likely to come from its today’s business.

**#2 Other liabilities: Inappropriate considerations**

Another mistake in Discounted Cash Flow is with respect to other liabilities.

- Corporate Value is determined based on the present value of future cash flows.
- Cash and any other non-operating assets are added while debt and any other liabilities are subtracted to arrive at shareholder value.
- Some other liabilities, like employee stock options, are trickier and more difficult to analyze. Thus most analysts do a very poor job analyzing these liabilities.
- At the same time,some liabilities are most common in some sectors.
- For example, post retirement employee benefit plans are more common in manufacturing industries while employee stock options occur most frequently in service industries.
- Hence investors must properly categorize and recognize other liabilities in the sectors where they may have a large impact on corporate value.

Also, check out Restricted Stock Units

**#3 Changes in Numbers**

- Sometimes small changes in assumptions can also lead to large changes in the value.
- Investors should also look to the value drivers like sales, margins, and investment needs as sources of variant sensitivity.

**#4 Double counting the values**

- Always make sure that your model does not get into the mistakes of double counting. Now you must be wondering what exactly is double counting. So let’s understand it in simple terms.
- Double counting simply means that some values are taken twice, causing errors in the model.
- Your intrinsic share price changes by considering the values twice.
- Double counting can also take place while considering the risk factor.
- There are the two ways of taking into account the uncertainty of future:

- Directly adjusting the cash flows in the model.
- Considering a discount rate.

- Hence if adjustments are made in both the above methods, it can lead to double counting of the risk thus leading to error.

**#5 Real and Nominal Cash Flows**

Let’s understand the difference between real and nominal cash flows.

- Nominal: Cash flows that incorporate the effects of inflation
- Real: Cash flows that exclude its effects are on a real basis.
- Thus, where real cash flows are used, the impact of inflation needs to be considered into the discount rate.
- Often errors are seen here as no adjustments are made.

**#6 Understanding the Market Conditions **

- In some cases, income and operating statements for a particular project do not reflect normal operating patterns.
- Thus ultimately this will have the effect on your DCF model and the intrinsic share price.
- In such a case it is necessary to reconstruct the actual operating statements to reflect market conditions.
- Projected operating or income statements must attempt to reflect actual market conditions.

**#7 Tax rate errors**

- General mistake made: Adopting a tax rate which does not reflect the long term tax rate for the asset.
- In order to properly reflect expected future cash flows, forecasts should be based on the expected effective tax rate applicable at that time.
- It is essential to devote some time to analyze the corporate tax rate.
- Properly analyzing the tax rate and considering it in your model will surely bring it one step closer to perfection.

Other related valuation articles that you may like

- Calculation of Equity Value
- What is Discounted Cash Flow Valuation?
- Calculating PE Ratios
- Why Price to Book is used in Banks?
- Calculate EV and Equity Value

**Conclusion**

Since you are now aware of all the probable things that can go wrong in DCF calculations, be well prepared. It is essential to ensure that the assumptions are economically sound as well as transparent. Even the slightest of change in assumptions in Cost of Capital, growth rates etc can change the recommendation from BUY to SELL or vice-versa. Please remember that very few DCF models pass the NO MISTAKE DCF test.

Now that you have gained some insights into “Mistakes in Discounted Cash Flow”, I hope that your Analysis will stand apart. Happy Valuations!

khoa do says

Hi Dheeraj,

Can yo explain why you calculate the share price base on FCFF not FCFE?

Thank you

Dheeraj Vaidya says

Hi Khoa, FCFF is more common approach for calculating the share price. There are certain limitations while applying FCFE and hence it is not preferred in most cases. You can look at a detailed note here on FCFE

alex Wang says

so good article

Dheeraj Vaidya says

thanks Alex.

Syed Muhammad Haider Hussain says

I must say, the article is very helpful, with easy to understand structure and in depth analysis.

The growth rate must be less than GDP, and the interpretation of beta less than equal to and greater than 1, these are the new things you added in my knowledge

Thanks sir dheeraj.

Dheeraj says

Thanks Syed! 🙂

Ishrak says

Your blog has some very good posts and I like this blog! It certainly helps people to get a good understanding of most of the topics and confusions that arises with these topics!Thank u very much but a little bit more publicity is needed.Good luck!

Dheeraj says

Thanks Ishrak, maybe you can help me in marketing this blog.

Best,

Dheeraj

BABU says

Can u provide detailed calculation for terminal value? How to calculate terminal value for FCFF & FCFE? Please explain in writing also.

Dheeraj says

Hi Babu,

I have written an article on Terminal Value. Hope you find this useful.

Thanks,

Dheeraj

Hij Pacete says

Hi Dheeraj.

Thank you.

I really learned a lot from you website.

Dheeraj says

Many Thanks Hij! I am glad you like this website.

Best,

Dheeraj

Fikri Syaryadi says

Thank you Mr. Dheeraj. This really helped me.

Dheeraj says

Thanks Fikri 🙂

Akanksha says

Thanks dheeraj very nice article.

Dheeraj says

Thakns Akansha 🙂

udit agrawal says

Hi Dheeraj

can u plz share the DCF analysis with excel templates.

it would be highly appreciable

Thanks

Udit Agrawal

Dheeraj says

Hi Udit,

Soon, i will be coming up with a complete DCF tutorial. It is taking a bit. Will update you shortly.

Best,

Dheeraj

Devansh Lakhani says

Very good article.

Dheeraj says

thanks Devansh!

Mike says

Hey Dheeraj, just wanted to say I’m really thankful for your website. I’m new to DCF valuation and I’ve learned a lot here. Everything is nicely broken down into easy-to-follow steps with great visuals.

Dheeraj says

Hey Mike, many thanks for your kind appreciation 🙂

Best,

Dheeraj