Complete the following problems in Excel and upload into Coursework as an Excel spreadsheet titled "Your Name" Chapter 6 Homework. 1. Calculate the present value of an 8-year bond with a 6.5% coupon. The interest rate is 9.5%. 2. Suppose that the market interest rate is 6% and then drops overnight to 3%. Calculate the present values of the 4%, 4-year bond and of the 4%, 25-year bond both before and after this change in interest rates. Assume annual coupon payments. 3. A 4-year maturity bond with a 11.7% coupon rate can be bought for $1,150. What is the yield to maturity if the coupon is paid annually? What is it is paid semiannually