please help me this using excel

Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years The bond currently sells for 93 percent of its face value. The company's tax 22 percent. What is the pretax cost of debt? What is the aftertax cost of debt? Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the YIELD function. You must use the built-in Excel function to answer this