Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Acme Corporation enters into a 5-year, $1,000,000 term loan with JP Morgan bank on January 1, 2020. JP Morgan is the lead with 40% and

Acme Corporation enters into a 5-year, $1,000,000 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 month term SOFR plus a spread, which is based on the companys credit rating. The spread ranges from 300 BPS to 400 BPS. 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 due 3/31/2020 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

$100,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 Acmes credit ratings are as follows (Note that 3-month Term SOFR is prospective).

1/1/2020 = 2%; Credit rating = BBB+

3/31/2020 = 2.5%; Credit rating = BBB+

6/30/2020 = 3%; Credit rating = BBB

9/30/2020 = 3.5%; Credit rating = BBB-

12/31/2020 = 4.0%; Credit rating = BBB-

3 month LIBOR is projected to increase, so if youre bullish on interest rates, youd 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. Acmes spread changes with the credit rating.

First principal payment is due in 6 months. Underlying calculation changes, as well as the amortizing notional swap. THIS IS THE FIRST PAGE ABOVE^ SCREENSHOT IS THE SECONDimage text in transcribed

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 1,000,000,000 b. 6/30/2020 1,000,000,000 c. 9/30/2020 1,000,000,000 d. 12/31/2020 1,000,000,000 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 1,000,000,000 b. 6/30/2020 1,000,000,000 c. 9/30/2020 1,000,000,000 d. 12/31/2020 1,000,000,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Technical Analysis Of The Financial Markets

Authors: John J. Murphy

1st Edition

0735200661, 978-0735200661

More Books

Students also viewed these Finance questions

Question

Eliminate street slang.

Answered: 1 week ago

Question

Why has Negotiating Women, Inc. focused its attention on women?

Answered: 1 week ago