Soved oblem 14-7 Calculating Cost of Debt. ? - X Calculating cost of debt - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT Sign In B I V Editing este lipboards 17 . - Font Cells - . A . Alignment Number Conditional Format as Cell Formatting Table Styles Styles : for F G Jiminy's Cricket Farm issued a 30-year, 7 percent servannual 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? 01/01/00 01/01/27 Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Tax rate 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. Drotav net of dont