Question

In: Finance

Calculate the duration of assets as a group and the duration of liabilities as a group, using a weighted-average approach

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 the bank against interest rate risk.

2) Setting the Leverage-Adjusted Duration Gap equal to 0 will also immunize the bank against interest rate risk

(0 = DA – k DL ).

a. Calculate the duration of assets as a group and the duration of liabilities as a group, using a weighted-average approach (weight each item by the percentage it represents of the total amount). Also, calculate and report the adjusted duration gap.

Assume the bank wants to leave its assets unchanged, and change the composition of its liabilities, but keep the current dollar amount of liabilities the same.

b. What DL would immunize the bank against interest rate risk? Use either immunization formula.

c. Assume the bank wants to keep its core deposits unchanged, but can issue new zero coupon bonds of any maturity to replace all of the current notes payable, and thereby achieve the desired DL. Calculate the required maturity of the zero-coupon bonds to immunize the bank against interest rate risk.

d. If the strategy in part b immunizes the bank from interest rate risk, and interest rates do rise from an average rate of 6.0% to 7.0%, calculate the new value of the bank’s assets (A), the bank’s liabilities (L) and the net worth (E). Use the formula: %A or %L = -D x [ ΔR / (1 + R) ]

e. Explain the main implications of this exercise in a full essay of a full paragraph or more, and refer specifically to your numerical results above.

Solutions

Expert Solution

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

By Changing the composition of Liabilities Core Deposits = 180$m & Notes Payable = $270M

Interest Rate = 0.06
Change in Interest rate = 0.07-0.06=0.01
Chane in Asset as a % = - Average Duration *(Change in Interest rate/(1+Interest Rate))
-5.85%
Change in Value of Assets          -29.25
New Value of Assets         470.75
Chane in Liabilities as a % = - Average Duration *(Change in Interest rate/(1+Interest Rate))
-1.32%
Change in Value of Liabilities            -5.94
New Value of Liabilities         444.06

Related Solutions

Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
What is the duration GAP of a bank whose assets and liabilities are as follows? Assets:...
What is the duration GAP of a bank whose assets and liabilities are as follows? Assets: Cash $48 million Short-term Investments (D=0.8) $149 million Short-term Loans (D=0.6) $201 million Long-term Investments (D=4.2) $254 million Long-term Loans (D=6.2) $398 million Liabilities: Demand Deposits $46 million Short-term Interest-bearing Deposits (D=0.3) $595 million CDs (D=2.5) $148 million Borrowed funds (D=0.1) $153 million Round to three decimals.
What is the duration GAP of a bank whose assets and liabilities are as follows? Assets:...
What is the duration GAP of a bank whose assets and liabilities are as follows? Assets: Cash $52 million Short-term Investments (D=0.4) $153 million Short-term Loans (D=0.8) $201 million Long-term Investments (D=3.8) $247 million Long-term Loans (D=5.2) $400 million Liabilities: Demand Deposits $46 million Short-term Interest-bearing Deposits (D=0.3) $592 million CDs (D=2.8) $148 million Borrowed funds (D=0.1) $151 million Round to three decimals.
Many banks have a duration mismatch between their assets and their liabilities. Explain why this duration...
Many banks have a duration mismatch between their assets and their liabilities. Explain why this duration mismatch arises and how swaps can be used to manage the interest rate risk caused by this duration mismatch.
The composition of the assets and liabilities of a financially strong NBFC are as follows: Duration...
The composition of the assets and liabilities of a financially strong NBFC are as follows: Duration of assets: 5.1 years, duration of liabilities: 2.1 years. What is its Leverage-adjusted duration? Select one: since value of assets and liabilities are not given, can we assume something here for K a. Equal to 3 years b. Almost equal to 3.6 years c. >3 years d. <3 years
how to calculate the balance using the weighted average method on the ledger card
how to calculate the balance using the weighted average method on the ledger card
Using the information provided, calculate the weighted average number of common shares in circulation for the...
Using the information provided, calculate the weighted average number of common shares in circulation for the year 2020.  The common shares of a company were 120,000 on January 1, 2020.  On February 1, the company issued 60,000 additional shares  Another 48,000 were issued on March 1.  On April 1, the company issued 24,000 new shares.  On May 1, the company bought 36,000 portfolio shares  Purchased another 36,000 portfolio shares on June 1.  On...
Using the following information, calculate the Weighted Average Cost of Capital (Ka) for the Carmel Restaurant:...
Using the following information, calculate the Weighted Average Cost of Capital (Ka) for the Carmel Restaurant: Capital Structure is 40% debt/ 60% equity, Interest Rate (Kdbt) = 7.5%, tax rate = 30%, market portfolio (Km) = 10.5%, risk-free rate = 4%, beta is estimated at 0.9 and the company has enough in new retained earnings to finance the equity portion of the capital budget.
How do you calculate risk-weighted assets?
How do you calculate risk-weighted assets?
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 13 years...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 13 years $ 970 Duration = 5 years $ 900 Equity 70 a. What is the FI’s duration gap? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16)) b. What is the FI’s interest rate risk exposure? c. How can the FI use futures and forward contracts to create a macrohedge? d. What is the impact on the FI’s equity value...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT