Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

  • 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions