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