Will like and thumbs up when answered! Thank you for the help!

Datasheet Maturity" Requirement 1 - In the Illustration of Cash Flow" part, input the cash flow payoffs for bonds with different maturities. List the cash flows in the column. Cash flows for different bonds should be in different columns. Requirement 2- In the Dynamics of Prices part, input the prices of bonds with different maturities under different market interest rates. Make sure the formula of bond price is correctly set up. Requirement 3 - Use the data from the Dynamics of Prices" section to draw a graph of bond price against the market interest rates for bonds with different maturities. Requirement 4 - Offer interpretation of data analysis results. Answer the questions at the end of each worksheet. C D J N 0 F Q K L M Dynamics of Prices 2 3 A B Bond Terms: Coupon Rate Par 5.12%. 1000 E F G H 1 Illustration of Cash Flow Time to Maturity Time 1-Year 30-Year 5-Year 10-Year 1 Time to Maturity 30-Year 5-Year 10-Year 20-Year 4 20-Year 1-Year 5 WN - 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Interst Rate 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% 9.00% 9.50% 10.00% 10.50% 11.00% 11.50% 12.00% 12.50% 13.00% 13.507 14.00% 14.50% 15.00% 15.50% 16.00% 16.50% 17.00% 17.50% 18.00% 18.50% 19.00% 19.50% 20.00% 41 42 43 44 45 46 47 48 49 Please finish the sentence or answer the questions: Observation on the maturity on the interest rate risk (read p. 169 bottom and type in the ansver) Asnenisse/unerarij. wowstuksepte woningin when buning sabon 50 51 52 53 54 55 56 All other things being equal.... 1. For the otherwise similar bonds except maturity, which bond has greater interest rate risk? 20-year or 30-year? 2. When market interest rate increases which bond will have greater price decrease, 10-year or 20-year? 3. When market interest rate decreases which bond will have greater price increase 5-year or 10-year