Please use EXCEL to do it

Show your answers along with the formula and steps you used for each question Table 1.en January 1,2019 LIBOR so Im days) Problem 3: On January 1, 2019,a US-based lender wishes to hedge against decrease n future interest rates. The lender proposes to hedge against this risk by entering into an FRA with the notional amount of S10 million Use 30/360 day ceent coav ention nd simple interest rate 540% 530% s 20% 510% A) An 360 Table I has spot LIBOR rates for maturities ranging freem 30 days to 360 days announced by the British Bankers Asseciation (BBA) en January 1,2019 Table 2. on February 15,2019 A) Indicate whether the manager should take a long or short FRA in seder to fully hedge interest rate risk and why? (2 points) 1) Cakine the price of this 3X12 FRA today. (2 Psints) C) Caelale the price of this 3X6 FRA oday 2 poins) 135 315 ) Ans: Suppose 45 days later on February 15, 2019, interest rates have decreased Table 2 has spot LIBOR ales for maturities ranging froem 45 days to 315 days announced by the British Banker's Association (BBA) on February 15, 2019 D) Suppose the manager enicred into 3X12 FRA at the price computed in (B). Calculate the value of this 3X12 FRA at this point. (2 points) E) At expiration, the 270-day LIBORs 4 5% Calculate the payoff en this 3X12 FRA. (2 points) D) Ans