Module Two Homework Template - Excel Insert View Review = > Cut E Copy Format Painter Clipboard Paste Tell me what you want to do Wrap Text General Merge & Center - $ - % , Page Layout Formulas Data 10 AA = IU. . . A. Font P4-17 B & D E Conditional Format as Cel Formatting Table Style Styles Alignment Number X G IBC DE 15 points H MN No credit will be given if work is not shown Highlight or bold your answers. P4-17 3 You have gathered the following data on three bonds: Bond Maturity Coupon % A 10 yrs 9% B 9 yrs C 5 yrs 5% 8 a. If the market's required return on all three bonds is 6%, what are the market prices of the bonds (you can assume annual interest payments). (Show 9 your work. Label S. Two decimal places required.) 10 b. The market's required return suddenly rises to 7% What are the new bonds prices, and what is the percentage change in price for each bond? (Show 11 your work. Label 5 and %. Two decimal places required for 5 and one decimal place required for %.) 12 c. If the market's required return falls from the initial 6% to 5%, what are the new prices, and what is the percentage change in each price relative to the 13 answer obtained in part (a)? (Show your work. Label 5 and %. Two decimal places required for S and one decimal place required for