A B > Jx D E F G H Jiminy's Cricket Farm issued a 30-year, 7...

Transcribed Image Text:

A B > Jx D E F G H 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 01/01/00 Maturity 01/01/27 Coupon rate 7% Price (% of par) 93 Redemption value (% of par) 100 Payments per year 2 Tax rate 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 A B > Jx D E F G H 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 01/01/00 Maturity 01/01/27 Coupon rate 7% Price (% of par) 93 Redemption value (% of par) 100 Payments per year 2 Tax rate 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