k_ps (cost of preferred stock)

if a ps pays $1.50 annual dividend and sells for $15, the investor's required rate of return, k_ps is ? 10

(ps issuer's viewpoint) what if the firm were to net $13.50 per share after issuance costs, what then will k_ps be? answer in excel