Please answer using formulas for Excel

55 e. How would the price of the bond be affected by changing the going market interest rate? (Hint: Conduct a 56 sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that the bond will 57 be called if and only if the going rate of interest falls below the coupon rate. That is an oversimplification, but 58 assume it anyway for purposes of this problem.) 59 60 Nominal market rate, r: 8% 61 Value of bond if it's not called: 62 Value of bond if it's called: The bond would not be called unless r