Latest stories

Valuation – reverse engineering the stock price

V

I discussed my approach on evaluating PE ratios (see here). In addition based on the table shown in the previous post, we can work out the assumptions built into the stock price in terms of the ROC, CAP and growth rates. These variables can be compared with the actual and expected results of the company to decide if the stock is undervalued or not. Sounds easy in concept, and it is if you understand the company and the industry well. This approach is also called as expectations investing and I learnt about it in the book -.expectationsinvesting. I would recommend reading this book to understand DCF and the previous post better.

The above approach is a very useful tool in analysing a company. Let me give two examples.

Example A – CRISIL . This company sells for a PE of almost 60+. The embedded expectations are
ROC – 25% (current value)
Profit growth ( Net profit = Free cash flow) – 18% p.a for last 6 years
CAP – 20 years

Basically the company needs to grow at 18% per annum for the next 20 years and maintain the ROC. The company would be earning a net profit of almost 1000 odd crores by then. To make money on the stock in long run, one has to believe that the company will do better than what is implied by the stock price. Will the company do as good or better than implied above? I don’t know and certainly not comfortable or confident of a company to do this well for such a long period of time.

Example B – Novartis. The company sells for an adjusted PE (take cash out from mcap) of around 7.
ROC – 50% +
Profit growth – around 10% per annum for last 6 years
CAP (implied) – 0 years (if you assume terminal value at 10-12 times cash flow).

Basically the company sells for 7 times earnings. Current earnings are around 90 crores on a very low capital base. In addition the company has strong competitive advantage. So with a mcap of around 600 odd crores, the company will earn the current investment back in 5 years. The market is current pricing novartis with an assumption that the company will be out of business in 4-5 years.

I have given the two examples for illustrative purposes only. It does not mean that the stock will do well for novartis in the next few months or do badly for Crisil. But the above analysis is useful in making investment decisions.

Valuation – How to evaluate the PE ratio

V

I had done a quick valuation exercise of MRO-TEK earlier (see here). I used a certain PE ratio in the post and said that I would explain my approach later. So here it goes …

To understand my approach, you have to look at the file Quantitative calculation and worksheets – cap analysis and ROC and PE. You download this file from the google groups
The worksheet ‘ROC and PE’ has DCF (discounted cash flow model) scenarios for various businesses such as Low growth, high ROC (return on capital ). For ex: Like Merck or high growth and high ROC like infosys etc.

As you can see in excel screenshot, I have put a growth of around 10% in Free cash flow, ROC of 40% and calculated the Intrinsic value (or Net present value). The ratio of the NPV/current earnings gives a rough value of PE for the above assumptions

Now I have used various assumptions of growth, ROC etc and created the matrix below (CAP analysis worksheet in the same file)

The above is for a matrix of ROC (return of capital = 15%). I have varied the growth and CAP (Competitive advantage period).

As you would expect, if growth increases, so does the intrinsic value and the PE. If the ROC increases the same happens. This is however ignored by most analysts and sometimes the market too. This is where opportunity lies sometimes. The third variable – CAP also behaves the same. Higher the period for which the company can maintain the CAP, higher the intrinsic value and higher the PE. CAP or competitive advantage period is not available from any annual report or data. It is the period for which the company can maintain an ROC above the cost of capital. For a better understanding of CAP, read this article – measuringthemoat from google groups. It’s a great article and a must read if you want to deepen your understanding of CAP and DCF based valuation approach.

As I was saying, CAP is diffcult to estimate as it depends on various factors such as the nature of industry, competitive threats etc. I usually assume a CAP of 5-8 years in my valuations. If it turns out to be more than that, then it serves as a margin of safety.

Now when I look at the company, I use the worksheet ‘ROC and PE’ and my thought process (simplified) is as follows

1. Look at ROC – does the company have an ROE or ROC of greater than 13-14% ? If yes, is it sustainable (this is subjective).
2. Use the above worksheet to select a specific ROC sceanrio.
3. What has been the growth for the company in the last 8-10 years. What is the likely growth (again subjective estimates).
4. What is the likely CAP? This is a very subjective exercise and requires studying the company and industry in detail. If the company checks out, I usually take a CAP of 5-6 years.
5. Plug the ROC, growth, CAP and current EPS numbers in the appropriate sceanrio and check the PE. That is the rough PE for the instrinsic estimate.
6. Check if the current price is 50% of the instrinsic value
7. Cross check valuation via comparitive valuations and other approaches.

If all the above checkout, it is time to pull the trigger.

In case the above has not bored you to tears, 🙂

Next posts: Some conclusions from table for CAP v/s PE v/s Growth (CAP analysis worksheet), pointers on DCF etc etc.

The black swan – unpredictability, futility of forecasting etc

T

I have just finished this book. I wrote about this book earlier here. I have also read N N Taleb’s earlier book – fooled by randomness and liked it a lot.

I will not be doing a detailed review of the book as that can be found on amazon and a lot of other website. I will however highlight some of the points, which struck me as important and how they impact me as an investor.

One of the key points, which the author makes, is about the complexity of the real world and lack of predictability. For ex: No one predicted the rise and the importance of the internet. The Internet has become one of the major forces shaping our world. It can be termed as a positive black swan. As a result all complex systems such as the economy, financial markets, which get impacted by such black swans, cannot be predicted. But that does not stop analysts and all the talking heads on TV from making predictions (predictions for 2008 etc etc)

Now one can argue that some prediction do come through. Well, you don’t have to be a guru for that. Just take some events, toss a coin and make a prediction based on the toss. You will be right 50% of the time. Analysts and TV gurus are worse than that in terms of their success rate. There are numerous studies supporting it, so you don’t have to take my word for it. Try this on your own – write down some predictions you hear this year and check back a year later.

Why are we suckers for this? because we want to resolve uncertainity and anyone who can or claims to provide visibility to the future is sought out (we do have astrologers !) . The author terms this as the narrative fallacy.

Personally, I stopped looking at predictions, analyst estimates, top picks/ hot picks etc etc long time back. If I want to be entertained I would rather watch a movie or a cricket match!

A logical question is how to invest if you do not predict. Does developing a DCF not amount to forecasting a company’s cash flow? Well it does. The difference is between a macro and a micro forecast. Forecasting a company’s cash flow is much easier than forecasting the direction of the stock market. If you know the company well, it is in your circle of competence, and you can figure out the few key variables driving the cash flow of the company then it is possible to arrive at a reasonable estimate. Will it be accurate? I don’t think so. However if you are conservative in your assumptions (don’t assume 50% growth rates) then the impact of the negative surprises would be minimal. I would not worry about positive errors (cash flow more than forecast) as I will gain from it. In addition, if you buy at a discount to the estimate of the intrinsic value (margin of safety concept), then you are protected further from errors in the forecast.

Compare this approach with macro, top down forecast. If some one says – infrastructure stocks will do well because infrastructure spending is to increase by 50%. In addition to all the stock specific factors, you thesis is also dependent on the increase in the spending which in turn depends on multiple factors. The more variables in the investment idea, the more there is a chance of something going wrong. In addition, you will also pay more for such an optimistic scenario. So if the macro forecast or something else with the company goes wrong, the losses can be severe.

HPCL – a quick review

H

I had written about HPCL earlier (see here). To recap, my main thesis was as follows.

HPCL now sells at around 9000 crores. The EV is around 10000-11000 crores at best. The replacement value of the assets is around 25000-30000 crs. The company is selling at 25-30% of replacement value, which can reduce due to the following reasons

1. The company is currently engaged in diversifying its revenue streams via various initiatives and reduce the impact of the pig headed policies of the government. These initiatives are lube marketing, Gas distribution and retail initiatives and oil trading and risk management. The market is currently not valuing any of these real options.
2. The GRM and net refining margins are at their lowest. Going forward the worst case sceanrio is that they would remain at the same level. If that is the case, the bottom line should still improve as the various company intiatives take effect (see page 53 of Annual report)
3. The 9 MMT refinery and expansion of Vizag refinery to 15 MMT and export of the petro-products and E&P activities should help the company improve its margins going forward.

So what is the situation now ? Well the company is selling at around 400 Rs/ share and the gap has now reduced to around 40% of replacement value. It is easy to declare that the original thesis has been validated. However although I think that the above reasons are still valid, they are not responsible for the reduction in the gap. I expected these reasons to play out over 1-2 years. However in the current bull run, each and every listed stock is rising almost every other day. HPCL is no different. That said, I am not complaining if I have been lucky.

These are interesting times in the market. The market is now at a PE of almost 27. Almost 1000+ stocks are now at a 52 week high and any stock which one could have picked in the last 6 months has risen. I cannot speak for others, but for me it is time to be cautious. Frankly I am having diffculty finding good ideas. It has almost become like searching for a needle in a haystack. However for me doing nothing is better than doing something stupid.

Disclosure: I have a position in the stock. As always please see the disclaimer too.

Subscription

Enter your email address if you would like to be notified when a new post is posted:

I agree to be emailed to confirm my subscription to this list

Recent Posts

Select category to filter posts

Archives