(Answers beed to be a formula in excel)

QPQ's stock price is $92. What rate of return will it provide if it pays a $6 dividend one year from now and then a $4 dividend two years from now, at which point it can be sold for $98?

HMRS's is expected to pay a $5 dividend next year and have a target price of $74.25. If the appropriate discount rate is 7 8.50%, what price should it sell for?

QPQ's stock price is $92. What rate of return will it provide if it pays a $6 dividend one year from now and then a $4 dividend two years from now, at which point it can be sold for $98 ? 6 HMRS's is expected to pay a $5 dividend next year and have a target price of $74.25. If the appropriate discount rate is 78.50%, what price should it sell for