What is the yield to call of a 20-year to maturity bond that pays a coupon rate of 9.03 percent per year, has a $1,000 par value, and is currently priced at $791? The bond can be called back in 8 years at a call price $1,078. Assume annual coupon payments.
Round the answer to two decimal places in percentage form. (Write the percentage sign in the "units" box)
You should use Excel or financial calculator.
I used the Rate formula on excel, but I can't seem to get the right numbers