Active TopicsActive Topics  Display List of Forum MembersMemberlist  CalendarCalendar  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin

Fundamental
 The Equity Desk Forum :Market Strategies :Fundamental
Message Icon Topic: Which Stock to Buy? A Quantitative Analysis Post Reply Post New Topic
<< Prev Page  of 19 Next >>
Author Message
wild dog
Newbie
Newbie


Joined: 19/Jan/2010
Online Status: Offline
Posts: 28
Quote wild dog Replybullet Posted: 16/Aug/2010 at 12:32pm
 Great work smart cat, great analysis and an must read for all those interested in investment in stocks.

Thanks a lot for sharing your views

IP IP Logged
Gnair
Newbie
Newbie


Joined: 14/Mar/2009
Online Status: Offline
Posts: 14
Quote Gnair Replybullet Posted: 16/Aug/2010 at 12:35pm
great work smart cat...!!! great insights and methodology...!
IP IP Logged
brijwanth
Senior Member
Senior Member
Avatar

Joined: 13/Oct/2008
Location: India
Online Status: Offline
Posts: 143
Quote brijwanth Replybullet Posted: 16/Aug/2010 at 12:37pm
This is simply superb work by smartcat ji

Market cap and scalability are difficult ones to analyse for each company so i think Market cap can be removed from analysis. Market cap is not controllable factor and is beyond the hands of the company. but anyways this ones the bestThumbs%20UpClap
Past will not be repeated in future but peaks and troughs do revert to mean, period and order of those peaks, troughs and mean days is the one i.e. not predictable- riser3 valuations
IP IP Logged
vijayM
Senior Member
Senior Member
Avatar

Joined: 21/Dec/2007
Location: India
Online Status: Offline
Posts: 649
Quote vijayM Replybullet Posted: 16/Aug/2010 at 12:43pm

Smartcat ji,

Excellent work.Clap

I have one point. All parameters are given equal weightage in the analysis. We have to find if we can give higher weightage to some parameters. For Ex: titan is the best performing stock but not in top 5 needs to be looked at.
 
regards
vijayM
If a business does well, the stock eventually follows:Warren Buffett
IP IP Logged
kulman
Senior Member
Senior Member
Avatar

Joined: 02/Sep/2006
Location: India
Online Status: Offline
Posts: 9319
Quote kulman Replybullet Posted: 16/Aug/2010 at 1:17pm
Originally posted by smartcat

Jahapanah Basant Maharaj has created TheEquityDesk XI


वाह बिरबल वाह !


IP IP Logged
smartcat
Senior Member
Senior Member
Avatar

Joined: 29/Mar/2007
Location: India
Online Status: Offline
Posts: 4243
Quote smartcat Replybullet Posted: 16/Aug/2010 at 1:27pm
Thanks all. Will respond to your suggestions/comments later.
 
ROUND NO. 9 - P/BV RATIO
 
A value investor's favorite - might not be a useful ratio for all portfolios. If a stock trades at a P/BV of 1 or less, it means that you can recover the share price value by just selling the assets. P/BV is also used to value financial stocks.
 
The biggest flaw in P/BV metric is that "book value" does not include the value of a brand (For eg: Prestige, Sony, Maruti). So you will notice that branded companies will trade at a higher P/BV ratio than other manufacturing/asset owning companies.
 
I would consider P/BV as an optional metric to be used based on the type of stocks in the shortlist/portfolio.
 
Company Name P/BV Ratio Points Earned
Voltamp Transformers 2.75 11
Yes Bank 3.53 10
HDFC Bank 4.46 9
HDFC 5.73 8
Voltas 6.89 7
Blue Star  7.49 6
Thermax 8.45 5
Hawkins Cookers  10.92 4
Page Industries  12.3 3
Titan Industries  15.44 2
Zydus Wellness  18.62 1
 
 
ROUND NO. 10 - DEBT/EQUITY RATIO
 
This is where I admit that the methodology is not 100% logical - I might need some help here finetuning the methodology. Debt/Equity ratio shows how leveraged a company is. If you find a company with little or no debt growing at a good pace, you have almost got yourself a long term winner.
 
However, looking at the debt/equity ratio of banks/financials don't make much sense (because it will be high). But I'm still including this metric in our analysis because at the end of the day, we are looking at how sensitive a company/stock is to interest rate movements. Banks/financials by nature of their business are highly interest rate sensitive, so they deserve to be at the bottom of the pile.
 
Is that logical?
 
Company Name Debt/Equity Ratio Points Earned
Thermax 0 11
Voltamp Transformers 0 11
Zydus Wellness  0 11
Blue Star  0.01 8
Voltas 0.01 8
Titan Industries  0.1 6
Hawkins Cookers  0.31 5
Page Industries  0.55 4
HDFC 6.35 3
HDFC Bank 7.78 2
Yes Bank 8.67 1
 
 
Tallying the final scores -
 
Company Name RoE (Pts) P/E (Pts) Market Cap (Pts) Sales Growth (Pts) Profit Growth (Pts) Div Yield (Pts) DPS Growth (Pts) Div Payout Ratio (Pts) P/BV Ratio (Pts) DE Ratio (Pts) Total Points
Hawkins Cookers  11 10 11 2 10 11 9 10 4 5 83
Voltamp Transformers 5 11 10 1 6 8 11 2 11 11 76
Blue Star  9 8 7 4 7 10 7 7 6 8 73
Page Industries  8 6 9 8 3 9 10 11 3 4 71
Zydus Wellness  10 3 8 10 11 4 5 5 1 11 68
Voltas 7 9 6 5 8 6 6 4 7 8 66
HDFC 4 5 2 6 2 7 3 8 8 3 48
Yes Bank 3 7 4 11 9 1 1 1 10 1 48
Titan Industries  6 2 3 7 4 3 8 6 2 6 47
Thermax 1 1 5 3 1 5 2 9 5 11 43
HDFC Bank 2 4 1 9 5 2 4 3 9 2 41
 
 
The ranking of stocks to buy in the TED XI at current market prices based on low P/E, P/BV, debt/equity ratio, marketcap and high RoE, sales/profit/dividend growth, div payout ratio & div yield goes something like this -
 
Company Name Ranking
Hawkins Cookers  1
Voltamp Transformers 2
Blue Star  3
Page Industries  4
Zydus Wellness  5
Voltas 6
HDFC 7
Yes Bank 7
Titan Industries  9
Thermax 10
HDFC Bank 11
 
 
COMMENTS:
 
- This data needs to be updated every 3 months atleast. Because prices change and financials keep changing.
 
- Low base effect of certain stocks like Voltamp will be removed in next financial year when we take the last 4 year data.
 
 - TED XI stocks are just an example. This is an attempt to justify buying a set of stocks from ANY shortlist.
 
- I intend to use this methodology to SELL stocks in my portfolio (get rid of the stocks in the bottom), rather than buy new stocks. The title of the thread can be changed to "Which Stock to Buy or Sell? A Quantitative Analysis" perhaps!


Edited by smartcat - 16/Aug/2010 at 1:32pm
IP IP Logged
smartcat
Senior Member
Senior Member
Avatar

Joined: 29/Mar/2007
Location: India
Online Status: Offline
Posts: 4243
Quote smartcat Replybullet Posted: 16/Aug/2010 at 1:49pm
So Hawkins scores high on all parameters. I would like to add one more qualitative strong factor which seems to be missing in all others in TED XI.
 
Manish_Okhade, I suspect you will be quite pleased to know that eClerx will almost match the score of Hawkins if it were to be in TED XI. eClerx performs well in 9 out 10 parameters.
 
Joel Greenblat does same thing but only based on his magical formulae of 2 parameters. a) RoCE and b) Earnings Yield.
 
Oh yeah, he copied from me. He keeps giving missed call to my mobile all the time. Geek
 
I was thinking if we could run this system as if we are in 2006-2007 and see how well the stocks that come up triumphs using the system have done in reality.I could do that once smartcat finishes his exercise.
 
Go ahead. Data is available on Moneycontrol & Rediff Money.
 
Smartcatji what is your opinion on using EV/EBIDTA as a replacement for PE ratio?
 
EV/EBIDTA is mostly used for loss making companies right? I keep hearing from EV/EBIDTA for companies like GMR from research reports. Anyway, EV/EBIDTA number for each stock is not easily available from financial websites.

 
Regarding market cap, please exercise caution especially for Hawkins which is operating in matured market and also market size it self can't be compared with other business.
 
The points weightage for Mcap IMO has to be revisisted , as an example at what Mcap would you say HAWKINS is high or low ..if the cookware industry size itself is 1000 crs and hawkins in 500 crs ..i wouldnt say its low mcap...on the other hand if cookware industry size is 10000 crs then hawkins has still a long way ahead. Same applies to almost all companies.
 
Let's say cookware industry is worth Rs. 1000 cr and Hawkins' MCap is Rs. 500 cr. Then obviously, Hawkins will not be able to grow its topline and bottomline much in the next financial year. And when we start ranking the stocks next year, it will show up with as a cascading effect on DPS growth. The company might then expand into other segments by taking on debt. This will again show up in debt/equity ratio, dividend payout ratio, RoE etc.
 
So eventually, since we are considering 10 different parameters and updating the stats every 3 months, the "marketsize/marketcap" issue will be automatically sorted out by the ranking system.
 
But it's difficult to "predict" scalability of business and I think smartcat doesn't want to go into prediction and hence MCAP is taken for simplicity.
 
Right. Scalability/marketsize cannot be determined for each stock listed in the stockexchange. Remember that we are not trying to analyze TED XI stocks - we are trying to rank any set of stocks in a shortlist or a portfolio.
 

 


Edited by smartcat - 16/Aug/2010 at 1:51pm
IP IP Logged
tigershark
Senior Member
Senior Member
Avatar

Joined: 13/Oct/2006
Location: India
Online Status: Offline
Posts: 3542
Quote tigershark Replybullet Posted: 16/Aug/2010 at 2:07pm
i would request smartcat to add another column titled management quality and integrity based on past descion making.this would complete a really fantastic analysis, because of which you have been blessed by a son.
understanding both the power of compound return and the difficulty getting it is the heart and soul of understanding a lot of things
IP IP Logged
<< Prev Page  of 19 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.
Bookmark this Page