Evaluating Bank performance -Problem TwoGiven the following information for MSH bank, knowing that this is the overall financialdata and any missing data refer to a zero account. Also, all the investments accounts in theassets section are considered to be short-term with maturity less than one year. Answerquestions I to 11 below:Cash and due from banks$ 250,000$ 73,342.000$ 34,450,000$ 2,298,000$ 13,840,000Total Llabilities and Equity $ 123,930,000Demand DepositsTime DepositsFederal Funds PurchasedFed Funds Sold$ 925.000$ 95,555.000$ 27,200,000$ 123,930.000Investment SecuritiesLoansEquityFixod AssetsTotal Assetstax rate40%interest on loans15.40%interest on investmentsInterest on time depositsinterest on federal funds purchasedNo interest on demand depositsOverhead ExpensesEarning assets % of total assets8.30%4.85%6.10%$120,00075%42O2,700Z.700JOU, 5502- The Net Income is:a- $6,800,815.25O b- $7,716,745.20O c- $5,235,920.32O d- $4,921,440.24e- None of the above

Net income refers to the leftover profit of a company after deducting all the expenses from the…

Given the following information for MSH bank, knowing that this is the overall financial data and any missing data refer to a zero account. Also, all the investments accounts in the assets section are considered to be short-term with maturity less than one year. Answer questions 1 to 11 below: Cash and due from banks $250,000 Fed Funds Sold Investment Securities Loans Fixed Assets Total Assets tax rate interest on loans interest on investments $ $925,000 $ 95,555,000 $ 27,200,000 $123,930,000 40% 15.40% 8.30% 4.85% 6.10% $120,000 75% interest on time deposits interest on federal funds purchased No interest on demand deposits Overhead Expenses Earning assets % of total assets Demand Deposits Time Deposits Federal Funds Purchased Equity $ 73,342,000 34,450,000 $ $ 2,298,000 $ 13,840,000 Total Liabilities and Equity $123,930,000

Given the following information for MSH bank, knowing that this is the overall financial data and any missing data refer to a zero account. Also, all the investments accounts in the assets section are considered to be short-term with maturity less than one year. Answer questions 1 to 11 below: Cash and due from banks $250,000 Fed Funds Sold Investment Securities Loans Fixed Assets Total Assets tax rate interest on loans interest on investments $ $925,000 $ 95,555,000 $ 27,200,000 $123,930,000 40% 15.40% 8.30% 4.85% 6.10% $120,000 75% interest on time deposits interest on federal funds purchased No interest on demand deposits Overhead Expenses Earning assets % of total assets Demand Deposits Time Deposits Federal Funds Purchased Equity $ 73,342,000 34,450,000 $ $ 2,298,000 $ 13,840,000 Total Liabilities and Equity $123,930,000

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter5: Internal Control And Cash

Section: Chapter Questions

Problem 5.21E

See similar textbooks

Similar questions

a) Bank A has the following balance sheet (in millions): Assets Cash Securities Loans Total assets $5 10 55 $70 Liabilities and equity Deposits Equity Total liabilities and equity The bank is expecting a $12 million net deposit drain. $62 8 $70 i) Show the new balance sheet if the bank uses purchased liquidity management to offset the expected drain. Also, explain the effect on the size and composition of assets and liabilities ii) Show the new balance sheet if the bank uses stored liquidity management to offset the expected drain. Also, explain the effect on the size and composition of assets and liabilities.
a) Bank A has the following balance sheet (in millions): Assets Cash Securities Loans Total assets $70 The bank is expecting a $12 million net deposit drain. Liabilities and equity Deposits Equity Total liabilities and equity $5 10 55 $62 9 $70 ii) Show the new balance sheet if the bank uses stored liquidity management to offset the expected drain. Also, explain the effect on the size and composition of assets and liabilities.
Balance sheet ($ million) Cash $10 50 Loans Securities 15 Deposit Equity $68 7 The bank is expecting a $15 net deposit drain. Show the bank's balance sheet if: a. The bank purchases liability to offset this expected drain. b. The bank uses the asset side liquidity to finance this expected drain.
The bank that you own has the following balance sheet: Assets Liabilities $ 60 million Deposits $120 million Bank capital $420 million Reserves $500 million $100 million Securities Loans a) Record a bookkeeping immediately after the bank suffers a deposit outflow of $50 million when a required reserve ratio on deposits is 10%. What problem do you see on the T-account after the event? Assets Liabilities Reserves Deposits Bank capital Securities Loans b) What action(s) you want to take to rectify the situation? Make your suggestion(s) in terms of the T-account and explain them. Assets Liabilities
C & D ONLY
SHOW FORMULAS USING EXCELNO FORMULAS = NO UPVOTE
Consider the balance sheet for Inspired to Thrive (IT) Bank below: Inspired to Thrive Bank Balance Sheet as at December 31, 2021 Assets SLiabilities and Owner's Equity 275 Deposits 1,105 Debts 660 Owner's Equity Reserves 1,550.00 Loans 340.00 Securities 150.00 2,040 2,040.00 What is the leverage ratio of IT bank? Why is this ratio significant to the bank's operation?
Ore
Key information from the balance sheet of Transurban Bank is given below (all numbers are in millions of dollars). Cash Loans Total Assets 40 160 200 a. $0.3600 million O b. $0.2100 million O c. $0.1700 million O d. $0.1400 million e. None of the other options is correct Liabilities and equity 156 24 20 Deposits Long-term debt Equity Total 200 Due to increasing competition, the bank expects its deposits to decrease by $24 million. The average interest earned on the loans is 5 percent and the average cost of deposits is 3.5 percent. Borrowing more debt will cost the bank 4.5 percent in the short term. The bank intends to keep $30 million in cash to meet its liquidity needs and then compensate any shortfall to fund its loans by purchasing liquidity. What will be the cost of using this strategy to meet the expected decline in deposits?
Given Bank A's Statement of Condition and Statement of Earnings, answer the next two questions: If the average net interest margin for this type of bank is 4.65 percent, then, ceteris paribus, this particular bank is performing
Consider the following data : Total interest income 520,500 Total interest expense 145,300 Non interest income 65,200 Non interest expense 45,800 Provision for loan losses 5,400 Loss on securities 2,500 Taxes 1,800 The bank efficiency ratio would be Select one: O a. 14.77% O b. 10.40% O c. -65% O d. 65%
Give typing answer with explanation and conclusion A bank has the following assets: cash and government bonds of $31.07, government agency bonds of $22.3, mortgages of 66.21, and loans to individuals and corporations of 133.46. According to Basel 1, what is the ratio of the bank's risk-weighted assets to total assets? Express in % to the nearest 0.01%; drop the % symbol. Blank 1. Calculate the answer by read surrounding text.