Working Paper 285

MarginWHEW Bank Futures:   Hedging Strategies and Accounting Under SFAS 133/IAS 39 for Eurodollar Interest Rate Futures to Hedge Profits on Forecasted Loan Transactions

Bob Jensen at Trinity University
Terminology is defined in  Bob Jensen’s SFAS 133 and IAS 39 Glossary

Case Objectives

The broad objectives of this MarginWHEW Bank Case and its companion MarginOOPS Bank Case are as follows:

 

Bob Jensen's Home Page

Case Objectives Case Introduction Case Questions
Glossary Mexcobre Case CapIT Corp. & FloorIT Banks MarginWHEW & MarginOOPS Banks

Case Introduction
Note that all terminology definitions are given at
http://WWW.Trinity.edu/rjensen/acct5341/speakers/133glosf.htm#0000Begin

On Dec. 17, 1999 MarginWHEW Bank had a firm commitment to receive quarterly interest payments on a $10 million, one-year loan at a fixed rate of 8.00% APR. The Treasurer of MarginWHEW Bank, George Arnold, commenced to worry about rising interest rates on the cost of MarginWHEW Bank loaned by the bank over the next year.  George anticipated inflationary pressures that might lead to upward movements in borrowing costs worldwide.  During the next year, LIBOR might well rise substantially, thereby, increasing the quarterly forecasted transaction refunding cost of capital used to carry the 8.00% fixed-rate loan. The MarginWHEW Bank would like to lock in the gross profit on the loan's four quarterly payments due on the 17th day of each of the months of March 2000, June 2000, September 2000 and December 2000.

The cost of a futures contract in a trading market such as the Chicago Mercantile Exchange (CME) is called the "settlement price" corresponding to a settlement "yield."  The "underlying" of an interest rate futures contract is usually some type of note having a principal amount referred to as the "notional."  Futures contracts give holders the option to purchase or sell notes at contracted settlement prices that translate into settlement yields for notes.  Futures contracts give holders the option to sell/buy notes at contracted settlement prices that translate into settlement gains and losses. 

Always remember that as interest rates go up, underlying note prices fall in trading markets and vice versa. Interest rate futures contracts can be used to lock in (approximately) borrowing or lending rates.  An advantage of futures contracts vis-a-vis interest rate option contracts is that the initial acquisition cost of a futures purchase or sales contract is virtually zero (i.e., there is no initial premium).  A huge disadvantage is that the financial risk is uncertain and possibly unbounded, whereas the most an option holder can lose is the initial premium paid for the contract.  Option holders do not incur a penalty if options are never exercised.  Futures contracts must be settled in every instance by either a netting out in cash or physical taking/delivery of the underlying notes.

Holders of interest rate sell-then-buy futures (STB-short) contracts gain from soaring futures prices caused by plunging interest rates, whereas holders of  buy-then-sell (BTS-long) contracts gain from soaring interest rates. Interest-rate futures are traded on in organized markets such as the Chicago Mercantile Exchange (CME), Chicago Board of Trade (CBOT), Tokyo Stock Exchange,  and others.  If an investor sells something "short" on June 17 for $12 and buys it on September 17 for current spot price of $10, the net gain is $2.  This type of thing would happen in interest rate STB-short futures if interest rates rose between June 17 and September 17.   Rising interest rates send the market prices of the underlying notes plunging so that they are cheaper to buy in the future.  At a certain point, the STB-short futures contract holder can purchase notes at low spot prices and deliver these notes under the futures sales contract at higher contracted settlement prices (having lower interest rates). Many investors acquire interest rate futures contracts in pure speculation that interest rates are going to go change (thereby creating futures contract gains or losses from changing prices of underlying notes). But instead of speculating, money borrowers may hedge against changing interest rates up or down by locking in a borrowing rate equal to the settlement rate (yield) at the date the futures contracts are acquired in advance of the loan transaction.   Common underlyings for interest-rate futures contracts are U.S. Treasury bonds, Eurodollars, Japanese government bonds, and Euroyen.

Eurodollar notes should not be confused with the new Euro currency. Eurodollar notes are virtually risk-free obligations of U.S. Banks that carry contracted interest rates based upon LIBOR. Eurodollars are time deposits in commercial banks outside the United States. Most are in Europe, but they are not confined to Europe. The CME offers Eurodollar time deposit futures contracts.  For a $1 million notional, the annualized tick is equivalent, therefore, to $100 = ($1,000,000)(0.01%) = $10,000. The 0.01%, however, is an annual percentage price (APR). The Eurodollar notes on the CME are 90-day notes, such that futures contract prices are based upon the 90-day portions of 0.01%.  These portions are expressed as ($100)(3/12 yr) = $25 per tick.  For example, a September 1999 futures contract having a listed settlement of 94.56 will have a discount of $13,600 = (100% - 94.56%)($1,000,000)(3/12 yr). The discounted price becomes $986,400 = $1,000,000 - $13,600.  On the CME, Eurodollar futures use the $25 tick illustrated in a somewhat more revealing way as shown below:

$100 = ($1,000,000)(0.01% per tick ) for a 12-month time span
$ 25 = ($1,000,000)(0.01% per tick )(3/12 yr) for a 3-month time span

     5.44% = 100% - 94.56% yield on June 17, 1999 for a September 1999 futures contract 
544 ticks  = 10,000 basis points - 9,456 basis points

$986,400 = $1,000,000 notional - ($25)(544 ticks)
                = $1,000,000 notional - ($2500)(5.44 listed yield of the futures contract)
)
                = $1,000,000 notional - ($250,000)(5.44%)
                = $1,000,000 notional - ($13,600 discount)

This  $986,400 "settlement price" is an artificial settlement price.  The net difference is added or subtracted each quarter to the customer's margin balance.   Rises in settlements caused by declines in discount yields benefit STB-short positions and hurt BTS Long positions.  Similarly rises in yields benefit BTS-long positions.

In the futures market this is termed "marking-to-market."  The customer may draw out the surplus above the margin limit.  However, if marking-to-market depletes the balance below the margin limit, the customer must put more funds into the margin account.  Therein lies the risk of futures trading vis-a-vis options trading.

The yield can be calculated as follows:

     $13,600 = $1,000,000 - $986,400 discount on June 17, 1999 for a September 1999 futures contract

  1.3600%          = ($13,600 discount) / ($1,000,000 notional) yield for (3/12 yr)
  5.4400% APR = (1.3600%)(4 quarters of the year) APR yield for a full year

Eurodollar interest-price futures are somewhat different since they are settled net for cash daily without physical delivery of the underlying notes themselves. There is virtually no cost to purchase a futures contract, but the trading exchanges require investors to maintain a deposit called a "margin" such as a $500 minimum margin.  Daily gains are credited to the investor's account, and daily losses are charged to it.  If the margin falls below the minimum threshold, the investor has to deposit more funds. 

Eurodollar futures are traded in the International Money Market (IMM) of the CME. This MarginWHEW Bank case focuses on buy-then-sell (BTS-Long) futures contracts to be used by MarginWHEW Bank to hedge a forecasted transaction to borrow $10 million.  George Arnold decided on a Dec. 17 to purchase 10 buy-then-sell (BTS-Long) futures contracts on each of four quarters at the futures prices shown in Exhibit 1.

-----------------------------------------------------------------------------------------------

Insert Exhibit 1 About Here

-----------------------------------------------------------------------------------------------

If LIBOR rates soar. the BTS-Long futures contracts have plunging purchase prices (and soaring gains) that can be settled in the contract periods for cash.  In theory, MarginWHEW Bank has "more or less" locked-in a fixed cost of MarginWHEW Bank borrowing rate that is the net rate between the eventual higher borrowing rates minus the gain rate on the hedging contracts. What really happens is that the net settlement of each futures contract hedge will approximately offset the increased or decreased cost of MarginWHEW Bank rates on $10 million for one year on a quarterly basis. Thus there is a fixed rate of return on the 8% loan of $10 million having interest received quarterly by MarginWHEW Bank.

On December 17, MarginWHEW Bank loaned $10 million at a fixed rate of 8.00% receivable at 2.00% quarterly.   MarginWHEW funded its loan for the first three months at an annualized rate of 5.75% APR.   The Bank intends to refund each quarter.  George Arnold worried that interest rate increases on the quarterly refunding may degrade the profit on the $10 million fixed-rate loan.  On December 17, George Arnold acquired Eurodollar buy-then-sell BTS-Long futures contracts for March 2000 (10 contracts), June 2000 (10 contracts), and September 2000 (10 contracts) in order to fix the rate of MarginWHEW Bank profit on the one-year firmly committed $10 million loan.  The futures contract prices are reproduced in Exhibit 1 .

Case Questions (in black) With Answers (in red)
(Students fill in the answers shown here in red.)

Question 1
Exhibit 1
shows selected Eurodollar interest-rate futures settlements taken from a base illustration at the CME web site. The CME illustration only provides the settlement yields for four dates.   In Exhibit 1 you will find an extended illustration with monthly yields so that it is possible to learn about margin settlements.  So that students are consistent in the main settlements, the calculation outcomes are provided for two rows in the table below.  Students are to compute the results for the two bottom rows.

Date

Settlement Price Expressed as an APR %

Yield

Settlement Total for
10 contracts

December 1999

Purchase Date

5.75% APR

Acquisition Date

March 2000

94.12% APR

5.88% APR

$9,853,000

June 2000

93.95% APR

6.05% APR

$9,848,750

September 2000

93.80% APR

6.20% APR

$9,845,000

  • Assume that 30 futures contracts (that each have a $1 million notional) are purchased on Dec. 17 in order to lock in a loan profit for MarginWHEW Bank across the four quarters.

  • Assume $25 per tick settlement factors that translate into $2,500 adjustment factors illustrated in the initial part of this case.

  • Assume all contracts are settled at the dates shown in the first column of the above table.

  • Assume that the Futures Margin Account can never fall below the minimum margin of $500.

  • Assume no interest expense or revenue on the balance left in the Futures Margin Account.  This is a simplifying assumption for students dealing with more complex issues in this case.

  • Although margin accounts are normally settled daily, the settlements in this case will only be on selected dates in order to simplify the illustration.

Fill in all contracted sales amounts (like a short sale for future delivery) shown in the last column of the above table and show how all of the three future contracted settlements are derived.  Note that the bank does not actually pay the huge price of 10 contracts.  This selling "settlement price" is an artificial selling price against which the eventual artificial purchase "settlement price" is subtracted at the day the sell-then-buy (BTS-Long) futures contracts are settled.  The net difference is added or subtracted each quarter to the margin balance of MarginWHEW Bank's customer account with the CME. 


Part A:
What are the December 17 artificial settlements (in total dollars) of all 30 futures contracts?

Hint:  The settlement for the first 10 contracts is shown as a guide for students.

$9,853,000 = [$1,000,000 - ($2,500)(5.88)][10 contracts] for 10 March 2000 contracts
$9,848,750 = [$1,000,000 - ($2,500)(6.05)][10 contracts] for 10 June 2000 contracts
$9,845,000 = [$1,000,000 - ($2,500)(6.20)][10 contracts] for 10 Sept. 2000 contracts


Part B:
What are the actual cash purchase amounts of all 30 futures contracts that must be paid by MarginWHEW Bank in cash on December 17, 1999?

$0 purchase amounts since there is no premium on futures contracts at the date of acquisition


Part C:
How much does MarginWHEW Bank have to deposit into the Futures Margin Account on December 17?

$500


Question 2
What are quarterly yields corresponding to the above annual yields?

For this part of the case, please adjust yields to quarterly rates using both the (90/360 yr) and (91/360 yr) adjustment factors. 

Date

Annual Yield

Quarterly Yield
Based on (90/360 yr)

Quarterly Yield
Based on (91/360 yr)

December 1999

5.75% APR

1.4375%

1.4534722%

March 2000

5.88% APR

1.4700%

1.4863333%

June 2000

6.05% APR

1.5125%

1.5293056%

September 2000

6.20% APR

1.5500%

1.5672222%

 

Date

Annual Yield

Quarterly Yield
Based on (90/360 yr)

Quarterly Yield
Based on (91/360 yr)

December 1999

5.75% APR

(5.75%)(3/12 yr)

(5.75%)(91/360 yr)

March1999

5.88% APR

(5.88%)(3/12 yr)

(5.88%)(91/360 yr)

June 1999

6.05% APR

(6.05%)(3/12 yr)

(6.05%)(91/360 yr)

September 1999

6.20% APR

(6.20%)(3/12 yr)

(6.20%)(91/360 yr)

Question 3 
What is the hedged annual APR cost of refundings rate locked-in by the acquisition of the 30 BTS-Long futures contracts used to hedge the profit on the $10 million loan?  Compute this rate on both the (90/360 yr) quarterly factors and the (91/360 yr) factors.

Hint: This calculation for the (91/360 yr) factors is illustrated under the section entitled "How to Get Started Trading CME Interest Rate Products:  Section Two:  CME Interest Rate Futures," at the CME web site.  In particular, try the online "how to"  link at http://www.cme.com/market/interest/howto/hedging.html .  You can insert the component rates that you derived in Question 3 above. 

Warning:  The above CME web page has a printing error.  The final adjustment factor for the (91/360 yr) components should have been printed in the formula as 364/365 instead of 360/364.  Then the CME calculation will yield the approximate 6.11% fixed rate shown at the CME web site.


Part A:
What is the locked-in annual rate using the (90/360 yr) factors derived in Question 3 above?

6.10499509% APR = [(1 + 0.01437500)(1 + 0.01470000)(1 + 0.01512500)(1+0.015500) - 1)][360/365]

Note that the (9/12 yr) factor is equivalent to (90/360 yr) factor.  To adjust for the full year, the final component in the equation becomes (360/365).


Part B:
What is the locked-in annual rate using the (91/360 yr) factors in Question 3 above?

6.1064654% APR = [(1 + 0.01453472)(1 + 0.01486333)(1 + 0.01529306)(1+0.015672) (360/364) - 1][360/364]

This rounds to the  6.11% solution at the CME web site at http://www.cme.com/market/interest/howto/hedging.html .


Part C:
Your cost of refundings rates computed above translate into what hedged cost of refundings dollars for the entire year from December 17, 1999 to December 17, 2000?

$610,495 = (6.1049509%)($10,000,000) hedge cost using (90/360 yr) factors
$610,646 = (6.1064654%)($10,000,000) hedge cost using (91/360 yr) factors


Question 4
What is the hedged annual APR loan profit rate and aggregate dollars locked-in by the acquisition of the 30 BTS-Long futures contracts used to hedge the profit on the $10 million loan?   For this computation, ignore reinvestment opportunities on the $200,000 received each quarter on the note receivable of $10,000,000.

From now on, you may assume the (91/360 yr) quarterly adjustment factor and ignore the (90/360 yr) adjustment factor.  The CME prefers the 91/360 adjustment factors.

If the reinvestment opportunity of the interest received on the loan is ignored, we derive the following hedged profit rate:

1.8935346% APR = 8.0000000% note receivable - 6.1064654% hedged cost of refundings  = hedged profit rate

Question
What is the annual gross profit that MarginWHEW Bank anticipates after hedging the cost of refunding the 8.00% loan for 12 months?  Express your answer in dollars.

$189,353 = ($10,000,000)( 1.8935346%) if reinvestment of interest received on the loan is ignored

 

Question 6 
Why is the computation of the hedged profit on the loan less reliable than the computation of the hedged cost of refundings for that loan (assuming interest rate futures contract hedging)?

The problem with the revenue stream is that it is fixed at 8.00% spread quarterly in amounts of $200,000 every three months.  Ideally, the reinvestment rate would be the cost of capital of MarginWHEW Bank. However, we are not given that rate, and estimating such a future cost of capital is very difficult.  If we ignore the opportunity to reinvest the $200,000 every quarter, the profits are understated. 

A similar problem arises with assumed opportunity values of the cash inflows and outflows from the futures contract hedge.  However, these are much smaller in amount than the interest payments on the note receivable.  Hence the error is much smaller in terms of total dollar computations of hedging cash returns.

Question 7 
This question entails calculating the balance sheet asset or liability reported in the financial statements for the Futures Margin Account on February 29, 2000 for all the futures contracts acquired by MarginWHEW Bank on Dec. 17.  Assume that SFAS 133 and IAS 39 rules for adjusting derivative financial instruments to fair values apply in this instance. Use the hypothetical settlement prices given in Exhibit 2

Please adhere to the following policies regarding cash flows in the Futures Margin Account:

  • Assume that all cash above the margin limit is retained in the account until a set of futures contracts are settled in cash.  The amount of that cash settlement is withdrawn in total provided the funds remaining are greater than or equal to the margin limit that is assumed to be $500 in this case. 
  • If there is more than $500 in the account but not enough to withdraw an entire settlement, only the amount above $500 is withdrawn.  For example, if the settlement is $2,000 when there is only $750 in the account after the settlement, the withdrawal is $250.
  • If there is less than $500 in the account at any time, then cash is added to bring the balance up to $500.
  • Although increases and decreases in the account take place daily in real life, for purposes of this case, cash flows to and from the account will be assumed to only take place on selected days specified in the case.
  • Initially assume that the discount rate used to discount the future cash flows back to a present value is zero.  For example, note Example 2 beginning in Paragraph 111 on Page 61 of FAS 133.  In particular, note the present value discussion in Paragraph 112.  Initially, for the MarginWHEW case, you are to assume a zero percent discount rate.  Later on the discount factor will be introduced in the case.

-----------------------------------------------------------------------------------------------

Insert Exhibit 2 About Here

-----------------------------------------------------------------------------------------------

What is the balance sheet asset or liability reported in the financial statements for the Futures Margin Account on February 29, 2000 for all the futures contracts acquired by MarginWHEW Bank on Dec. 17?  First compute the value assuming no margin requirements, and then adjust the account by the amount needed to follow the bank's stipulated margin account policy.

Recall that we earlier computed the following using the December 17 settlements shown in Exhibit 1:

5.88% = 100% - 94.56% yield on Dec. 17, 1999 for a September futures contract on the CME
588 ticks = 10,000 basis points - 9,412 basis points

$985,300 = $1,000,000 notional - ($25)(588 ticks)
                = $1,000,000 notional - ($2500)(5.88 listed yield of the BTS-Long futures contract)
                = $1,000,000 notional - ($250,000)(5.88%)
                = $1,000,000 notional - ($14,700 discount)

This  $985,300 "settlement price" is an artificial selling price against which the eventual artificial purchase "settlement price" is subtracted at the day the sell-then-buy (BTS-Long) futures contracts are settled.  The net difference is added or subtracted each quarter to the customer's margin balance.

On February 29 using Exhibit 2 data, we derive the following for the September futures contracts:

   6.50%     = 100% - 93.50% yield on Feb. 29 for a March futures contract on the CME
   650 ticks = 10,000 basis points - 9,350 basis points

$983,750    = $1,000,000 notional - ($25)(650 ticks)
                   = $1,000,000 notional - ($2500)(6.50 listed yield of the BTS-Long contract in Exhibit 2)
                   = $1,000,000 notional - ($250,000)(6.50%)
                   = $1,000,000 notional - ($16,250 discount)

This  $983,750 "settlement price" is an artificial buying price against which the December 17 artificial sales "settlement price" is netted against in the day the sell-then-buy (BTS-Long) futures contracts are settled.  The net difference is added or subtracted each quarter to the customer's margin balance.  The difference is value of the August 31 single BTS-Long futures contract:

$1,550 = $985,300 selling amount  - $983,750 purchase amount on Feb 29 for one March 2000 BTS-Long futures contract
$15,500 = ($1,550)(10 contracts) = the balance sheet asset component on February 29 of the March 2000 futures contracts

This same answer can be computed quickly as follows using yield rates:
$15,500 = -(5.88
Dec. settlement - 6.50 Feb. 29 settlement)($2,500)(10 contracts) for March 2000 futures

The aggregate for all 30 contracts is derived below using Exhibit 1 data:

$15,500 = -(5.88 Mar 17 settlement - 6.50 Feb. 29 settlement)($2,500)(10 contracts) for March 2000 futures
$13,500 = -(6.05
June 17 settlement - 6.59 Feb. 29 settlement)($2,500)(10 contracts) for June 2000 futures
$12,250 = -(6.20
Sept 17 settlement - 6.69 Feb. 29 settlement)($2,500)(10 contracts) for Sept. 2000 futures

The sum of these is shown below:

$41,250  = the aggregate asset value caused by increases in LIBOR between December 17 and February 29.   To this we must add the initial $500 margin deposit such that the balance in the Futures Margin Account is $41, 750 on February 29, 2000.

Since none of the above futures contracts have been settled for cash, there are no cash withdrawals from the Futures Margin Account on February 29, 2000 according to MarginWHEW Bank policy.  But if there were to be a withdrawal, the bank would say "WHEW" over the fact that it hedged against rising interest rates.

Question 8
First compute the cash settlement of the March 2000 futures on March 17, 1999.  Then compute the cash withdrawal of cash settlements from the Futures Margin Account according to MarginWHEW Bank policy.  What is the balance sheet asset or liability reported in the financial statements for the Futures Margin Account on March 17, 2000 for all the remaining futures contracts acquired by MarginWHEW Bank on Dec. 17? 

Assume that SFAS 133 and IAS 39 rules for adjusting derivative financial instruments to fair values apply in this instance. Use the hypothetical settlement prices given in Exhibit 2


Part A:
What are the March 17 hypothetical settlement values for all the 30 contracts using
Exhibit 1  and Exhibit 2 data?

Hint:  The settlement for the first 10 contracts is shown as a guide for students.

$28,500 = -(5.88 June 17 settlement - 7.02 March 17 settlement)($2,500)(10 contracts) for March 2000 futures
$25,750 = -(6.05
June 17 settlement - 7.08 March 17 settlement)($2,500)(10 contracts) for June 2000 futures
$23,750 = -(6.20
June 17 settlement - 7.15 March 17 settlement)($2,500)(10 contracts) for Sept. 2000 futures
$78,000


Part B:
What is the aggregate contribution of the above 30 hedge settlements toward fixing the profit on the 8.00%, one-year note receivable?

$78,000  = the aggregate profit caused by increases in LIBOR between December 17 and March 17.  To this we must add the initial $500 margin deposit such that the balance in the Futures Margin Account is $78,500 before withdrawing the March 2000 futures contracts settlements.


Part C:
FAS 133 requires that futures hedging profits be partitioned into the part that can be deferred in Other Comprehensive Income (OCI) versus the part that must be credited to current earnings.  The OCI portion is the amount attributable to changes in spot rates.  By way of illustration, this portion is derived below for the time period between December 17, 1999 and March 17, 2000 using Exhibit 2 spot rates as follows (recall that 10 out of 30 contracts expired on March 17 such that only 20 futures contracts remain):

(Change in Spot Rates)(Number of Contracts)($2,500)
-$63,500 = (5.75 - 7.02)(20 remaining contracts)($2,500)

How would the accumulated "profit" from the 30 contracts on March 17 be partitioned between OCI and retained earnings (or current earnings if the books have not been closed)?  Assume a zero discount rate for the moment since the more complicated task of discounting is taken up later on in the case.

$78,000  = the aggregate profit caused by increases in LIBOR between December 17 and March 17 is then partitioned as follows for the March 17, 2000  balance sheet:

($63,500) = the credit balance in OCI for the remaining 20 contracts 
($14,500)  = difference (($78,000) - ($63,500)) 
($78,000) = the aggregate profit derived above for March 17, 2000


Part C:
Following MarginWHEW Bank policy, the March 2000 futures are settled for cash and the settlement is withdrawn from the Futures Margin Account.  What is the revised balance in that account?

The values for the remaining 20 contracts are derived below using Exhibit 1 data:

$25,750 = -(6.05 June 17 settlement - 7.08 March 17 settlement)($2,500)(10 contracts) for June 2000 futures
$23,750 = -(6.20
June 17 settlement - 7.15 March 17 settlement)($2,500)(10 contracts) for Sept. 2000 futures

The sum of these is derived below:

$49,500  = the aggregate asset value caused by increases in LIBOR between December 17 and March 17.  To this we must add the initial $500 margin deposit such that the balance in the Futures Margin Accounting is $50,000 on March 17, 2000.

Question 9
What is the balance sheet asset or liability reported in the financial statements for the Futures Margin Account on March 31, 2000 for all the remaining futures contracts acquired by MarginWHEW Bank on Dec. 17. 

Assume that SFAS 133 and IAS 39 rules for adjusting derivative financial instruments to fair values apply in this instance. Use the hypothetical settlement prices given in Exhibit 2

Hint:  Only the 10 contracts for June 2000 and the 10 contracts for September 2000 remain on March 31, 2000.


Part A:
What are the settlements on March 31 for the remaining 20 futures contracts?  Part of the calculation is shown below as a hint on how to proceed.

$26,250 = -(6.05 June 17 settlement - 7.10 7.10 March 31 settlement)($2,500)(10 contracts) for June 2000 futures
$24,250 = -(6.20
June 17 settlement - 7.17 March 31 settlement)($2,500)(10 contracts) for Sept. 2000 futures


Part B:
What is the aggregate contribution of the above 20 hedge settlements toward fixing the profit on the 8.00%, one-year note receivable?

$50,500  = the aggregate asset value caused by increases in LIBOR between December 17 and March 31.


Part C:
Following MarginWHEW Bank policy, what is the revised balance in that account on March 31?

Hint:  Remember that cash withdrawals are not made at the end of any month since contracts are not settled at the end of any month.

Since none of the above 20 futures contracts have been settled for cash, there are no cash withdrawals from the Futures Margin Account on March 31, 2000 according to MarginWHEW Bank policy.  The Futures Margin Account thus has a balance of $50,500 plus the $500 initial margin deposit for a total debit balance of $51,000 on March 31 after marking-to-market.

Question 10
First compute the cash settlements of all futures contracts that were settled on March 17, 2000, June 17, 2000, and September 17, 2000.  Use the hypothetical settlement prices given in Exhibit 2.  Discuss the impact of all the interest rate futures in the MarginWHEW Bank case.  Next compute the interest expense for the first three months from December 17, 1999 to March 17, 2000 and then add to this the refunding costs for each quarter thereafter up to December 17, 2000.  Use the hypothetical interest rates shown in Exhibit 3.

After computing the aggregate interest expense with the aggregate hedging amount from all 30 interest rate futures contracts, discuss the impact of the hedge upon the refunding costs for the funds raised to carry the $10 million loan receivable.  In particular, comment as to whether the hedgings were "effective" in the context of SFAS 133.

-----------------------------------------------------------------------------------------------------------------------------

Insert Exhibit 3 About Here

-----------------------------------------------------------------------------------------------------------------------------

Hint:  Hedge "ineffectiveness" is defined in Bob Jensen's online glossary at http://www.trinity.edu/rjensen/acct5341/speakers/133glosf.htm.


Part A:
What are the cash settlements on March 17, June 17, and September 17 in Year 2000 for the 30 interest rate futures contracts acquired on December 17, 1999?   What is their aggregate contribution toward fixation of the profit on the 8.00% note receivable? 

Hint:  The settlement for the first 10 contracts is shown as a guide for students.

$28,500 = -(5.88 June 17 settlement - 7.02 March 17 settlement)($2,500)(10 contracts) for March 2000 futures
$25,750 = -(6.05
June 17 settlement - 7.08 March 17 settlement)($2,500)(10 contracts) for June 2000 futures
$23,750 = -(6.20
June 17 settlement - 7.15 March 17 settlement)($2,500)(10 contracts) for Sept. 2000 futures

The total settlements aggregate to $85,750 gain on the futures contracts.  MarginWHEW made money on its futures contract hedging because interest rates lifted higher and higher.


Part B:
Given the note payable rates in Exhibit 3, compute the interest expense of the initial quarter and all refundings in subsequent quarters.   Then compare these aggregate "actual" interest payments with the fixed "expected" interest payments that you derived in Question 3 using the (91/360 yr) and (364/365) adjustment factors.

Hint:  The interest expense paid out on March 17 is shown as a guide for students.

(Note the rising quarterly interest expenses!)

   $145,347 = (5.75% on Mar. 17, 2000)($10,000,000)(91/360 yr) (This part of the calculation is a hint.)
   $177,450 = (7.02% on June  17, 2000)($10,000,000)(
91/360 yr)
   $182,000 = (7.20% on Sept. 17, 2000)($10,000,000)(91/360 yr)
   $184,781 = (7.31% on Dec.  17, 2000)($10,000,000)(91/360 yr)
   $689,578 = actual interest expense before hedging the quarterly refundings
 -$  85,750 = gain from futures contracts
   $603,828 = actual interest expense after hedging outcomes (or 6.038%)

   
   $603,828 = actual interest expense after hedging outcomes (or 6.038%)
  -$611,787
= (6.1179%)($10,000,000) expected cost derived in Question 3

  -$    7,959
= convergence error = 0.796% error


Part C:
What are the main criteria for a cash flow hedge to be considered effective under SFAS 133? 
Was the hedging in MarginWHEW Bank effective or ineffective?

The main criteria are spelled out in Section 2 beginning in Paragraph 62 on Page 45 of SFAS 133.  The margin of convergence error is so small each quarter in this case, that ineffectiveness is not an issue.

The hedge was fairly effective in achieving a fixed refunding cost of approximately 6.038% for the year.  When interest rates steadily increased, the futures contract settlements cut the refunding costs back toward the expected $611,787 fixed cost.  The discrepancy between the 6.038 actual rate and the 6.1179% hedged rate is explained in the answer to the next question.

Question 11
Why did the actual hedged refunding costs differ from the expected hedge refunding costs?

Hint:  Recall that the MarginWHEW Bank case is an extension of an illustration provided by the Chicago Mercantile Exchange.   Please go to the section entitled "How to Get Started Trading CME Interest Rate Products:  Section Two:  CME Interest Rate Futures," at the CME web site.  In particular, try the online "how to"  link at http://www.cme.com/market/interest/howto/hedging.html

The following is a quotation from the section entitled "How to Get Started Trading CME Interest Rate Products:  Section Two:  CME Interest Rate Futures," at the CME web site.  In particular, try the online "how to"  link at http://www.cme.com/market/interest/howto/hedging.html

Recall that the banker had expected to lock up funding at 6.1179%. In fact, funds were acquired at 6.038%, or approximately eight basis points lower. This discrepancy occurred because of less-than-perfect convergence between the cash refunding rates and the futures liquidation rates. If the bank had funded at exactly the same rate as the futures liquidation rate, the target would have been achieved. In this case, however, the actual funding over the term of the loan was, on average, one and one-third basis points lower than the futures liquidation rates. Put another way, these basis adjustments positively affected the performance.

The minimal difference between the target rate and the effective funding rate can be attributed to the fact that the refunding dates were quite close but not identical to the futures expiration dates. If the respective dates were further apart, the funding rates and the futures rates would not necessarily converge as closely as those used in the above example.

This example of a one-year loan funded with three-month deposits illustrates a negative interest rate "gap" that is, where shorter-term liabilities are funding a longer term asset, and rising interest rates will have an adverse impact. The same basic hedging approach can be followed to remedy an overall balance sheet maturity mismatch.

 

Question 12
Are the changes in the value of the Eurodollar futures contracts in this case debited/credited to current earnings or Other Comprehensive Income (OCI) under IAS 39?   Although it is probably not true for MarginWHEW Bank, for purposes of this question assume that the cost of capital in MarginWHEW Bank is perfectly correlated with movements of LIBOR just as CME Eurodollar futures contracts settlements are perfectly correlated with LIBOR movements.

Hint:  See the terms "Cash Flow Hedge" and "Comprehensive Income" at http://www.trinity.edu/rjensen/acct5341/speakers/133glosf.htm#C-Terms
Also see Paragraphs 30 and 31 on Pages 21-22 of SFAS 133.

IAS 39 does not have OCI requirements comparable to the OCI requirements in SFAS 130 and SFAS 133. In England, the OCI reconciliation statement is called a "Struggle Statement." However, the IASC does not yet require OCI and Struggle Statements. You can read more about OCI under the definition of Other Comprehensive Income and Struggle Statements in http://www.trinity.edu/rjensen/acct5341/speakers/133glosf.htm .

However, the distinction is a moot point since IAS 39 still requires that cash flow hedge gains and losses be deferred by in equity in an account other than retained earnings such that the net effect is still the same as FAS 133.

Question 13
Are the changes in the value of the Eurodollar futures contracts in this case debited/credited to current earnings or Other Comprehensive Income (OCI) under SFAS 133?  Although it is probably not true for MarginWHEW Bank, for purposes of this question assume that the cost of capital in MarginWHEW Bank is perfectly correlated with movements of LIBOR just as CME Eurodollar futures contracts settlements are perfectly correlated with LIBOR movements.

Please discuss the implications of portfolio hedging versus having the futures contracts tied to a specific hedged item such as a notes payable for $10 million that must be refunded at a variable interest rate.

Hint:  See the terms "Cash Flow Hedge" and "Comprehensive Income" at http://www.trinity.edu/rjensen/acct5341/speakers/133glosf.htm#C-Terms
Also see Paragraphs 30 and 31 on Pages 21-22 of SFAS 133.

With respect to Paragraph 29a on Page 20 of SFAS 133, it should be noted that if the hedged item is a portfolio of assets or liabilities based on an index (such as the U.S. Prime), the hedging instruments cannot use another index (such as LIBOR) even though the two indices are highly correlated.   However, if both are based entirely upon the same index, there is a perfect correlation between the hedged item (e.g., the cost of capital in MarginWHEW Bank) and the Eurodollar interest rate futures hedging instruments.  In that case, it would seem that the value changes in the hedging instruments could be carried in OCI until the futures contracts are settled.

The hedging instrument (e.g., a forecasted transaction or firm commitment foreign currency hedge) must meet the stringent criteria for being defined as a derivative financial instrument under SFAS 133.  This includes the tests for being clearly-and-closely related.  It also includes strict tests of Paragraphs 21 beginning on Page 13 , 29 beginning on Page 20, and Paragraph 56 on Page 33 of SFAS 133 with respect to the host contracts that are being hedged.  Those tests state that if the forecasted "transaction" is in reality a group or portfolio of individual transactions, all transactions in the group must bear the same risk exposure within a 10% range discussed in Paragraph 21.  Also see Footnote 9 on Page 13 of SFAS 133.  The grouping tests are elaborated upon in the following Paragraphs:

  • Paragraph 21 on Page 13,
  • Paragraph 29 beginning on Page 20,
  • Paragraph 241 on Page 130,
  • Paragraph 317 on Page 155,
  • Paragraphs 333-334 beginning on Page 159,
  • Paragraph 432 on Page 192,
  • Paragraph 435 on Page 193,
  • Paragraph 443-450 beginning on Page 196
  • Paragraph 462 on Page 202,
  • Paragraph 477 on Page 208.

Question 14
FAS 133 allows MarginWHEW Bank to avoid testing for cash flow hedge effectiveness in this Eurodollar futures hedging illustration provided the hedge is is declared as a hedge of the loan's refunding at spot rates.  Why is this allowed?  When the Margin Futures Account (or the Futures Account) balance  is adjusted for futures settlement movements, what amount is, thereby, supposed to go to OCI and what amount is supposed to go to current earnings?

Hint:  See a 1999 book entitled Introductory Cases on Accounting for Derivative Instruments and Hedging Activities by Walter R. Teets and Robert Uhl.  In particular read about hedging with futures contracts and see the C.I. Smith and Sons Case.  The book, cases, and Excel programs written by Teets and Uhl can be downloaded free from http://www.gonzaga.edu/faculty/teets/index0.html.
Trinity University students will find this book and accompanying files on the path 
J:\courses\acct5341\readings\teets\derivcas.pdf 

Teets and Uhl (1999, p. 14) state the following:

If the company has chosen to measure variability in anticipated cash flows by changes in spot prices, the portion of the change in value of the futures due to changes in spot prices will exactly offset the change in expected cash flows due to a change in spot prices, discounted to present value. This portion of the change in value of the futures is therefore an effective hedge of the anticipated transaction, and is reflected in OCI. The change in the value of the futures contract due to the change in the difference between futures prices and spot prices will be excluded from determination of hedge effectiveness, and will be reflected in net income. The entire fair value of the futures contract will still be reflected as an asset or liability in the balance sheet. At the end of each accounting period, the following journal entry will be made to record the change in value of the futures contracts, and to apportion the change into OCI and net income. (The journal entries made at each balance sheet date will use the same accounts, but whether the entries to specific accounts are debits or credits will depend on the relative changes in futures and spot prices.) 

Futures Contracts XX 
         OCI                              YY 
         Other Income                ZZ 

The accounting for situations in which futures contracts are used as hedging instruments is illustrated in the fourth case, "C.L. Smith and Sons: Accounting for Futures Hedging Commodity Purchases and Sales."

The change in the futures contract value is affected by spot rate movements and futures price movements.  If the Note Payable is refunded at spot rates, that portion of the hedge's value change that is attributable to spot rates should be perfectly effective in hedging the refunding cost at spot rates.  The FASB reasons that such a perfect hedge should not have to be subject to quarterly effectiveness testing required of most hedges.  That portion of a futures contract's value change that is attributable to the change in spot rates can be deferred in OCI as a perfectly effective hedge.  The remaining portion of the value change impacted by futures price movements net of spot rate changes must be debited or credited to current earnings as opposed to OCI.

 

Question 15
What are the journal entries for all transactions in this case with a $500 margin limit below which the account called "Futures Margin Account" cannot fall.  If marking-to-market makes this fall below $500, add more cash to the account to bring it up to $500.  Assume SFAS 133 rules are in effect.  Also assume that the hedged item is the particular note payable that is refunded each quarter using interest rates shown in Exhibit 3.

Note that the journal entries should follow the accounting suggested by Teets and Uhl in the previous question's hints.  Initially assume that the discount rate used to discount the future cash flows back to a present value is zero.  For example, note Example 2 beginning in Paragraph 111 on Page 61 of FAS 133.  In particular, note the present value discussion in Paragraph 112.  Initially, for the MarginWHEW case, you are to assume a zero percent discount rate.  Later on the discount factor will be introduced in the case.

The journal entries are to be derived using the Exhibit 4 template.  For the journal entries, you need only fill in the columns under the zero discount rate alternative.  The discounting columns will be filled in in a later question.

The journal entries are shown in Exhibit 4 assuming that all value changes in the futures contracts are charged to current earnings and not the OCI account.  

---------------------------------------------------------------------------------------------------

Insert Exhibit 4 About Here

---------------------------------------------------------------------------------------------------

 

Question 16 
Hedging a borrowing cost via an interest rate futures contract is only one of several alternatives for hedging. Other alternatives include interest rate swaps and interest rate options. What are the key advantages and disadvantages of futures contracts in hedging interest rates?

The main advantage is that such contracts have no cost (premiums) at the date of acquisition.  If they steadily increase in value as illustrated in the MarginWHEW Bank Case, then there is never a cash outlay and the hedging cash rolls in for BTS-Long futures contracts as interest rates rise and futures prices decline..  It rolls in for STB-Short futures contracts as interest rates fall.

The huge disadvantage of such contracts is that they can be very risky and the level of risk is not fixed.  In the MarginOOPS Bank Case, the bank had to keep throwing money into the Futures Margin Account when interest rates plunged.   If they had continued to plunge, the loss could have become immense. 

The main advantage of options contracts in the place of futures contracts is that the risk is known and fixed at an amount equal to the initial level of investment in the purchase cost of the futures contracts. For example, when CapIT Bank purchased 25 put contracts for $53,125 on Dec. 17, the maximum harm done, no matter what happens in the trading markets,  is $53,125 from purchasing the futures contracts. In other hedging alternatives, such as interest rate forward/futures contracts, the initial investment are virtually zero, but the loss risk may soar with big changes in LIBOR. Futures and forward contracts expose the holder to enormous risks. Futures contract holders have no risks beyond the cost of the futures.  Acquisitions of hedging futures are quick and easy if satisfactory deals are traded on open exchange systems such as the Chicago Board of  Futures Exchange.

Interest rate swaps have the advantage of both having a low initial cost and fixed risk if a variable price of interest is swapped for a fixed price. The problem with interest rate swaps is that they are custom contracts in which counter parties to the swap must be located and dealt with in private or brokered negotiations. Also it is better if the swap periods coincide.

Question 17 
It was stressed that the 30 futures contracts were "cash flow hedges." Suppose that the refunding rates were fixed rather than variable based upon spot rates.  How would the journal entries change if  they were "fair value hedges" as defined in SFAS 133? Is the distinction between cash flow versus fair value hedges as relevant in the international IAS 39 standard as it is in the U.S. SFAS 133 standard?  Where is there a major illustration of using futures contracts to hedge fair value in SFAS 133?

Hint: The terms "cash flow hedge" and "fair value hedge" have important distinctions in SFAS 133. You may find references to parts of that standard by looking up these terms in http://www.trinity.edu/rjensen/acct5341/speakers/133glosf.htm#0000Begin .

Changes in futures contract values may not be placed in OCI under SFAS 133 rules unless the hedges are designated as cash flow hedges. The distinction is between cash flow hedges and fair value hedges is less important in IAS 39 rules since there is no OCI alternative for either type of hedge in IAS 39.

The major example of using futures contracts to hedge fair value is Example 1 beginning in Paragraph 105 on Page 59 of SFAS 133.

 

Question 18
What is the basic difference between the Cash Account and the Futures Margin Account?

The Futures Margin Account is a cash equivalent much like other cash equivalents such as certificates of deposit.  Cash may be withdrawn at any time as long as the balance left in the Futures Margin Account does not fall below the margin limit.  Firms often leave a cushion in the account to cover downturns in value.   They probably would not leave as much cushion as was left by MarginOOPS Bank on various dates.

 

Question 19
At long last we will drop the simplifying assumption of a zero discount rate and make the MarginWHEW case more like Example 2 beginning in Paragraph 111 on Page 61 of FAS 133.   FAS 133 requires that present values be computed using appropriate discount rates.  

Required:  Fill in the last two columns of Exhibit 4 assuming a discount rate of 6.00% APR which translates to 0.016438356% daily.  Use the daily rate.  Note that the journal entries should follow the OCI accounting suggested by Teets and Uhl in the quote provided above.

Answer:  Details of this answer are given in the 285wp.xls Excel workbook.

 

 

For a copper price swap analysis, see the Mexcobre Case.

For hedging via futures contracts, see the MarginOOPS Bank Case.

For hedging via futures contracts, see the CapIT Bank Case.

For hedging via futures contracts, see the FloorIT Bank Case.