Could you please solve part A and part B. If you could do this in excel and show steps it would be greatly appreciated, thank you!

QUESTION #1 PART A A firm just paid an annual dividend of $1.20 and the dividend is expected to grow by 5% indefinitely. If investors require an 11% return on an investment in the firm's equity, then what is the intrinsic value of one share of the firm's stock? PARTB A firm is expected to pay an annual dividend of $1.20 in one year and the dividend is expected to grow by 5% indefinitely. If investors require an 11% return on an investment in the firm's equity, then what is the intrinsic value of one share of the firm's stock