Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Our platform connects you with professionals ready to provide precise answers to all your questions in various areas of expertise. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.
Sagot :
Answer:
a. Pretax cost of debt is 4.84%.
b. Aftertax cost of debt is 3.15%.
c. Aftertax cost of debt is more relevant. The reason is that it is the actual cost of debt to the company.
Explanation:
a. What is the pretax cost of debt?
The bond's Yield to Maturity can be calculated using the following RATE function in Excel:
YTM = RATE(nper,pmt,-pv,fv) * 2 .............(1)
Where;
YTM = yield to maturity = ?
nper = number of periods = number of semiannuls to maturity = Number of years * Number of semiannuals in a year = 7 * 2 = 14
r = Semiannual coupon rate = Annual coupon rate / 2 = 6.2% / 2 = 0.062 / 2 = 0.031
pmt = semiannual coupon payment = fv * r = 1000 * 0.031 = $31 = 31
pv = present value = current bond price = fv * 108% = 1000 * 108% = 1080
fv = face value or par value of the bond = 1000
Substituting the values into equation (1), we have:
YTM = RATE(25,90,-1250,1000) ............ (2)
YTM = RATE(14,31,-1080,1000)*2
Inputting =RATE(14,31,-1080,1000)*2 into excel (Note: as done in the attached excel file), the YTM is obtained as 4.84%.
Therefore, the YTM of 4.84% is the pretax cost of debt.
b. What is the aftertax cost of debt?
Aftertax cost of debt = Pretax cost of debt * (100% - Tax rate) = 4.84% * (100% - 35%) = 3.15%
c. Which is more relevant, the pretax or the aftertax cost of debt? Why?
Aftertax cost of debt is more relevant. The reason is that it is the actual cost of debt to the company.
We appreciate your time on our site. Don't hesitate to return whenever you have more questions or need further clarification. We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. Find reliable answers at Westonci.ca. Visit us again for the latest updates and expert advice.