Question

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

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

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

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 22 minutes ago

asked 23 minutes ago

asked 28 minutes ago

asked 34 minutes ago

asked 43 minutes ago

asked 56 minutes ago

asked 58 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago