Question

In: Finance

1. It is April 2019. A US company needs to borrow $100,000,000 for three months starting...

1. It is April 2019. A US company needs to borrow $100,000,000 for three months starting five months from now. The current 3-month LIBOR is 2.5%. The company is afraid that rates may rise during those five months before it obtains the loan. Should the company buy or sell Eurodollar futures? And how many (ignoring the present value of the basis point change)?

Which month should the futures settle/expire?

Assume that the appropriate Eurodollar future is trading at 97.4. What interest does the company pay if the 3-month LIBOR rate finishes at 95 (factoring in the gain/loss of the Eurodollar futures contracts)? Or finishes at 98? Assume each month has 30 days.

Solutions

Expert Solution

This is a very interesting question and needs a thorough understanding of the Eurodollar futures to answer. I will try to break down the concepts and explain the answer by logical steps.

The company needs to borrow the money in future. The adverse impact for borrowing would be the interest rates going up. Hence, we need a hedging instrument that will protect against rising interest rate risk. The instrument used here is the Eurodollar futures (EDF). The underlying for EDF is a Eurodollar time deposit which at the rate of 3-months LIBOR.

We will need to short-sell the EDF to protect against the rising interest rates. The price of EDF reflects the anticipated LIBOR rates at the time of settlement. By short selling the contract, the company profits from the rising interest rates, which is captured in the lower EDF prices.

The money needs to be borrowed in 5 months i.e. at the end of Sept’19. Hence, the contract needs to be settled in Sept. The maturity of EDF contracts is usually 3 months. The period for which the money needs to be borrowed is not important here. The expiration months for EDF on CME exchange are March, June, September and December.

The principal or notional value for EDF is $1M. Since we need to borrow $1 M only, we can purchase a single Eurodollar future contract.

The tick size or minimum fluctuation for EDF is 0.0025 bps or 0.25% in the nearest expiring month and 0.005 bps or 0.5% for all other months. Since, the contract is for 5 months, this is not the nearest expiry month contract and the relevant tick size as of today will be 0.5%. One basis point change in the EDF price reflects a change of $25 per contract.

EDF prices are expressed numerically as- 100 minus the implied 3-month LIBOR rate. The EDF price of 97.4 reflects an implied LIBOR of 2.6%. If the EDF at expiry is 95 which implies that the LIBOR is 5% at the time of borrowing the money. The gain from short selling the EDF at 97.5 and covering the sell at 95 at the time of expiry is 97.4-95= 2.4% or 240 bps. Hence, a move of 240 bps will reflect a change of $6000 per contract, which is a gain in this case. The effective interest rate is calculated as below-

Principal borrowed        1,000,000
LIBOR 5%
Interest rate              12,500
Gains from EDF 6000
Net interest payout                6,500
Effective interest rate 2.60%

In second case, when the EDF price at expiry is 98, the implied LIBOR is 2%. The loss from short selling the EDF at 97.5 and covering the sell at 98 at the time of expiry is 97.4-98= -0.6% or 60 bps. Hence, a move of 60 bps will reflect a change of $1500 per contract, which is a gain in this case. The effective interest rate is calculated as below-

Principal borrowed        1,000,000
LIBOR 2%
Interest rate                5,000
Loss from EDF -1500
Net interest payout                6,500
Effective interest rate 2.60%

Notice how in each case, the effective rate of borrowing is fixed at 2.6% which is the implied LIBOR from the EDF price at the time of purchasing the hedge.


Related Solutions

The BCJ Company needs a master budget for the three months beginning April 1, 2020. The...
The BCJ Company needs a master budget for the three months beginning April 1, 2020. The company retails widgets. The 2020 budget should be based on the following information. An ending minimum cash balance of $10,000 each month is required. Sales are forecasted at an average selling price of $8 per widget. Merchandise costs are $4 per widget. Currently, the company maintains an ending inventory balance equal to 20% of the next month’s projected cost of goods sold. Purchases during...
A company is planning to borrow $120 million after three months for a period of six...
A company is planning to borrow $120 million after three months for a period of six months. The quote for the loan is LIBOR. The loan rate, LIBOR, will be determined at the start of loan and stay the same for its duration. Currently LIBOR is 3%. The company is willing to pay 3.25% fixed interest on the loan to avoid variable interest. Part a. Construct a Forward Rate Agreement (FRA) for the company. Part b. Should the company buy...
A company is planning to borrow $120 million after three months for a period of six...
A company is planning to borrow $120 million after three months for a period of six months. The quote for the loan is LIBOR. The loan rate, LIBOR, will be determined at the start of loan and stay the same for its duration. Currently LIBOR is 3%. The company is willing to pay 3.25% fixed interest on the loan to avoid variable interest. Part a. Construct a Forward Rate Agreement (FRA) for the company. Part b. Should the company buy...
Citibank need to borrow $1 million for 6 months starting in 3 years.  Citibank is concerned about...
Citibank need to borrow $1 million for 6 months starting in 3 years.  Citibank is concerned about the interest rate would like to lock in the interest rate it pays by going long an FRA with Bank of America.  The FRA specifies that Citibank will borrow at a fixed rate of 0.03 for 6 months on $1 million in 3 years. If the 6 months LIBOR rate proves to be 0.01. Then to settle the FRA, what is the cash flow to...
Hanig Bottle Company wants to borrow $20M three months from today for a 9 month period....
Hanig Bottle Company wants to borrow $20M three months from today for a 9 month period. Hanig wants to protect against interest rate risk by entering into a 3x9 forward rate agreement (FRA) at 3.25%. In 3 months, the interest rates are 2.5%. Hanig receives $112,500 from the FRA. Hanig allows the FRA to expire unused. Hanig receives $150,000 from the FRA Hanig pays $112,500 on the FRA.
 Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June....
 Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here and the following information in its preparation.​ Sales: February $514,000​; March $489,000​; April $550,000​; May $586,000​; June $663,000​; July $668,000​Purchases: Purchases are calculated as 57% of the next​ month's sales, 11% of purchases are made in​ cash, 46% of purchases are paid for 1 month after​ purchase, and the remaining 43% of purchases are paid for 2 months after...
Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June....
Maris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June. Use the format given here LOADING... and the following information in its preparation. ​Sales: February $ 514 comma 000 $514,000​; March $ 514 comma 000 $514,000​; April $ 555 comma 000 $555,000​; May $ 595 comma 000 $595,000​; June $ 648 comma 000 $648,000​; July $ 655 comma 000 $655,000 ​Purchases: Purchases are calculated as 57 % 57% of the next​ month's sales, 9...
Wildhorse Company purchased land and a building on April 1, 2019, for $369,600. The company paid...
Wildhorse Company purchased land and a building on April 1, 2019, for $369,600. The company paid $110,400 in cash and signed a 5% note payable for the balance. At that time, it was estimated that the land was worth $145,000 and the building, $224,600. The building was estimated to have a 25-year useful life with a $35,000 residual value. The company has a December 31 year end, prepares adjusting entries annually, and uses the straight-line method for buildings; depreciation is...
Cash disbursements scheduleMaris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May,...
Cash disbursements scheduleMaris​ Brothers, Inc., needs a cash disbursement schedule for the months of​ April, May, and June and the following information in its preparation.​Sales:February March $481,000​; April $535,000​; May $588,000​; June $656,000​; July $625,000​ Purchases are calculated as 57% of the next​ month's sales,12% of purchases are made in​ cash, 48% of purchases are paid for 1 month after​ purchase, and the remaining 40% of purchases are paid for 2 months after purchase.​Rent: The firm pays rent of $7,970...
develop a? three-period moving average forecast for april 2019
A geneticist discovers a new mutation in Drosophila melanogaster that causes the flies to shake and quiver. She calls this mutation spastic (sps) and determines that it is due to an autosomal recessive gene. She wants to determine if the gene encoding spastic is linked to the recessive gene for vestigial wings (vg). She crosses a fly homozygous for spastic and vestigial traits with a fly homozygous for the wild-type traits and then uses the resulting F1 females in a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT