Question

In: Finance

Table 2 list various accounts from a bank's balance sheet ($'s in millions). In year 2 the bank's total net income was $5 million.

 

Table 2:

Balance Sheet Account Year 1 ending balance Year 2 ending balance
Stock Issued $50 $50
Cash and Reserves $80 $89
Allowance for Loan Losses ($20) ($21)
Federal Funds Purchased $70 $65
Demand Deposits $650 $685
Treasury Bills Purchased $230 $220
Retained Earnings $70 $75
Bank Bonds issued $130 $130
Commercial Loans made $500 $550
Now Accounts $100 $125
Net Building/Equipment $100 $120

Question 3: Table 2 list various accounts from a bank's balance sheet ($'s in millions). In year 2 the bank's total net income was $5 million. What was the bank's Return on Assets (ROA) in year 2? Show you answer as a percentage to two decimal places in the following format x.xx%

Question 4: Using the same information in table 2 and keeping constant the assumption that the bank made $5 million of net income in year 2, what was the bank's Return on Equity (ROE) in year 2? Show you answer as a percentage to two decimal places in the following format x.xx%

Question 5: Using the data from table 2 and the following four new pieces of information:

  1. Assume that the interest rate that the bank charges on its Commercial Loans is 7.5%,
  2. Assume the bank receives interest income of 2.5% on all of its financial security holdings.
  3. Assume that the bank pays an average interest rate of 2% on all of its customer deposit accounts
  4. And also assume that the bank pays 5% interest rate on the bonds that it has issued.

Calculate the bank's Net Interest Margin (NIM).   Show you answer as a percentage to two decimal places in the following format x.xx%

Solutions

Expert Solution

Q-4) Return on equity = Net profit/Equity = 5/104 =4.80%

where Equity = Shareholder's fund or total assets - total liablity = 1044-130-685-125 = 104

Q-5) Net Interest Margin = Interest returns - Interest expense/ Average earning assets = 48.375-22.7/1012= 2.53%

where, Interest returns= 41.25(7.5%on 550) + 7.125(2.5% on t bill and federal loan i.e 285) = 48.375

Interest expense = 6.5(5% on bonds 130) + 16.2(2% on deposites 685+125) = 22.7


Related Solutions

A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:   a.  How much is the​ firm's net working​ capital? b.  Complete an income statement and a balance sheet for Belmond. c. If you were asked to respond to parts ​(a​) and (b​) as part of a training​ exercise, what could you tell your boss about the​ company's financial condition based on your​ answers? SHEET Inventory 6,510 Common stock 45,100 Cash 16,590 Operating...
A scrambled list of accounts from the income statement and balance sheet of? Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of? Belmond, Inc. is found? here: Inventory   $6,450 Common stock   45,010 Cash   16,550 Operating expenses   1,390 Short-term notes payable   560 Interest expense   920 Depreciation expense    530 Sales   12,750 Accounts receivable   9,560 Accounts payable   4,840 Long-term debt   55,160 Cost of goods sold   5,720 Buildings and equipment   122,050 Accumulated depreciation   34,400 Taxes   1,440 General and administrative expense   810 Retained earnings   ? ?? a.??How much is the? firm's net working?...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:   Inventory 6,490 Common stock 45,000 Cash 16,550 Operating expenses 1,400 ​Short-term notes payable 570 Interest expense 850 Depreciation expense 470 Sales 12,710 Accounts receivable 9,630 Accounts payable 4,770 ​Long-term debt 54,610 Cost of goods sold 5,780 Buildings and equipment 121,650 Accumulated depreciation 33,790 Taxes 1,440 General and administrative expense 850 Retained earnings ​?  a.  How much is the​ firm's net working​ capital?...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:  . Inventory 6,460 Common stock 44,950 Cash 16,580 Operating expenses 1,350 ​Short-term notes payable 630 Interest expense 850 Depreciation expense 450 Sales 12,710 Accounts receivable 9,560 Accounts payable 4,760 ​Long-term debt 55,420 Cost of goods sold 5,740 Buildings and equipment 122,330 Accumulated depreciation 33,580 Taxes 1,490 General and administrative expense 880 Retained earnings ​?   a.  How much is the​ firm's net working​...
(Review of financial​ statements) A scrambled list of accounts from the income statement and balance sheet...
(Review of financial​ statements) A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here: a. How much is the​ firm's net working​ capital? b. Complete an income statement and a balance sheet for Belmond. Inventory   6,480 Common stock   45,090 Cash   16,510 Operating expenses   1,330 Short-term notes payable   560 Interest expense   900 Depreciation expense    500 Sales   12,850 Accounts receivable   9,640 Accounts payable   4,780 Long-term debt   54,750 Cost of goods sold   5,770 Buildings...
Burns Corporation's net income last year was $92,800. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $92,800. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 21,300 Accounts receivable $ 13,400 Inventory $ (17,600 ) Prepaid expenses $ 4,200 Long-term investments $ 11,000 Property, plant, and equipment $ 71,400 Accumulated depreciation $ 33,500 Liability and Equity Accounts: Accounts payable $ (18,400 ) Accrued liabilities $ 17,000 Income taxes payable $ 4,200 Bonds payable $ (64,200...
Burns Corporation's net income last year was $98,300. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $98,300. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 25,000 Accounts receivable $ 14,200 Inventory $ (17,100 ) Prepaid expenses $ 4,100 Long-term investments $ 11,000 Property, plant, and equipment $ 72,100 Accumulated depreciation $ 33,800 Liability and Equity Accounts: Accounts payable $ (19,600 ) Accrued liabilities $ 17,300 Income taxes payable $ 4,200 Bonds payable $ (62,400...
Burns Corporation's net income last year was $96,500. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $96,500. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 18,600 Accounts receivable $ 13,300 Inventory $ (16,300 ) Prepaid expenses $ 4,300 Long-term investments $ 10,300 Property, plant, and equipment $ 74,200 Accumulated depreciation $ 31,600 Liability and Equity Accounts: Accounts payable $ (19,400 ) Accrued liabilities $ 17,600 Income taxes payable $ 4,200 Bonds payable $ (63,600...
Megan Corporation's net income last year was $101,000. Changes in the company's balance sheet accounts for...
Megan Corporation's net income last year was $101,000. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ (5,400 ) Accounts receivable $ (17,000 ) Inventory $ 4,500 Prepaid expenses $ (9,100 ) Long-term investments $ 83,000 Property, plant, and equipment $ 61,000 Accumulated depreciation $ 64,000 Liability and Equity Accounts: Accounts payable $ 0 Accrued liabilities $ 17,020 Income taxes payable $ (12,120 ) Bonds payable...
Burns Corporation's net income last year was $94,600. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $94,600. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 17,000 Accounts receivable $ 13,300 Inventory $ (16,600 ) Prepaid expenses $ 4,300 Long-term investments $ 10,300 Property, plant, and equipment $ 73,500 Accumulated depreciation $ 31,600 Liability and Equity Accounts: Accounts payable $ (18,400 ) Accrued liabilities $ 17,100 Income taxes payable $ 4,200 Bonds payable $ (64,200...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT