need asap

Acme Corporation 51.000.000.000 Term B Debt Acme Corporation enters into a 5 year term loan with JP Morgan bank on January 1, 2020. IP Morgan is the lead with 40% and has syndicated the remaining 60% with PNC, Wells Fargo and Deutsche at 20% each Loan Interest is calculated quarterly and is based on 3 month LIBOR plus a spread, which is based on the company's credit rating. The spread ranges from 300 BPS to 400 BPS. IT Acme is rated BBB+ or better, the spread is 300 BPS. It is rated less than 38B+, the spread is 400 BPS. Loan interest is calculated ACT/360 with the first payment due 3/31/20020 and subsequent quarterly payments on the last day of each quarter. Principal payments are based on the follow schedule: $50,000,000 due 6 months post inception 3100,000,000 due 12 months post inception 5200,000,000 due 24 months post inception $250,000,000 due 48 months post inception 1400.000.000 due 60 months post inception $1,000,000,000 Total $200,000,000 due 24 months post inception 5250,000,000 due 48 months post inception 5400.000.000 due 60 months post inception $1,000,000,000 Total 3 month LIBOR resets as follows: 1/1/20202 3/31/2020 - 2.5% 5/30/2020 - 35 9/30/2020 - 3.5 Provide your observations regarding the above underlying loan from what we discussed in class. What are your thoughts on an interest rate swap? Calculate the all-in interest rate and payment due for each quarter end in FY 2020. There are 4 total. Make sure to pay attention to the schedules. On 6/30/2020 you enter into a floating-for-fixed interest rate swap with KeyBank and the swap term begins the same day. Your mid-market fixed rate is 3% all-in. What are the swap cash flows between KeyBank and Acme on 9/30/2020? Is Acme at-the-money, in-the-money or out-of- the money on the swap? What are the swap cash flows between KeyBank and Acme on 12/31/2020? Is Acme at-the-money, in-the-money or out-of- the money on the swap