Common stock value: Constant growthSeagate Technology is a global leader in data storage solutions and a high-yield dividend payer. From

2015 through 2019, Seagate paid the following per-share dividends:

2019 $ 2.49

2018 $ 2.23

2017 $ 1.81

2016 $1.15

2015 $1.54

Assume that the historical annual growth rate of Seagate dividends is an accurate estimate of the future constant annual dividend growth rate. Use a

18 % required rate of return to find the value of Seagate's stock immediately after it paid its 2019 dividend of $2.49.

can you solve in excel and show formula