Question

MLK Bank has an asset portfolio that consists of $160 million of 15-year, 8.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 byt2.00 percent? b-1. The duration of these bonds is 9.0101 years. What are the predicted bond prices in each of the four cases using the duration rule? b-2. What is the amount of error between the duration prediction and the actual market values? Complete this question by entering your answers in the tabs below Required A1 Required A2 Required B1Required B2 What is the amount of error between the duration prediction and the actual market values? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Amount of Error At + 0.10% At-0.10% At + 2.0% At-2.0% (0.05) (0.05) (18.21) (21.97) Required B1 Required B2

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The actual bond prices have been calculated using the PV function in EXCEL

the predicted bond prices have been calculated as follows:

as per duration rule:

% change in bond's price due to change in yield , p= -m*y

where m = modified duration y = change in yield to maturity of bond

predicted bond price = (1+p)*initial bond price

initial bond price = face value since bond sells at par initially

amount of error = actual bond price - predicted bond price

1 time to maturity 2 coupon rate 3 duration 4 convexity 5 yield to maturity 6 par value 7 coupon value 8 modified duration 9 current price 10 a-1) 11 new YTM 12 change in ytm 13 new bond price 14 a-2) 15 new YTM 16 change in ytm 17 new bond price 18 b-1) 19 YTM 20 % change in price 21 predicted bond price 22 b-2) 23 at +0.1% 24 at-0.1% 25 At +2% 26 At-296 15 0.085 9.0101 161.2 0.085 1000 85 8.304239631 1000.00 0.086 0.001 991.75 0.084 0.001 1008.35 0.105 0.02 852.12 0.065 0.02 1188.05 0.086 -0.00830424 991.70 amount of error 0.05 0.05 18.21 21.97 0.065 0.00830424 -0.1660848 0.16608479 1166.08 0.084 0.105 1008.30 833.92

1 time to maturity 2 coupon rate 3 duration 4 convexity 5 yield to maturity 6 par value 7 coupon value 8 modified duration 9 current price 10 a-1) 11 new YTM 12 change in ytm 13 new bond price 14 a-2) 15 new YTM 16 change in ytm 17 new bond price 18 b-1) 19 YTM 20 % change in price 21 predicted bond price 22 b-2) 23 at +0.1% 24 at-0.1% 25 At +2% 26 At-296 15 0.085 9.0101 161.2 0.085 1000 B6 B2 B3/(1+B5) -PV(B5,B1,B7,B6) B5+0.001 B5-0.001 -C11-$BS5 --PV(C11,ŞB$1,ŞB$7,$B$6) B11-SB$5 --PV(B11,ŞB$1,ŞB$7,$B$6) SB$5+0.02 B15-$B$5 B5-0.02 -C15-$BS5 B11 -C11 B8 C12 (1+C20) *SB$9 -C15 --$B$8*B12 1+B20) SB$9 -B15 -B8 B16 (1+D20)*$B$9(1+E20) *SB$9 E-B8 C16 amount of error B13-B21 -C13-C21 B17-D21 -C17-E21

Add a comment
Know the answer?
Add Answer to:
MLK Bank has an asset portfolio that consists of $160 million of 15-year, 8.5 percent coupon,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • MLK Bank has an asset portfolio that consists of $160 million of 15-year, 8.5 percent coupon,...

    MLK Bank has an asset portfolio that consists of $160 million of 15-year, 8.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? At +0.10 At -0.10 a-2. What will be the new prices if market yields change immediately by ± 2.00 percent? At +2.0 at -2.0 b-1. The duration of these bonds is 9.0101 years. What are the predicted...

  • MLK Bank has an asset portfolio that consists of $240 milion of 15-year, 9-percent-ooupon, $1,000...

    MLK Bank has an asset portfolio that consists of $240 milion of 15-year, 9-percent-ooupon, $1,000 bonds with annual coupon payments that sell at par 0.10 peroent? (Do not a-1. What will be the bonds' new prices if market yields change immediately by round intermediate calculations. Round your answers to 2 decimal places. (e-g. 32.16) At+0.10% At-0.10% a-2. What will be the new prices if market yields change immediately by t 2.00 percent? (Do not round intermediate calculations. Round your answers...

  • 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. b-1. The duration of these bonds is 9.4892 years. What are the predicted bond prices in each of the four cases using the duration rule? (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%        At + 2.0%        At −...

  • A 33-year maturity bond making annual coupon payments with a coupon rate of 15% has duration of 10.8 years and convexity of 1916 . The bond currently sells at a yield to maturity of 8% Required (a) F...

    A 33-year maturity bond making annual coupon payments with a coupon rate of 15% has duration of 10.8 years and convexity of 1916 . The bond currently sells at a yield to maturity of 8% Required (a) Find the price of the bond if its yield to maturity falls to 7% or rises to 9%. (Round your answers to 2 decimal places. Omit the "$" sign in your response.) Yield to maturity of 7% Yield to maturity of 9% (b)...

  • An insurance company issued a $94 million one year, zero-coupon note at 9 percent add-on annual...

    An insurance company issued a $94 million one year, zero-coupon note at 9 percent add-on annual interest (paying one coupon at the end of the year) and used the proceeds plus $14 million in equity to fund a $108 million face value, two-year commercial loan at 11 percent annual interest. Immediately after these transactions were simultaneously undertaken, all interest rates went up 19 percent a. What is the market value of the insurance company's loan investment after the changes in...

  • Q3. Follow Bank has a S1 million position in a five-year, zero-coupon bond with a face...

    Q3. Follow Bank has a S1 million position in a five-year, zero-coupon bond with a face value of $1,402,552. The bond is trading at a yield to maturity of 7.00 percent. The historical mean change in daily yields is 0.0 percent and the standard deviation is 12 basis points a. What is the modified duration of the bond? What is the maximum adverse daily yield move given that we desire no more than a 5 percent chance that yield changes...

  • An Fl has a $290 million asset portfolio that has an average duration of 8.0 years....

    An Fl has a $290 million asset portfolio that has an average duration of 8.0 years. The average duration of its $250 million in liabilities is 6.6 years. Assets and liabilities are yielding 9 percent. The Fl uses put options on T-bonds to hedge against unexpected interest rate increases. The average delta (d) of the put options has been estimated at -0.1 and the average duration of the T-bonds is 8.5 years. The current market value of the T-bonds is...

  • 6. An Fl has a $270 million asset portfolio that has an average duration of 7.8...

    6. An Fl has a $270 million asset portfolio that has an average duration of 7.8 years. The average duration of its $230 million in liabilities is 4.6 years. Assets and liabilities are yielding 15 percent. The Fl uses put options on T-bonds to hedge against unexpected interest ate increases. The average delta (5) of the put options has been estimated at -0.3 and the average duration of the T-bonds is 8.3 years. The current market value of the T-bonds...

  • An Fl has a $290 million asset portfolio that has an average duration of 8.0 years....

    An Fl has a $290 million asset portfolio that has an average duration of 8.0 years. The average duration of its $250 million in liabilities is 6.6 years. Assets and liabilities are yielding 9 percent. The Fl uses put options on T-bonds to hedge against unexpected interest rate increases. The average delta (ö) of the put options has been estimated at -0.1 and the average duration of the T-bonds is 8.5 years. The current market value of the T-bonds is...

  • Problem 6-15 (LG 6-2) A $1,800 face value corporate bond with a 5.7 percent coupon (paid...

    Problem 6-15 (LG 6-2) A $1,800 face value corporate bond with a 5.7 percent coupon (paid semiannually) has 14 years left to maturity. It has had a credit rating of BBB and a yield to maturity of 6.2 percent. The firm has recently gotten into some trouble and the rating agency is downgrading the bonds to BB. The new appropriate discount rate will be 73 percent. What will be the change in the bond's price in dollars and percentage terms?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT