Happy New Year all…
I recently came across the tweets, memes etc., on 10 year challenge…
Just thought how would it be to see the market cap of companies 10 years back and now
So decided to run some queries to find out companies whose market cap has grown 10 times in 10 years
Market Capitalization >= 10*Market Capitalization 10years back
Result was 551 companies !!!
Then, I tweaked the query to add more performance parameters using the following simple query:
Market Capitalization >= 10*Market Capitalization 10years back AND
Market Capitalization > 500 AND
Sales > 100 AND
Net profit > 0 AND
Free cash flow last year > 0 AND
Debt = 0
Result was 34 companies !!!
Then, got intrigued and wanted to find out if there are companies that made 50, 100, 500 and 1000 times increase in Market cap 10 years.
Yes!!! there are. Try out… its interesting…
Then, why only companies that increased market cap by 10 times…
I am sure there must be companies whose market cap eroded by 10 times in 10 years.
So, tried this…
Market Capitalization 10years back >= 10*Market Capitalization
69 companies made the list !!!
Ok, now you would have got what I would have done next… 🙂
Yes, try changing the above number to 50, 100, etc., to find out companies whose market cap eroded by ‘n’ number of times in 10 years
Thanks to http://www.screener.in which made me write this post in less than 10 mins