Question

A 25-year, $1,000 par value bond has an 8.5% annual coupon. The bond currently sells for...

A 25-year, $1,000 par value bond has an 8.5% annual coupon. The bond currently sells for $875. If the yield to maturity remains at its current rate, what will be price be 7 years from now?

*Mention the excel functions you used and the value of each input you entered

Homework Answers

Answer #1

First we need to find the yield to maturity as on today. Use RATE function in EXCEL

=RATE(nper,pmt,pv,fv,type)

nper=25 years

pmt=coupon rate*face value=8.5%*1000=85

pv=875

fv=face value=1000

=RATE(25,85,-875,1000,0)=9.86%

Now after 7 years, the time to maturity becomes=18 years (25 years-7 years)

To find the price , use PV function

=PV(rate,nper,pmt,fv,type)

rate=9.86%

nper=18 years

pmt=85

fv=1000

=PV(9.86%,18,85,1000)=$887.26

The price of the bond after 7 years=$887.26

Know the answer?
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
Similar Questions
A 25-year, $1,000 par value bond has an 8.5% annual coupon. The bond currently sells for...
A 25-year, $1,000 par value bond has an 8.5% annual coupon. The bond currently sells for $875. If the yield to maturity remains at its current rate, what will the price be 5 years from now?
A 25-year, $1,000 par value bond has an 8.5% annual payment coupon. The bond currently sells...
A 25-year, $1,000 par value bond has an 8.5% annual payment coupon. The bond currently sells for $925. If the yield to maturity remains at its current rate, what will the price be 10 years from now? a. $950.49 b. $930.11 c. $865.00 d. $850.49 e. $1021.11
A 25 year, $1000 par value bond has an 8.5% annual payment coupon. The bond currently...
A 25 year, $1000 par value bond has an 8.5% annual payment coupon. The bond currently sells for $790. If the yield to maturity remains at its current rate, what will the price be 5 years from now?
•A 20-year, $1,000 par value bond has an 6.5% annual payment coupon. The bond currently sells...
•A 20-year, $1,000 par value bond has an 6.5% annual payment coupon. The bond currently sells for $1025. If the yield to maturity remains at its current rate, what will the price be 8 years from now?
A 30-year, $1,000 par value bond has a 7.5% annual payment coupon. The bond currently sells...
A 30-year, $1,000 par value bond has a 7.5% annual payment coupon. The bond currently sells for $910. If the yield to maturity remains at its current rate, what will the price be 10 years from now? $884.19 $921.01 $930.96 $947.25 $978.50
A 30-year, $1,000 par value bond has an annual payment coupon of 7.5%. The bond currently...
A 30-year, $1,000 par value bond has an annual payment coupon of 7.5%. The bond currently sells for $910. If the yield to maturity remains at its current rate what will the price be 10 years from now?
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for...
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for $925. If the yield to maturity remains at its current rate, what will the price be 8 years from now? a. $937.7 b. $956.95 c. $939.85 d. $503.21
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for...
A 20-year, $1,000 par value bond has a 9% semi-annual coupon. The bond currently sells for $925. If the yield to maturity remains at its current rate, what will the price be 10 years from now? a. $935.01 b. $930.01 c. $952.84 d. $945.72
A 10-year corporate bond has an annual coupon of 9% and a par value of $1,000....
A 10-year corporate bond has an annual coupon of 9% and a par value of $1,000. The bond is currently selling at a premium of 20% to par ($1,200). Which of the following statements is more likely to be CORRECT? a.    The bond’s yield to maturity is 9%. b.   The bond’s current yield is 9%. c.    IF the bond’s yield to maturity remains constant over the next year, an investor owning the bond will earn a capital GAIN of 11%...
1. Analyze the 20-year, 8% coupon rate (Semi-annual payment), $1,000 par value bond. The bond currently...
1. Analyze the 20-year, 8% coupon rate (Semi-annual payment), $1,000 par value bond. The bond currently sells for $1,218. What's the bond's yield to maturity? A. 5.06% B. 5.68% C. 5.38% D. 6.10% 2. Analyze the 20-year, 8% coupon rate (Semi-annual payment), $1,000 par value bond. The bond currently sells for $1,218. What's the bond's current yield, and capital gain yield? (Please show your work) A. 6.57%, -0.47% B. 6.07%, -0.69% C. 6.57%, -0.47% D. 6.07%, 0.69%