Problems. Round all amounts to 2 decimal places needed. This includes percentages which means you will need 4 decimal places in your calculator if using a calculator). There are 6 problems, some with multiple parts. Note which question you are answering on your Excel document or paper that you are planning to submit. Problem #1. (12 points.) Broadside Markets has a 5.5% coupon bond outstanding that matures in 6 years. The bond pays interest semiannually. a. What is the value of this bond if the face value is $1,000 and the yield to maturity is 4.5%? b. What is the value of the bond if the yield to maturity is now 6.5%? c. What is the value of the bond if the yield to maturity is now 5.5%? d. Describe thoroughly the relationships that we discussed in class which explain why the bond value changes in a, b, &c above