Bond Valuation Assume that a 10-year, 2.5% annual coupon bond with semiannual (two periods per year) payments has a par value of $1,000. Assume the bond can be called at the five-year mark (i.e., in 5 years) at a call price of $1,100. The bond currently sells for $950. Employ the Excel file to answer the following questions: Part 2: Relation between Bond Value and Market Interest Rate F) Assume the current annual market rate is 5% and the periodic market rate is half of the market rate. Use the Excel PV function to calculate the present value of the noncallable bond. Note for the PV function, a negative sign should be placed on both the payment and future value. (7 Points) G) Assume the current annual market rate is 5% and the periodic market rate is half of the market rate. Use the Excel PV function to calculate the present value of the callable bond. Note for the PV function, a negative sign should be placed on both the payment and future value. (7 Points) H) Calculate present values under different interest rates for the noncallable and callable bond tables. Use the Excel PV function to calculate bond present values. (7 points) 1) Copy present values from the previous step into the table and fill in the table. A bond will only be called if it is cheaper for the issuer (i.e., if PV Noncallable - PV callable is positive). Actual present value depends on whether the bond is called or not (i.e., actual present value will equal to the PV of a callable bond, only if it will be called) (7 Points)