Concept explainers
Duration Blue Stool Community Bank has the following market value balance shoot:
Asset or Liability | Market value (in $ million) | Duration (in year) |
Federal funds deposits | $ 31 | 0 |
Accounts receivable | 540 | .20 |
Short-term loans | 320 | .65 |
Long-term loans | 98 | 5.25 |
Mortgages | 435 | 12.85 |
Checking and savings deposits | 615 | 0 |
Certificates of deposit | 390 | 1.60 |
Long-term financing | 285 | 9.80 |
Equity | 134 | N/A |
- a. What is the duration of the assets?
- b. What is the duration of the liabilities?
- c. Is the bank immune to interest rate risk?
a.
To calculate: Duration of assets.
Duration:
It is an object used in bond valuation to determine the sensitivity of the bond. High duration comes with high probability of interest rate risk while in lower duration there is low risk of interest rate fluctuation.
Explanation of Solution
Calculation of duration of assets
Assets |
Amount ($) |
Duration (in years) |
Federal Fund deposits | 31 | 0 |
Account receivables | 540 | 0.20 |
Short term loans | 320 | 0.65 |
Long term loan | 98 | 5.25 |
Mortgage | 435 | 12.85 |
Total | 1,424 |
Table (1)
Given,
Amount of federal fund deposit is $31.
Duration is 0 years.
Total amount of assets is $1,424.
Formula to calculate duration,
Substitute $31 for amount of federal fund deposit, 0 for number of years and $1,424 for total amount of assets.
So, duration for federal fund deposit is 0 year.
Given,
Amount of account receivables is $540.
Duration is 0.20 years.
Total amount of assets is $1,424.
Formula to calculate duration,
Substitute $540 for amount of account receivables, 0.20 years for number of years and $1,424 for total amount of assets.
So, duration for account receivables is 0.07584 year.
Given,
Amount of short term loans is $320.
Duration is 0.65 years.
Total amount of assets is $1,424.
Formula to calculate duration is
Substitute $320 for amount of short term loans, 0.65 years for number of years and $1,424 for total amount of assets.
So duration for Short term loans is 0.14606 year.
Given,
Amount of long term loan is $98.
Duration is 5.25 years.
Total amount of assets is $1,424.
Formula to calculate duration,
Substitute $98 for amount of long term loan, 5.25 years for number of years and $1,424 for total amount of assets.
So, duration for long term loans is
Given,
Amount of mortgage is $435.
Duration is 12.85 years.
Total amount of assets is $1,424.
Formula to calculate duration,
Substitute $435 for amount of mortgage, 12.85 years for number of years and $1,424 for total amount of assets.
So, duration for mortgage is 3.9253 years.
Calculation of total duration of assets
Calculated values,
Duration of federal fund deposits 0 year.
Duration of account receivables is 0.07584 year.
Duration of short term loans is 0.14606 year.
Duration of long term loan is
Duration of mortgage is 3.9253 years.
Formula to calculate to total duration,
Substitute 0 year for asset 1, 0.07584 year for asset 2, 0.14606 year for asset 3, 0.36130 year for asset 4, and 3.9253year for asset 5.
So, total duration of assets is 4.5085 years.
b.
To calculate: Duration of liabilities.
Explanation of Solution
Calculation of duration of liabilities
Liabilities |
Amount ($) |
Duration (in years) |
Checking and saving deposit | 615 | 0 |
Certificates of deposit | 390 | 1.60 |
Long term financing | 285 | 9.80 |
Equity | 134 | N/A |
Total | 1,424 |
Table (2)
Given,
Amount of checking and saving deposit is $615.
Duration is 0 years.
Total amount of liabilities is $1,424.
Formula to calculate duration,
Substitute $615 for amount of checking and saving deposit, 0 for number of years and $1,424 for total amount of liabilities.
So, duration for checking and saving deposit is 0 year.
Given,
Amount of certificates of deposit is $390.
Duration is 1.60 years.
Total amount of liabilities is $1,424.
Formula to calculate duration,
Substitute $390 for amount of certificates of deposit, 1.60 years for number of years and $1,424 for total amount of liabilities.
So, duration for certificates of deposit is 0.43820 year.
Given,
Amount of long term financing is $285.
Duration is 9.80 years.
Total amount of liabilities is $1,424.
Formula to calculate duration,
Substitute $285 for amount of long term financing, 9.80 years for number of years and $1,424 for total amount of liabilities.
So, duration for long term financing is 1.96 year.
Calculation of total duration of liabilities
Given,
Duration of checking and saving deposit is 0 year.
Duration of certificates of deposit is 0.43820 year.
Duration of long term financing is 1.96 year.
Formula to calculate to total duration,
Substitute 0 year for liability 1, 0.43820 year for liability 2, and 1.96 year for liability 3.
So total duration of liabilities is 2.3982 years
c.
To explain: Whether the bank is immune to interest rate risk or not.
Answer to Problem 8QP
No, bank is not immune to interest rate risk.
Explanation of Solution
Since, the duration of assets and duration of liabilities is not the same, bank is not immune to the interest rate risk. It is mandating that the duration of assets and duration of liability to match for immune the interest rate of risk.
Therefore, bank is not immune to the interest rate of risk due the different duration of assets and liabilities.
Want to see more full solutions like this?
Chapter 25 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
- Nearby Bank has the following balance sheet (in millions): Assets Liabilities and Equity Cash $60 Demand deposits $140 5-year T notes $60 1-year CD $160 30-year mortgages $200 Equity $20 Total Assets $320 Total L and E $320 What is the maturity gap for Nearby Bank?arrow_forwardShow the Bank’s balance sheet if the Bank purchases liabilities to offset a net deposit drain of $10 million (required reserves ratio 7%): Assets :Cash $10Traiding portfolio $15Loans $50Investment portfolio $25Liabilities and Equitites:Deposits $68Interbank loans $20Equity $12arrow_forwardA Input Area: Interest Income $ Amount of line of credit Term (months) Annualized interest rate on line of crdt Interest Cost Average deposit balance Annualized interest rate on deposit bal Expected Revenues Loan commitment fee (1%) Deposit management fees Wire transfer fees B Fees for agency services Expected Costs Cost of other funds raised Account activity costs Wire transfer costs Loan processing costs Recordkeeping costs Output Area: Expected Revenues Interest income from loan (4%, 9 mo,) Loan commitment fee (1%) Deposit management fees Wire transfer fees Fees for agency services Total Revenues Expected Costs Interest paid on customer deposits Cost of other funds raised Account activity costs Wire transfer costs Loan processing costs Recordkeeping costs Total Costs Total Revenues - Total Costs Before-tax rate of return over costs from the entire relationship C 10,000,000 6 4.00% 2,125,000 2.50% 100,000 4,500 3,500 4,500 180,000 5,000 1,300 12,400 4,500 D Earrow_forward
- Consider the following balance sheet for Whiz Financial Services Limited: Assets K Liabilities K Cash 6.25 Equity 25.00 Short term consumer loans (1 yr maturity)62.50 Demand deposits 50.00 Long term consumer loans (2 yr maturity)31.25 Client Savings accounts 37.50 3 month T-Bills 37.50 3 month CDs 50.00 6 month T-Bills 43.75 3 months Bankers Acceptances 25.00 3 year T-Bonds 75.00 6 month commercial paper 75.00 10 year, fixed rate mortgages 25.00…arrow_forwardA bank’s customer wants to exercise a $6,750,000 loan commitment. Show the balance sheet after the loan is established using purchased liquidity to fund the loan. Assets Liabilities and Equity Cash $1,550,000 Deposits $7,960,000 Loans 3,470,000 Equity 1,440,000 Securities 4,380,000 Total Assets $9,400,000 Total Liabilities and Equity $9,400,000 Please answer with excel explaination. Don't upload image.arrow_forwardThe T-account below represents assets and liabilities for a bank. Use the T-account to calculate the bank's loans Loans Bonds Reserves Provide your answer below: million Assets ? $18 million $5 million Liabilities + Net Worth Deposits Net Worth $12 million $13 millionarrow_forward
- Assume a bank has the following balance sheet. Determine the 2-year GAP. AssetAmount LiabilityAmountCash$100 90-day CDs$1006-month Gbonds$400 360-day CDs$200 2-yearcommercialloans$400 Time Deposits 2- year $900 5-year fixedrate loans$500 Stockholder’s equity$200 Total$1,400 Total$1,400 GAP = (RSA2 yr – RSL2 yr) 0 -$100 -$200 -$300 -$800arrow_forwardContinental Bank holds assets and liabilities as follows: Assets Amount (million) Duration Liabilities Amount (million) Duration Commercial loans 170 3.7 Deposits 280 0.80 Consumer loans 166 2.9 Certificates of deposit 180 1.60 Mortgage loans 270 9.2 Original interest rate = 3.75% Original interest rate = 1.25% 1.The bank expects interest rates on assets and liabilities to rise to 4.25% and 1.75% respectively. What is the net change in net worth if the bank’s expectation on the interest rate change is correct? Show your calculations. 2.The bank would like to be immune from interest rate change, and it would like to maintain the duration of the liabilities. What is the target duration of the assets the bank should try to achieve?arrow_forwardAssume a bank has the following balance sheet. Determine the 2-year GAP. Asset Amount Liability Amount Cash $100 90-day CDs $100 6-month $400 360-day CDs $200 Gbonds Time Deposits 2- year 2-year $400 $900 commercial loansarrow_forward
- Consider the following bank balance sheet and the associated yields for earning assets and costs of liabilities. Assets Amount (000). Rate cash 400. 0% securitie 1600. 6.5% commercial loans 4000 9.0% credit card loans 3300. 10.0% loss reserves. 200 other assets 500 total assets. 10,000 Liabilities and equity Demand deposits. 1600 MMDAs. 3600 6.0% CDs. 2600 6.5% ST deposits. 1360. 5.0% Deferret tax credit. 200 Equity 640 total. 10000 Assume that net charge-offs $44,000 cash taxes paid $78,000 and allocated risk capital is $550,000 with a capital charge of 6 percent. determine : a) Calculate and show the bank income statement.arrow_forwardb) The Balance Sheet for First Union Bank are shown below: Balance Sheet (in millions) Assets Cash and due from banks Investment securities Federal funds sold Net loans Premises Total iii) Total operating income Liabilities and Equity iv) Asset utilization ratio $380 Demand deposits 1,650 Small time deposits 880 Jumbo CDs 5,300 Federal funds purchased 400 Equity $8,610 Total liabilities and equity $3,000 2,200 2,550 70 790 The interest income for First Union Bank is $730 million and the noninterest income is $200 million. Calculate the following ratios and show each step of your calculation. Explain your results. $8,610arrow_forwardb) The Balance Sheet for First Union Bank are shown below: Balance Sheet (in millions) Assets Cash and due from banks Investment securities Federal funds sold Net loans Premises Total Liabilities and Equity Demand deposits iv) Asset utilization ratio $380 1,650 Small time deposits 880 Jumbo CDs 5,300 Federal funds purchased 400 Equity $8,610 Total liabilities and equity $3,000 2,200 2,550 70 790 $8,610 The interest income for First Union Bank is $730 million and the noninterest income is $200 million. Calculate the following ratios and show each step of your calculation. Explain your results.arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education