Question

In: Finance

Consider the following balance sheet for ABC Inc( in millions) Assets Liabilities and Equity Floating Rate...

Consider the following balance sheet for ABC Inc( in millions)

Assets Liabilities and Equity
Floating Rate loans ( currently 6% annually) = $80 Demand Deposits(currently at 1% annually) = $30
20 year fixed rate loans ( currently 5% annually) = $20 Time Deposits( currently at 6% annually) = $60
Total Assets = $100 Equity = $10
Total Liabilities and Equity = $100

a) What is ABC's expected net interest income at year end?

b) What will be the net interest income at year end if interest rates rise by 100 basis points?

c) Using the cumulative IS Gap model, what is the expected net interest income for a 1 percent increase in interest rates?

d) Comparing b and c what do you observe?

Solutions

Expert Solution

a) calculating expected net interest income

Expected Net Interest income = interest income-interest expenses

therefore, expected interest income= 80*.06 +20*.05 = 5.8 (mn $)

expected expenses = 30*.01+60*.06=1.08 (mn $)

so expected net interest income = 5.8-1.08=4.72 (mn $)

b) Since interest rate is rising by 100bps, so it will affect only floating rate. fixed will remain same

therefore, expected net interest income = (80*.07+20*.05)-(30*.02+60*.06) = 2.4 (mn $)

c) repricing gap can be calculated by subtracting liabilities from assets in floating rate section-

therefore, repricing gap = 80-30 = 50

so change in income after 1 % increase in interest rates = 50 *.01 = 0.5

therefore there is a change of 0.5 (mn $)

d) there is drastic difference while comparing the results of Points B & C.

B says there will be change of 2.32 mn dollars however C identifies change of 0.5 mn dollar only. there is a difference of 1.82 when we compare both the methods.


Related Solutions

Consider the following balance sheet for Watchover Savings, Inc. (in millions): Assets Liabilities and Equity   Floating-rate...
Consider the following balance sheet for Watchover Savings, Inc. (in millions): Assets Liabilities and Equity   Floating-rate mortgages      (currently 12% p.a.) $ 86   Now deposits      (currently 8% p.a.) $ 118   30-year fixed-rate loans      (currently 9% p.a.) 103   5-year time deposits      (currently 8% p.a.) 26   Equity 45      Total $ 189   Total $ 189 a. What is Watchover’s expected net interest income at year-end? (Enter your answer in millions rounded to 2 decimal places. (e.g., 32.16))   Net interest income $  million b. What...
Consider the following balance sheet for Watchover Savings Inc. (in millions): Assets Liabilities and Equity Floating-rate...
Consider the following balance sheet for Watchover Savings Inc. (in millions): Assets Liabilities and Equity Floating-rate mortgages (currently 12% p.a.) $ 70 Now deposits (currently 8% p.a.) $ 110 30-year fixed-rate loans (currently 9% p.a.) 95 5-year time deposits (currently 8% p.a.) 21 Equity 34 Total $ 165 Total $ 165 a. What is Watchover’s expected net interest income at year-end? (Enter your answer in millions rounded to 2 decimal places. (e.g., 32.16)) b. What will be the net interest...
Consider the following balance sheet for WatchoverU Savings Inc. ($ in millions): Assets Liabilities Floating-rate mortgages...
Consider the following balance sheet for WatchoverU Savings Inc. ($ in millions): Assets Liabilities Floating-rate mortgages (currently 10% annually) $ 60 NOW accounts (currently 6% annually) $ 80 30-year fixed-rate loans (currently 7% annually) 60 Time deposits (currently 6% annually) 24 Equity 16 Total $ 120 $ 120 a. What is WatchoverU’s expected net interest income at year-end? b. What will be the net interest income at year-end if interest rates rise by 2 percent?
Consider the following Balance Sheet for Total Caribbean Bank(TCB) (in millions) ASSETS LIABILITIES Floating rate mortgages...
Consider the following Balance Sheet for Total Caribbean Bank(TCB) (in millions) ASSETS LIABILITIES Floating rate mortgages 120 Demand deposits 110 (currently 12% annually) (currently 3% annually) 30 years fixed rate loans 1 year CD 50 (currently 7% annually) 80 (currently 6% annually) Equity 40 200 200 a.      What is TCB expected net interest income (NII) at year end? (1mark) b.     What is TCB expected net interest income at year end if interest rates grew by 500 basis points. (1 mark)...
Consider the following income statement for WatchoverU Savings Inc. (in millions): Assets Liabilities Floating-rate mortgages (currently...
Consider the following income statement for WatchoverU Savings Inc. (in millions): Assets Liabilities Floating-rate mortgages (currently 12% annually) $ 63 NOW accounts (currently 8% annually) $ 83 30-year fixed-rate loans (currently 9% annually) 63 Time deposits (currently 8% annually) 26 Equity 17 Total $ 126 $ 126 a. What is WatchoverU’s expected net interest income at year-end? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places. (e.g., 32.16)) Net interest income $ 4.51 million...
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...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 10 years...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 10 years $950 Duration = 2 years $860 Equity     90 a)What is the FI's duration gap? b)What is the FI's interest rate risk exposure? c)How can the FI use futures and forward contracts to put on a macrohedge? d) What is the impact on the FI's equity value if the relative change in interest rates is an increase of 1 percent? That is, DR/(1+R) =...
Hillside, Inc. BALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS LIABILITIES Revenue      ...
Hillside, Inc. BALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS LIABILITIES Revenue       28,681.10 Cash & Marketable Securities          449.90 Accounts Payable       1,611.20 Cost Of Goods Sold       20,768.80 Accounts Receivable          954.80 Salaries Payable          225.20 Gross Profit         7,912.30 Inventories       3,645.20 Other Current Liabilities       1,118.80 Other Current Assets          116.60 Total Current Liabilities       2,955.20 Operating Expenses: Total Current Assets       5,166.50 Selling, General & Admin.         5,980.80 Other Liabilities          693.40...
Ratio Analysis: Balance Sheet (Millions of $)       Assets   Liabilities and Equity   Cash and securities $  1,554.0...
Ratio Analysis: Balance Sheet (Millions of $)       Assets   Liabilities and Equity   Cash and securities $  1,554.0 Accounts payable $  7,980.0 Accounts receivable 9660.00 Notes payable 5880.00 Inventories   13,440.0 Accruals     4,620.0 Total current assets 24654.00 Total current liabilities 18480.00 Net plant and equipment   17,346.0 Long-term bonds   10,920.0 Total assets 42000.00 Total debt 29400.00     Common stock 3360.00     Retained earnings     9,240.0     Total common equity 12600.00     Total liabilities and equity 42000.00 Income Statement (Millions of $)   Other data:   Sales 58800.00 Shares outstanding (millions) 175.00...
State Bank has the following year-end balance sheet (in millions): Assets Liabilities and equity Cash $  ...
State Bank has the following year-end balance sheet (in millions): Assets Liabilities and equity Cash $   10 Deposits $   90 Loans $   90 Equity $   10 Total assets $ 100 Total liabilities and equity $ 100 The loans primarily are fixed-rate, medium-term loans, while the deposits are either short-term or variable-rate deposits. Rising interest rates have caused the failure of a key industrial company, and as a result, 3 percent of the loans are considered uncollectable and thus have no...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT