1000+ companies rated as per ROE


(Excel Monkey) #1

list of 1000+ companies ranked as per ROE
the ROE has been calculated on based onconsolidated financials
some stocks might be missing

https://spreadsheets.google.com/ccc?key=0Ar55s_sCPoredGYzcVE2YjgyLVV6STZibzFuOUtqRXc&hl=en&authkey=CN7hnpkG


(Siddharth Shukla) #2

Thanks Satnam, thats a useful sheet but a dangerous one ,if one looks at ROE. I would rather look at ROCE, which is a much better ratio to compare across industries. This data can be used to come up with something like a Magic Formula List of cheap stocks.


(Excel Monkey) #3

I prepared this sheet for the exactly the same reason

for geniuses like you to come up with good picks


(Rudra Goud) #4

onconsolidated financials

Link: https://spreadsheets.google.com/ccc?key=0Ar55s_sCPoredGYzcVE2YjgyLVV6STZibzFuOUtqRXc&hl=en&authkey=CN7hnpkG https://spreadsheets.google.com/ccc?key=0Ar55s_sCPoredGYzcVE2YjgyLVV6STZibzFuOUtqRXc&hl=en&authkey=CN7hnpkG Link: https://spreadsheets.google.com/ccc?key=0Ar55s_sCPoredGYzcVE2YjgyLVV6STZibzFuOUtqRXc&hl=en&authkey=CN7hnpkG

Thanks. Pls post updated one.


(Subash Nayak) #5

One thing I learned is that just one year ROE, ROCE or ROIC number doesn’t give much info. One need to look for last 3-4 years of consistent 20+ ROCE number. This new number can be used as one of the parameter to gauge managerial effectiveness. You can modify this 3-4 year number to last 2 year, future 2 year, if you are sure you can predict it well.

Such 3-4 year 20+ ROCE companies, when available at a bargain PEG ratio, and low DE ratio, zero/negligible promoter pledging, high promoter holding are a dream company for small investor. Mayur Uniquoter was at such place last 1 year back.

Last 1 year experience tells me that they can create huge wealth if you can choose 10-15 such stocks and seat patiently for 1-2 years. Sooner or later the EPS or Dividend increases making their PE too less, or dividend yield mouth-watering resulting in increase in stock price. You get a bonus if a PE rerating happens to them.

Note: Having last 3-4 year ROCE average/standard deviation, (plus some estra constraint as described above) will reduce the stock count, thereby increasing your research effort per stock.