Read-Only] - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ACROBAT 06 Cut Calibri General BB Copy 11 A A Be Wrap Text Normal Bad Good Paste BIU- - DE Merge & Center % 00 30 Conditional Format as Check Cell Explanatory ... Input Format Painter Formatting Table Clipboard Font Alignment Number Styles K37 X V fx A B C D E F G H M N O BOND A: Zebra Inc W N Problem Two 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 CO - 5/25/2043 AA No 9 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 1 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 18 B: Zebra Inc 9 4) Out of these two bonds A and B, which one carries a greater interest rate risk? What 20 specific bond feature(s) could have caused this bond to carry a greater interest rate risk? If Coupon Rate Payment Frequency 21 you become uncertain about the future movement direction of US market interest rate (i.e- 7.350% Semi-Annual 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 AA No 25 (PS: To answer the above questions, you are required to apply Excel finance functions such as Last Trade Price Last Trade Yield Last Trade Date 26 -PRICE and =YIELD whenever applicable. Or there will be heavy deductions for failing to show 27 132.60 (relative to par 100) ?????? 10/5/2020 28 me such required learnings.).) 31 32 +