A B C E F. G H J K use excel functions and/or mathematical operators Go to https://www.sec.gov/edgar/search/ and use "more search options" to search "LUMN" as company ticker. Find the forms tab on left and the "10-K" and click, then click "open filing", then open the 10-K document. As you can see, it's a big document (put together by a big team of accounting and finance folks). Find the annual dividends declared paid per share in years 2019-2020 (ignore 2018). Assume today is 12/31/2021. Produce the timeline in excel for dividends paid from 2019-2022 (and we are going to assume that the 2019-2020 growth rate continues forever) year 2019 2020 2021 2022 dividend Answers 15 Additional Questions 1) What was the year 2019 dividend paid per share? 2) What is the growth rate of dividends? growth between 2019 and 2020 3) What should be the price of the stock if the required rate of return is 9%? What is the theoretical stock price based on the appropriate dividend growth model 4) What would be the expected dividend in year 2030? 5) Under these conditions, find LUMN's actual current price (internet), is it over, under or fairly valued based on the dividend growth model inputs? A B C E F. G H J K use excel functions and/or mathematical operators Go to https://www.sec.gov/edgar/search/ and use "more search options" to search "LUMN" as company ticker. Find the forms tab on left and the "10-K" and click, then click "open filing", then open the 10-K document. As you can see, it's a big document (put together by a big team of accounting and finance folks). Find the annual dividends declared paid per share in years 2019-2020 (ignore 2018). Assume today is 12/31/2021. Produce the timeline in excel for dividends paid from 2019-2022 (and we are going to assume that the 2019-2020 growth rate continues forever) year 2019 2020 2021 2022 dividend Answers 15 Additional Questions 1) What was the year 2019 dividend paid per share? 2) What is the growth rate of dividends? growth between 2019 and 2020 3) What should be the price of the stock if the required rate of return is 9%? What is the theoretical stock price based on the appropriate dividend growth model 4) What would be the expected dividend in year 2030? 5) Under these conditions, find LUMN's actual current price (internet), is it over, under or fairly valued based on the dividend growth model inputs