Please use and show all formulas using excel. I cannot understand the answer if I can't see the formulas for each. Thank you very much.
Common stock value: Constant growth
Seagate Technology is a global leader in data storage solutions and a high-yield dividend payer. From 2015 through 2019, Seagate paid the followingper-share dividends:
Year Dividend per share
Assume that the historical annual growth rate of Seagate dividends is an accurate estimate of the future constant annual dividend growth rate. Use a 20% required rate of return to find the value of Seagate's stock immediately after it paid its 2019 dividend of $2.52.
Get Answers For Free
Most questions answered within 1 hours.