In: Finance
| Solution: | |||
| 1) Given: | |||
| Coupon rate | 9.40% | ||
| YTM i.e RATE | 7.75% | ||
| Face value i.e FV | $1000 | ||
| Market price i.e PV | $990 | ||
| Semiannual interest payment: | |||
| Semiannual interest payment = Face value *Coupon rate | |||
| $1000*9.40%*6/12 | |||
| 47.00 | |||
| Semiannual interest Amount = $47.00 | |||
| 2) Given: | |||
| Term i.e NPER | 14 Year i.e 28 Semiannual Periods = 14*2 | ||
| Face value i.e FV | $1000 | ||
| Coupon payment | 10% i.e 5% Semiannual rate 10%/2 | ||
| Required rate of Return i.e RATE | 8.5% i.e 4.25% Semiannual rate | ||
| Coupon amount i.e PMT | $1000* 5% i.e $50 | ||
| Selling price today i.e PV | |||
| Using the PV Function in excel we will calculate the price at which the bond can be sold today: | |||
| PV(4.25%,28,$50,$1000,0) | |||
| 1121.44780543188 | |||
| The bond should sell for $1121.45 | |||
| 3) | |||
| 2) Given: | |||
| Term i.e NPER | 30 Year | ||
| Face value i.e FV | $1000 | ||
| Coupon payment | 4.75% | ||
| Required rate of Return i.e RATE | 25.00% | ||
| Coupon amount i.e PMT | $1000* 4.75% i.e $47.5 | ||
| Selling price today i.e PV | |||
| Using the PV Function in excel we will calculate the price at which the bond can be sold today: | |||
| PV(25%,30,$47.5,$1000,0) | |||
| 191.002731431821 | |||
| The bond should sell for $191.00 | |||