ezitttion.com/hm.tpx Calculate the pretax cost and the atertax cost of debt Calculating Cost of Debt-Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVEW VIEW Sign In : 1 u . Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles oard Font Styles 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? Settlement Maturity Price (% of par) Coupon rate Payments per year Tax rate 01/01/00 01/01/18 107 6% 35% Complete the following analysis. Do not hard code values in your calculations. Pretax cost Aftertax cost of debt Sheetl +100% ADY e xB@ here to search