Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
1) Compute the after-tax cost for the following debt: a bond with a market price of $1,080 and a coupon interest of 10%
1) Compute the after-tax cost for the following debt: a bond with a market price of $1,080 and a coupon interest of 10%. Rotation costs for a new issue would be approximately 8% of the market price. The bonds mature in 15 years. The corporate tax rate'is 35%.
2) Omidi Enterprises, a Persian-American Conglomerate, has a 15-year bond issue pays a 9 percent coupon. The bond is currently priced at $894.60 and has a par Interest is paid semiannually. What is the yield to maturity for these bonds? a. 8.67 percent b. 10.13 percent c. 10.16 percent d. 10.40 percent e. 10.45 percent
Expert Solution
1)
Computation of Cost of Debt using Rate Function in Excel:
=rate(nper,pmt,-pv,fv)
Here,
Rate = Cost of Debt = ?
Nper = 15 years
PMT = $1,000*10% = $100
PV = $1,080 *(1-8%) = $993.60
FV = $1,000
Substituting the values in formula:
=rate(15,100,-993.60,1000)
Rate or Cost of Debt = 10.08%
After-tax Cost of Debt = 10.08%*(1-35%) = 6.55%
2)
Computation of Yield to Maturity using Rate Function in Excel:
=rate(nper,pmt,-pv,fv)*2
Here,
Rate = Yield to Maturity = ?
Nper = Number of Periods to Maturity = 15 years*2 = 30 Periods
PMT = Periodic Coupon Payment = $1,000*9%/2 = $45
PV = Current Selling Price = $894.60
FV = Face Value = $1,000
Substituting the values in formula:
=rate(30,45,-894.60,1000)*2
Rate or Yield to Maturity = 10.40%
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.
