24-12. Please see the attached. I need the answers and associated excel formulas. Thank you.

Problem 24-12 Boeing Corporation has just issued a callable (at par) three-year, 5% coupon bond with sem annual coupon payments. The bond can be called at par in two years or anytime thereafter o coupon payment date. It has a price of $99. What is the bond's yield to maturity and yield to call? Coupon rate Payment frequency Time until first call date (years) Term of bond (years) Call price Current price 5.00% Semi-annually 2 3 $100.00 $99.00 Coupon payment Yield to call Yield to maturity Requirements 1. 2. In cell D13, by using cell references, calculate the semi-annual coupon payment (1 pt To calculate the yield to call of the bond, use the function RATE. In cell D14, by usin function RATE and cell references, calculate the yield to call of the bond (1 pt.). 3. To calculate the yield to maturity of the bond, use the function RATE. In cell D15, by using the function RATE and cell references, calculate the yield to maturity of the bo pt.). oupon bond with semir anytime thereafter on a o maturity and yield to coupon payment (1 pt.). E. In cell D14, by using the f the bond (1 pt.). RATE. In cell D15, by d to maturity of the bond (1