which bond would you rather own if you expect interest rates to fall by 2%

please show formulas

Financedsx-Excel Insert Page LayoutFormulas Times New Roma 12 A A B 1 u ,?? '? .LL, DataRevieViAdd-Ins XLMiner Platform Solver Home Tell me what you want to do.. Sign in Cut E Copy AutoSum A Fill Clearier Select Wrap Text $. % , ' :.s conditional Format as Cell Styles Paste Format Painter E FE E Merge & Certer Insert Delete format -.Clear Sort &Find & Fonmatting iTable Clipboard Font Cells You have been considering diversifying your portfolio by adding some bonds. Your choices have come down to these two bonds The question is which bond would you rather own if you expect interest rates to fall by 2% 7 10 12 13 Bond A Bond B 14 Redemption Vaue S1,000.00 S1.000.00 15 Coupon Rate 16 Frequency 17 Maturity (Ye 18 Required Return 19 20 Value 21 Current Yield 5.00% 7.00% 10.00% 10.00% 23 Settlement Date 24 Maturity Date 25 26 27 Duration 28 Modified Duration 12/15/2015 12/15/2015 8/15/2025 5/15/2035 30 31 Instructions Capital Budgeting Bond Valuations Regression Graphing StatisticsForecasting Ready