How can I solve this using the what if analysis on excel? I highlight the table and then what do I select for the row and columns? What are the exact steps to take to solve for this problem?

Alejardro Guizr Flc Home nsert Poge Layout Fcrmu asREv Vw Hep owwer Piworscarch Share Comments Insert Delete formst Sort & TindIdess inked Cell Mery. &Carter . ormst Psmter Furmalling-Tab 0 50 NON ANSWER THE FOLLOWING NEW QUESTIONS 52 e. How would the price of the bond be affected by changing the going market interest rate? (Hint: Conduct a sensitivity 53 analysis of price to changes in the going market interest rate for the bond. Assume that the bond will be called if and 54 only if the going rate of interest falls below the coupon rate. That is an oversimplification, but assume it anyway for 55 purposes of this problem.) 57 Nominal market rate, r 58 Value of bond if it's not called 8% $1,000.00 $1,027.02 59 Value of bond if it's called: The bond would not be called unless r