You purchase a 15-year, $1,000 face value bond that pays interest on a semiannual basis, for $1,324.23. If the markets required rate of return is 8 percent, how much interest does this bond pay each year? *Please answer using excel and show how you compute the value.

A) $117.50

B) $126.79

C) $110.93

D) $153.46