Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started