with excel functions

Jiminy's Cricket Farm issued a 30 -year, 4.5 percent semiannual bond three years ago. The bond currently sells for 104 percent of its face value. The company's tax rate is 22 percent. Input Area: (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the "Basis" input blank in the function.)