Scenario:

The upper management of AS Co. needs to borrow $50 million for twenty years. The bank that they normally work with makes the company a loan at a rate = SOFR + a 100 basis point credit spread, payable annually. AS Co wants to change their interest rate exposure, so the company enters into a 20 year swap with KY Inc.

Assumptions:

The fixed payer of the swap has a swap rate for all periods = 3.65507659%.

The fixed payer of the swap pays based on a 30/360 interest accrual.

The floating rate payer on the swap has a swap rate = 12 month SOFR + 0 bps.

The floating rate leg estimated future payments are based on the hypothetical forward SOFR curve (see "Swap Schedule" tab, column D).

The floating rate leg pays on the applicable forward rate for the given period and an ACTUAL 360 interest accrual method.

The swap has annual settlement periods with the first payment on 10/1/2023.

The Swap Schedule tab has been constructed from the perspective of the pay fixed swap payer (this is important when calculating the column J amounts).

Question:

a. Considering only its bank loan (i.e. prior to the swap), what is AS Co. interest rate exposure - ie is it fixed or floating?

b. When considering both the bank loan and the swap, what is AS Co. remaining or net interest rate exposure?

c. What is the effective interest rate that AS Co. pays when considering both its bank loan and it's interest rate swap?

d. In period/year 2, what is/are the payment amounts on the swap? Do both parties to the swap have to make payments? If so, why? If not, why not?

e. In period/year 12, what is/are the payment amounts on the swap? Do both parties to the swap have to make payments? If so, why? If not, why not?