Answer:
the rate is 4.36%
Explanation:
The computation of the pre tax cost of debt is shown below:
Given that
NPER = 24 × 2 = 48
FV = $1,000
PMT = $1,000 ×5% ÷ 2 = $25
FV = $1,175 - $80
= $1,095
The formula is shown below:
= RATE(NPER;PMT;-PV;FV;TYP
After applying the above formula, the rate is 4.36%