Please solve the parts and yellow and explain what EXCEL Functions were used to solved the problems.

Bond 1Bond 2 Bond 3 2 Price 3Face Value $900.00 $1,100.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 9.00% 7.00% 10.00% Coupon Rate 5 Frequency 6 Maturity (Years) 7 Required 8 Call Premium % 3 Years to first call 15 9.00% 3.00% 20 8.00% 4.00% 30 9.00% 5.00% 11a) Determine the highest price you would be willing to pay for each of 2 these bonds using the PV function. Also find whether the bond is 13 Value 14 UnderlOver Valued 16 b) Determine the yield to maturity on these bonds using the RATE function 17 assuming that you purchase them at the given price. Also calculatet 8 Yield to Maturity he Current Yield 21 c) Determine the yield to call of each bond using the RATE function(both 22 the time to first call and the call premium are provided in the 1st table 23 Yield to Call 24 25 d) Assume the following settlement dates for each bo Bond 1 Bond Bond 3 27 Settlement Date 28 Maturity Date 23 Call Date 111201861112018 91112018 112033 61112038 91112048 112023 61112022 g112021 30 ? Use the PRICE and YIELD functions to recalculate your answers on parts(a), (b), and(c): 31 Value 32 nderlOver Valued 33 Yield to Maturity 34 Current Yield 35 Yield to Call 37 e) Determine the duration and the modified duration for each bond 38 Duration 39 Modified Duration