Bond valuationAnnual interest Calculate the value of the bond shown in the following table, assuming it pays interest annually. (Click on the icon here e in order to copy the contents of the data table below into Par value $100 Coupon interest rate Years to maturity Required return 15% 12 11% The value of the bond is $. (Round to the nearest cent.) data-9_24_2020-10_56 AM - Excel Team Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Add-ins If Calibri - 11 - AA Wrap Text General ET HH * Cut e Copy Format Painter FM BC Paste BIU 1 E Merge & Center $ - %, Y 6.000 .000 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells A1 X f Par value A E F G H 1 J L M N B C D 1 Par value Coupon interest rate Years to maturity Required return 2 15 121 11 3 100 4