answer in excel formulas with exact cells please!

29 0 Saved A1 A B c D E H 3 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? 4 5 6 7 01/01/00 01/01/27 8 7% 9 Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Tax rate 10 11 93 100 2 22% 12 13 14 15 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 question. Pretax cost of debt 16 17 18 19 Aftertax cost of debt 20 21 Sheet1