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
smartcat
Senior Member
Senior Member
Avatar

Joined: 29/Mar/2007
Location: India
Online Status: Offline
Posts: 4243
Quote smartcat Replybullet Posted: 15/Aug/2010 at 9:46pm
Hey, just kidding about the climax and the twist ending. Even I do not how the list/ranking will finally end up. Right now, I'm collecting the data for the stocks.
 
Data Sources:
 
Rediff Money
MoneyControl.com
 
Instead of using ROE and payout in isolation use ROE(1 - payout ratio)
 
RoE x (1 - dividend payout ratio)? What do we get from that?
 
You can use the one year forward EPS and forward PE to eliminate total reliance on historical data
 
Trailing P/E is a fact. Forward P/E is mostly fiction Geek. I intend to keep this a mathematical analysis which a software should be able to do.
 
Also, forward P/E's are not available from research reports for stocks like Thangamayil Jewellery, Sumedha Fiscal & Jenburkt Pharma - those are names of stocks I own!
 
You could also add the management pedigree to this,although wouldn't make much difference to the TED XI rankings. 
 
Unfortunately, one cannot quantify management pedigree in numbers. How about ranking promoters based on the number of times they got into trouble with SEBI/Law?
IP IP Logged
bihisello
Senior Member
Senior Member


Joined: 28/Apr/2010
Online Status: Offline
Posts: 557
Quote bihisello Replybullet Posted: 15/Aug/2010 at 10:27pm
Originally posted by smartcat

....
Trailing P/E is a fact. Forward P/E is mostly fiction Geek...
...


Wah! Wah!
IP IP Logged
hit2710
Senior Member
Senior Member
Avatar

Joined: 15/Jun/2009
Location: India
Online Status: Offline
Posts: 4013
Quote hit2710 Replybullet Posted: 15/Aug/2010 at 12:41pm
Thanks smartcat for coming out with some good data based investment model.

The flaw as I see in some of the rounds I see are esp in sales and profits cagr, companies with low base will outscore those with consistent profits.(this is just an observation and takes nothing away from a wonderful effort)

But at a first glance, Hawkins and Zydus appear winners, even without going into too much details.

The kitten seems to be providing you with sleepless nights with nothing to do but devise investment models. Positive change of fatherhood.
Stockmarket is a weird place. For every person who buys a stock there is a person who sells it and both think they are very smart.
IP IP Logged
smartcat
Senior Member
Senior Member
Avatar

Joined: 29/Mar/2007
Location: India
Online Status: Offline
Posts: 4243
Quote smartcat Replybullet Posted: 15/Aug/2010 at 12:55pm

The flaw as I see in some of the rounds I see are esp in sales and profits cagr, companies with low base will outscore those with consistent profits.

Good point! But all the data points (RoE, sales growth, div yield etc) have equal weightages in the calculation of final rankings. So even if a low base stock manages to top the list in sales & profit growth, its ranking at the top is not guaranteed - because it still has to perform better than the others in 8 other parameters.
 
Yes, zydus could do surprisingly well in this contest.
IP IP Logged
smartcat
Senior Member
Senior Member
Avatar

Joined: 29/Mar/2007
Location: India
Online Status: Offline
Posts: 4243
Quote smartcat Replybullet Posted: 15/Aug/2010 at 1:49am
ROUND NO. 6 - DIVIDEND YIELD
 
Most of time you keep hearing that high dividend yield stocks don't fall much in a crash. 2008 proved that the above line is mostly rubbish. However, a good dividend yield is a very important parameter.
 
- In large (in value terms, not number of stocks) portfolios, dividend from stocks is enough to take care of expenses. One doesn't need to sell stocks.
 
- A company which has grown its bottomline at a decent pace trading at a price offering a largish dividend yield (Eg: Hawkins, Ador Fontech etc) could signify a significant near term upside in the stock price.
 
Company Name Div Yield in % Points Earned
Hawkins Cookers  3.71 11
Blue Star  1.78 10
Page Industries  1.61 9
Voltamp Transformers 1.38 8
HDFC 1.2 7
Voltas 0.97 6
Thermax 0.67 5
Zydus Wellness  0.52 4
Titan Industries  0.5 3
HDFC Bank 0.48 2
Yes Bank 0.47 1
 
 
ROUND NO. 7 - LAST 4 YEARS DIVIDEND PER SHARE CAGR
 
If a company is growing at 30% CAGR, there is a possibility of the stock price going nowhere - it automatically does not guarantee a large appreciation in stock price. But if a company is growing at 30% CAGR and if the dividend per share is growing at 30% CAGR, then there is a 100% guarantee that the stock price will appreciate (at almost a similar pace, but not exactly).
 
Because, if the stock price doesn't appreciate, and if the dividends keep rising, then the stock will soon be available at a dividend yield of 20%! Markets won't allow that to happen (Eg: hawkins).
 
Company Name Dividend/share CAGR in % Points Earned
Voltamp Transformers 123.61 11
Page Industries  68.75 10
Hawkins Cookers  68.18 9
Titan Industries  49.53 8
Blue Star  35.12 7
Voltas 35.12 6
Zydus Wellness  31.61 5
HDFC Bank 21.54 4
HDFC 15.83 3
Thermax 10.12 2
Yes Bank 0 1
 
 
ROUND NO. 8 - DIVIDEND PAYOUT RATIO
 
Dividend payout ratio is the percentage of profits that is paid out as dividends. That is, if a company has a profit of Rs. 100 cr and it paid out Rs. 30 cr as dividends, then its dividend payout ratio is 30%
 
Why look at this parameter? Simple. You will NEVER have a Satyam, Pyramid Saimira, Asian Electronics, HFCL or a Compact Disc in your portfolio if you invest in stocks which payout 15% plus of their profits as dividends.
 
Plus, a company that pays out a large percentage of profits as dividends but still manages to grow its profits without taking on debt is a sign of an excellent company. That's why in the next round, we consider the debt/equity ratio too in our analysis.
 
Company Name Dividend Payout Ratio in % Points Earned
Page Industries  69.18 11
Hawkins Cookers  68.95 10
Thermax 49.12 9
HDFC 42.64 8
Blue Star  39.87 7
Titan Industries  31.01 6
Zydus Wellness  30.19 5
Voltas 22.41 4
HDFC Bank 21.72 3
Voltamp Transformers 17.86 2
Yes Bank 12.47 1
 
 
Tallying the 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) Total Pts
Hawkins Cookers  11 10 11 2 10 11 9 10 74
Page Industries  8 6 9 8 3 9 10 11 64
Blue Star  9 8 7 4 7 10 7 7 59
Zydus Wellness  10 3 8 10 11 4 5 5 56
Voltamp Transformers 5 11 10 1 6 8 11 2 54
Voltas 7 9 6 5 8 6 6 4 51
Titan Industries  6 2 3 7 4 3 8 6 39
HDFC 4 5 2 6 2 7 3 8 37
Yes Bank 3 7 4 11 9 1 1 1 37
HDFC Bank 2 4 1 9 5 2 4 3 30
Thermax 1 1 5 3 1 5 2 9 27
 
 
And so finally, this is the ranking of companies which offer the best compromise between low P/E, market cap and high RoE, sales/profit/dividend growth, dividend yield & payout ratio.
 
Company Name Ranking
Hawkins Cookers  1
Page Industries  2
Blue Star  3
Zydus Wellness  4
Voltamp Transformers 5
Voltas 6
Titan Industries  7
HDFC 8
Yes Bank 9
HDFC Bank 9
Thermax 11
 
 
ANALYSIS:
 
- If you haven't noticed, Yes Bank paid out their maiden dividend in FY10.
 
- Although Thermax suffered a large loss (extra ordinary item)  in 4QFY10, they still paid out 49% of their profits are dividends. One can read a lot into little moves like this.
 
 


Edited by smartcat - 15/Aug/2010 at 1:53am
IP IP Logged
basant
Admin Group
Admin Group
Avatar

Joined: 01/Jan/2006
Location: India
Online Status: Offline
Posts: 18403
Quote basant Replybullet Posted: 15/Aug/2010 at 6:09am
Brilliant! This original thesis is priceless. I have a similar model on an Excel sheet which I use for buying stocks but unlike rankings I have a base number on which I set up points to the stock.

For example a company with a 60% RoE and a 11PE when compared with another company with a 20% RoE and a 10PE will get equal weightage which is not similar in terms of the companies in analysis ceteris paribas.

But really outstanding work!!!

Try working with the RoE (1- payout ratio) and if possible update the previous posts thugh I doubt if that will make a lot of difference to the analysis.



'The Thoughtful Investor: A Journey to Financial Freedom Through Stock Market Investing' - A Book on Equity Investing especially for Indian Investors. Book your copy now: www.thethoughtfulinvestor.in
IP IP Logged
paragdesai
Senior Member
Senior Member
Avatar

Joined: 22/Oct/2007
Location: India
Online Status: Offline
Posts: 837
Quote paragdesai Replybullet Posted: 15/Aug/2010 at 8:16am
Wonderful Analysis Smartcatji!

Thanks.

Clap
Luck is what happens when preparation meets opportunity ....
IP IP Logged
maaran
Newbie
Newbie


Joined: 23/Mar/2009
Online Status: Offline
Posts: 8
Quote maaran Replybullet Posted: 15/Aug/2010 at 9:06am
Ingenious !

This analysis apears to assume an equal weight on all the parameters considered . May I suggest we assign different weightage & see what a weighted sum throws up

Edited by maaran - 15/Aug/2010 at 9:07am
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.094 seconds.
Bookmark this Page

Join Theequitydesk.com Today!

It’s easy to Join and it’s free.

Here's why members would love to be a part of theequitydesk.com

  • Equity Desk focuses on why to buy shares and invest in share rather than what to buy.
  • Live discussion forum wherein members can discuss the current Indian share Market trend, BSE Sensex or the Nifty Index.
  • Have huge cache of information on Indian and World Share Market.
  • Analysis of Indian stock market, Global events, Investing insights, portfolio management strategies and thoughts,
  • Meet investors from round the globe check their investing strategies share experiences and learn for their experiences on stocks and shares, evaluate opinions on investing in India.

Register now while it’s free!

Already a member? Close this window and log in.

Join Us           Close