please solve using excel and show formulas. thank you!

1. Price a plain vanilla one-year interest rate swap with semiannual settlements with a notional principal of $25 million. The current term structure of LIBOR is as follows: L0(180)=5.85%L0(360)=6.05% What is the semiannual fixed rate payment? What should the market value of the swap to the counterparties be 120 days later. The term structure of LIBOR 120 days later is as follows: L120(180)=6.13%L120(360)=6.29%