Answer the following in Excel. Show your work

Beryl Corporation (BC) recently paid a dividend of $2.75 per share. BC expects to grow its dividend at a current rate of 4.4% indefinitely. BCs common stock is currently selling for $28.00 per share and your required rate of return is 9.25%.

i. Given your required return, what is the value of one share of BC common stock to you?

ii. Given the market price, what is the expected rate of return for BCs common stock?

iii. Should you invest in BC common stock? Explain.