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:

Assume that the interest rate that the bank charges on its Commercial Loans is 7.5%,
Assume the bank receives interest income of 2.5% on all of its financial security holdings.
Assume that the bank pays an average interest rate of 2% on all of its customer deposit accounts
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

jeff jeffy answered 1 year ago

Next > < Previous

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...

Subjects