Please show the exact excel formula to get the answer.

? Calculating Cost of Debt - Excel FORMULAS DATA REVIEW - 2x Sign In FILE HOME INSERT PAGE LAYOUT VIEW Arial 12 AA . A Paste B I U. Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Editing Clipboard Font X C2 for Mudvayne, Inc., is trying to determine its cost of debt. The firm has a debt issue E F G H I Mudvayne, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 18 years to maturity that is quoted at 107 percent of face value. The issue makes semiannual payments and has an embedded cost of 6 percent annually. What is the company's pretax cost of debt? If the tax rate is 35 percent, what is the aftertax cost of debt?! 01/01/00 01/01/18 Settlement Maturity Price (% of par) Coupon rate Payments per year Tax rate 107 6% 35% Complete the following analysis. Do not hard code values in your calculations. Pretax cost Aftertax cost of debt ... Sheet1 . +