Last trade yield and last trade price are the two problems that needs to be solve. Subject is finance

21 DEB Copy Times New Ro - 14 - A A Aa AaBbCcDc AaBbCCDc AaB AaBbCi AaBb( AaBbCcI AaBbCCD aste B Heading 1 Heading 2 Title Subtitle Subtle Em. Format Painter I U . abe X x A - Z- A 1 Normal No Spac.. Clipboard Font Paragraph A B C D E F G H K M N O P Problem Two BOND A: Zebra Inc Let's assume that we observe the following two bonds issued by Zebra Inc. - Coupon Rate Payment Frequency 5.120% Semi-Annual 1) Compute the missing value (either Price, or Yield) for bonds A and B, respectively. Maturity Date Credit Rating Callable 5/25/2043 AA No 8 2) If the market-driven yields for all bonds rise 1.50 percentage along with US market interest 10 rate level, will these two bonds' prices rise or drop? What will be the rates of return (i.e., % Last Trade Price Last Trade Yield Last Trade Date gain or loss) for the prices of Bonds A and B, respectively? ?????? (relative to par 100) 4.725% 10/1/2020 12 13 14 3) If the market-driven yields for all bonds drop 1.50 percentage along with US market interest 15 rate level, will these two bonds' prices rise or drop? What will be the rates of return (i.e., % 16 gain or loss) for the prices of Bonds A and B, respectively? 17 BOND B: Zebra Inc 18 19 4) Out of these two bonds A and B, which one carries a greater interest rate risk? What specific bond feature(s) could have caused this bond to carry a greater interest rate risk? If Coupon Rate Payment Frequency you become uncertain about the future movement direction of US market interest rate (Le., 7.350% Semi-Annual 20 unsure whether the interest rate will rise or fall in the future), what investment strategy shall 22 you undertake about these two bonds? 23 Maturity Date Credit Rating Callable 9/10/2033 24 AA No 25 (PS: To answer the above questions, you are required to apply Excel finance functions such as Last Trade Price 26 -PRICE and =YIELD whenever applicable. Or there will be heavy deductions for failing to show Last Trade Yield Last Trade Date 132.60 (relative to par 100) ?????? 27 me such required learnings.).) 10/5/2020 28 29 30 31 32 33 34 35 36