Tuesday, May 5, 2009

Hunting for value in stocks


Published in The Hindu - Sunday Magazine on May 24, 2009


A back of the envelope technique to spot gems during the current downturn


It is that time of the year when the CXO daddy’s and mommy’s prepare for their annual exam…ironically at a time when the kids are enjoying the holidays. Yup! I am of course talking about the annual earnings season for the Apr08 – Mar 09 financial year. CEOs and CFOs sincerely do their homework and probably even a dress rehearsal or two – first for putting on a good show at the board meeting, second for the dreaded 5 minute interview on CNBC. That’s understandable; the CNBC guys can be brutal in their grading! But for all practical purposes, their analysis is useless - especially for investors (it makes good mid-day entertainment though). The two key metrics, which they use for the scorecard– namely ‘sales growth’ and ‘profit growth’ offers a very shortsighted view and perhaps even a wrong one. The worst part is comparing the above metrics to analysts’ ‘target’ for the year. These are companies for god’s sake, not racehorses.

The first flaw with the CNBC view, something that my regular readers would have guessed by now, is that mere earnings (net profit) growth is not an indicator of stellar performance by a company. Even a totally dormant savings or fixed deposit account will produce steadily rising interest earnings each year because of compounding. The appropriate measure of managerial performance would be ‘return on capital’. The second flaw is the short-term approach, which severely penalizes even companies with a long track record of high return on capital, just because of one bad year (sometimes a bad quarter is sufficient). The combination of the two flaws results in share prices of good companies falling below their intrinsic value sometimes.

That’s great! I say. Let’s buy shares of great companies at cheap prices. Long live the stupidity and irrationality of herds (I find it hard to understand how economists actually assume that all humans are ‘rational’).

Nobody is going to let you buy shares of a ‘star’ company, right after its best innings, for cheap. Just wait for one bad year when the earnings or the growth falls below expectations (mostly for no fault of the company per se) and the same stock would virtually be available for a song.

What most people don’t understand is that good companies (i.e > 20% return on capital track record) have deep ‘moats’ to survive temporary slumps caused by external factors and can emerge back in shape. Buy their shares cheap, when there is a dip in performance and you can earn above average returns.

The Recipe

In my previous article, I discussed the ‘cheapness indicator’ for companies with high return on capital track record. Many readers asked for a step-by-step guide to use this formula, along with an example. So I have tried to provide a breakdown of the methodology along with an experiment to figure out if the stock of a leading paint company, ‘Kansai Nerolac’ (formerly ‘Goodlass Nerolac’), is worth acquiring.

• Step 1: Download company’s Annual reports for the last five years (usually available on the company website). Go to the ‘Consolidated’ Balance Sheet and Profit & Loss account (usually available in the section titled ‘Consolidated statements’ towards the end of the Annual report). A warning for those using third party sources such as Moneycontrol: the figures reported there are for ‘Standalone Company’ and hence not appropriate.

• Step 2: Calculate Return on capital for the company over last five years and take an average (Refer my article dated April 12, 2009 for the return-on-capital formula). Is the average greater than 20 per cent? If yes, proceed. For Kansai Nerolac, the average return on capital from financial year 2005 to 2009 is 23 per cent.

• Step 3: Calculate the company’s total capital at end of previous financial year (from consolidated balance sheet). Is debt capital divided by total capital less than 25%? If yes, proceed.

For Kansai Nerolac, the consolidated total capital of company, as on Mar ’08 (since balance sheet for financial year 2009 is not yet released) is 737.5 crores (Equity capital = 612.7 cr, Debt capital = 124.8 cr). Debt capital/Total capital = 17 per cent

• Step 4: Compute Total capital of company * (1+ average return on capital over previous 5-10 years)^5
For Kansai Nerolac, 737.5 *(1+ 23 per cent) ^5 = 737.5 * 2.8 = 2065 crores

• Step 5: Calculate the market capitalisation of the company (i.e share price multiplied by total number of shares). Don’t fail to add the value of unlisted preference shares if there are any (you can look this up from the Balance Sheet under Equity capital section)
For Kansai Nerolac, market capitalisation (based on Monday’s closing share price of Rs 468) is Rs 1261 crores and the company has no preference shares outstanding.

• Step 6: Compute Enterprise value = Market capitalisation + value of preference shares if any + Debt capital
For Kansai Nerolac, Enterprise value = 1261 cr + 124.8 cr = 1385.8 crores (significantly less than the five-year breakeven value of 2065 crores and hence fulfils our ‘cheapness indicator’)

The fact that the ‘Enterprise Value’ of Kansai Nerolac is at a 33 per cent discount to the benchmark on the right hand side of the ‘cheapness indicator’ formula gives us a comfortable ‘margin of safety’ to acquire the stock. Typically, companies with share prices that obey our formula are also cheap in terms of price to earnings ratio (P/E). For example, Kansai Nerolac has a P/E ratio of 12, extremely low and attractive.

The same company’s share price at its peak last year touched Rs 900, but now it is going for half the value. Why is the company trading so cheap? The only reason I can find is that they have reported a 20 per cent drop in profits. This is a clear example of the shortsightedness caused due to herd mentality of investors and analysts who are oblivious to the fact that Nerolac is a 80-year-old company and the second largest paint manufacturer in India with a 20 per cent + average return on capital over the last 15 years. If you dig a little deeper, you’ll notice that the company derives half its revenues from home paints and half from industrial and auto sector — unfortunately both sectors are experiencing a cyclical slowdown. But does it mean that the company will go bust in the next few years (reading from the share price) — something that has not happened over the last 80 odd years? Happy value hunting!



18 comments:

Manish Chauhan said...

My God !! hats off !!

So simply you have explained the formula for making money . You strength is simplicity . I am going to follow the process and find out some good stocks for myself and my readers on my blog .

Manish
http://www.jagoinvestor.com

mahesh said...

HI

Great sir, Now am able to understand, because you have provided an example, i wish, i will be in a position to calculate for many other companies soon.

Thanks for your good work and keep going....

Mahesh

Anonymous said...

Very good article. Thanks a lot for writing this.
One doubt though. While calculating "Enterprise value = Market capitalization + value of preference shares if any + Debt capital", how do we know of Debt capital, at that point of time?
May be the company have taken a huge loan, lately. Will that detail be available from company website?

Thank you,
Ravikumar

income.portfolio said...

Shyam,

Interesting approach to calculate value. determining Enterprise value is includes "market capitalization". I have a difference of opinion on any valuation measure that includes "market capitalization".

enterprise value as a function of market price has weak rationale. Market Pricing can be used as comparison metric to determine whether current pricing is high or low. But if is used to determine fair value, i believe it distorts the fair value calculation.

if we look at mid year 2008 pricing, valuation will come pretty high. Because both valuations, i.e. current and average, were higher in short term. It gets distorted by using only 5 year average.

valuations in 2008 very going above 30PE ratios. With this method, it indirectly justifies that higher valuation is acceptable because markets say so. It does not question the fact that market may be in bubble. paying 30PE is just nuts. any value investor will not like it.

my viewpoint is, any fair valuation should consider earnings per share (past and presents). Capability of an organization to generate earnings is what we are all after?

Shyam Pattabi said...

Manish, Mahesh - thanks. do let me know how it works.

Anonymous - good point and that is indeed a handicap. companies disclose their balance sheet only once a yr.

Income.portfolio - I dont think you have understood the methodology described. The 'fair value' guideline is on the right hand side of the equation (the 5 year breakeven formula)and uses return on capital (which by the way requires "earnings" for calculation). On the left hand side we have EV (enterprise value) and that includes market value to find out if the "market value" is less than "fair value" guideline. Essentially you are checking if EV is at significant discount to 'fair value' for a stock with atleast 20%-25% average ROC track record (which indicates 'good' stock at 'cheap' price), to make your purchase decision.

other clarifications:
1. nowhere have I said EV is "fair value" (in fact we are checking if EV is less than "fair value")

2. "earnings" IS being used , just not plainly as earnings but in the form of "return on capital"

P.S. If you do the workings you'll realize that companies that satisfy the equation must have low PE (meaning you don't overpay in a bubble situation) , so your hypothetical case of PE > 30 does not hold true.

Srikant said...

Hi Shyam,

Wonderful step by step approach to value investing! Thanks for that :-)..just on a critical note though- would you agree that we may lose out on growth stories (stocks)if we use this formula.was looking at Bharti Airtel- 5 years back it had ROCE of <1%. I would not have even looked it using the formula.Not to undermine what you have explained, Shyam- your article has truely been an eye opener.Thanks a ton!

Anonymous said...

Such a valuable Post ... Simple, lucid and easy to follow...

Pls..keep up your blog rolling with such a great posts Sir....

saravanan said...

Sir,

Your articles are very useful to me. I have few queries.

1. You mentioned that If we use Money control, it shows the reports of Stand alone companies. What do you mean by Stand alone companies?

2. I am not able to find Annual reports of companies for teh last 5 years. only 2006-07 & 2007-08 are availble. Even for Nerolac, it is not available for before 2006-07. How did you find the data from Nerolac ?

Pl. help me.

REgards,

Saravanan

KGR said...

I remember e-mailing you some time back, perhaps just after the 'Buffet Way' article, suggesting that the nuts and bolts of how to do it need to be explained. Is this series by any chnce a result of that? If so, 3 cheers for me, if not, no matter, it's a very informative series for neophytes like me and many others.

One Q, are there, or have u developed, spreadsheet programmes for doing such an evaluation? Would be very useful, dont u think, so if the answer is 'no' why not make that yr next big effort?
K.G. Rao - email:kgopalrao@rediffmail.com

ehealth said...

Hi Shyam
You back of the envelope actually proved true, Kanasi Nerolac was the top gainer at BSE today with a 20% change in one single day...WOW you are a Genius !

Shyam Pattabi said...

Srikant - i agree. but what can I say - i am a conservative investor and hate to undergo permanent loss of capital.

saravanan - by standalone i mean the income from subsidiaries don't get reported

you can get past annual reports from www.reportjunction.com

KGR - thanks. will try.

ehealth - congrats! but don't get used to such instant returns.

KGR said...

If you're gonna try (an xl sheet for co. evaluation), I take it it even you dont have a ready programme, and have to do it manually step by step. Strikes me a tedious and time-consuming exercise. Is there no aid at all to the process?

May I put a Q on the daily share mkt that I have never understood. There are His and Los which never get reflected in trades even if one's orders have been placed online the previous day. When one checks the intra-day graph, these Hi/lo levels do not figure. Evidently there are huge spikes at the start of the day (Hi or Lo), after which these Hi/Lo levels do play any part in the days trend. How do such unnatural Hi/Lo figures occur?

Just one more. The official close for the day is not the last traded price at 1530, but the fixed post-closing session price between 1550-1600. How is this set, and isn't this an artificial figure, not determined by market forces? If you agree, would it not distort all analyses?

KGR said...

This is quite a while after this column appeared, so I hope it'll come to yr notice.
You said it's better to get Bal.Sh and P&L stts from the company web-sites, as sites like moneycontrol give 'standalone' results. Could you confirm for us unitiated whether this is a reference to subsidiary cos held by the parent co under evaluation, such sub.co results being included in the stts on the co web-site but not on business sites such as MC or Way2Wealth. If not so, what exactly is meant by standalone?
KGR - kgopalrao@rediffmail.com

Vistahunt said...

Shyam,

Very good article. But is it possible to apply this method to Banks?

How to find Enterprise value of a Bank-
EV ( Bank) = Market cap + borrowings

whether th above equation will work? Please reply. You can mail me at vistahunt@gmail.com

Shyam Pattabi said...

Vistahunt - I need to modify this formula for banks & financial services firms (because these are unique organisations with extraordinary leverage) ...give me sometime and will post an update on this.

Frances Anne said...

Sir,

Were you able to get the formula in computing a bank's enterprise value? Could you have it posted on your blog? Thank you.

Suresh AR said...

Hi Shyam,
It would be great if you can give your ideas on financial planning for us. I have been regularly following Dhirendra kumar of valueresearchonline.com and his ideas on long term investing which is one of passive SIP investing in MFs.
i have a question regarding valuing a particular stock. as of today, Satyam has a market cap of Rs. 8000 crores and has equity capital/reserves of Rs.7300. although it is obviously a bargain, is it right to look at these numbers after the merger with Tech Mahindra. you always insisted on not looking at stand-alone companies while calculating RoC.
Can we ever trust the balance sheet coming from Satyam?

Anonymous said...

Shyam, thanks for explaning this so clearly.

Now, how to i trigger a "SELL" based on this? for instance as of now EV for Kansai is much more than the breakeven value. So do we sell it?

Can you please explain the "SELL" criteria based on this logic

Thanks
Sam