I need to have this answered asap please....need help!

A 1 1 2 3 4 5 6 7 8 B C D E Given the following data, construct a table of cash flows assuming that you would sell the stock at the end of year n (just after the last dividend payment). It is assumed that the stock cash flow (dividend) will grow at gs until the end of period n, then grow at g forever afterward. Then answer the following questions in the Blackboard Quiz. Before you go any further, enter the data from the Blackboard Quiz into the orange cells: CF1 = 0.02 n= 17 9 g = 3.10% gs = 10 k = 0.10% Pactual ### $52.12 11 a. 13 b. 14 c. 15 d. 12 16 What is the sum of the PVs of the first n cash Flows? What is the future value of the perpetuity value? What is the estimated value of the price of the stock? What value would k have to be in order for your model compute the estimated price to equal $52.12? 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20