A tool for Fundamental Analysis

Hi

I have attached a fundamental anlyais tool and have compleated a sample analysis for ABB. Hope you will find the tool intresting and useful

Please help in validating the results for one and all


regards
Suresh

Attached Files

finding stocks the warren buffett way ABB.xls (65.5 KB, 1370 views)

This one is a classic case

Some one recommended Castrol India to me and I put it through the same test the results are very clear and obvious. it clearly brings out the company as a stagnant and there is absolutely no growth that had happened with this company in the last 7-8 years. I could not find any reason for any growth in the company

The stock seems to be active and have gone from 220 to 280 in a month i could not find any reason for it except that I saw a add for the Castrol in association with the movie "tara rum pum" or is there something truly happening with this company??


Note : I have used this tool on many companies and it gives a justification for the current market price, as for the 10 year projection of the model ……..

Attached Files

Castrol India.xls (24.5 KB, 501 views)

good work man.

No doubt the tool in itself is gr8 but i hav difficulty in using the tool frm where 2 get the data to be filled for last 8 yr, i tried a lot but not able to get the last 8 yr data pls hlp me...............

I use both http://economictimes.***************/ which gives 10 yr data to calculate the historical EPS and Book value data and ********* to for the 5 year high lows.

Please be aware that the stocks which have had stock splits and/or issued bonus shares will need data correction

regards

Merck ltd

The stock showed up as promising while using a filter to identify companies with more then 5 % dividend yield

The analysis with the bajkowski excel gave a surprisingly strong projection of 25.1 % based on historical growth and 24.5 % growth prospect on sustainable growth rate prompting further interest.

A check on the company website http://www.merck.co.in/investor/index.html reveled this
“Sales fell by 31% to Rs.704 million. The profit before taxes fell by 26% to Rs. 229 million. Earnings after taxes fell by 14% to Rs.159 million. Sales & Profit fell due to sale of Life Science and Analytics (excluding Bulk Drug) Business in the year 2006. An amount of Rs.22.1 million was added to the fixed assets during Jan-Mar 2007. The company has investments in Bank Deposits and Liquid funds of Rs.3,054 million.”

A news article of interest

Merck, the Indian subsidiary of the German pharma major Merck KgaA, is all set to ‘sell off’ its life science and analytics businesses to its wholly-owned subsidiary in India, Merck Specialties. The transfer, it is learnt, will take away a substantial part of the business from the listed company of Merck in India. http://economictimes.***************/...ow/1359150.cms

The start of a 100% subsidy Merck Specialties in India seems to be dampen the prospects of the Merck ltd in which the parent company has a 51 % share

Further searched in internet also revealed that they are the only manufacturer of vitamin E in India you may also check the reports about the company by way2wealth.com

For future valuation of Merck we have to take in to consideration the sale of the LS&A unit the revised valuations with 30% lesser sales and 26 % drop in profit a rough calculation gives 33.3 EPS for the year and at the market price of 410 its trading at 12 times which is at the lower end of the companies historical PE.

A industry comparison shows that Merck is valued attractively to others

With the large cash poison the company is in the lookout for acquisition which can provide a trigger in the medium term. The cash position of Rs180 per share will also cushion the downside.

The annual report says that substantial portion of the vitamin E raw material is imported and if the treading is in $ the recent developments can help in bringing down the cost

Risk factors
Cheap imports of vitamin E from China
Diminishing Support form parent company
Failure of new products launches

regards

Note: this is the first time I have identified a company based on my own criteria’s. Please don’t take it as an recommendation but would like to have your comments to know if I m in the right direction

Attached Files

Merck Ltd.xls (24.5 KB, 142 views)

http://www.way2wealth.com/pdf/29184.pdf

way to wealth report on merck ltd

from where can i get old data of companies ...
hi suresh, i browsed http://economictimes.***************/ but was unable to locate ...
i founded tool very useful... would plz anybody tell me how to get old data of companies
thanks in advance

Follow the link

http://economictimes.***************/...nge=b&ticker=a

or from the home page click ""stocks"" in the market section and then click on ""share prices"" you will get alphabetical list of companies, you can browse or search for a company data

I hav got the historical data but how to calc the bvps eps, pls guide me