Advance, inc., is trying to determine its cost of debt. the firm has a debt issue outstanding with 11 years to maturity that is quoted at 104 percent of face value. the issue makes semiannual payments and has a coupon rate of 4 percent annually. a. what is advance's pretax cost of debt? b. if the tax rate is 35 percent, what is the aftertax cost of debt?

a. 3.56%

b. 2.31%

Explanation:

In this question, we use the Rate formula which is shown in the spreadsheet.  

The NPER represents the time period.

Given that,  

Present value = $1,040

Assuming figure - Future value or Face value = $1,000  

PMT = 1,000 × 4% ÷ 2 = $20

NPER = 11 years × 2 = 22 years

The formula is shown below:

= Rate(NPER;PMT;-PV;FV;type)

The present value come in negative

So, after solving this,

1. The pretax cost of debt is = 2 × 1.78% = 3.56%

2. And, the after tax cost of debt would be

= Pretax cost of debt × ( 1 - tax rate)

= 3.56% × ( 1 - 0.35)

= 2.31%

answer may be d i think

you get one warning and if you do something to violate the guidelines of after that you get kicked off.

mark as