updated with cell positions

Jiminy's Cricket Farm issued a 30 -year, 7 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The company's tax rate is 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