Shows the payments and receipts of both parties

Assignment Help Financial Management

Reference no: EM131932327

Prepare a spreadsheet that shows the payments and receipts of BOTH parties, for the swap and for the position on their books, and for BOTH interest rate scenarios.

Two parties enter into a swap with the following parameters:

Term/Tenor 3 years

Fixed Rate: 3.00%

Floating rate: 3-month LIBOR

Payment Frequency: 2 (semi-annually)

Notional Amount: $50,000,000

LIBOR at initiation: 2.00%

LIBOR in future:

1. assume LIBOR increases by 0.20% (20 bp) every 6 months

2. assume LIBOR decreases by 0.20% (20 bp) every 6 months

Party A is the fixed rate payer. A’s books show it has borrowed using a floating rate note in the amount of $50,000,000 with interest at 3-month LIBOR. The proceeds are invested in a fixed rate asset that pays a fixed rate of 3.50%

Party B is the floating rate payer. B’s books show it has a floating rate investment in the amount of $50,000,000 that pays 3-month LIBOR but is funded by fixed rate debt at 2.50%.

Reference no: EM131932327

Questions Cloud

Considering expansion of their data storage system : Google is considering an expansion of their data storage system, What do you recommend the CFO propose to the company's Board of Directors?

Represent the number of underinflated tires on an automobile : Which of the following p(x) functions specifies a legitimate distribution for x, and why are the other two not legitimate?

What are possibilities that the residents will ever achieve : If Manila disrupts this squatter settlement, what are possibilities that these residents will ever achieve quality of life they appreciate in North Cemetery?

Describe your career goals in the social work profession : Please discuss your interest in entering the social work profession. Describe your career goals in the social work profession.

Shows the payments and receipts of both parties : Prepare a spreadsheet that shows the payments and receipts of BOTH parties, for swap and for the position on their books and for BOTH interest rate scenarios.

How the movie supported or refuted stereotypes : Provide a brief overview of the plot of the movie and the scenes that are pertinent to the special population. Explain how the movie supported or refuted.

Identify an environmental controversy : Writer a chance to receive feedback on the paper and make revisions in anticipation of the final draft submission - identify an environmental controversy

Create a flyer representing your research topic : CIS 112 Final Project - You will do research on the location and will create a flyer in MS Word, a worksheet and charts in MS Excel

Differences between common stock and preferred stock : Outline the differences between common stock and preferred stock? What are the differences between capital projects that are independent, mutually exclusive,

User Account

All Pages