Answered

Explore Westonci.ca, the top Q&A platform where your questions are answered by professionals and enthusiasts alike. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

It is now January 1, 2018, and you are considering the purchase of an outstanding bond that was issued on January 1, 2016. It has a 9% annual coupon and had a 20-year original maturity. (It matures on December 31, 2035.) There is 5 years of call protection (until December 31, 2020), after which time it can be called at 109-that is, at 109% of par, or $1,090. Interest rates have declined since it was issued, and it is now selling at 114.12% of par, or $1,141.20. What is the yield to maturity

Sagot :

Answer:

YTM is 7.54%.

Explanation:

The yield to maturity can be calculated using the following RATE function in Excel:

YTM = RATE(nper,pmt,-pv,fv) .............(1)

Where;

YTM = yield to maturity = ?

nper = number of periods = number of years to maturity = original maturity number of years - number of years between January 1, 2016 and January 1, 2018 = 20 - 2 = 18

pmt = annual coupon payment = face value * annual coupon rate = 1000 * 9% = 90 (Note: This is an inflow to the bondholder and it is therefore a positive figure).

pv = present value = current bond price = -1141.20 (Note: This is an outflow to the buyer of the bond and it is therefore a negative figure).

fv = face value of the bond = 1000 (Note: This is an inflow to the bondholder and it is therefore a positive figure).

Substituting the values into equation (1), we have:

YTM = RATE(18,90,-1141.20,1000) ............ (2)

Inputting =RATE(18,90,-1141.20,1000) into excel (Note: as done in the attached excel file), the YTM is obtained as 7.54%.

Therefore,  YTM is 7.54%.

View image amcool
Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Keep exploring Westonci.ca for more insightful answers to your questions. We're here to help.