Please answer using excel, and showing the excel functions/equations.

11. Valuing Callable Bonds Williams Industries has decided to borrow money by issuing perpetual bonds with a coupon rate of 6.5 percent, payable annually, and a par value of $1,000. The 1-year interest rate is 6.5 percent. Next year, there is a 35 percent probability that interest rates will increase to 8 percent and a 65 percent probability that they will fall to 5 percent a. What will the market value of these bonds be if they are noncallable? b. If the company decides instead to make the bonds callable in one year, what coupon will be demanded by the bondholders for the bonds to sell at par? Assume that the bonds will be called if interest rates fall and that the call premium is equal to the annual coupon. c. What will be the value of the call provision to the company