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

Question

08-03-2021
Business

Answered

IDNLearn.com connects you with a community of experts ready to answer your questions. Discover comprehensive answers from knowledgeable members of our community, covering a wide range of topics to meet all your informational needs.

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 :

Thank you for contributing to our discussion. Don't forget to check back for new answers. Keep asking, answering, and sharing useful information. Find the answers you need at IDNLearn.com. Thanks for stopping by, and come back soon for more valuable insights.

Which Of The Following Is The Best Explanation Of Why Cotton Was Grown In The Southern Colonies? The Southern Colonies Had Nutrient-rich Dense Soil And Mild Wea

The Economy Of Mexico Depends Greatly On One Of The Fossil Fuels.Which Fossil Fuel Is It? Give A Statistic About This Fossil Fuel.

Discuss Why Science Cannot Answer All Questions.

Emily's Family Loves To Work Together In The Garden. They Have A Slight Preference For Flowers, As 60% Of Their Plants Are Flowers And 40% Are Vegetables. They

Which Of The Following Quadratic Function Has A Maximum Value Of 16? 1- Y=x^2+16 2- Y=16-x^2 3- Y=(x-16)^2 4- Y=(x+16)^2

Why Is Using The Right Diction Is So Important In The Business World

Which Sentence Has A Transitive Verb? A. The Cornbread Doesn't Taste Sweet Enough. B. Cindy Read A Story To Her Little Sister. C. Ms. Alvarez Is The Volleyball

-5x+3y-=8 THAN X=9-10Y

Who Was The Leader Of The Polish Movement Called "Solidarity"? A. Pope John Paul II B. Lech Walesa C. Karol Wajtyla D. Mikhail Gorbachev

What At 25 Equations That Equal 36

Amcoolidn Amcoolidn · Answer 1 · 2021-03-10T19:43:37-05:00

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%.

Sagot :

Other Questions