MLK Bank has an asset portfolio that consists of $100 million of 30-year, 8 percent annual...

MLK Bank has an asset portfolio that consists of $100 million of 30-year, 8 percent annual coupon, $1,000 bonds that sell at par. (LG 3-4, LG 3-6) a. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? What will be the new prices if market yields change immediately by ± 2.00 percent? b. The duration of these bonds is 12.1608 years. What are the predicted bond prices in each of the four cases using the duration rule? What is the amount of error between the duration prediction and the actual market values?

in excel please

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

jeff jeffy answered 1 year ago

MLK Bank has an asset portfolio that consists of $230 million of 15-year, 8 percent coupon,...

MLK Bank has an asset portfolio that consists of $230 million of 15-year, 8 percent coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? b-1. The duration of these bonds is 9.2442 years. What are the predicted bond prices in each of the four cases...

MLK Bank has an asset portfolio that consists of $220 million of 15-year, 7 percent coupon,...

MLK Bank has an asset portfolio that consists of $220 million of 15-year, 7 percent coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? b-1. The duration of these bonds is 9.7455 years. What are the predicted bond prices in each of the four cases...

MLK Bank has an asset portfolio that consists of $130 million of 15-year, 5.5 percent coupon,...

MLK Bank has an asset portfolio that consists of $130 million of 15-year, 5.5 percent coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? b-1. The duration of these bonds is 10.5896 years. What are the predicted bond prices in each of the four cases...

Please show all work. MLK Bank has an asset portfolio that consists of $100 million of...

Please show all work. MLK Bank has an asset portfolio that consists of $100 million of 30-year bonds with 8 percent coupon rate (coupons are paid annually) and $1,000 face value selling at par. a) What will be the bonds’ new prices if market yields change immediately by ± 0.05 percent? What will be the new prices if market yields change immediately by ± 1.00 percent? b) The duration of these bonds is 12.1608 years. What are the predicted new...

MLK Bank has an asset portfolio that consists of $170 million of 15-year, 9.5-percent-coupon, $1,000 bonds...

MLK Bank has an asset portfolio that consists of $170 million of 15-year, 9.5-percent-coupon, $1,000 bonds with annual coupon payments that sell at par. a1. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Bonds’ New Price At + 0.10% __$ At − 0.10% ____ a2. What will be the new prices if market yields change immediately by...

MLK Bank has an asset portfolio that consists of $150 million of 15-year, 7.5-percent-coupon, $1,000 bonds...

MLK Bank has an asset portfolio that consists of $150 million of 15-year, 7.5-percent-coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Bonds’ New Price At + 0.10% $ At − 0.10% a-2. What will be the new prices if market yields change immediately by ±...

PMG Inc. has an asset portfolio that consists of $130 million of 15-year, 5.5 percent coupon,...

PMG Inc. has an asset portfolio that consists of $130 million of 15-year, 5.5 percent coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices when market yields change immediately by ± 0.10 percent? a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? b-1. The duration of these bonds is 10.5896 years. What are the predicted bond prices in each of the four cases...

HHK Inc. has an asset portfolio that consists of $220 million of 15-year, 7 percent coupon,...

HHK Inc. has an asset portfolio that consists of $220 million of 15-year, 7 percent coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices when market yields change immediately by ± 0.10 percent? a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? b-1. The duration of these bonds is 9.7455 years. What are the predicted bond prices in each of the four cases...

Problem 3-40 (LG 3-4, LG 3-6) MLK Bank has an asset portfolio that consists of $120...

Problem 3-40 (LG 3-4, LG 3-6) MLK Bank has an asset portfolio that consists of $120 million of 15-year, 12 percent coupon, $1,000 bonds with annual coupon payments that sell at par. a-1. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? b-1. The duration of these bonds is 7.6282 years. What are the predicted bond prices...

A bank invested $50 million in a one-year asset paying 10 percent interest per year and...

A bank invested $50 million in a one-year asset paying 10 percent interest per year and simultaneously issued a $50 million, two-year liability paying 8 percent interest per year to pay for it. • Is the bank short funded or long funded? • What is the bank’s net interest income in year one • What will be the bank’s net interest income in year two if at the end of the first year all interest rates have decreased by 1.5...

Question