How can I classify stocks using excel tools?
It is a great deal easier if you were to use a screening tools such that Yahoo provides. You can find it here.
http://screener.finance.yahoo.com/newscreener.html
Use the first one, not the second.
Now you need to decide which parameters to use to identify a blue chip stock.
There might be some argument as to which define a blue chip or even exactly what a blue chip entails.
Here are mine:
Debt to equity of less than 1/2.
return on assets of 10%
dividend of greater than 2.5%. There could be a great deal of argument about this parameter.
market capitalization of greater than 10 billion. Now there are plenty of stocks that meet the above criteria that do not have the market capitalization. But a company with this cap, most likely is of blue chip quality. In other words it did not get to that size by accident.
Now you can adjust these parameters yourself to suit your own preferences as to what you consider a blue chip company. There really is no hard and fast rule.
But using Yahoo stock screener, with these paramenters you arrive at a total of 30 companies. Using Morningstar stock screener with exactly the same parameter you arrive at a total of 8 companies and not entirely the same. Fidelity’s stock screener yields 22 companies.
Here are some:
MO, INTC, COP, ABB, PAYX, TLK