please answer all parts and explain what formula and what exactly was entered in the formula in excel or whichever spredsheet(what rate what fv etc) please explain why the certain formula was used and why. thank you i will like if correct.

Krell Industries has a share price of $21.71 today. If Krell is expected to pay a dividend of $0.77 this year and its stock price is expected to grow to $24.05 at the end of the year, what is Krell's dividend yield and equity cost of capital? The dividend yield is %. (Round to two decimal places.) Assume Gillette Corporation will pay an annual dividend of $0.62 one year from now. Analysts expect this dividend to grow at 12.1% per year thereafter until the 6 th year. Thereafter, growth will level off at 1.9% per year. According to the dividend-discount model, what is the value of a share of Gillette stock if the firm's equity cost of capital is 7.1% ? The value of Gillette's stock is \$ (Round to the nearest cent.)