Answer:
1. 6.40%
2. 4.16%
3. After tax cost of debt
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,000 × 95% = $950
Assuming figure - Future value or Face value = $1,000 Â
PMT = 1,000 × 6% ÷ 2 = $30
NPER = 26 years × 2 = 52 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 6.40%
2. And, the after tax cost of debt would be
= Pretax cost of debt × ( 1 - tax rate)
= 6.40% × ( 1 - 0.35)
= 4.16%
c. After tax cost of debt is more relevant as the  after tax cost of debt is less than the pre tax cost of debt