Determining the required return on preferred stock

Question

William's All Night Long DJ, Inc. has outstanding preferred stock that pays an annual dividend of $6.00 per share. Compute the current price of the preferred stock if the investor's required return on the preferred stock is:

(a) 8%

(b) 10%

(c) 12%

Show work in excel