Assume that you are valuing a swap contract with terms as stated in the provided template in the "swap information" section.

1. Complete the floating rate portion of the swap template by calculating the values of the missing cells (in pink highlight).
2. Once you have completed the columns, show formula for the sum of column I in cell I21, and formula for the sum of column J in J21 (orange highlight). Then, calculate the fixed rate in column I22 (orange highlight) using the formula from the lecture notes.
3. Using the fixed rate, complete columns K and L (yellow highlight) with the calculation of the fixed cash flows and the present value of the fixed cash flows.
4. Finally, show formula for the sum of column L (present value of the fixed cash flows) in cell L21. This answer should be the same as the value in Cell I21. Why? Please answer this question in Cell A23.

wap Information Term 3 years Period? Quarterly Start Date 1/1/16 and Date 12/31/17 otiona $100,000,000 Reference Rate -month LIBOR Current 3- Start Date End Date Number of Days in Quarter month LIBOR Futures Rate Futures Rate Floating Cash annual) Quarterly) Discount FactofFlow Present Value of Discount Factor * (annual) Floating Cash Flow Days/360 * Notional Fixed Cash Flow Present Value of Cash Flow 1/1/16 3/31/16 91 2.00% 0.51% 0.994969875 $505,555.56 $503,012.55 $25,150,627.38 4/1/16 6/30/16 91 2.10% 7/1/16 9/30/16 92 2.20% 10/1/16 12/31/16 2.50% 1/1/17 3/31/17 2.70% 4/1/17 6/30/17 3.00% 7/1/17 9/30/17 3.10% 10/1/17 12/31/17 3.30% Totals Fixed Rate Answer to Question 4