Question

In: Finance

7.3 - Appendix Bank Balance Sheet (Note: Use this information for all three problems) Item                ...

7.3 - Appendix

Bank Balance Sheet (Note: Use this information for all three problems)

Item                             Amount            Duration       Interest Rate       

Cash-type Securities       $50m                1.2 year             2.25%

Commercial Loans          $100m             2.4 years           4.50%

Mortgages                     $350m             8.0 years           6.50%

Core Deposits                $270m             1.0 year             2.00%

Notes Payable                $180m             2.0 years           4.50%

3. Off-Balance sheet futures hedge (Use balance sheet information above, 8 points)

T-Bond futures contracts for the delivery of $100,000 face value are trading at 102-16, and have a duration of 9.50 years.

a. What is the total dollar price of each futures contract (PF)?

b. For this bank to achieve complete immunization, solve for F (total dollar value of futures contracts to immunize). Note: We don’t know the number of contracts yet or a specific interest rate change, so that information should not be used to solve for the dollar value F. Use only the information provided above to solve for F.

c. Using F from part b above, solve for the number of T-Bond futures contracts needed by this bank to hedge the interest rate risk (round to the nearest whole number of contracts).

d. Explain in a full essay what risk this bank faces, what position this bank would take on the T-Bond futures contracts to hedge against the interest rate risk it faces, why it would take that position, and graph that position in a fully-labeled futures payoff diagram.

Assume average interest rates rise from the original level of 6.0% to 7.50%.

e. Calculate the on-balance sheet change in the bank’s value (ΔE), and specify the sign (positive or negative)

f. Calculate the off-balance sheet change in the value of the futures contracts (ΔF), and specify if it’s a gain or loss.

g. Assume you are a financial analyst and risk management specialist for the bank above. Write a full, complete, and convincing essay (executive summary) of at least several complete paragraphs to your company’s CEO that summarizes the main conclusions from this third problem, and specifically refer to your numerical results from parts e and f.

Solutions

Expert Solution

The contract size for Treasury future is usually $100,000. Each contract trades in handles of $1,000,

but these handles are split into thirty-seconds, or increments of $31.25 ($1,000/32)

a)$ Price of Futures Contract = $102.5

b)$ Value of futures Contract = $100000+$2000+($1000*16/32) = $102500

c) 1000 Future Contracts

e)

Assets Amount($M) Weight(%) Duration Weighted Duration
Cash-type Securities 50 0.1 1.2 0.12
Commercial Loans 100 0.2 2.4 0.48
Mortgages                      350 0.7 8 5.6
Total 500 6.2
Liabilities Amount($M) Weight(%) Duration Weighted Duration
Core Deposits 270 0.6 1 0.6
Notes Payable 180 0.4 2 0.8
Total 450 1.4
Duration Gap = Average duration of Assets-(Liabilities/Assets)*Average Duration of liabilities
Interest Rate = 0.06
Change in Interest rate = 0.075-0.06=0.015
Chane in Asset as a % = - Average Duration *(Change in Interest rate/(1+Interest Rate))

= -8.77%

F)

Change in Value of Futures contact on account of Change in Interest rate from 6 to 7.5%
Formula

Duration/((1+YTM)/2)*Market value of bond*0.015

= $14042

g) To,

CEO,

ABC Bank

On account of change in interest rate from 6 to 7.5% Value of bank assets decreased by $43.87

and Futures contract value decreased by $14042 since Treasury bond value is inversely related with Interest rate increase

In order to overcome this in Future we have to enter in to Interest rate Forward rate so that Our Portfolio values will not be effected by change in interest rates


Related Solutions

Bank Balance Sheet (Note: Use this information for all three problems) Item                             Amount  &nb
Bank Balance Sheet (Note: Use this information for all three problems) Item                             Amount            Duration       Interest Rate        Cash-type Securities       $50m                1.2 year             2.25% Commercial Loans          $100m             2.4 years           4.50% Mortgages                     $350m             8.0 years           6.50% Core Deposits                $270m             1.0 year             2.00% Notes Payable                $180m             2.0 years           4.50% 2. On-Balance Sheet Immunization Analysis (Use balance sheet information above, 6 points) Immunization formulas: 1) Setting DA x A = DL x L will immunize...
7.1 (E) Please assist with E Bank Balance Sheet (Note: Use this information for all three...
7.1 (E) Please assist with E Bank Balance Sheet (Note: Use this information for all three problems) Item                             Amount            Duration       Interest Rate        Cash-type Securities       $50m                1.2 year             2.25% Commercial Loans          $100m             2.4 years           4.50% Mortgages                     $350m             8.0 years           6.50% Core Deposits                $270m             1.0 year             2.00% Notes Payable                $180m             2.0 years           4.50% 1. Deposit Outflow Analysis (6 points) a. Calculate the bank’s assets (A), liabilities (L) and its current value, or...
7.3 Part D Bank Balance Sheet Item                             Amount         &n
7.3 Part D Bank Balance Sheet Item                             Amount            Duration       Interest Rate        Cash-type Securities       $50m                1.2 year             2.25% Commercial Loans          $100m             2.4 years           4.50% Mortgages                     $350m             8.0 years           6.50% Core Deposits                $270m             1.0 year             2.00% Notes Payable                $180m             2.0 years           4.50% 3. Off-Balance sheet futures hedge (Use balance sheet information above, 8 points) T-Bond futures contracts for the delivery of $100,000 face value are trading at 102-16, and have a duration...
You are given the following balance sheet information about Bank of the Coyote. Use it to...
You are given the following balance sheet information about Bank of the Coyote. Use it to answer the questions. Assets Liabilities Reserves at the Fed $1.2 million Checkable Deposits $6 million Vault Cash $0.3 million Saving Deposits $9 million Loans $15 million Time Deposits $4 million Securities $9 million Federal Funds loans $2.5 million Federal Funds loans $0 million Bank Capital $4 million a. Calculate Bank of the Coyote's leverage ratio. b. Suppose the Bank of the Coyote earned $0.8...
Use the following balance sheet information to answer this question. Balance Sheet (dollars in thousands) and...
Use the following balance sheet information to answer this question. Balance Sheet (dollars in thousands) and Duration (in years) Duration Amount T-bills 0.5 90 T-notes 0.9 55 T-bonds 4.393 176 Loans 7 2,724 Deposits 1 2,092 Federal funds 0.01    238 Equity 715 A )What is the average duration of all the assets? B )What is the average duration of all the liabilities? C )What is the FI’s leverage-adjusted duration gap? What is the FI’s interest rate risk exposure? D...
In addition to the bank balance sheet information shown below, the bank also has an Allowance...
In addition to the bank balance sheet information shown below, the bank also has an Allowance for Loan Losses (ALL) of $10. The preferred stock shown is qualifying noncummulative perpetual preferred stock. Calculate the two required Basel I ratios and also the leverage ratio to answer the following: (1) Does this bank currently comply with Basel I capital requirements (why or why not?)? (2) Under U.S. PCA standards, what capitalization class or level does this bank currently possess and why?...
Question 16             1 pts Use the following information for the next three items. The balance sheet...
Question 16             1 pts Use the following information for the next three items. The balance sheet of Y Company showed the following: Accounts payable P145,000 Accounts receivable 110,000 Accrued liabilities 4,000 Cash 80,000 Income tax payable 10,000 Inventory 140,000 Marketable securities 250,000 Notes payable, short-term 85,000 Prepaid expenses 15,000 The amount of working capital for the company is Group of answer choices P211,000 P351,000 P336,000 P361,000 Question 171 pts The company’s current ratio as of the balance sheet date is...
Refer to the information below for XYZ Corporation for the problems below. Balance Sheet 2007               ...
Refer to the information below for XYZ Corporation for the problems below. Balance Sheet 2007                2008 Cash                                                                9,000             500 A/R                                                                 12,500             16,000 Inventories                                                      29,000             45,500 Total Current Assets                                       50,500            62,000 Land                                                                20,000             26,000 Plant & Equipment                                         70,000             100,000 Less Accumulated Depreciation                     (28,000)         (38,000) Total Fixed Assets                                          62,000             88,000 Total Assets                                      ...
Bank A Balance Sheet Assets                                     &nbsp
Bank A Balance Sheet Assets                                      Liabilities                           Reserves         $60 million      Deposits   $600 million Loans           $640 million      Capital     $100 million Bank B Balance Sheet Assets                                      Liabilities                           Reserves         $90 million      Deposits   $600 million Loans           $610 million      Capital     $100 million Assume the Required Reserve Ratio is 10% as mandated by the Fed. Both banks are free to keep required reserves in accordance with their respective bank policies. If both banks suffer a $10 million deposit outflow, which bank is in a better shape now, Bank A or Bank B? Why? Explain your answer by showing and usingboth banks’...
Use the financial statements below for problems 4 to 7                               Balance Sheet Assets
Use the financial statements below for problems 4 to 7                               Balance Sheet Assets 2017 2018 Cash $14,000 $9,282 Short-term investments. 48,600 18,000 Accounts receivable 351,200 632,160 Inventories 710,200 1,287,360    Total current assets $1,124,000 $1,946,802 Gross fixed assets 491,000 1,202,950 Less: accumulated depreciation 146,200 263,160    Net fixed assets $344,800 $939,790 Total assets $1,468,800 $2,886,592 Liabilities and equity 2017 2018 Accounts payable $145,600 $324,000 Notes payable 200,000 720,000 Accruals 136,000 284,960    Total current liabilities $481,600 $1,328,960 Long-term debt...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT