DCF Calculator

*********

Let’s calculate the Intrinsic value of ITC using the Discounted Cashflow Valuation method. (Please note that all the data used here has been gathered from Yahoo Finance.)

1. First of all, we will start by finding the free cash flow of ITC, which is the first component of the DCF Calculator. Here, we’ll take the FCF for the last 3 years and consider their average as the reasonable FCF. Now, free cash flow is equal to cash from operating activities minus the capital expenditures. The FCF of ITC for the last three years is equal to Rs 10,291.2 Cr, Rs 7,505.7 and Rs 7,451.36 Cr. The average FCF for last 3 years turns out to be (Rs 25,248.26 Cr/3) = Rs 8,416.08 Cr. (Source: Yahoo Finance, See: Financials–> Cash flow)

2. Next, we don’t want to project this free cash flow for perpetuity. We’ll project this FCF only for the next ten years. Although, the company may continue for many more years after the tenth year, however predicting free cash flow for over 10 years is really difficult. Therefore, we assume that the company will sell off all its assets at the end of year ten at a ‘Sell off valuation’. We’ll use a multiplier of 12 for the tenth year cash flow to simulate the value of these cash flows in the case company would sell all its assets (This is a necessary assumption that we need to make in order to find the value of the company).

3. Apart from the cash flows, the next important input is the net cash which the company reflects on its balance sheet. For ITC, this value is equal to Rs 2,899.6 Cr. (Source: Yahoo Finance, See: Cash and cash equivalents and short-term investments).

4. Besides cash, the next essential input is the debt (as debts have to be first paid off and shareholders are last in the line). ITC has a total debt of Rs 18.57 Cr. (Source: Yahoo Finance, See: Liabilities).

5. Next, we need to find the growth rate for ITC. Let’s take a conservative annual growth rate of 12% for ITC company. (Note: To get an idea of the growth rate, you can refer what the analysts are expecting here: Yahoo Finance, See: Growth Estimates (Next 5 years). However, do your own analysis to find the growth rate. Analysts expectations should not be considered precise, but just a rough estimate).

6. Further, just as our fair value calculator assumptions, let’s take a 10% discount rate.

7. In addition, we need the total numbers of outstanding shares. It is equal to 1,225 Crores. (Source: Yahoo Finance, See: Share statistics)

8. Finally, let’s take a margin of safety of 10% on our overall calculated intrinsic value.

After placing the above values in the DCF Calculator, the true intrinsic value per share of ITC turns out to be Rs 159.50 (after a margin of safety of 10% on the final intrinsic price). This is the intrinsic value estimate per share for Indian Tobacco Company at the time of writing using the DCF model (January 2019). The current stock price of ITC is at Rs 275.05. This means that this stock is overvalued by over 74.45% right now.

Quick Note: Although this stock may ‘NOT’ be under-priced currently. However, there are thousands of listed companies in the Indian stock exchange. If you keep looking for great companies, you’ll eventually find good companies which are trading at a decent valuation. Nevertheless, do not overpay for purchasing any company. As Benjamin Graham (father of value investing) used to say- “A good company is not a good investment if you overpay for it”. Happy Investing.

Warning: Garbage in, Garbage out

DCF is a very powerful tool for valuing stocks. However, this methodology is only as good as the inputs.

For example, even a small change in inputs (like growth rate or discount rate) can bring large changes in the estimated value of the company. (Try changing these values by 1% or 2%- and you can notice a significant change in the result). In short, if the inputs are not reasonable, the out will also not be correct -‘Garbage in, garbage out’.

Therefore, fill all the inputs carefully as they all have the potential to erode the accuracy in the estimated intrinsic value.

 How does this DCF Calculator work?

1. First, you need to enter the current year Free cash flow (FCF) of the company. The DCF model takes the yearly FCF and projects this over 10 years into future by multiplying it with the expected growth rate (please assume a realistic growth rate for the company).

2. Next, it calculates the net present value (NPV) of these cash flows by dividing it by the discount rate. The calculator takes the NPV of the FCF from each of these 10 years and adds them up.

3. The last year FCF is multiplied by the terminal factor (usually between 7 to 12) to find the terminal or sell-off value of the company and added to the original calculations. (Read more about discounted terminal value here).

4. Finally, net cash and debt available on the company’s financial statements are adjusted in the calculations to arrive at the market value estimate of the entire company.

5. When you divide this value with the total number of outstanding shares, you will get the intrinsic value per share of the stock.

(You can read more regarding DCF Valuation here.)