Six years ago, your firm issued $1,000 par, 25-year bonds, with a 8% coupon rate and a 12% call premium. Assume semiannual compounding.
A. If these bonds are now called, what is the actual yield to call for the investors who originally purchased them at par? Do not round intermediate calculations. Round your answer to two decimal places.
___% annually
B. If the current interest rate on the bond is 6% and the bonds were not callable, at what price would each bond sell? Do not round intermediate calculations. Round your answer to the nearest cent. $
I have answered the question below using excel and have attached the image below.
Please up vote for the same and thanks!!!
Do reach out in the comments for any queries
Answer:
1) | 2) | |||
N | 12 | RATE | 3% | |
PMT | 40 | NPER | 38 | |
PV | -1000 | PMT | 40 | |
FV | 1120 | FV | 1000 | |
YTM | 4.76% | PV | $1,224.92 | |
YTM*2 | 9.53% |
1) | 2) | |||
N | 12 | RATE | 0.03 | |
PMT | 40 | NPER | 38 | |
PV | -1000 | PMT | 40 | |
FV | 1120 | FV | 1000 | |
YTM | =RATE(J112,J113,J114,J115) | PV | =-PV(M112,M113,M114,M115) | |
YTM*2 | =J117*2 |
Get Answers For Free
Most questions answered within 1 hours.