Question

  The bond shown in the following table pays interest annually. ​(Click on the icon here in...

  The bond shown in the following table pays interest annually. ​(Click on the icon here in order to copy the contents of the data table below into a​ spreadsheet.)

par value =1000

coupon interest rate=14%

years to maturity=11

current value=1110

a. Calculate the yield to maturity​ (YTM​) for the bond.

b. What relationship exists between the coupon interest rate and yield to maturity and the par value and market value of a​ bond? Explain.

1 0
Add a comment Improve this question Transcribed image text
Answer #1

Yield to maturity is calculated using the RATE function in excel as follows:-

=RATE(nper,pmt,pv,fv)

=RATE(11,14%*1000,-1110,1000)

=12.14%

What are the options for part--b, write in the comments.

Add a comment
Know the answer?
Add Answer to:
  The bond shown in the following table pays interest annually. ​(Click on the icon here in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT