Acme Corporation \$1,000,000,000 Term B Debt (Floating) Acme Corporation enters into a 5 year term loan with JP Morgan bank on January 1, 2020, JP 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 moath SOFR plus a spread, which is based on the company's credit rating. The spread ranges from 300BPS to 400BPS. If Acme is rated BBB+ or better, the spread is 300 BPS. If it is rated less than BBB+, the spread is 400 BPS. Loan interest is calculated ACT 360 with the first payment doe 3/31/2020 and subsequent qaarterly payments on the last day of each quarter. Principal payments are based on the follow schedule: $50,000,000 due 6 months post inception 5100,000,000 due 12 months post inception $200,000,000 due 24 months post inception $250,000,000 due 48 months post inception $400,000,000 due 60 months post inception $1,000,000,000 Total 3 month Term SOFR and Acme's credit ratings are as follows (Note that 3 menth Term SOFR is prospective). 1/1/2020=2%;Creditrating=BBB+3/31/2020=2.5%;Creditrating=BBB+6/30/2020=3%;Creditrating=BBB9/30/20203.5%;Creditrating=BBB-9/30/2020=4.0%;Creditrating=BBB- 3 month L.IBOR is projected to increase, so if you're bullish on interest rates, you'd enter into a floating to fixed rate interest swap. Interest rate and principal payments are made to JPM as lead and syndicated to Wells, PNC and Deutsche. Acme's spread changes with the credit rating. First principal payment is due in 6 months. Underlying calculation changes, as well as the amortixing notional swap. Swap On 1/1/2020, concurrent with the execution of the Term Debt, you enter into a $1,000,000,000 amortizing notional floating-for-fixed interest rate swap with KeyBank and the swap term begins the same day. Your mid-market fixed rate is 2.0%, and the first swap transaction using this rate will occur on 3/31/2020. 1. Calculate the debt service (principal and interest) for the underlying term loan for the following dates. Please calculate the pro rate debt service amount due each bank participating in the syndication. a. 3/31/2020 b. 6/30/2020 c. 9/30/2020 d. 12/31/2020 2. Calculate the swap fixed and floating cash flows that Acme owes Key and Key owes Acme for the following dates: a. 3/31/2020 b. 6/30/2020 c. 9/30/2020 d. 12/31/2020