Please help in answering this. it will be helpful if you can show this through excel

Goodwin Technologies, a relatively young company, has been wildly successful but has yet to pay a dividend. An analyst forecasts that Goodwin is Likely to pay its first dividend three years from now. She expects Goodwin to pay a $1.50000 dividend at that time (Da = $1.50000 ) and believes that the dividend will grow by 7,80000\% for the following two years (Du and Ds). However, after the fifth year, she expects Goodwin's dividend to grow at a constantrate of 3.42000% per year. Goodwin's required retum is 11.40000\%. Fill in the following chart to determine Goodwin's horizon value at the horizon date (when constant growth begins) and the current intrinsic value. To increase the accuracy of your calculations, do not round your intermediate calculations, but round all final answers to two decimal places. Assuming that the markets are in equibbrum, Goodwin's current expected dividend yield is , and Goodwin's copital gains yield is Goodwin has been very successful, but it hasn't paid a dividend yet. It circulates a report to its key investors containing the following statement: Goodwin has a large selection of profitable investment opportunities: Is this statement a possible explanation for why the firm hasn't paid o dividend yet? begins) and the current intrinsic value. To increase the accuracy of your calculations, do not round your intermedate calculations, but round all final answers to two decimal places. Assuming that the markets are in equilabrium, Goodwin's current expected dividend yield is , and Goodwin's capital gains yield is Goodwn has been very successful, but it hasn't paid a dividend yet. It circulates a report to its key investors containing the following statement: Goodwin has a large selection of prohitable investment opportunities. Is this statement a possible explanation for why the firm hasn't paid a dividend yet? No Term Value Horizon value Current intrinsic value Assuming that the markets $27.11 ilibrium, Goodwin's current expected dividend yield is , and Goodwin has been very suc $19.20 t it hasn't paid a dividend yet. It circulates a report to its key investors Goodwin has a large selection of profitable investment opportunities. Is this statement a possible explanation for why the firm hasn't paid a dividend yet? No Goodwin has been very suc $16.32 it it hasn't paid a dividend yet. It ci $16.77 Goodwin has a large selection of profitable investment opportunities. Goodwin has been very successful, but it hasn't paid a dividend yet. It circulates a report to 7.72% vestors containing the following statement: Assuming that the markets are in equilibrium, Goodwin's current expected dividend yield is , and Goodwin's capital gains yield is Goodwin hars a large selection of protitable investment opportunities. Assuming that the markets are in equilibrium, Goodwin's current expected dividend yield is and Goodwin's capital gains yield is en very successful, but it hasn't paid a dividend yet. It circulates a report to its key investors containing the following statement: a large selection of profitable investment opportunities. Is this statement a possible explanation for why the firm hasn't paid a dividend yet? No Yes