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 | |||