Sunday, December 27, 2009

India Stock Screeners: Tools to screen Indian Stocks listed on NSE and BSE

There are several ways to learn about new companies and sectors to invest your hard money in. I am being a dumb investor (yes, still I am even after a couple of years in the market!!) dependent so far on business news websites like moneycontrol.com, business-standard.com. Usually, I come across an interesting story, like millions of other readers, and then start to dig a little into sector and/or companies mentioned.

But, I learnt that this top-down approach is not the most effective way since the news papers, sites, analysts and brokerage firms can and will cover only a small percentage of the companies listed on NSE/BSE and you miss out on the bigger percentage where some of the best opportunities lie hidden. And you basically just follow the crowd since everyone have the same information as you!

So, the obvious (which was not so obvious till a week ago) question was "is there a better way?."

And the answer is yes, that’s what I got while reading a book yesterday and it’s called stock screening. Stock screening, simply put, is the process of filtering/identifying companies, from thousands across sectors and industries, based on parameters that meets an individual's risk, expected returns, and even taste. One example could be searching for companies with a dividend yield of 4% or more. Of course, this will only help you cut down the number of companies to look at from 1000s to, possibly, few 10s but then one needs to analyze each company further to better understand its business, past and future(expected) performance before making a decision of whether to invest in it or not.

Since we are lucky to be living in an internet age this screening process is not as daunting as it could sound like. There are several tools, limited for Indian stocks but numerous for US listed ones, that help with this and some of the good ones are really free! The following is the list of some sites and tools that provide free tools to screen NSE and BSE listed stocks.

IDBI Paisabuilder
http://www.idbipaisabuilder.in/Market_Content/CMcorpinfo.aspx

I had used this site in the past and I really like it. It provides a decent number of parameters, more than equity master which comes next in the list, to filter stocks on and the research section of the site also includes various other useful tools that can be really useful. The following screenshots shows the search form and the results for a search on stocks in NSE 500 that have a dividend yield of more than 3%

Search form:


Search results:


EquityMaster

http://www.equitymaster.com/research-it/company-info/search/internal.asp

This has a decent stock screener; the following screenshot shows the results I got for companies having a dividend yield between 3% and 4%.

There are few bugs with this tool though, the year criterion in the search form is only till 2007 but the search still does give results for 2009 and 2008 so I am not sure (have not compared against other tools) if the results are accurate and reflect latest information.It also has other useful tools like sector info,recent quarterly performance of some of the companies (I liked this one, see screenshot below)

ICICI Direct Research

http://content.icicidirect.com/research/customsearch.asp

ICICI Direct also provides a screener but the search form is limiting in the parameters e.g. I could only search large cap stocks, and not all, with dividend yield greater than 3%

BSE

http://www.bseindia.com/stockscanner/stockscanner.aspx

BSE website also find a stock screener but again the form is limited to four criteria (see screenshot below)

Buzzing Stocks

http://www.buzzingstocks.com/in/search.pl

This one is different in the sense that it lets you screen stocks based on technical parameters. The search form takes criterion in plain english and it also comes with a pre-defined list that users can use. I plan to use if I buy anything for trading purpose. The following screen shot shows list of stocks that have had serious buying interest and which could go up higher.



There could be other tools and I plan to update this post as and when I come across them.

RK.

Other posts that could be of interest:

Warren buffets low diversification good for average investors?

Think before investing in india's ETFs

Stock picks top 20 indian stocks to own

Financial bubbles of next decade

Little book that beats the market

Wednesday, December 16, 2009

Financial Bubbles of the next decade!!

Think you seen the end of bubbles?? Forbes does not think so, they have an article on forbes.com titled "Seven Looming Financial Bubbles" that lists the sectors/countries and areas which can go bust in the next decade. Here is the list and the reasons why they think so

Gold
Gold is up 300% over the last decade, in part because investors see it as a store of wealth during times of trouble and inflation. Look beyond the hype and you may see an asset with its best gains behind it. As an asset that generates no actual income, gold's price is purely a function of what others are willing to pay for it.

China
China has positioned itself as the factory for the world, pushing out everything from drywall to toys. It's growing in large part due to easy money. Its government is already on the hook for debt equal to over 70% of gross domestic product. By keeping its own currency artificially low, China has also pushed its citizens to invest at home, artificially inflating property and stock prices.

Emerging Markets
Investing in emerging markets was hugely profitable in 2009 as confidence in the U.S. waned. An ETF that tracks the Brazilian market has gained nearly 125% this year, but overall economic growth in Brazil has fallen short of forecasts. The main Russia ETF has gained more than 135% in 2009, even as the country's GDP shrank. Now is probably not a good time to be hopping on the notoriously volatile emerging-markets bandwagon.

Treasuries
Warren Buffett and Chinese Premier Wen Jiabao were among those who lamented the Treasury bubble in 2009 as the U.S. borrowed to fund its record budget deficit. Signs the bubble is at or near the bursting point: rates on short-term bills that have fallen to negative levels after inflation--meaning investors are paying the government to hold onto their money--and a growing national debt.

College Tuition
Over the last 20 years, college tuition has risen at double the rate of inflation. There are now more than 60 colleges charging over $50,000 a year, and the average student now leaves school with $20,000 in education loans. With financially strapped parents reluctant to foot the bills, colleges may soon be forced to cut amenities--like gourmet dining hall food--introduced in boom times. And some ivy-covered doors are likely to close for good.

Exchange-Traded Funds
These index- and sector-tracking products were designed to provide investors the breadth of mutual funds on the cheap. They were a big hit in the wake of the last recession, jumping in number from 152 ETFs in 2004 to nearly 760 today. But this once pristine area is on the verge of being overrun by opportunists. Some investment companies have been hawking ETFs with expense ratios more than four times higher than those of their rivals. It won't be long before ETFs join the ranks of the dubious financial products they were supposed to replace.

Copper
Spot prices for copper spiked during the mid-decade housing boom, shooting from about $1,500 a pound in 2004 to nearly $4,000 a pound in 2007. Copper plummeted in 2008 to below $2,000, but prices are once again approaching boom-time levels. Some of the demand is coming from China. Another source is ETFs that let average investors buy commodities contracts that were once restricted to institutions, resulting in an oversubscribed investing idea.

RK

Friday, December 11, 2009

Rakesh jhunjhunwala trims infoMedia 18 limited holding

In case you are a follower of Rakesh jhunjhunwala then this news might be of interest to you. As per communication to stock exchanges he, his wife Mrs Rekha Jhunjhunwala and brother Mr. Rajeshkumar Jhunjhunwala have
sold 4,45,389 number of shares on December 09, 2009 and 2,22,366 numbers of shares on December 10, 2009. They still have about 4.2% in this company. So it will be interesting to see if they will hold on or sell it off.

update: Rakesh jhunjhunwala continues to dilute his holding in infomedia 18, there were transactions on Dec 11th again.

Info

Saturday, November 14, 2009

Indian telecom companies - invest or stay away?

Indian telecom companies have been taking a pounding recently and the reasons are well known. I am in sync with those analysts and individuals who think this negativity is only a short term one and this is the right time to invest to make money 2 years down the line. This is a test to the big players and if these companies are worth their salt then they will emerge out stronger. My strategy will put in some money regularly for next few months into airtel and rcom.

There was an interesting analysis in the business line today. I'm copying it verbatim here
----------------/--------------------/-----------
Indian telecom companies have suddenly gone from being the institutional investors’ blue-eyed boys to last on the shopping list. Stocks such as Bharti Airtel are languishing close to their 52-week low even as the market is close to its yearly highs.

Telecom stocks now trade at 10-15 times forward earnings, compared to 20-25 times till end-September, and are at a substantial discount to the broader market. Fears of new players winning market share away from the entrenched players, sliding revenues and the spectre of “per second’ billing have all had a hand in battering telecom stock valuations.

However, how much of this de-rating of the likes of Bharti Airtel, Idea Cellular and Reliance Communications (RCom) is justified? Some correction in valuation may be called for, given that popular metrics such as ARPUs, subscriber additions and usage minutes have come down, hinting at lower growth for players. But the situation may not turn out as dire as markets now expect.

First, with all operators joining the per-second billing race, the loss of subscribers to new players may be temporary. Second, this offering itself may be short-lived because of its adverse impact on profitability, unless operators resign themselves to making losses on all short-duration calls.

Third, for players such as RCom and Bharti, non-cellular businesses have been contributing significantly to overall revenues and at robust margins, providing a cushion against competitive pressures in mobile services.

With Idea Cellular, entry into lucrative new circles as it becomes a pan-India GSM player offers scope for growth. This is evident from the fact that with these launches, Idea has also increased its subscriber addition run-rate in the month of October. Here’s an analysis of the concerns and the reasons why larger players may survive this phase.

Tariff war and its longevity
The new regime of per-second billing, recently launched by Tata DoCoMo (GSM arm of Tata Teleservices), has set the cat among the pigeons in the telecom space. In the few months since this billing was introduced, Tata DoCoMo became the largest incremental market-share gainer with four million subscribers added in September.

RCom joined the battle soon, offering Rs 0.5 per minute for all calls, local and STD. This led to fears of slowing subscriber growth for other top players. This assessment, though justified in the short term, may not, however, hold good in the long run.

First, with all operators now joining the ‘per-second’ bandwagon, the market share drift to one or two operators may be limited sooner than later. Witness to this is the fact that, after a lull in September, all the frontline operators have seen rapid improvement in subscriber additions for October. Overall GSM additions (excluding Tata DoCoMo and RCom) in October are up 14.2 per cent relative to September to over 10 million.

Second, the economics of the per-second itself suggests that it may not last too long.

Players such as Bharti, RCom, Idea and Vodafone derive about 50-56 paisa per minute as revenue per subscriber. The cost of providing a mobile call for Bharti works out to approximately 40-42 paisa per minute, and may be similar or marginally higher for other players.

For regional players (though many have pan-India licences), the cost of providing this service may be higher as they do not have the scale and nationwide connectivity and may have to rely on pan-India players for NLD and roaming services.

The termination charge an operator pays for a call made by its subscriber to another operator’s is about 20 paisa per minute.

This suggests that only a subscriber who speaks for at least 40 seconds would ensure break-even! For example, a person who has spoken for exactly 60 seconds would ensure realisations are above current levels for operators, while another who speaks for 20 seconds would entail a stiff loss.

The calls made between different operators (local and NLD) account for 44 per cent of the total calls, according to data released by the telecom regulator. Unless, termination charge is shifted to a per-second basis, and cost of providing calls is drastically reduced (which is impossible for a new operator), this pricing cannot continue indefinitely.

‘Failing’ in metrics
The tariff wars apart, the September quarter earnings numbers of telecom majors too were a reason for their de-rating after they came in below market expectations.

For Bharti, Idea, RCom, Vodafone and TTML, ARPU (average revenues per user) fell 7-20 per cent sequentially and about 20-25 per cent from year-ago levels. Subscriber additions for Bharti and Idea fell below their quarterly run-rates.

But how much should an investor be worried about this?

Two factors need to be kept in mind. One, revenue growth for telecom operators has not hinged on subscriber growth in recent years. Two, companies have improved margins substantially amid a slower pace of revenue growth. Revenue growth has substantially lagged subscriber growth from 2005. Between 2005 and 2008, while the annual growth in subscribers was 61-74.8 per cent for the top operators’ revenues grew by only 27.7-50.9 per cent. Though ARPUs have fallen 34-45 per cent in absolute terms over these years, all operators actually expanded their margins!

Even with the fall in tariffs, the number of minutes used by subscribers has been falling steadily over the last 4-5 quarters. The usage minutes fell 11-14 per cent, but rate per minute declined 9-10 per cent.

Though monthly subscriber additions have gone up from 5 million to over 10 million the last 3-4 years, thanks to a series of tariff cuts, innovative schemes and, finally, the disruptive ‘lifetime recharge’, this hasn’t resulted in proportionate revenue growth. This suggests that the incremental subscribers, especially from the rural areas, were not revenue accretive at all.

Subscriber additions, ARPU and minutes of usage may serve as an accurate gauge when there is a connect between subscriber adds and revenue growth. That is no longer the case, and underperformance on this count should not be the cause to de-rate stocks.

Second, there is the problem of multiple SIM cards that subscribers tend to use. So, depending on the use, and affordable tariff plans, a subscriber may use the services of multiple operators. So, subscribers would show up in different operators’ networks at different points in time, creating significant duplication. Bharti estimates such subscribers to be as much as 30 per cent of the subscriber base, while Idea pegs the number at 20 per cent.

Other businesses of telcos
Though there have been tariff cuts over the years, Bharti, RCom and Idea have EBITDA margins of 27-40 per cent. This suggests that players ensure a sufficient margin of safety before they sacrifice profits to tariff wars.

Majors such as Bharti and RCom also generate a substantial portion of their revenues from a host of non-mobile services. These revenues also sport EBITDA margins over 40 per cent for these companies, which are well-placed to take advantage of potential, both in India and overseas.

RCom derives over 30 per cent of its revenues from its global, broadband and enterprise data business, while for Bharti, this forms just over 20 per cent of revenues. Since Bharti, RCom and BSNL are the only players with a pan-India fibre-optic network, they provide NLD connectivity to a lot of incumbent players as well as new operators. This apart, Bharti and RCom are among the top players in the enterprise data connectivity market in India, estimated to be Rs 7,400 crore currently and set to go up to over Rs 13,000 crore by 2013, according to a Frost & Sullivan report.

Reliance Infratel, the tower infrastructure arm of RCom, also has been successful in increasing tenancy for its towers. It has signed several deals in recent times, prominent among them being a Rs 10,000-crore outsourcing contract with Etisalat DB.

Both these companies also have over a million DTH subscribers, suggesting another sustainable revenue stream.

With tailor-made packages, capability to deliver both free and pay channels, and ability to drive value-added services, DTH ARPU (average revenue per user), which is in the Rs 150-160 range, could grow over the next few years. A recent PwC report states that DTH households are likely to increase to 35 million(from 16 million currently) by 2013.

Idea, which acquired Spice Communications and also new licences over the last 18 months has become a pan-India player. It is in growth mode and is being fully funded for all its expansions, through infusion from Axiata and Providence.

Most of the new circles that the company has launched operations in are metros such as Mumbai, Chennai and Kolkata, apart from other profitable States. Being a partner in Indus Towers means it has been able to get operations up and running in new circles quicker than many new entrants.

Clearly, all these three players have substantial potential. Investors need to look beyond the immediate price wars and view the industry from a 2-3 year horizon. They may accumulate all the three stocks, especially Bharti Airtel.

----------------/--------------------/-----------

Rk