CategoryInvestment process

How i analyse stocks

H

I have been asked via emails and comments on the process I follow in analysing stocks. I have written about my approach earlier, but may have never put it formally in a single post.

My approach essentially consists of the following steps

1. Idea generation – This is typically the first step in the process. It involves searching for undervalued ideas. I do not have a strict formula for the search process. I use icici direct website to run a few screens to generate some ideas. Some of the screens are as follows

PE less than 13
ROE greater than 13%,
debt / Equity less than 0.7

Once I get this list, I export it into excel and then add additional parameters to it such as Net profit performance for last 5 years, ROE for last 5 years etc . A few companies get eliminated at this stage if they had losses for the last few years and have only been profitable for a year or two. Once I have shorter list, I start looking at the Profit and loss statement, Balance sheet and ratios. A few companies get eliminated if I don’t like what I see at this point of time. For ex: If the free cash flow is poor for the company, I will remove the company from the list.

In some cases the elimination is not really scientific and is driven by my whims and fancy ( I am not as rational as I should be). So highly cyclical companies, which seem to have a very low PE due to sudden profit spurt are eliminated if their normalised PE is not attractive. After all this number crunching, I may be left with a 10-12 companies.

Another source of ideas are blogs of other value investors, articles or suggestions by some other investors I admire and follow. If I see them talking about a company, I add it to the list and start investigating it.

2. Annual report review – Once I have a list of interesting ideas, I start scanning the annual reports of these companies to look for any red flags or hidden value. Some companies get eliminated at this stage if I find something fishy. Once I like the numbers I see, I start reading the Annual report from the beginning, starting with the Director’s report, Management discussion etc.

3. Valuation template – Once I have a rough idea of the company and if the company still looks good, I start updating my valuation template. I start with the Quantitative numbers, follow it up with an industry analysis, competitive analysis etc. I keep referring back to the annual report to update the worksheets and answer some of the questions in the template. I also use this stage to generate more questions on the company.

4. Broad research – After updating the basic numbers and the qualitative worksheet, I may end up with some open questions. For ex: How is the industry expected to do over the next few years? . How will competition impact the company etc ?. At this point, I start doing some research on the net to find answers to these questions though I may or may not be successful at this stage in finding answers . I may even download the AR of the main competitors and review it to get a feel of the industry. This stage is fairly unstructured and I just trying to gather as much information about the company and industry as possible

5. Valuation – If I am still comfortable with the company, I start the DCF calculation and other valuation exercises. Over time I have realised the valuation exercise is fairly redundant. If the undervaluation is not perfectly obvious by now, then plugging some numbers and making a bunch of assumptions is not going to make the company an attractive buy. The numbers being plugged into the model are dependent on the qualitative analysis done during previous stages.

During this stage I go through a DCF valuation, comparative valuation and a probability based valuation exercise. If the numbers match with each other in all the approaches, then I am more confident of the Intrinsic value estimates

6. Portfolio inclusion – I typically try to keep 12-15 companies in my portfolio. So if a company has to get added, another has to go out. This prevents my portfolio from becoming a zoo of mediocre ideas. I compare the discount at which the new company is selling to my estimate of the intrinsic value. I then compare this discount with that of the other companies in my portfolio. If the new idea is better than an existing one, then it replaces it. Else I may make just a very small token investment to track the company and wait till it become more attractive or some other company goes out of the portfolio.

Although I have listed the steps in a very linear and logical fashion, in reality it is not so neat. Multiple steps are going on at the same time and I may sometimes skip a step too.

As you can see, the process is a bit elaborate and time consuming. I however do not find it cumbersome as I enjoy doing it.

Come to think of it, why should it be easy? is there any competitive profession in the world where you can make good money without any effort ? why should investing be any different ? Have you ever heard that someone has become a heart surgeon in a day?

Rear view mirror investing

R

Was reading this article – mutual fund NAVs take the plunge. The following caught my eye

“The high erosion in the NAVs is the outcome of heavy concentration by mutual fund industry in sectors like banking, real estate, capital goods, engineering, cement and construction which were going great guns in 2007, but have eroded sharply this year. Most schemes had comfortably ignored sectors like pharma, FMCG and IT, which have started to perform now. So, the funds that failed to tap in these opportunities then are paying a heavy price today.”

The above statement gives me such a feeling of deja-vu. History repeats itself in the stock market, again and again. I saw the same thing happen in 2000 with IT. Most of the mutual funds piled into the IT sector, right before the crash. The same seems to have happened now.

Ofcourse it takes courage of conviction to go against the crowd. It is not rocket science to figure out that a company selling at 70 times earnings could be overvalued. But then most of the fund managers, wanting to keep their jobs are more worried about their quarterly performance than doing well in the long run.

For those who say that the small investor is at a disadvantage v/s the pros, I would say it is complete hogwash. All other factors aside, as a small investor I am personally not forced to invest in the current hot stocks. At the cost of looking like a moron in the short run, I can afford to pickup undervalued scrips which will give me good long term returns. That advantage alone is more than all other advantages the big boys have such as more research, access to management etc.

This rear view approach is however not limited to the big boys alone. Unfortunately a lot of small investors do the same. However if they lose money, they end up blaming everyone except themselves.

I am guilty of doing the same thing in the past. However the sensible thing I did was to blame myself completely for the losses. It is not that I mindlessly go against the crowd ( I wont cross the road with a red signal when everyone else is standing on the sidewalk for the sake of going against the crowd 🙂 ).

If am looking at a company, I need to convince myself why the market is undervaluing the company and what is my variant perception. For stocks which favored by everyone else, I have generally found that the market is either too optimistic or is valuing them fairly and hence it is unlikely that I will make good returns.

Business scalability and valuation

B

My pervious post was about business scalability, a term used by Rakesh jhunjhunwala frequently. I attempted to lay out my understanding of the term in that post.

Business scalability is a critical factor in valuation. As I detailed on my post on intrinsic value, the DCF formulae can be used to calculate this number. There are two key variables in the formuale – Free cash flow and the duration of the same before the terminal value is applied. This duration also referred to as CAP (competitive advantage period) is the time period during which the company is able to earn above its cost of capital. Beyond this period the company earns its cost of capital and hence is valued at its terminal value.

A company with a scalable business will be able to grow its free cash flow faster (higher growth) and also have a higher CAP at the same time. Now higher the growth and CAP, higher is the intrinsic value. If you can identify such a company much before the market does, as Rakesh jhunjhunwala and other top investors are able to, then the returns are very very high.

However identifying such companies is not easy. The most common error I have seen with analysts is that they identify the market opportunity, pick a company most likely to do well and stop at that. The analysis should also involve analysing the business model in detail, identifying the key drivers of performance and doing an assessment of these drivers. If this sounds complicated, then it is. The value is not easily apparent and requires quite a bit of analysis and digging around. All this has to be done before the market recognizes the company and bids up the price.

I think this approach to investing is a very advanced form of investing. It is not easy for a novice investor to practise this form of investing easily. One should have a keen understanding of business models, valuations, economics and other aspects of investing. Graham or deep value investing requires much lesser expertise and also has more diversification of risk. However this form of investing, where an investor can correctly identify a scalable business, is the key to long term riches.

Business scalability

B

I received the following question from rathin and thought that this a good question which cannot be answered in a short comment.

Hi Rohit,Can you elaborate more on “Business scability”…Rakesh JhunJhunwala emphasises on that…Can you also give one practical example of a company??

Rakesh Jhunjhunwala empahsizes the term ‘business scalability’ a lot in his interviews and presentations. Let me try to give my understanding of of the term

I think business scalability should be analysed based on two key factors

1. Market opportunity – How big is the addressable market, the company is trying to target
2. Business model – How scalable is the business model in its ability to tap the above opportunity profitably

Let me expand further on the above two points via some examples

Lets take the example of Bharti or any other similar telecom company.

Market opportunity – The market opportunity is case of telecom is huge. Telecom services are still far below international level and even after years of hyper growth, there is still a large untapped market. Market opportunity is easier to identify and one can compare the indian market with other markets to get a sense of it. However the fallacy by most analysts is to take a direct linear estimation. For ex: for argument sake US consumes 20 Kg of choclate per capita per annum. India’s per capita consumption is say 100 gm. so the market opportunity is 200 times that of US.

This is a very simplistic approach and should be taken with a pinch of salt. There are far more variables involved in evaluating market opportunity and a range of values for most products and services should be considered.

Business model – This is far more complex to analyse. This is where the genius of investors such as Rakesh jhunjhunwala is apparent. They are able to evaluate the business model far in advance and are able to judge if the business model of the company can scale profitably.

For ex: In case of telecom, there is a huge upfront investment in the infrastructure, license, setting up the marketing infrastructure etc. However once these investments are done, incremental cost of gaining a Rupee of revenue is low. Such business models are far more scalable

To get technical – The marginal cost remains steady or reduces in scalable models. Such companies get more profitable as they grow.

In contrast lets look at IT companies. It is apparent that the market opportunity is large. However the business model is not as scalable as Telecom. Here the relationship of revenue and cost is at best linear. In some case there may be a disadvantage to the scale. As the company grows larger, you need to manage more employees, have more layers and there are other costs involved in managing such large organizations. The top tier IT companies now have 100000 employees . A 10% CAGR growth for next 10 years , which is not a high assumption , would take the employee strength to 1 million plus. So you are talking of model which is not as scalable as Telecom

Lets take an extreme example of a roadside eatry. The addressable market is big. However the business model is not scalable as the eatry can only serve limited geography and may be limited by the competency of its owner and the employees running it. However if the owner can develop a franchise and start licensing it, then the model is scalable. Alternatively if the owner can brand its product then it is scalable to a certain extent

Among the two factors discussed above, I think the more crucial aspect is the scalability of the business model and how competent would the management be in tapping the external opportunity.

Next post: How does scalability impact valuations ?

What is intrinsic value ?

W

In all my posts on investment ideas, I typically refer to the instrinsic value of the company. Although the definition and the concept is deceptively simple, application takes a lifetime.

What is intrinsic value – It is the total free cash flow the company will produce from now to closure of the firm. Discounting these cash flows gives the intrinsic value.

I will not be able to give a complete rundown on the DCF (discounted cash flow) computation. That could be another post, when I am really in mood to bore everyone to tears :). However the formuale for the computations is present in my valuation template – see the tab ‘DCF’

You can find the formulae here. The key parameters are free cash flow, discount rate, terminal values and growth rate. There are volumes written on each parameter and I will not get into the pros and cons of it. Let me give you how I calculate each. You can find the mechanics for each in my worksheets for companies.

Free cash flow = Net profit (after adjusting for all one time gains / losses) + depreciation – maintenance capex

Discount rate = around 12-13 %. That’s the hurdle rate for me. I don’t use any risk premium above that. Discount rate is a research topic in itself. I prefer to use a rough approach though and not tie myself up in academic acrobatics.

Growth – self-explainatory

Terminal value – It is the value of the company from the nth year ( n-1 year are the no. of CAP years) onwards. I would suggest looking at some textbook for more details as it is difficult to explain it in a short post.

I take it as 12 times Free cash flow of the previous year. Simple formulae for terminal value is NOPAT (net operating profit after tax)/ WACC (weighted average cost of capital). However let me warn you that the DCF calculations are very sensitive to the terminal value and it is important to be conservative on this parameter.

Once you have worked these numbers, you can plug them into a spreadsheet and get the intrinsic value. As you can see all these numbers are estimate and hence intrinsic value is an estimate too. The trick is in the assumptions you make. You have to be careful in making conservative assumptions, otherwise the DCF calculation could give you inflated numbers. That’s why a good valuation requires an indepth understanding of the company and its economics.

Discounted cash flow (DCF) analysis is the most fundamental way of calculating the instrinsic value. The other approaches such as PE, relative valuation which depends on comparing the valuation with other companies in the same industry etc are indirect valuation approaches. They can be used an input into the valuation process, but should not be the sole approach

Portfolio management and anchoring

P

A lot of energy is wasted around discussing the market levels. Short of buying an index, I think if you are focussing on a company, the market levels do not matter. If the company is overvalued in your opinion, the market level will not matter and vice versa. So all the decision is around the stock price and its relationship with the intrinsic value.

That said, it is not easy to ignore the noise. In order to so do, I have modified the way I manage my portfolio and track individual stocks. I have done this also to avoid anchoring to the price at which I buy the stock. To read on anchoring see here

The normal tendency is to look at how the stock has done v/s the price at which it was bought. So I used to get pained if it went below the buy price and happy when it went above. That can mislead us – this is how

Suppose the company you bought came out with results which are poorer than expected. You analyse the results and realize your estimate of the intrinsic value is off by 30%. What should you do ? If you are anchored to the purchase price and if the current price is higher, you tend to discount this information and may continue to hold on to the stock, when a good decision could be to sell.

This is how I currently try to avoid the problem –

I maintain a spreadsheet of all my holding with the following columns

Name
No. of stocks
Intrinsic value estimate
Buy price
Current price
Discount to intrinsic value (intrinsic value- current price / current price)
% gain/ loss

I am constantly looking at the discount to intrinsic value number. If the price drops and the discount is more than 50%, I start buying. If the discount is less than 50%, I sit pat.

After every quarterly/ annual results, I review the instrinic value estimates again and update this number. Check the discount again and buy if below 50%. In addition if I come across some information which I had not considered, I review the instrinsic value again.So the comparison is always to the intrinsic value (which is changing based on new information) and buy/hold or sell decisions are based on the discount to the intrinsic value.

The above ensures that I am not fixated to the current price or market level or what the analysts are saying – Ok I am joking about analysts, I never bother about their opinions (prefer to make my own blunders).

Next post : Adding, selling stocks and adjusting wieghtages

Valuation – some more thoughts

V

I covered my approach to estimating the appropriate PE for a stock and reverse engineering the current valuations in the previous posts. This is ofcourse not the approach taken by analysts. The typical approach is to look at the past history and decide on the likely earnings (and not even free cash flow). If the analyst is optimisitic he slaps on a high PE and voila ..we have the price target. To support the argument, the analyst does a comparison with other companies in the sector and tries to justify the PE. So we may have an optimisitic earnings estimate and on top of that a high PE attached to it, which would amount to double counting.

That is an incomplete approach. If the sector is in a bull run or has very high valuation then you are committing the same mistake twice. First assuming an optimistic estimate of earnings and then applying a high PE. Don’t believe me ? …well several IT companies sold for a PE of 100 in 2000 and real estate and capital goods companies sell for similar high valuations. Average PE for IT companies is now below 20 and mid caps in IT sometimes sell for less than 10 times.

This brings me to some interesting observations which you can derieve from this table below

For a company to justify a PE of 30+ the following has to happen – The company has to grow a more than 15-18% per annum for 9-10 years and maintain a ROE or ROC of 15% or higher. That would justify the PE of 30. If a company sells for that PE, then for you to make money the company has to do better than that. PE ratios of higher than 40, require higher growth, higher ROC and much longer CAPs.

Is that likely ? well it can happen …but don’t bet on that. Industries which have high growths and high ROC tend to attract a lot of competiton which drives the returns down. That’s a given rule of economics.

As a result I am wary of companies having a high PE. To justify an investment, the company has do better than the implied value (which you can get from the table above).

Final point – I have put comments on the right of the table with color schemes. Red means stay away for me !

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.

Maintenance capex calculation

M

I discussed about maintenance capex and its relation with Free cash flow. To recap

Free cash flow = Net earnings + depreciation – maintenance capex

And free cash flow is the money the owner of business can take out or re-invest in the business.

Maintenance capex however does not have a precise formulae. That does not mean you cannot calculate it. But as you can see, if valuation is based on free cash flow which itself is based on an imprecise measure such as maintenance capex, it cannot be precise in itself.

Valuation depends on free cash flow, project growth rates , terminal value and the discount rates. All these are estimates and hence valuation is itself an estimate. That is the reason I find it assuming when analysts give reports where they give precise valuation targets and on top of that even the duration (next one year !!) when the target would be met.

So, coming back to maintenance capex, how do I estimate it? let me warn you at the outset. My approach is self developed, imprecise and only roughly right.

I will use my valuation template to explain my approach

Worksheet – anal – In this worksheet I fill up the sales, depreciation, wcap etc. On line 26, I calculate the additional capex (additional fixed asset and Wcap for the year). Line 27 is capex as % of sales. This gives me a capex trend (total) for a period of time for the business. I then use this trend to estimate the maintenance capex.

For ex: if the business has an asset turn (on average) of 2, then I would assume capex as 2.5% of sales

Sales = 100
Asset = 50
Inflation increase in sales = 5
Corresponding asset required = 2.5 (2.5% of sales)

If the business is asset heavy (commodity industry) then the maintenance capex as % of sales is high.

If the asset turn is 1, then maintenance capex would be roughly 5% of sales. You can compare this % with depreciation as a % of sales to see if both are roughly equal.

You may find some errors in my worksheet and I plan to load an updated version soon. I don’t use these worksheet very frequently now. After using these worksheets for several years, I am now in a position where I can look at the numbers and estimate if the company looks roughly undervalued. A lot of companies don’t pass that test and are rejected outright. If a company passes that filter, I fill up the excel and go through the entire exercise (which is not very precise in itself)

I have loaded a few samples in the google groups. If you go through this exercise yourself several times, you will see patterns and it will be faster for you too.

In addition to the above excel, please have a look at the excel – Quantitative calculation – worksheet : Maintenance capex to see the relationship between Sales, Asset turns, Maintenance capex and ROC.

Ofcourse you can have a counter argument – who the hell wants to go through such an elaborate exercise to value a company? Don’t I have better things to do in life 🙂

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