| Gillette's most recent annual dividend was $8 per share. The company expects the growth of its dividends to be stable at 3% per year going forward. a) If investors require a 9% return, what is the...

Explain how to do in excel please.

Extracted text: | Gillette's most recent annual dividend was $8 per share. The company expects the growth of its dividends to be stable at 3% per year going forward. a) If investors require a 9% return, what is the current value of Gillette's stock? (round to nearest cent) |b) If the stock currently trades at $116.57 per share, what is the dividend growth rate investors expect? (round to nearest percent) Hint: When the constant-growth formula is solved for the growth variable, it is g = -D/P +r