Prepare a spreadsheet that shows payments and receipts

Assignment Help Financial Management

Reference no: EM131930539

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

Questions Cloud

Increase the operating cycle : Identify which of the following will increase the operating cycle.

Experiences of consumer decision-making : Critically reflect on the role that 'ethics' play in your everyday experiences of consumer decision-making.

What are your views on the targeting of products : What are your views on the targeting of products to children in todays world - discuss the issue of targeting to children fron two perspectives

What law applies : What law applies? What are the most important facts? How do the facts prove the elements of the law? What is your conclusion about the case

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

What is the after-tax salvage value : ABC Company purchased $89,196 of equipment 5 years ago. The equipment is 7-year MACRS property. The firm is selling this equipment today for $8,897.

Private sector entities seeking government contracts : This attracts private sector entities seeking government contracts. Isn't this a good thing? Don't we want to provide incentive for new innovation?

What is the annual operating cash flow : ABC Company is considering a new project. The project is expected to generate annual sales of $75, 275, variable costs of $26, 275, and fixed costs of $13, 947.

Write a review on the movie The Big Short : Write a review on the movie "The Big Short". It's a finance assignment, so your review should focus more on finance perspective and not from English perspective

User Account

All Pages