Answer:
B. 6.68%
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 = $980 - 4% = $940.80
Future value = $1,000
PMT = 1,000 × 9.5% ÷ 2 = $47.5
NPER = 15 years × 2 = 30 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 10.28%
2. And, the after tax cost of debt would be
= Pretax cost of debt × ( 1 - tax rate)
= 10.28% × ( 1 - 0.35)
= 6.68%