0 x A bond trader purchased each of the following bonds at a yield to maturity of 10%. Immediately when she purchased the bones, totes Tell to 5%. The data has been collected in the Microsoft Excel Online below. Open the spreadsheet and perform the required ways to answer the questions below Open spreadsheet What is the percentage change in the price of each bond after the decline interest rates Assume annual coupons and annual compounding Fill in the following table. Do not round Intermediate calculations. Round your answers to two decimal places Price 10% Price 5% Percentage Change $ 10-year, 10% coupon 10-year zoro 5-year caro 30-year zero $100 perpetuity Check My Work Psobim Black A Interest Rate My c D 10.00% 5.00% 10-year zarb coupon bond 10 10.00% $100000 Maturity em, N Coupon rate Par value, FV PMT 10 0.00% 31,000.00 $0.00 Original told to maturity a Changed yold to maluty immediately after purchas 5 6 10 y 10 annual coupon bond 7 Maturity term, N 8 Coupon rate 9 Par value, FV 10 PM 11 12 Original price 13 Price with changed sold to maturity 14 Percentage change 15 10 Formulas 17 PMT 18 Original pro SUO 19 Price with changed yield to maturity 20 Percentage change Original posts Price with changed yield to maturity Percentage change Formu NA ONIA NIA INTA NA Original price at Price with changed you to maturity Porcentage change SOA NA A C D F G H 1 Coupon rate Par value, FV PMT 0.00% $1.000.00 $0.00 Coupon rate Par, FV PMT 6.00 $1,000,00 5000 Original print Prion with changed yuld to maturity Percentage change NA WNIA NA INA Formulas Original price at Prion with changed yaad to my Percentage change WA Ongina price at Price with changed yold to maturity Percentage change 1 2 Formulas 3 Original price at Price with changed yold to mananty 35 Percentage change 36 32 Perpetuity 5100 anys coupon 38 Arm coupon 39 40 Original prication 11 Pron with changed to mounty 12 Percoriage change 3 $100 Sheet 230 er