Sunday, October 3, 2010

Castrol India: A little analysis on dividend

To start with I have calculated Castrol India's dividend yield from last 10 years dividend data on the basis of current stock price. Now I will try to fit a regression line (using TREND function from MS Excel) and find out from which year I will start beating the risk free return of 7.5% of FDs.
My aim from this analysis is to understand if Castrol India will be a good investment choice for my dividend portfolio at current price.












So what is my conclusion?
I will wait for Castrol India a bit. I think I should achieve my dividend target of > 7.5% way before 2020.

No comments:

Post a Comment