## 14.1 – The Stock Price

In the previous chapter, we understood stage 1 and stage 2 of equity research. Stage 1 dealt with understanding the business, and stage 2 dealt with understanding the company’s financial performance. One can proceed to stage 3, only if he is convinced with both the earlier stages’ findings. Stage 3 deals with the stock price valuation.

An investment is considered a great investment only if a great business is bought at a great price. In fact, I would even stretch to say that it is wonderful to buy a mediocre business, as long as you are buying it at a great price. This only shows the significance of ‘the price’ when it comes to investing.

The objective of the next two chapters is to help you understand “the price”. A valuation technique can estimate the price of a stock. Valuation per se helps you determine the ‘intrinsic value’ of the company. We use a valuation technique called the “**Discounted Cash Flow (DCF)**” method to calculate the company’s intrinsic value. The intrinsic value as per the DCF method is evaluating the ‘perceived stock price’ of a company, keeping all the future cash flows in perspective.

The DCF model is made up of several concepts which are interwoven with one another. Naturally, we need to understand each of these concepts individually and then place it in the context of DCF. In this chapter we will understand the core concept of DCF called “The Net Present Value (NPV)”, and then we will proceed to understand the other concepts involved in DCF, before understanding the DCF as a whole.

## 14.2 – The future cash flow

The concept of future cash flow is the crux of the DCF model. We will understand this with the help of a simple example.

Assume Vishal is a pizza vendor who serves the best pizzas in town. His passion for baking pizzas leads him to innovation. He invents an automatic pizza maker which automatically bakes pizzas. All he has to do is, pour the ingredients required for making a pizza in the slots provided and within 5 minutes a fresh pizza pops out. He figures out that with this machine, he can earn annual revenue of Rs.500,000/- and the machine has a life span of 10 years.

His friend George is very impressed with Vishal’s pizza machine. So much so that, George offers to buy this machine from Vishal.

Here is a question for you – What do you think is the minimum price that George should pay Vishal to buy this machine? Obviously, to answer this question, we need to see how economically useful this machine will be for George. Assuming he buys this machine today (2014), over the next 10 years, the machine will earn him Rs.500,000/- each year.

Here is how George’s cash flow in the future looks like –

2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|---|---|---|

500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 |

I was hoping you could do note, for the sake of convenience, I have assumed the machine will start generating cash starting from 2015.

Clearly, George will earn Rs.50,00,000/- (10 x 500,000) over the next 10 years, after which the machine is worthless. One thing is clear at this stage, whatever is the cost of this machine, it cannot cost more than Rs.50,00,000/-. Think about it – Does it make sense to pay an entity a price which is more than the economic benefit it offers?

To go ahead with our calculation, assume Vishal asks George to pay “Rs. X” towards the machine. At this stage, assume George has two options – either pay Rs. X and buy the machine or invest the same Rs—x in a fixed deposit scheme that guarantees his capital and pays him an interest of 8.5%. Let us assume that George decides to buy the machine instead of the fixed deposit alternative. This implies, George has foregone an opportunity to earn 8.5% risk-free interest. This is the ‘opportunity cost’ for having decided to buy the machine.

So far, in our quest to price the automatic pizza maker we have deduced three crucial bits of information –

- The total cash flow from the pizza maker over the next 10 years – Rs.50,00,000/-
- Since the total cash flow is known, it also implies that the machine’s cost should be less than the total cash flow from the machine.
- The opportunity cost for buying the pizza machine is an investment option that earns 8.5% interest.

Keeping the above three points in perspective, let us move ahead. We will now focus on cash flows. We know that George will earn Rs.500,000/- every year from the machine for the next 10 years. So think about this – George in 2014, is looking at the future –

- How much is the Rs.500,000/- that he receives in 2016 worth in today’s terms?
- How much is the Rs.500,000/- that he receives in 2018 worth in today’s terms?
- How much is the Rs.500,000/- that he receives in 2020 worth in today’s terms?
**To generalize, how much is the cash flow of the future worth in today’s terms?**

The answer to these questions lies in the realms of the “**Time value of money**”. In simpler words, if I can calculate the value of all the future cash flows from that machine in terms of today’s value, then I would be in a better situation to price that machine.

Please note that we will digress/move away from the pizza problem in the next section, but we will eventually get back to it.

## 14.3 – Time Value of Money (TMV)

Time value of money plays an extremely crucial role in finance. The TMV finds its application in almost all the financial concepts. Be it discounted cash flow analysis, financial derivatives pricing, project finance, calculation of annuities etc., the time value of money is applicable. Think of the ‘Time value of money’ as the car engine, with the car itself being the “Financial World”.

The concept of the time value of money revolves around the fact that money does not remain the same across time. Meaning, the value of Rs.100 today is not really Rs.100, 2 years from now. Inversely, the value of Rs.100, 2 years from now is not really Rs.100 as of today. Whenever there is the passage of time, there is an element of opportunity. Money has to be accounted (adjusted) for that opportunity.

If we have to evaluate, what would be the value of money that we have today sometime in the future, then we need to move the ‘money today’ through the future. This is called the “**Future Value (FV)**” of the money. Likewise, if we have to evaluate the value of money that we are expected to receive in the future in today’s terms, then we have to move the future money back to today’s terms. This is called the “**Present Value (PV)**” of money.

In both cases, as there is a passage of time, the money must be adjusted for the opportunity cost. This adjustment is called “Compounding” when we have to calculate the future value of money. It is called “Discounting” when we have to calculate the present value of money.

Without getting into the mathematics involved (which is really simple) I will give you the formula required to calculate the FV and PV.

**Example 1** – How much is Rs.5000/- in today’s terms (2014) worth five years later assuming an opportunity cost of 8.5%?

This is a case of Future Value (FV) computation, as we are trying to evaluate the future value of the money that we have today –

**Future Value = Amount * (1+ opportunity cost rate) ^ Number of years**.

= 5000 *(1 + 8.5%) ^ 5

= 7518.3

This means Rs.5000 today is comparable with Rs.7518.3 after 5 years, assuming an opportunity cost of 8.5%.

**Example 2** – How much is Rs.10,000/- receivable after 6 years, worth in today’s terms assuming an opportunity cost of 8.5%?

This is clearly the case of Present Value (PV) computation as we are trying to evaluate the present value of cash receivable in future in terms of today’s value.

**Present Value = Amount / (1+Discount Rate) ^ Number of years**

= 10,000 / (1+ 8.5% ) ^ 6

= 6129.5

This means Rs.10,000/- receivable after 6 years in future is comparable to Rs.6,129.5 in today’s terms assuming a discount rate of 8.5%.

**Example 3** – If I reframe the question in the first example – How much is Rs.7518.3 receivable in 5 years worth in today’s terms given an opportunity cost @ 8.5%?

We know this requires us to calculate the present value. Also, since we have done the reverse of this in example 1, we know the answer should be Rs.5000/-. Let us calculate the present value to check this –

= 7518.3 / (1 + 8.5%) ^ 5

= 5000.0

Assuming you are clear with the concept of the time value of money, I guess we are now equipped to go back to the pizza problem.

## 14.4 – The Net Present Value of cash flows

We are still in the process of evaluating the price of the pizza machine. We know George is entitled to receive a stream of cash flows (under owning the pizza machine) in the future. The cash flow structure is as follows

2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|---|---|---|

500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 |

We posted this question earlier, let me repost it again – **How much is the cash flow of the future worth in today’s terms?**

As we can see, the cash flow is uniformly spread across time. We need to calculate each cash flow (receivable in the future) by discounting it with the opportunity cost.

Here is a table that calculates the PV of each cash flow keeping the discount rate of 8.5% –

Year | Cash Flow (INR) | Receivable in (years) | Present Value (INR) |
---|---|---|---|

2015 | 500,000 | 1 | 460,829 |

2016 | 500,000 | 2 | 424808 |

2017 | 500,000 | 3 | 391481 |

2018 | 500,000 | 4 | 360802 |

2019 | 500,000 | 5 | 332535 |

2020 | 500,000 | 6 | 306485 |

2021 | 500,000 | 7 | 282470 |

2022 | 500,000 | 8 | 260,335 |

2023 | 500,000 | 9 | 239,946 |

2024 | 500,000 | 10 | 221151 |

Total | 50,00,000 | 32,80,842 |

The sum of all the present values of the future cash flow is called “**The Net Present Value (NPV)**”. The NPV, in this case, is Rs.** 32,80,842** This also means, the value of all the future cash flows from the pizza machine in today’s terms is Rs.** 32,80,842**. If George has to buy the pizza machine from Vishal, he has to ensure the price is Rs.** 32,80,842** or lesser, but definitely not more than that and this is roughly how much the pizza machine should cost George.

Now, think about this – What if we replace the pizza machine with a company? Can we discount all future cash flows that the company earns to evaluate its stock price? Yes, we can, and in fact, this is exactly what will we do in the “Discounted Cash Flow” model.

### Key takeaways from this chapter

- A valuation model, such as the DCF model helps us estimate the price of a stock.
- The DCF model is made up of several interwoven financial concepts.
- The ‘Time Value of Money’ is one of the most crucial concepts in finance, as it finds its application in several financial concepts, including the DCF method.
- The value of money cannot be treated the same across the time scale – which means the value of money in today’s terms is not really the same at some point in the future.
- To compare money across time, we have to ‘time travel the money’ after accounting for the opportunity cost.
- Future Value of money is the estimation of the value of money we have today at some point in the future.
- The present value of money estimates the value of money receivable in the future in terms of today’s value.
- The Net Present Value (NPV) of money is the sum of all the present values of the future cash flows.

What are other valuation models which are used in equity research or say M&As?

Hope my question is not ambiguous..

There are basically two valuation techniques – Intrinsic valuation and relative valuations. DCF is the best way to do intrinsic valuations, which is what we have explained here. Relative valuation is a bit dicey as you are essentially comparing two companies by assuming they are similar. But in reality no 2 companies are similar. Not that DCF is a very clean technique..both have its drawbacks. The industry practices both these techniques.

Hi,

Do we take opportunity cost always as current fixed deposit’s rate of return at the time of calculations?

Waiting for the reply

Yes, you can.

Hello,

I have to ask one more question I hope you wouldn’t mind answering it too..?

As you said FD rates at the time of calculations must be taken as opportunity cost.

So the question is what about the Discount rate ?( which is cost of capital itself,right? ) As you have taken it same as the opportunity cost. Is it always the same I.e. FD rate only?

I hope you get my point..??

Considering FD rates have fallen quite a bit, I think we need to have a better discount rate :). I have a tendency to take conservative numbers, hence something like 10-12% should be alright.

How to Evaluate NBFC’s , PVT Banks. which model to use to get intrinsic value

Devaa, like I have indicated earlier, these entities require a slightly different set of variables. I’ve been meaning to put of something on these lines for a while now 🙂

Little typing mistake noticed

No. 14.3 is missing where as 14.2 is double

🙂

Missed seeing your comment! Thanks for pointing out, made the changes 🙂

i am interested in a career in equity research. i do not have any prior experience but i am very keen to learn. Is it possible to get trained under zerodha? I am willing to join you as a fresher or even as a trainee.

Thanks for the interest expressed. I’m afraid we have no such openings in Equity Research as such. Would the support desk interest you?

Dear Sir,

Thanks a lot for your reply. Yes, i would like to go ahead with the support desk profile. Kindly share the details.Waiting for your reply.

Regards,

Abhimanyu Jamaiyar

How to calculate the fair price of usd/inr currency pair? Explain with example.

Unfortunately I’m not to familiar with currency valuation techniques. But my guess is that this is largely market driven.

Please suggest me from where i get information about that?

This should help you with a start – http://blogs.wsj.com/economics/2011/10/03/guest-contribution-how-to-value-a-currency/

Good luck.

I am unable to understand PV properly…………please help

Present value is the current value of the future payment. For example assume you are expected to receive Rs.100,000/- 10 years from now. PV helps you answer find out the worth of that Rs.100,000/- in today’s terms.

Price of Amararaja has gone up 🙂 do you have other analysis could be shared ?? Thanks for the investor education …priceless

Nothing worth sharing as of now 🙂

Shouldn’t we account inflation while calculating the present value of money?

You kind of factor in this when you take a very conservative discount rate.

While calculating the Free Cash Flow, the formula is Cash Generated From Operations – Purchase of Fixed Assets

Do we also add ‘Sale of Fixed Assets’ figure in this formula??

Cash flow from ‘Sale of fixed asset’ could be a one off event. Hence, its best to ignore this one.

Thank you. While analyzing the fundamentals using all the ratios, I found a few companies that are fundamentally very sound. While doing the DCF analysis that too using very conservative assumptions (Growth rate 8% for each year till 10 years, opportunity cost @ 9%) , I found that the CMP of those stocks are less than the margin of safety price (30% discounted price from the lower intrinsic price). Shall I go ahead and accumulate these stocks?

Yes, you should. But please make sure you are thoroughly convinced with the business model and management quality.

Yes, Management Quality is something that has to be focused on. Thanks Karthik for your insight.

Welcome and good luck!

please provide description of formula of finiding pv fv

PV = Cash Flow / (1 + discount rate)^(time)

FV = Cash Flow * (1 + expected return)^(time)

How do you find/calculate the discount rate and expected return rate?

The discount rate is usually close to the risk-free rate in the economy. Expected return – https://zerodha.com/varsity/chapter/expected-returns/

Dear Karthik

How did you calculate the amount 7518.30? didn’t understand it

thanks

Its the future value of Rs.5000 when compounded at 8.5%.

Respected sir! How should I evaluate an NPV with different negative and positive cash flow? What sense does it make?

There is no NPV of -ve cashflows.

Hi Karthik, I have joined your last Live Webinar @ 12 … It was simply Superb.

How Dividend payout coming under Financial activities, Is it operational activity ?

Thanks! I’m glad you liked the webinar 🙂

OA consists of activites which are core to the company, where as div is an optional thing for companies.

sir thanks for this module ! it was nice to learn new things

and sir please can you share the excel sheet format of the dcf model ?

Glad you liked it Jaggi 🙂

I guess the excel is available at the end of the chapter.

hi..can i have the dcf excel sheet plz

We will soon start a module on Financial modelling, you will have DCF and more.

sir,

current p/e ratio is on 23.66 and current p/b is on 3.56

is it the time that good investors doesn’t invest money and the nifty has made its top.

Not confirm about p/b as it hasn’t crossed 4 but it still may be considered overbought and p/e should also be considered as overvalued.

Am i right?

It really depends on your time frame, Shabaz. There is no harm investing on a selective basis.

Sir,

Different websites (like Economic Times, NDTV Profit, Moneycontrol) having different P/E ratio, P/B value for SAME COMPANY. Why it is so??? Please share how to calculate P/E ratio, P/B values ACCURATELY from financial statements. Should we focus on Standalone balance sheet or consolidated balance sheet of company while buying a stock?? P/E ratio, P/B values are very important in fundamental analysis. Please provide detail guidance regarding this. Your help will be very useful to me. Thank you very much.

Difference could be due to consolidated and standalone data? You should look at consolidated financial data. Will share a note on how to calculate these ratios sometime soon.

Sir,

I am studying your module 2 of fundamental analysis. I think that there is small mistake in calculating EBITDA . Please share your email id so that I can contact you. This is very important. You have taken financial cost twice.

Total Expense – Finance Cost – Depreciation & Amortization .

In the total Expense financial cost is already added (I think) and again Finance cost. Please clarify

Thanks for pointing this, Ajay. Let me check this again.

Thanks a lot for the detailed DCF primer. I learned a lot. One question I have is :- the (reserves/Outstanding) is not added to NPV? Is it a norm or can we add it?

Yup, reserves is not really considered for NPV and DCF calculations.

Thanks a ton for this knowledgeble detailed Varsity.

I am willing to know that how can be accumulate data like future cash flows, discount rates etc in real practical scenarios for a company to calculate its intrinsic values.

Is there a way to gather these data ? if so can it vary basis the assumptions of investor?

This data is best if you can calculate them yourself. This is where the skill of the investor comes into play. So as a long term investor, its best if you develop these skills yourself.

Thank you for the reply.

But as a new investor, if I think to take a first step for valuation of any company. What factors needs to be taken into consideration? If you can give example once as to how you proceed for this exercise.

Everything documented in this chapter is important Gourav, you cannot afford to ignore one over the other.

Considering more than 3000 companies listed in the Indian stock market how to do analysis of all these stocks?

Exactly why companies like Smallcase has useful tools like Screener. Check this out – https://screener.smallcase.com/welcome

Hi Karthick,

Excellent work!!

I have 2 questions :

1.Once I start valuating a company based on DCF with annual reports for last 3 years and arrived at good MOS to buy, how can i keep check on the price based on quarterly results that will be published by the company in coming financial year? is there any data from quarterly reports that can help in DCF else I will have to wait another year to ascertain based on annual report published by the company.

2. With growth stocks, its very difficult to value a company by DCF. In that case i just try to do reverse DCF to find out how much of growth is implied in current price or the market values it. Say for eg : Avanti feeds from reverse DCF gives me 31% growth for next 10 years in current price of 1886( TGR : 3.5%, Discount rate : 12 %,Growth I & II : 32% & 30%). Whats your take on DCF for growth stocks? How do you value growth stocks? Do you use earnings power?

Thanks in advance.

1) You will have to track new for quarterly result announcement

2) Yes, that does make sense. Earning power, business moat, market size – these are few things that help.

Thanks for the quick reply. Regarding 1st question again: But the attributes used in DCF are not available from quarterly results report given by companies like cash from operations, CAPEX, non current debt, current debt or is it given somewhere? Please help me here.

True, balance sheet items are not available during the year. But you don’t really need them as well. Once you develop the valuation model, you will have a fair idea of how much the stock is (should be) worth.

Yes I am able to sense it.Thanks.. I am eagerly waiting for your module on Financial modelling. Keep up the good work!!!!

Hopefully soon 🙂

Karthik you write the content in a very lucid manner. Thanks for helping millions understand for free!!!!

Happy learning, Dinesh!

First of all, Awesome work Karthikji!

I’m completely new to Trading/Share Market but your systematic approach has boosted my confidence in learning it.

Second, pleasantly surprised to see the thread to be alive even after 3 years!!

Superb work!

Happy learning, Sanjay 🙂

Hi Karthik,

In kite we have charts of stocks, it is provided by 3rd party, It will be good if zerodha adds 1 more tab where we can get different ratios of that stock, when we click on chart- chart displays for different time frame. Similarly with the help of 3rd party or by your own 1 fundamental tab’s implantation will be very helpful.

Thanks,

Jyotshna

We have taken a step towards that, have you checked out the stock widget? Click on a stock widget option next to the stock name. Its in the same place where you get the options for Buy/sell/market depth etc.

This suggestion is for fundamental analysis related. If a button is implemented near chart button then by clicking on that button we can get data like PE ratio, EPS, Dividend etc. of that stock.

Yes, this is already there in the stock widget, powered by smallcasae.

How can we use this(DCF Primer) to calculate the future price of a Stock or to know that the current price is over / undervalued.

eg. Current price of ARBL is 771, how can we calculate the future price suppose after 2 years or , how can we say that at 771 ARBL is over valued or undervalued?

DCF lets you price in the current and future earning and arrive a fair value. End of the day, it is really a mathematical model, the out depends on the quality of information you feed in.

Thanks, You have explained that in next chapter 🙂

Cheers! Happy learning 🙂

sir mail me the excel file of DCF MODEL.

Ah, maybe I’ll update the DCF model on the site itself. Thanks for pointing out.

Why have you assumed that the machine will generate 5,00,000 Rs worth of revenue every year? As inflation increases price of pizza will also increase so the revenue generated will also increase from the machine. Shouldnt the revenue generated also grow at the average rate of inflation?

This concept is good, but It would be more helpful if the following are addressed.

1. How to calculate the cost of a share after calculating DCF?

2. 8.5 is a constant?

3. How does inflation impact the model?

4. How do we account for other risks involved in the business?

5. What is the best source to feed in the model?

Thanks

Amith

1) Its explained in the chapter

2) No, varies based on the company

3) Yes – especially when you take the discount rate

4) That is outside the purview of DCF, however, you can take conservative growth numbers to accommodate for this

5) Not sure about this

Sir, Why is impact of inflation not taken into account along with opportunity cost while calculating FV/PV?

OR

Is it like that opportunity cost rate of 8.5% is considered equivalent to inflation rate only?

Need to confirm whether inflation has no role in DCF model?

When you discount, you actually take in inflation to some degree.

Hello Karthick, As usual it is a great and easy explanation and I am reading this chapter to know about present value for Greek Calculator. And I noticed that at “14.3 – Time Value of Money (TMV)” it is mentioned as TMV instead of TVM, correct if I am wrong. Thank you.

Thanks, Dheepak. Will make the change 🙂

thanku sir for sharing ur knowledge……..i had one qusestion, in DCF how toidentify growth rate of different companies

Depends on the company, some can be as high as 12-15% and some can be as low as 6-7%.

Hello karthik,

Thanks for this excellent article..!! Just have a confusion..

Discount rate (which is given as 8.5%) is constant or it is varies depends on the company?

If it varies, then how to calculate it?

Some other website shows a term called WACC as discount rate with a formulae while you assumed that discount rate is simply 8.5 – 9% relative to the FD interest rate..

Could you please help me understand this further?

The general thumb rule is that the discount rate depends on the risk-free rate prevailing in the economy.

So you say discount rate would be same for all companies in general?

Binu, in a sense yes. This is an easy approximation. The discount rate is the prevailing rates in the economy, so it remains same for all companies. However, you can also use CAPM model to arrive at the exact rate.

In below formula how can I calculate capital expenditure? I did visit moneycontrol.com website to see capex but didn’t find.

FCF = Cash from Operating Activities – Capital Expenditures

I’d suggest you look for CAPEX number as indicated in “Cash flow from investing activities”, in the cash flow.

Thank you sir for your valuable suggestion.

When I look for “Net Cash Used In Investing Activities” (sorry I can’t find “cash flow from investing”) of ARBL for year 2013, 2014, values showing -120.51 & -344.84 respectively. & in example those values are 72.47 & 330.3 for year 2012-13 & 2013-14.

Can you suggest which website is good to get all values for DCF.

Check out the custom excel sheets available in Screener.in, few have DCF model built in.

Hi Karthik,

How do you do (^) this in a calculator ?

Maybe use excel?

Thanks.

Welcome!

Could you please provide the excel sheet where you do the calculation

You can download this, available at the end of the chapter.

Sir, while calculting DCF analysis, what is the best possible discount rate I can take? Can I use a general value of growth and discount rate for all stocks, or should I take values depending on the stock?

The discount rate should be around the risk-free rate of the economy. I personally prefer to add 200 – 250 basis points to the risk-free rate to arrive at the discount rate.

Hi,

How to decide growth rate 1 & 2 for free cash flow & also how you decide discount rate? Intrinsic value is largely dependent on growth & discount rate and their correct estimation is very essential. Also can you provide benchmark for these rates for different industry verticals like metals, banks, FMCG etc.

Dinesh, it is hard to fix a generic growth rate. This really depends on the sector and the growth stage of the company. Don’t have a ready reckoner of sorts, but will look for one and share 🙂

Sir, thanks for providing excellent platform to learn the concepts related to equity. It will be highly appreciable if you make a separate course for making financial model to analyse any stock.

Regards,

Yogendra, that is the plan. I will try and do that next year sometime. Thanks.

Dear Karthik,

Request to provide if there is any link where we can obtain current “Market Cap/Market GDP” ratio. If it is in the form of a chart, even better.

Thank You

Regards

Kiran

I’m not sure about a reliable source for this, kiran. Btw, check this, these guys may have – https://www.tijorifinance.com/

Thank You …

Welcome.

Hi Karthik,

I have question regarding the discount rate. I read all the comments regarding this topic, but I still need a clear understanding of it.

As far as I understand, discount rate is the rate of return the investor expects from his/her investment.

For example: If I expect a CAGR of 15%, I would consider the discount rate to be 15. This 15% takes care of inflation and also provides me with surplus income to grow my capital. Is this understanding right?

Slightly different, Pavan. The discount rate wrt to DCF is the opportunity rate. Keep this close to the risk free rate in the economy.

Hi Karthik,

I am not able to find the Sheet for DCF calculation. Can you please help ?

Regards,

Akhosh

I got the link in the next module . Thank you 🙂

Saved me some trouble of finding it, thanks 🙂

I dont think I’ve put up the excel as such, but the snapshot from the excel sheet. Let me recheck again.

From last 3 years the nifty indicies trading more than 25 percent … At present it’s trading 28 percent … Do you think Dynamics of the market have got changed ? I don’t think so market can go below 16 percent whether there is recession.

What are these percentages, Vamsee?

Sorry I meant P/E ratio

Yes, I personally think the PE is still high, especially when you compare it to the historical levels.

Hi Karthik,

how could handle negative value in operating activities… i got negative terninal value and share price as well…

In such cases, the DCF cannot be applied.

how to do valuation of small cap companies which have negative cash flows but huge growth potential.

Companies with -ve cashflows are hard to value in a conventional way. You’ll have to take a call based on its business prospects.

it is a good practise to do dcf for 10 years or more .because every 3 to 5 year bussiness dynamics of a company changes like management ,new products ,competition etc .if we do dcf only for 5 years .will it give us somewat right intrinsic value or not.

Yes, usually the DCF considers 10 years of financial data.

how to find early signs that a business or company is reaching from growth stage to mature stage .

plz provide points we can look in this transition .

Usually, the growth starts to slow down and remains flat at an elevated level. This is a sign that the company has/may transition.

Sir

While doing this analysis,we should consider standalone or consolidated reports?

Consolidated reports.

Sir

I have noticed that data from previous year annual report and data of previous year in current year’s annual report diifers.

why is it so?

This could because the numbers could be restated. The difference should not be much though.

Hello Karthik ,

This Might not be related to the Subject discussed on this thread , The Reason for my comment is just this, I wanted to know the Following :

I took the Varsity class , In the Technical Lessons , I did some what Average . While Going for the Certification Exam , I performed terribly worst . But the Question Number 13 , is Creating Confusion and frustration : Q- Identify the Pattern Highlighted in the Chart ? .

I Answered it as Piercing pattern because the Short trend prior to this candle is Bearish the Candle pattern in Question , P1 is a Large RED Candle , P2 is a Green Candle With Both Upper and Lower Wicks , The P2 Has tried to Engulf the P1 but has not been Fully Successful But It has Closed well above the Half mark of P1 . According to your Lesson it is a piercing Pattern . But you have said in results that it is not a valid pattern as the Prior trend does not satisfy – How ? .

If this is not a piercing Pattern then what is this ?

For any candlestick pattern (except marubuzo), the presence of a prior trend is mandatory. Without this, it does not qualify as a ‘candlestick pattern’, irrespective of P1 and P2 behave.

Also , As I have failed can I take a fresh exam with a new set of Question twisted well not a repeat. is that possible ? is it that once failed one cannot attempt a second test ? I want to again read those lessons well and make an attempt . is that possible Sir ?

Not sure if there is anything much I can do about this, Shreedhar.

Sir ,

In The Same Context Question Number , Q4 – At 1.14PM , a Technical Analyst is Looking at the 5- Minute Chart of Indigo . The OHLC Of this 5 Minute Candle will Represent – Selected a wrong answer but your Answer is confusing ,Could you please Explain – How can any one Know the Closing Price at 1.15.59 when the Current time is 1.14.00 ? , How can one Find a Closing price of future for sure the Difference is 1.59 Minutes . Are you saying He predicted the future ? if yes on what basis ? the Complete Candle Forming time should be 1.20.00 on a 5 minute Candle , Right ? what is the Logic behind 1.15.59PM ? . or else you were thinking of 1.14.59PM and 1.15.59PM was a typing mistake ?

I Also Counted the Number of 5 minutes Candles not once but several times to make sure it adds up to 9.15 AM but that is where i lost my time .

Can you please post this under relevant chapter? It is just that it may help other people with similar queries.

Hi,

If we want to apply DCF for listed companies, how we should get the data of next 5 years projections. I think regulators doesnt allow that to companies?

Yes, but you can make a projection based on the historical data.

Ya. That I have just seen in next chapter. Thanks. Its a great reading material.

Glad, happy reading 🙂

Hi sir,

I tried calculating intrinsic value of reliance industries. In all the past three years their capex is more than their net operating cost. So the average cash flow is coming in negative value. What should i do now ??? I am awaiting for your reply !!

In fact, this is one of the drawbacks of DCF, it does not work for -ve cashflow situations.

Then what method i should use for negative cash flow ?? Or shall i use the average of operating cost ?

I’d suggest you look at the relative valuations technique to look at companies with -ve cashflow.

I request you to include relative valuation technique in your module sir.

I will, in module 13 🙂

Hello Karthik,

Great content indeed!!

1. while calculating the PV and NV, what does the opportunity cost rate and discount rate mean? Why is that you have only considered 8.5% as the value for the both?

2. Can I also use this formulae in calculating the PV and NV of any goods in real time, like bike ? does the opportunity cost rate and discount rate will be again 8.5% in this case?

Regards,

Kiran

1) Opportunity cost is usually the prevailing risk-free rate in the economy. I guess it was 8.5%, when I wrote this. You discount at opportunity cost, so it is the same.

2) Depends on the current economic condition and the prevailing rates.

hi karthik

just want to know one think

why do we take opportunity cost rate? idoes it have something to do with adjustment of inflation?

Not really. But opportunity cost is representative of what you are likely to earn if you do not take the risk with your investment.

Hello Karthik…

Thank you very much for neatly structured articles.

I’ve one question regarding DFC model.

How do adjust this model for companies with negative free cash flow?

Companies with very high CAPEX for eg, TATA Motors.

Pavan, unfortunately, DCF does not work with -ve cash flows. You can use an alternate model such as relative valuation. I’ve not discussed that here but will do in the module on Financial Modelling.

Thank you Karthik.

Can you kindly let us know names of some other popular modelling techniques, so that we can educate ourselves.

Did I mention Relative Valuation?

Hi there…

In previous discussions you had referred to ‘Discount Rate’ as WACC

If i am not wrong; in simple terms , is WACC the rate at which the company is financing itself..???

Yes, its the cost of capital.

Thanks Karthik,

In continuation of my previous query, the computation of WACC is quiet time consuming and moreover employs some estimations which are usually out of reach of retail investors to some extent.

1. I’ve shared a link of TOPSTOCK which gives us WACC on Y-O-Y basis for Amaraja Batteries ( https://www.topstockresearch.com/INDIAN_STOCKS/AUTO_ANCILLARIES/RiskPriceAndValuationOfAmara_Raja_Batteries_Ltd.html)

My question is according to above data WACC ranges between 13% to 17%. But in your example you had considered only 8.5%. I would like to know your views on data shared above…?

2. Does ‘Weight of Debt WACC’ or ‘Weight of Equity WACC’ will have any impact on the Discount rate figures..?

3. In an economy; where interest rates are falling, will not the the WACC of company automatically fall…?

4. Higher the Discount rate; smaller (conservative) will be my intrinsic value. Am I right…?

1) I had consider 8.5% 5 yrs ago, market and economic conditions have changed. Clearly that rate won’t hold now.

2) Yes, end of the day, the risk-free rate prevailing in the economy matters

3) Yes

4) Nope, depends on the company’s free cash flow output

Hi,

Tested the DCF model with nifty 50 and to my surprise only a few companies were trading for market value less than intrinsic value even after a huge downfall due to covid ( considering 5% discount rate), So-

1- Do I need to change future cash flow growth projection along with discount rate too? ( took 15% and 10% for 5 years each )

2- Found out DCF doesnt work with financial companies and Banks, which will be the best way to find out their valuation.

Thanks a lot!

1) I think 15% is on the higher side now. More like a 8-10% may help

2) Yes, that’s true. It is best to look at book value and related valuation metrics for the financial services firm

Got it Thanks.

By 8-10% you mean for the first year or all ten?

Also, if all the years then 8% for first 5 and 10% for next five ?

10% for the first 5 yrs and 8 for the remaining 5. 2 stage basically. Tweek it according to the industry and company you are working on.

Hi,

How is price appreciation accounted?

Example the earnings may not be fixed at 500000/- for next 10 years. It could appreciate, keeping the number of Pizza’s sold constant. As the proce of Pizza’s could have increased. With that in mind, the IV of machine could still be 5000000/- in 2015? Therefore, is there a need to discount the future price to ‘Present Value’?

From a buyer perspective it makes sense, as it considers the worst case. But from a seller perspective it could be a loss?

Stitching back to Companies/Shares – we might undermine the true value – again good for risk averse invester.

Sorry, I’m not sure if I understand the query completely. Can you add more context?

Hi, very good explanation.

Could you please guide for banking and financing stocks how to evaluate as I find it difficult. Most of finance and banking shows negative cash flow. Which valuation model suits best for banking and financial. Please guide.

Hmmm, this I’m not sure myself, Aasim. Let me look for an online resource.

Thank you so much for sharing this knowledge, though I have one small doubt.

While calculating the net present value, the amount of 195.29 was assumed or was a fact if it was an assumption on what basis was it assumed?

“For example in 2015 – 16 (2 years from now) ARBL is expected to receive Rs.195.29

Crs. At 9% discount rate the present value would be –

= 195.29 / (1+9%)^2

= Rs.164.37 Crs”

This is the part of from the above chapter, please help.

195.29Crs was the projected free cash flow no? As explained in the chapter.

Sir from where do I find the discount rate and the opportunity rates?

You will have to look at the prevailing rates in the economy and estimate these rates.

Good Evening Sir,

I am following Zerodha Varsity rigorously, I read 8 modules during the past 2 lockdown months. Thank you for providing such valuable knowledge for free.

I have a small doubt, what inputs will differ if we were to use DCF analysis on Finance/Banking Industry. Or will the analysis be same?

I’m glad you read all the modules, Dhruv. Hope you liked these modules 🙂

I’ve never really used DCF on BFSI, hence I’m not sure if I can comment on this.

Thank you for your quick response, and yes I absolutely loved all the modules. Again thank you for this.

Another small quick doubt, though this is not related to Fundamental Analysis, I wanted to ask how can we download the previous Futures data from Zerodha Pi? In module ten you showed the example of SBI by downloading previous 200 days data.

Right-click + save to excel should work. Do try that.

Sir, could you please how calculate 500000* (1+8.50%)^6

is it 500000*(1+8.50/100)^6

i.e 47500^6

Also let me know the meaning of this sign “^” & how to calculate ^6

^6 means, raised to the power of 6. Try the equation again by raising it to the power of 6.

Thank you very much sir

Welcome!

Dear Karthik

We need to focus on which shares.

Basic or Diluted and whats the exact difference between the two??

Regards

Indranil

You need to look at Diluted. Diluted includes all the shares which are locked in and soon will be converted to equity shares. Basic, on the other hand, considers only the outstanding shares.

Does annuity from FD gets compounded annually?

Yes, as long as its reinvested at the same rate.

Sir basically it is indicating about inflation? The value of the money that we have today in future’s perspective.

Yes, Future value money factors in inflation.

Hello Karthik,

Today I noticed the premium for RELIANCE AUG 2340 CE shot up by 200% which made me wonder if stock returns are continuously compounded?

So if I invested 100 INR in stock, my return for every 1% gain would be:

1 INR (1% of 100)

1.01 INR (1% of 101)

1.0201 INR (1% of 102.01).

Does the same happen to option premium too?

https://www.calculatorsoup.com/calculators/financial/compound-interest-calculator.php?given_data=find_A&P=100.00&R=200&n=0&t=1&given_data_last=find_A&action=solve

According to the calculator, continuously compounded, your invested money would increase by 6x on a 200% gain. Is it correct or am I missing something?

No, it does not work that way Varun. The returns cannot be timed and stay consistent. You may get 1.0201 after 1 year or 9 months, no one really can predict this.

Hi,

I am new to investing in stock market. I wanted to know, Do large cap stocks (say Nifty 50) ever trade below their intrinsic value(considering margin of safety) in a normal bearish market. I felt the recent fall during March was exceptional, hence not considering that.

Thanks in advance.

Of course, they do, Varun. The market is not partial to market caps 🙂

First of all thank you so much for this great content in Varsity which is quite helpful for individual investors and traders.As Banks and NBFC cant be valued using DCF valued and like you mentioned in one of the comments that you are going to update something specific to these financial institute valuation technique.Can you please confirm when it will be available.If already updated elsewhere,Could you please share link or chapter name.Very happy to pickup from there.

Ravi, I know this is pending for a while. Its just that I’ve not been able to do it, not because of time, but I still dont have the confidence to write about it 🙂

Hello Sir,

Nice article, thanks for sharing such good information. I personally like value investing and after reading your article became more interested in it. Could you please share how to evaluate Banking sector companies? I saw in above comments you have been working on those, could you please share the link for the same if that work is completed.

Awaiting for your reply.

Thanks

Gaurav, I’m glad you liked it. I’m not sure if I can point to a source, as I’ve not really come across any good one 🙂

You have shown the calculation for Future value, Ex: 5000*(1+8.5%) ^5 and the answer is 7518.3. I am not a science or commerce person so can you please explain the calculation especially ^5 this part. Can you please explain as i didn’t understand hoe you got this value of 7518.3

Shalin, ^5 means, you raise it to the power of 5.

I have a query regarding DCF. I noticed in your notes, while calculating the net debt, you have considered only long term borrowings. Shouldnt we consider the short term borrowings as well? And also, if there are any lease liabilities, will they be considered while calculating the total current year debt?

Not really, since the short term debt will anyway be settled within a year. Lease liabilities – you need to look at the liability in relation to the overall size of the company.

Ihave a question regarding DCF. I have noticed in your notes, while calculating NET DEBT, you have considered only long term borrowings. Shouldnt we include short term borrowings as well? and also if there are any lease liabilities, will they be included in the debt as well?

Thanks for the inputs. I come from the science background and im new to investing. But your app has been extremely helpful to me. The explanation is crisp, simple and to the point. Wonderful work!

Happy reading!

valuable lessons

sir can i use compounding formula to calculate future value

Hmm, it is used but you need to know the context. Have explained the same in the chapter.

It will be good if you can explain this for one of the stock as an example.

Will do that and more in the next module after, Raj. Next module after personal finance.

I’m MBA fresher I’m interested to start career in stock market. Which job profile should I look as a fresher. Recently I had passed NISM module by reading u r content it really helped me.When r u going to start finance modeling course

I’m really glad you could clear NISM with Varsity’s help! Congrats 🙂

You can start looking for opportunities in AMCs, they keep hiring MBAs. Will start Finance modelling course soon.

Hi,

Very Interesting Articles Sir.

Regarding calculation while getting Present Value for Rs.5,00,000/- in 2 years assuming 8.5% Discount rate.

It comes Rs.4,24,727/- know! why it is shown as Rs.4,24,808/- any particular reason or Am i missing something?

Please clear my doubt.

Thank you.

Ah, need to check again. Quite possible I could have done a typo 🙂

Hello sir,

1) Do the intrinsic value changes over time; means if I have calculated intrinsic value in march 2021 will that value remain forever?

2). The current market price of many good stocks are far far above intrinsic value will those price come to intrinsic value range?

3). If yes, what would the reason for for such great fall in prices of good companies stocks? (Means for which opportunities one should look for)

Thanks

1) Yes, with the change in stock prices, there will be a change in the intrinsic value as well.

2) Probably, if the market corrects. Or the earnings have to increase to match up to the valuations.

3) General market correction.

Thanks

1) if the intrinsic value of stock changes with market price then how frequency one need to calculate the intrinsic value of particular stock, means every year..

Hence the need to arrive at the company’s intrinsic value range. The intrinsic value cannot be a single price point.

a Very good article, Thanks Karthik

Thanks, happy learning.

How to arrive at future cash flows for a company stock?

Have explained in the chapter itself right?

1. To be on conservative side, can we take GDP rate as growth rate for future cash flows for a company stock?

2. What is cash flow number. Is it cash flow from operations or cash & cash equivalents at the end of year?

1) No, we do not take GDP as such.

2) Do read the explanation in this and the subsequent chapter, Mohan. Thanks.

I have gone through the Fundamental analysis and understood all the calculation except one point “Share price”. As you mentioned in PDF to get fair share price, you need to calculate as Share Price = Total Present Value of Free Cash flow / Total Number of shares. But the DCF module excel file which you uploaded for calculation. In that excel file the formula is different, it is showing as Share Price = (Total PV of Cash flow – Net Debt) * 10^7 / Total No of Shares.

I am confused with this 10^7, Could you please explain why we have multiply 10^7 and what is 10^7 logic used for calculating to get share price value?

Look forward for your comment.

10^7 = 1 Crore. So we basically we use it to ensure we convert the numbers to the Crore denominator.

A company’s cash flow change’s each year how are you taking cash flow as constant?

Valuation is at a particular point of time, where we consider the data up until now.

absolutely amazing explanation . Can zerodha launch some more training program like MS excel , financial modelling etc .

The next module is on Financial Modelling. 1st chapter will be up on Monday.

Sir, in the pizza example we have assumed that machine will generate 5 lakh every year but isn’t that wrong considering inflation because of which pizza price will increase and so do the total annual earning for the machine. So instead of calculating present value for future earning shouldn’t we be calculating future value for present earnings?? Hope you get my query. Waiting for the reply.

Thank you.

Ah,I do get your point. But I wanted to keep it simple with no complications (introducing inflation, etc) to help understand the concept of PV of future earning, better.

Hello Sir,

a) Are company promoters allowed to trade in their own stock?

b) Or what if a promoter who hold 30% decides to offload all his stock in a period of 3-4 weeks, without block deal and bulk deals as block deal and bulk deals are known to the public.

Only quarterly results tell us the shareholding pattern.

a) Yes, but it has to be declared to the exchange

b) Again, has to be informed to the exhcnages.

Sir, you people did a great job here. I was into markets, but my fundamentals were not so clear. Now that I’m taking courses from Zerodha Varsity under study, I must say I’ve learnt quite a few new concepts. Moreover, the certification is a icing on the cake. Great job ! Thanks!

Also I was keen to know if you people provide any kind of internship opportunities, I would be glad to join. I’m a MBA 1st year student at KJ Somaiya, Mumbai.

Happy learning, Bijay!