Question

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 yield to maturity (YTM) for the bond is % (Round to two decimal places.) b. What relationship exists between the coupon interest rate and yield to maturity and the par value and market value of a bond? Explain. (Select the best answer below) O O A. The market value of the bond approaches its par value as the time to maturity increases. The yield-to-maturity approaches the coupon interest rate as the time to maturity declines. B. The market value of the bond approaches its par value as the time to maturity declines. The yield-to-maturity approaches the coupon interest rate as the time to maturity declines OC. The market value of the bond approaches its par value as the time to maturity declines. The yield-to-maturity approaches the coupon interest rate as the time to maturity increases OD. The market value of the bond approaches its par value as the time to maturity increases. The yield-to-maturity approaches the coupon interest rate as the time to maturity increases

Answer 1

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:

a)

Using RATE function in excel we can solve the following

N 90 PMT FV 1000 1230 PV YTM 6.07%

b)

The market value of the bond approaches its par value as the time to maturity declines. The yield to maturity approaches the coupon interest rate as the time to maturity declines