Im currently learning applications and formulas for stocks that dont pay dividends.

Although, as I was working through excel I got really confused and hung up on my own working notes.

Please see the attached photo and solve the question. (If you could show your work through excel, that would be so helpful.)

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 $2.75000 dividend at that time (D3=$2.75000) and believes that the dividend will grow by 14.30000% for the following two years (D4 and D5 ). However, after the fifth year, she expects Goodwin's dividend to grow at a constant rate of 3.72000% per year. Goodwin's required return is 12.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 equilibrium, Goodwin's current expected dividend yield is , and Goodwin's capital 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: Investors prefer the deferred tax liability that capital gains offer over dividends. Is this statement a possible explanation for why the firm hasn't paid a dividend yet? Yes No