Westonci.ca makes finding answers easy, with a community of experts ready to provide you with the information you seek. Explore thousands of questions and answers from a knowledgeable community of experts ready to help you find solutions. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.
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.
Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Thank you for choosing Westonci.ca as your information source. We look forward to your next visit.