Answer :
Answer:
a. 5%
b. 3.8%
c. 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 × 105% = $1,050
Assuming figure - Future value or Face value = $1,000
PMT = 1,000 × 5.4% ÷ 2 = $27
NPER = 20 years × 2 = 40 years
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this,
a. The pretax cost of debt is 5%
b. And, the after tax cost of debt would be
= Pretax cost of debt × ( 1 - tax rate)
= 5% × ( 1 - 0.24)
= 3.8%
c. After tax cost of debt is more relevant as it consider the tax effect
