i need to calculate the yield to maturity % of some bonds. I was told i can use the rate function in excel to do this, but the result is a NUM! error. I don't know what i'm doing wrong, but i'm sure someone does, so what do i need to do to calculate this?

Bond details:

5 years

annually paid coupon

10% coupon

$1,000 par value

$960 current price

B6 fo D E F 5 $100 A B 1 No of payments 2 coupon payment amt 3 par value $1,000 4 current price 5 YTM #NUM! 6 $960 7 8