Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Visit finance.yahoo.com and search for AT&T (T) and Microsoft (MSFT). 2. Go to the 'Historical Data' tab and download the dividend data for the

1. Visit finance.yahoo.com and search for AT&T (T) and Microsoft (MSFT).
2. Go to the 'Historical Data' tab and download the dividend data for the last 10 years.
3. Calculate the average annual growth rate of dividends. You can do this by taking the dividend from the most recent year and the dividend from 10 years ago. Use the formula: [(Recent Dividend / Dividend from 10 years ago)^(1/10)] - 1
4. Adjust the most recent quarterly dividend to an annual dividend by multiplying it by 4.
5. Use the Gordon Growth Model (also known as the constant dividend growth model) to calculate the required rate of return. The formula is: Required Return = (Annual Dividend / Current Price) + Dividend Growth Rate
6. Compare the required rate of return for both stocks.

If the required rate of return is higher than what you require for your investments, it might be a good investment. However, remember that this model assumes that dividends grow at a constant rate indefinitely, which might not be the case. Always consider other factors and risks before making investment decisions.

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Fundamentals Of Corporate Finance

Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford

5th Edition

0135811600, 978-0135811603

More Books

Students also viewed these Finance questions

Question

Discuss the impact of commissions in organizations growth?

Answered: 1 week ago

Question

Solve each equation. x 3 - 6x 2 = -8x

Answered: 1 week ago