Question

In: Finance

On March 3, XYZ Company borrows $10,000,000 for one year with interest paid quarterly at LIBOR...

On March 3, XYZ Company borrows $10,000,000 for one year with interest paid quarterly at LIBOR and also has a long position in an interest rate cap with an exercise rate of 9% for a premium of $50,000 in order to protect against rising interest rates. Given the following term structure, determine the effective cost of borrowing with and without the cap.

Date

Days in Period

LIBOR (%)

March 3

9

June 3

91

8

September 3

92

11

December 3

92

12

March 3

90

13

Solutions

Expert Solution

To calculate effective interest cost all we have to do is calculate interest in both cases i.e.
a) with cap

b) without a cap

Case a)

In case of cap interest rate maximum will be 9 %
which means period ending with
Month Actual % To be used %  

3 June 8 8
3 Sep 11 9
3 Dec 12 9
3 March 13 9

So final calculation will be

Principal $10,000,000
Premium $50,000
Interest June 3 $199,452
Interest sep 3 $226,849
Interest dec 3 $226,849
Interest march 3 $221,918
Total interest + premium $925,068
effective cost 9.251

case b) without a cap
In this case, actual % will be used and no premium will be paid

Month Actual % To be used %  

3 June 8 8
3 Sep 11 11
3 Dec 12 12
3 March 13 13

So final calculation will be

Principal $10,000,000
Premium $0
Interest June 3 $199,452
Interest sep 3 $277,260
Interest dec 3 $302,466
Interest march 3 $320,548
Total interest + premium $1,099,726
effective cost 10.997

Related Solutions

A. Company XYZ has just paid a dividend of $3. As XYZ is a young company...
A. Company XYZ has just paid a dividend of $3. As XYZ is a young company and successful, it is estimated that they will grow at rate of 20% for 5 years and then at 3% in perpetuity. The company faces a required return on equity of 7%. What is the current price of the company’s stock using the DDM model? Use excel for all calculations​
5) If a company borrows money from a bank, the interest paid on this load should...
5) If a company borrows money from a bank, the interest paid on this load should be reported on the statement of cash flows: A. Operating activity B. Investing activity C. Financing activity D. Noncash investing and financing activity E. This is not reported in the statement of cash flows. 6) The appropriate section in the statement of cash flows for reporting the purchase of land in exchange for common stock is: A. Operating activities B. Financing activities C. Investing...
A company borrows $110000, which will be paid back to the lender in one payment at...
A company borrows $110000, which will be paid back to the lender in one payment at the end of 8 years. The company agrees to pay yearly interest payments at the nominal annual rate of 7% compounded yearly. At the same time the company sets up a sinking fund in order to repay the loan at the end of 8 years. The sinking fund pays interest at an annual nominal interest rate of 11% compounded yearly. Find the total amount...
A company borrows $200000, which will be paid back to the lender in one payment at...
A company borrows $200000, which will be paid back to the lender in one payment at the end of 8 years. The company agrees to pay monthly interest payments at the nominal annual rate of 4% compounded monthly. At the same time the company sets up a sinking fund in order to repay the loan at the end of 8 years. The sinking fund pays interest at an annual nominal interest rate of 13% compounded monthly. Find the total amount...
A company borrows $170000, which will be paid back to the lender in one payment at...
A company borrows $170000, which will be paid back to the lender in one payment at the end of 8 years. The company agrees to pay yearly interest payments at the nominal annual rate of 11% compounded yearly. At the same time the company sets up a sinking fund in order to repay the loan at the end of 8 years. The sinking fund pays interest at an annual nominal interest rate of 4% compounded yearly. Find the total amount...
Gary borrows 150,000 with interest at 15% compounded quarterly. How many 9,500 quarterly payments are required?...
Gary borrows 150,000 with interest at 15% compounded quarterly. How many 9,500 quarterly payments are required? Show complete solution
Capital One Bank enters into a $10,000,000 quarterly‐pay plain‐vanilla interest rate swap as the fixed‐rate payer...
Capital One Bank enters into a $10,000,000 quarterly‐pay plain‐vanilla interest rate swap as the fixed‐rate payer at a swap rate of 6% based on a 360‐day year. The floating‐rate payer, First Bank, agrees to make payments at 90‐day LIBOR plus a 0.6% margin. The 90‐day LIBOR rate currently stands at 4%. LIBOR‐90 rates are as follows:  90 days from today = 4.5% 180 days from today = 5.1% 270 days from today = 5.6% 360 days from today = 6.0%...
On January 2, 2020, Pharoah Corp. issues a $8–million, five–year note at LIBOR, with interest paid...
On January 2, 2020, Pharoah Corp. issues a $8–million, five–year note at LIBOR, with interest paid annually. To protect against the cash flow uncertainty related to interest payments that are based on LIBOR, Pharoah entered into an interest rate swap to pay 8% fixed and receive LIBOR based on $8 million for the term of the note. The LIBOR rate for the first year is 7.6%. The LIBOR rate is reset to 8.7% on January 2, 2021. Pharoah follows ASPE...
Explain why an Interest Rate Swap (assume LIBOR as the floating rate) with quarterly settlement (assume...
Explain why an Interest Rate Swap (assume LIBOR as the floating rate) with quarterly settlement (assume 90 days per quarter) can be viewed as a strip of Eurodollar futures contracts. (Note: A strip is a sequence of ED futures with successive expirations) Note: This question is worth 10 marks.
XYZ Corp. borrows $300,000 to be paid-off in six years. The loan payments are semiannual with...
XYZ Corp. borrows $300,000 to be paid-off in six years. The loan payments are semiannual with the first payment due in six months, and interest is at 6%. What is the amount of each payment? A) 25,750 B) 29,761 C) 30,139 D) 25,500
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT