Question

# Missing information on a bond. Your broker faxed to you the following information about two quarterlyquarterly...

Missing information on a

bond.

quarterlyquarterly

coupon

bonds that you are considering as a potential investment.​ Unfortunately, your fax machine is blurring some of the​ items, and all you can read from the fax on the two different bonds is the​ following:

. Fill in the missing data from the information that the broker sent.

What is the price of the IBM coupon​ bond?

(Click on the following icon

in order to copy its contents into a​ spreadsheet.)

Calculation of price of IBM coupon bond:
FV = 5000
PMT = 5000 * 8.5% = 425
Rate = 9.5%
Nper = 20

Price of the bond can be calculated by using the following excel formula:
=PV(rate,nper,pmt,fv)
=PV(9.5%,20,-425,-5000)
= \$4,559.38

Price of IBM coupon bond = \$4,559.38

Calculation of coupon rate:
FV = 1000
Rate = 11.5%
Nper = 30
PV = 537.68

Coupon payment can be calculated by using the following excel formula:
=PMT(rate,nper,pv,fv)
=PMT(11.5%,30,-537.68,1000)
= \$59.72

Coupon rate = coupon payment / face value
= \$59.72 / 1000
= 5.97%

Coupon rate of AOL coupon bond = 5.97%

#### Earn Coins

Coins can be redeemed for fabulous gifts.