Valuation is generally the toughest part of fundamental analysis. There are so many methods to value a stock to know whether the stock is currently overpriced , fairly priced or cheaply priced. Here I am showing a very simple valuation method which requires very less calculation.

**PE Ratio Stock Valuation Model **

To use this method you need

- The forward price multiple or the PE multiple which you expect the market will give to the stock. You can also use the average PE that companies in that sector get.
- The current earning per share (EPS) of the stock. Take the diluted EPS
- Current dividend per share of the stock. Calculate the dividend payout ratio from that

For an example lets take the FMCG company Marico. The average PE of FMCG companies is 40. I will take PE as 40 in the calculations assuming that market will continue to give PE multiple of 40.

The current eps of the company is 5.5 Rs

The current dividend yield 3.2 Rs per share. The dividend payout of Marcio has been varying from 20-50% over the last 5 years period. I take the dividend payout ratio as 30% That means for each 100 Rs of net profit company pays 30 Rs to shareholders as the dividend.

Assuming the company can continue to grow at 20% for the next three years I take the growth rate as 20% . The EPS and the Dividends for the next three years will be.

Year | EPS | Dividend |
---|---|---|

Year 0 | 5.5 | 3.5 |

Year 1 | 6.6 | 2.0 |

Year 2 | 7.9 | 2.4 |

Year 3 | 9.5 | 2.9 |

Total | 29.5 | 10.7 |

You can see that at the end of the 3rd year the company will have EPS of 9.5 Rs We can arrive the expected share price by multiplying PE multiple with the EPS. We will get the expected share price 9.5 x 40 = 380

The company will also pay the total dividend of 10.7 Rs adding that to the expected share price we get the new expected share price 390 Rs. This whole calculation tells that after three years the share price can be 390 Rs

At what price we should buy?

The answer to this questions depends on how much return you want. You should discount the expected share price by the rate of return you want from the stock. If I want 20% annual return from the stock I have to discount the share price by 20%. On discounting the price 390 390/(1.20)^3 I get the value 225 . That means for 20% annual return from Marico I should buy it below 225.

I did the calculation for three years if you wish to hold for more than 3 years and expects the company can continue to grow at a good pace for many years you can do the same calculation for 5 years or more also.

To do all these calculations easily you can build an excel sheet. I have built my own excel sheet where I have to enter the stock code and rest all calculations are done by the sheet.

**Caution:** The results will depend on your estimated PE and growth rate. Desired results won’t come if the PE and growth rate assumptions are not matched.

Shukla Ji, Unable to understand the Dividend calculation at present Rs. 3.5, after 1 year 2, then 2.4, then 2.9 ? Because dividend payout ratio is assumed 30% of Profit. Please help. Thanks

Last financial year all the companies have paid above average dividend, thanks to govt taxing the dividend income above 2 lakh from FY17 , 3.5 is the dividend company paid this year and I don’t think it will continue because of high tax from current years. Over the 5 year period company has paid dividend 20-58% I have taken the average as 30% thats why you are seeing lower dividend than the present year

O.K. Got your view.

Hi Abhishek,

Can you tell me how you manage to add quotes in excel. If possible can I get copy of that excel?

Thanks,

Rahul Lamkhade

use Googlefinance(“stockcode”) function in google docs

Hi Abhishek

Need information about some stocks which I want to pick for at least next 5 years.

Thanks

Abhishek by any chance is it possible to share excel with me.