please answer in excel with formula text

Use the two-stage dividend growth model to value a lock, using the following information The cost of cquity is 13% (1) Dividends have been growing at an annual rate of 10% for the last five years and assume thin growth rate will continue through the next 5 years, which is the first stage. The last dividend paid was $2.00. Calculate the expected dividend each year for years 1 - 5 and their present values (2) Suppose that after year 5, the dividends are expected to grow at 2.5% hecond-stage growth rate) per year, indefinitely (3) Calculate today's stock price based on the above information 10