Question

• Calculate the annual dividend growth rate for the last 10 years. Kindly provide excel formulas.
• Based on the annual dividend growth rate for data provided, will you forecast a constant or non-constant growth in dividends? Please explain.

Date	Dividends
8/11/2010	0.303
12/8/2010	0.303
3/9/2011	0.365
5/11/2011	0.365
8/10/2011	0.365
12/7/2011	0.365
3/8/2012	0.398
5/9/2012	0.398
8/8/2012	0.398
12/5/2012	0.398
3/8/2013	0.47
5/8/2013	0.47
8/7/2013	0.47
12/4/2013	0.47
3/7/2014	0.48
5/7/2014	0.48
8/6/2014	0.48
12/3/2014	0.48
3/11/2015	0.49
5/6/2015	0.49
8/5/2015	0.49
12/2/2015	0.49
3/9/2016	0.5
5/11/2016	0.5
8/10/2016	0.5
12/7/2016	0.5
3/8/2017	0.51
5/10/2017	0.51
8/9/2017	0.51
12/6/2017	0.51
12/7/2017	0.51
3/8/2018	0.52
5/10/2018	0.52
8/9/2018	0.52
12/6/2018	0.52
3/14/2019	0.53
5/9/2019	0.53

Answer 1

The annual dividend growth rate can be computed using the formula = (Dividend at the end / Dividend at the beginning)^(1/number of years) - 1

Annual Dividend Growth from 8/11/2010 to 5/9/2019 = 6.60%

The dividend has been consistently growing each of the year and there has been a single year where the dividend has come down.Hence with the data provided, a constant growth in dividends can be forecasted.