Solution in excel?

Common stock value: Constant growth Seagate Technology is a global leader in data storage solutions and a consistent dividend payer. From 2018 through 2022, Seagate paid the following per-share dividends: Year Dividend per share 2022 2021 2020 2019 2018 $2.56 2.28 1.82 1.19 1.53 Assume that the historical annual growth rate of Seagate dividends is an accurate estimate of the future constant annual dividend growth rate. Use a 22% required rate of return to find the value of Seagate's stock immediately after it paid its 2022 dividend of $2.56. *** The value of Seagate's stock is $. (Round to the nearest cent.)