Question: please help solve using excel and show formulas! thank you! ABC bank has agreed to receive 3 month LIBOR and pay 8% per annum on

please help solve using excel and show formulas! thank you!

ABC bank has agreed to receive 3 month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5month, 8-month, and 11 -month, are 6.5%,7%,7.5%, and 8%, respectively. The 3 -month LIBOR rate at the last payment date was 6%. Estimate the value of the swap to ABC Bank by estimating the values of the floating leg and the fixed leg. Use the 30/360 day count method. A. The present value of the fixed leg? B. The present value of the floating leg? C. The value of the swap to ABC bank

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please show all below calculations in Excel. Q2:Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining...

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for...

Please show below with Excel calculations: Q2:Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining...

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of11 months. The LIBOR spot rates for...

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for...

I'm studying for a test and am not sure if I have the right answers to these problems. Practice Problems SWAPS 1. Company X wishes to borrow U.S. dollars at a fixed rate of interest. Company Y wishes...

1) Under the terms of an interest rate swap, a financial institution has agreed to pay 10% per annum and to receive 3-month LIBOR in return on a notional principal of $100 million with payments being...

Under the terms of an interest swap, a bank has agreed to pay 10% per annum and receive three-month LIBOR in return on a notional principal of $100 million with payments being exchanged every three...

Under the terms of an interest rate swap, a financial institution has agreed to pay 10% per annum (with quarterly compounding) and receive three-month LIBOR in return on a notional principal of $100...

Differential Amplifiers with Current Mirrors as Active Load and Bias [12 points] VDD ww Q R V -Val2 VI+ V HIIHII Q5 V3 Q3 1 V Q Q4 Q6 VI- -Vg/2 H|H|"" VB - Vo CL Fig. P3 Use "CD4007 NMOS devices (Vtn...

A steam radiator in a room at 25C has saturated water vapor at 110 kPa flowing through it, when the inlet and exit valves are closed. What is the pressure and the quality of the water, when it has...

What is the cash coverage ratio for 2 0 1 2 ? 7 . 4 8 9 . 1 8 1 1 . 1 8 3 3 . 2 2

Exercise 6.8. Prove Proposition 6.8. Proposition 6.8. In any equilibrium ol two-player game that is not degenerate, both players use mixed strategies that mix the same number of pure strategies

Do you actively seek criticism? How do you rate your ability to accept criticism? Do you get emotional and defensive? How can you improve your ability to accept criticism? After getting criticized,...

Discuss the role of digital information technology in this case as a medium of communication.

Looking at the communication process, describe at what step of the process you think H&M failed in their hoodie marketing campaign.