Question: 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

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%

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!

On September 15th, 2013, ABC bank entered into a 2-year currency swap contract with GV Manufacturing, paying Euro fixed 6% and receiving USD floating with notional principal of $133 million and ?100....

Please show all below calculations in Excel. 1: Pricing Interest Rate Swap A. Price a plain vanilla one-year interest rate swap with quarterly settlements and $100 million notional principal. The...

Q 1: Pricing Interest Rate Swap A. Price a plain vanilla one-year interest rate swap with quarterly settlements and $100 million notional principal. The current term structure of LIBOR is given in...

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: L 0 (180) = 5.85% L 0 (360)...

Q 1: Pricing Interest Rate Swap A. Price a plain vanilla one-year interest rate swap with quarterly settlements and $100 million notional principal. The current term structure of LIBOR is given in...

Finance: Investment Analysis and Portfolio Management SHOW YOUR WORK. 1. You wish to hedge 90 percent of the current portfolio value with futures. The value of the portfolio is $ 50 million and...

Download Toro's annual report from the activities folder and try questions 1-2. What is the balance-sheet based accrual ratio of Toro for the year of 2011? Note that total debts should include debts,...

A leading skin care business is expanding into the cosmetics market. It is attempting to use the same methods from the 1980s, when it first launched its business for today's market. Design a new...

A box contains a total of 100 coins of 1 rupee, 50 p and 25 p denominations. Find the total number of coins of 25 p if there are a total of 49 rupees in the bag and it is known that the number of 25...

6. One requirement for becoming a CPA is to pass the: a. Final CPA Examination. b. SEC Accounting Examination. c. Uniform CPA Exam. d. State Board Examination.

Answer all questions below with specific examples about the Industry Expert Panel (related to Career talk) Reporting or Recalling What do you think was the most valuable advice that was offered...

4.5 Explain the difference between ajob description and ajob specification.

5. In what ways maythe transfer of some HR functions to work group supervisors improve the efficiency of the HR division? In what ways may work group supervisors be advantaged or disadvantaged by the...

2. Why have the HR and training divisions built quite different database systems? What are the difficulties involved in integrating the functions of these divisions? Jack Newman had recently been...