ASAP

You know that the after-tax cost of debt capital for Oriole Company is 15.4 percent. If the firm has only one issue of five-year bonds outstanding. Assume the bonds make semiannual coupon payments and the marginal tax rate is 30 percent. Assume the par value of the bonds is $1,000. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Problem 13.15 a1-a2 (Excel Video) (a1) Calculate the pre-taxcost of debt capital. Pre-tax cost of debt capital %