Task  In this assignment, you will solve problems about Interest Rate Futures, F

Photo of author

By admin

Task 
In this assignment, you will solve problems about Interest Rate Futures, Forwards, and Swaps.
Instructions 
Use your textbook to answer the following questions from Chapter 23:
Exercise 16 and 17. 
Please, upload xls, xlsx file.
Please, use the full computing power of Excel.
 
16.    Two firms X and Y are able to borrow funds as follows:
A: Fixed-rate funding at 4% and floating rate at Libor − 1%.
B: Fixed-rate funding at 5% and floating rate at Libor + 1%.
Show how these two firms can both obtain cheaper financing using a swap. What swap
would you suggest to the two firms if you were an unbiased advisor?
17.    Firm A can borrow fixed rate at 10%. It can also borrow floating at Libor + 1%. The
market swap rate at the bid is Libor versus 8.9% and is Libor versus 9.1% at the ask
(i.e., the firm can enter into a swap by paying fixed at 9.1% or receiving at 8.9%). Find
the cheapest form of financing for the firm if it wishes to be in floating-rate debt.