1. Calculate the pretax cost of debt using excel

2. Calculate the aftertax cost of debt using excel

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? Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Tax rate 01/01/00 01/01/27 7% 93 100 2 22% 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 Aftertax cost of debt Sheet1