Answered step by step
Verified Expert Solution
Link Copied!

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).

image text in transcribed

image text in transcribed

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 Dividend

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