Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Following are the historical dividend data over the last 5 years for a company from Yahoo! Finance. Compute the average annual percent change in dividends
Following are the historical dividend data over the last 5 years for a company from Yahoo! Finance. Compute the average annual percent change in dividends over the last five years to proxy for the growth rate of dividends using the following formula. (Write this number as a decimal and not as a percentage, e.g. 0.11 not 11%. Round your answer to three decimal places. For example 1.23450 or 1.23463 will be rounded to 1.235 while 1.23448 will be rounded to 1.234).
4 D sum_last_4qtrs -1= Historical growth rate for dividends: D sum_qtrs_20 ago-17 ago Date Dividends Dividends Mar 04, 2021 1.023 Dividend Dec 03, 2020 1.023 Dividend Sep 03, 2020 1.023 Dividend Jun 04, 2020 1.023 Dividend Mar 05, 2020 0.955 Dividend Dec 05, 2019 0.955 Dividend Sep 05, 2019 0.955 Dividend Jun 06, 2019 0.955 Dividend Feb 28, 2019 0.928 Dividend Dec 06, 2018 0.928 Dividend Sep 06, 2018 0.928 Dividend May 31, 2018 0.928 Dividend Mar 01, 2018 0.805 Dividend Nov 30, 2017 0.805 Dividend Aug 30, 2017 0.805 Dividend May 31, 2017 0.805 Dividend Mar 01, 2017 0.753 Dividend Nov 30, 2016 0.753 Dividend Aug 31, 2016 0.753 Dividend Jun 01, 2016 0.753 DividendStep 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