Collect data and analyse trend of historical dividend $($Interim$,$ Final$)$ for $5$ years for Dr Reddy Laboratories

$$ Calculate and analyse dividend yield, dividend payout, dividend rate, sustainable growth rate and total returns for each of the $5$ years.

$$ Identify the dividend policy and comment on it$.$

$$ Assess the impact of change in the ownership structure on dividend $($Retail vs Institutional$).$

$$ Assess whether the company dividend payments are in accordance with Gordon theory.

$$ Assess the impact of change in taxation paradigm on the dividend payment.

$$ Based on company$$s capex and debt position, should the company pay dividend.

$$ Analyse the sustainability of dividend through Dividend coverage, Dividend payout, FCFE

coverage ratio and company's future prospects $($Dividend matrix$).$

$$ If company has done share repurchase, bonus & stock split in the past five years; analyse

the reason and impact.

$$ If company has not done share repurchase, bonus & stock split in the past five years;

recommend whether the company should have done it or should do it$.$

$$ Conclusion: Is the company appropriate for Dividend Investing?

use excel sheet