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
  • 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 t o Yield to maturity a spreadsheet.) the contents of the date table below into Par value $500 Coupon interest rate Years to maturity Current value $630 139 a. Calculate the yield to maturity (TM) 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 a....

  • Yield to maturity a spreadsheet.) The bond shown in the following table pays interest annually. (Click...

    Yield to maturity a spreadsheet.) 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 Coupon interest rate Years to maturity Par value $1,000 Current value $1,230 a. Calculate the yield to maturity (VTM) 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 a. The...

  • Yuld to maturity The bond shown in the following table prys interest ruly (Click on the...

    Yuld to maturity The bond shown in the following table prys interest ruly (Click on the icon located on the top-right comer of the lata table below in order to copy its contents into a spreadsheet) Coupon Interest rate Y ears to maturity Current value 20 $370 Par value $1.000 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...

  • Bond valuation Annual interest Calculate the value of the bond shown in the following table, assuming...

    Bond valuation Annual interest Calculate the value of the bond shown in the following table, assuming it pays interest annually. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Years to maturity Par value $1,000 Coupon interest rate 16% Required return 16% The value of the bond is $ . (Round to the nearest cent.)

  • Bond valuationlong dash—Annual interest   Calculate the value of the bond shown in the following​ table, assuming...

    Bond valuationlong dash—Annual interest   Calculate the value of the bond shown in the following​ table, assuming it pays interest annually. ​(Click on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.) Par value Coupon interest rate Years to maturity Required return Copy to Clipboard + Open in Excel + ​$500500 99​% 88 88​% The value of the bond is ​$nothing . ​(Round to the nearest​ cent.)

  • The bond shown in the following table pays interest annually.   ​ Par value    Coupon interest...

    The bond shown in the following table pays interest annually.   ​ Par value    Coupon interest rate     Years to maturity    Current value ​$100 12​% 20 ​$130 Calculate the yield to maturity (YTM​) for the bond. Show formula

  •    The bond shown in the following table pays interest annually. Par value Coupon interest rate Years...

       The bond shown in the following table pays interest annually. Par value Coupon interest rate Years to maturity Current value ​$100 8​% 6 ​$80 Calculate the yield to maturity ​ (YTM​) for the bond.

  • The Salem Company bond currently sells for $956.79 has a coupon interest rate of 8 %...

    The Salem Company bond currently sells for $956.79 has a coupon interest rate of 8 % and a $1000 par value, pays interest annually, and has 12 years to maturity. a. Calculate the yield to maturity (YTM ) on this bond. b. Explain the relationship that exists between the coupon interest rate and yield to maturity and the par value and market value of a bond.

  • P6-16 (book/static) Question Help Bond valuation-Annual interest Calculate the value of the bond shown in the following...

    P6-16 (book/static) Question Help Bond valuation-Annual interest Calculate the value of the bond shown in the following table, assuming it pays interest annually. (Click on the icon located on the top-right coner of the data table below in order to copy its contents into a spreadsheet.) Required return Par value $1,000 Coupon interest rate Years to maturity 20 11% 12% The value of the bond is $ (Round to the nearest cent.)

  • ield to maturity The Salem Company bond currently sells for $95544, has a coupon interest rate...

    ield to maturity The Salem Company bond currently sells for $95544, has a coupon interest rate of 9% and a $1000 par value, pays interest annually, and as 18 years to maturity Calculate the yield to maturity (YTM) on this bond Explain the relationship that exists between the coupon interest rate and yield to maturity and the par value and market value of a bond. The yield to maturity on this bond is %. (Round to three decimal places.) ....

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