Question

In: Finance

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 13 percent). Fixed-rate loans are selling at par and have five-year maturities with 14 percent interest paid annually. Assume that fixed rate loans are non-amortizing. Core deposits are all fixed rate for two years at 10 percent paid annually. Euro CDs currently yield 11 percent.

a.

What is the duration of Gotbucks Bank’s (GBI) fixed-rate loan portfolio if the loans are priced at par? (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g., 32.161))

  Duration years  
b.

If the average duration of GBI’s floating-rate loans (including fed fund assets) is .56 year, what is the duration of the bank’s assets? (Note that the duration of cash is zero.) (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g., 32.161))

  Duration (assets) years  
c.

What is the duration of GBI’s core deposits if they are priced at par? (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g., 32.161))

  Duration (deposits) years  
d.

If the duration of GBI’s Euro CDs and fed fund liabilities is .421 years, what is the duration of the bank’s liabilities? (Do not round intermediate calculations. Round your answer to 4 decimal places. (e.g., 32.1616))

  Duration (liabilities) years  
e-1.

What is GBI’s duration gap? (Do not round intermediate calculations. Round your answer to 4 decimal places. (e.g., 32.1616))

  Duration gap years  
e-2.

What is the expected change in equity value if all yields increase by 200 basis points? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign. Do not round intermediate calculations.)

  Expected change in equity value $   
e-3.

Given the equity change in e-2. what is the expected new market value of equity after the interest rate change? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign. Do not round intermediate calculations.)

  New market value $   

Solutions

Expert Solution

NO INTERMEDIATE ROUNDING IS DONE


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...
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...
Problem 22-9 (LG 22-3) Use the data provided for Gotbucks Bank, Inc., to answer this question....
Problem 22-9 (LG 22-3) Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 42   Core deposits $ 49   Federal funds 32   Federal funds 62   Loans (floating) 117   Euro CDs 142   Loans (fixed) 77   Equity 15   Total assets $ 268   Total liabilities and equity $ 268 Notes to the balance sheet: Currently, the fed funds rate is 9.7 percent. Variable-rate loans are priced at 5 percent...
Problem 22-9 (LG 22-3) Use the data provided for Gotbucks Bank, Inc., to answer this question....
Problem 22-9 (LG 22-3) Use the data provided for Gotbucks Bank, Inc., to answer this question. Gotbucks Bank, Inc. (in $ millions) Assets Liabilities and Equity   Cash $ 42   Core deposits $ 49   Federal funds 32   Federal funds 62   Loans (floating) 117   Euro CDs 142   Loans (fixed) 77   Equity 15   Total assets $ 268   Total liabilities and equity $ 268 Notes to the balance sheet: Currently, the fed funds rate is 9.7 percent. Variable-rate loans are priced at 5 percent...
Use the data in BUSI1013 Bank Dataset.xlsx (Unit 1 Question 2) to answer this question. (4...
Use the data in BUSI1013 Bank Dataset.xlsx (Unit 1 Question 2) to answer this question. (4 points for each part; 8 points total) Perform a statistical test to see whether the average loans of customers before the change at the Brock and Chase branch are different. Construct a 95% confidence interval for the difference of average loans of customers before the change at the Brock and Chase branch. Loans After Increase in Loans 48.1 12.9 62.4 8.1 51.1 12.6 63.3...
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:...
Use the data below to answer the question parts (a) and (b). This data is for...
Use the data below to answer the question parts (a) and (b). This data is for forecasting fure sale consdiering additive seasonality approach and answer related questions. SHOW EACH CALCULATION STEP AND DESCRIBE IT ROUND answers to 2 decimal points. Time Year Season Sale 1 2018 Q1 1 2 Q2 7 3 Q3 3 4 Q4 2 5 2019 Q1 6 6 Q2 8 7 Q3 1 8 Q4 9 PART a) What is the seasonality index for second season...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT