*****NOTE****** Question must be answer by referencing the cells stated above (e.g. D8= 7%)

Calculating cost of debt - Excel ? HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Arial A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Styles D17 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% 10 12 13 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 15 16 17 Pretax cost of debt