Question

In: Accounting

Questions 27-29 refer to the following rate sensitivity report for Gotbucks Bank, Inc. ($million).                         Maturity &

Questions 27-29 refer to the following rate sensitivity report for Gotbucks Bank, Inc. ($million).

                       

Maturity                      Overnight                    1-30 days        31-91 days      92-181 days

Assets:

            Fed Funds       $20      

            Loans             $ 0                              $10                              $15                  $80

Liabilities:

            Fed Funds       $ 50

            Euro CDs        $   5                             $25                              $40                  $ 0

                                      

Calculate the funding gap for Gotbucks Bank using (a) a 91 day maturity period and (b) a

            181 day maturity period? (Note: Each maturity period is cumulative).

            a.         ‑$25;   +$80                

            b.         ‑$50; ‑$75

            c.         ‑$75;   +$5

            d.        +$55; ‑$40                

            e.         0; 0

How will an increase of 25 basis points in all IRs affect Gotbuck's net interest

            income over a planning period of 91 days?

            a.         ‑$0.1875 million                        

            b.         ‑$0.1250 million

            c.         +$0.1375 million                        

            d.         ‑$0.0625 million

            e.         0

What does Gotbucks Bank's 91 day gap positions reveal about the bank management's

            IR forecasts and the bank's IR risk exposure (ignoring the OBS positions)?

            a.         The bank is exposed to IR decreases and positioned to gain when IR decline.

            b.         The bank is exposed to IR increases and positioned to gain when IR decline.

            c.         The bank is exposed to IR increases and positioned to gain when IR increase.

            d.         The bank is exposed to IR decreases and positioned to gain when IR increase.

            e.         Insufficient information since OBSA position is unknown.

PLEASE SHOW ALL WORK

Solutions

Expert Solution

Ques 1)
C. -$75 and $5

RSA(91) = Fed Funds + overnight loan bucket + 30-day loan bucket + 91-day loan bucket
RSL(91) = Fed Funds + overnight Euro CD bucket + 30-day Euro CD bucket + 91-day Euro CD bucket
RSA(91) = (20 + 0 + 10 + 15) = $45
RSL(91) = (50 + 5 + 25 + 40) = $120
GAP(91) = 45 - 120 = -$75

Simialarly for 181 days maturity period we have

RSA(91) = (20 + 0 + 10 + 15+80) = $125
RSL(91) = (50 + 5 + 25 + 40+0) = $120
GAP(91) = 125 - 120 = $5

Ques 2)
A. -$0.1875 million
Change in NII over a 91-day planning period if rates inrease 25 basis points (+0.0025)
∆NII = (91-day GAP) × ∆R
∆NII = -$75,000,000 × (+0.0025) = -$187,500 or -$0.1875 million

Ques 3)
B. The bank is exposed to interest rate increases and positioned to gain when interest rates decline.
The bank has a negative 91-day GAP. Therefore, it is positioned to gain if rates decrease and liabilities can be rolled-over at lower cost


Related Solutions

Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets   Liabilities and Equity Cash   $   48     Core deposits   $   43 Federal funds      38     Federal funds      68 Loans (floating)      123     Euro CDs      148 Loans (fixed)      83     Equity      33         Total assets   $   292     Total liabilities and equity   $   292         Notes to the balance sheet: Currently, the fed funds...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 35   Core deposits $ 36   Federal funds 25   Federal funds 55   Loans (floating) 110   Euro CDs 135   Loans (fixed) 70   Equity 14   Total assets $ 240   Total liabilities and equity $ 240 22-4 Notes to the balance sheet: Currently, the fed funds rate is 9 percent. Variable-rate loans are priced at 3 percent over LIBOR (currently...
Use the data provided for Gotbucks Bank, Inc., to answer this question.    Gotbucks Bank, Inc....
Use the data provided for Gotbucks Bank, Inc., to answer this question.    Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 38   Core deposits $ 42   Federal funds 28   Federal funds 58   Loans (floating) 113   Euro CDs 138   Loans (fixed) 73   Equity 14   Total assets $ 252   Total liabilities and equity $ 252    Notes to the balance sheet: Currently, the fed funds rate is 9.3 percent. Variable-rate loans are priced at 4 percent over LIBOR...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 32   Core deposits $ 25   Federal funds 22   Federal funds 52   Loans (floating) 107   Euro CDs 132   Loans (fixed) 67   Equity 19   Total assets $ 228   Total liabilities and equity $ 228 Notes to the balance sheet: Currently, the fed funds rate is 8.7 percent. Variable-rate loans are priced at 3 percent over LIBOR (currently at...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in...
Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 50   Core deposits $ 50   Federal funds 40   Federal funds 70   Loans (floating) 125   Euro CDs 150   Loans (fixed) 85   Equity 30   Total assets $ 300   Total liabilities and equity $ 300 Notes to the balance sheet: Currently, the fed funds rate is 10.5 percent. Variable-rate loans are priced at 3 percent over LIBOR (currently at...
Using the below sensitivity report, answer the following questions: SENSITIVITY REPORT ANALYSIS PROBLEM
Using the below sensitivity report, answer the following questions:SENSITIVITY REPORT ANALYSIS PROBLEM  a. If this is a LP product mix problem report, how many units of each product should be produced?b. If one unit of French is force produced, what will happen to the Objective Function value?c. The Caribbean’s Objective Coefficient is increased to 80. How will the new Objective Function value be determined? d. Which constraints are binding?e. If Finishing is decreased by one unit, how will the Objective...
A bank has Federal funds totaling $25 million with an interest rate sensitivity weight of 1.0....
A bank has Federal funds totaling $25 million with an interest rate sensitivity weight of 1.0. This bank also has loans of $105 million and investments of $65 million with interest rate sensitivity weights of 1.40 and 1.15 respectively. This bank also has $135 million in interest-bearing deposits with an interest rate sensitivity weight of .90 and other money market borrowings of $75 million with an interest rate sensitivity weight of 1.0. What is the weighted interest-sensitive gap for this...
Refer to Table 29-5. If the bank faces a reserve requirement of 6 percent, then the bank
8. Refer to Table 29-5. If the bank faces a reserve requirement of 6 percent, then the bank a. is in a position to make a new loan of $12,000. b is in a position to make a new loan of $18,000 c. has excess reserves of $12,000. d. None of the above is correct.  9. Refer to Table 29-5. If the bank faces a reserve requirement of 8 percent, then the bank a. is in a position to make...
Refer to Eli Lilly’s 2012 annual report to answer the following questions. The 2012 annual report...
Refer to Eli Lilly’s 2012 annual report to answer the following questions. The 2012 annual report of Eli Lilly & Company can be found here: http://www.sec.gov/Archives/edgar/data/59478/000005947813000007/lly-20121231x10k.htm How much of the 2012 accounts receivable balance does the company expect to collect? What is the percentage of “other receivables” to total current assets at the end of 2012? Round to the nearest whole percentage. What is included in the “other receivables” balance?
22-4 d is not .6495 Use the data provided for Gotbucks Bank, Inc., to answer this...
22-4 d is not .6495 Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 35   Core deposits $ 36   Federal funds 25   Federal funds 55   Loans (floating) 110   Euro CDs 135   Loans (fixed) 70   Equity 14   Total assets $ 240   Total liabilities and equity $ 240 Notes to the balance sheet: Currently, the fed funds rate is 9 percent. Variable-rate loans are priced at 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT