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

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter6: Cash And Receivables

Section: Chapter Questions

Problem 12C: Researching GAAP Situation Hamilton Company operates in an industry with numerous competitors. It is...

See similar textbooks

Similar questions

a)Calculate the equity (total asset –total liability) to asset ratio of the bank (Hint: equity to asset ratio = total equity/total asset) b)Calculate the duration and convexity of the both asset and liability sides; c)If the interest rates go up by 1%, using the duration and convexity ruleto determine the net worth of the bank and the equity to asset ratio; d)In c)’s scenario, to maintain the equity to asset ratio at 40% which is required by the regulation, the bank decides to raise cash (zero duration and zero convexity) from the equity holders. How much cash does the bank need to raise? e)Do you agree with the following statement? Explain why.“The information about a bond’s duration and convexity adjustment is sufficient to quantify interest rate risk exposure.” please can you answer part d and e
a)Calculate the equity (total asset –total liability) to asset ratio of the bank (Hint: equity to asset ratio = total equity/total asset) b)Calculate the duration and convexity of the both asset and liability sides; c)If the interest rates go up by 1%, using the duration and convexity rule to determine the net worth of the bank and the equity to asset ratio; d)In c)’s scenario, to maintain the equity to asset ratio at 40% which is required by the regulation, the bank decides to raise cash (zero duration and zero convexity) from the equity holders. How much cash does the bank need to raise? e)Do you agree with the following statement? Explain why.“The information about a bond’s duration and convexity adjustment is sufficient to quantify interest rate risk exposure.”
The money creation process Suppose Southeast Mutual Bank, Walls Fergo Bank, and PJMorton Bank all have zero excess reserves. The required reserve ratio is presently set at 20%. Brian, a Southeast Mutual Bank customer, deposits $1,500,000 into his checking account at the local branch. Complete the following table to reflect any changes in Southeast Mutual Bank's T-account (before the bank makes any new loans). Assets Liabilities 2 categories under Assets: 1. Building and furniture, Deposits, Loans, Net worth or Reserves 2. $300,000 or $1,200,000 or $1,500,000 or $3,600,000 2 Categories under Liabilities: 1. Building and furniture, Deposits, Loans, Net worth or Reserves 2. $300,000 or $1,200,000 or $1,500,000 or $3,600,000 Complete the following table to show the effect of a new deposit on excess and required reserves when the required reserve ratio is 20%. Hint: If the change is negative, be sure to enter the value as negative number. Amount Deposited Change in…
Bank L's balance sheet(in millions) is provided below.The bank does not have any off-balance-sheet activity. 1.Please calculate Tier 1 risk-based capital ratio of the bank. 2.Please calculate the total risk-based capital ratio of this bank. Assets Liabilities and Equity Cash $20 Deposits $980 Treasury bonds(risk-weight=0) $40 Subordinated debentures $25 Mortgate loans(risk-weight=50%) $600 Common Stock $45 Business Loans $430 Retained earnings $40 Total assets $1090 Total liabilities and equity $1090
Bank L's balance sheet(in millions) is provided below.The bank does not have any off-balance-sheet activity. Please calculate Tier 1 risk-based capital ratio of the bank. Assets Liabilities and Equity Cash $20 Deposits $980 Treasury bonds(risk-weight=0) $40 Subordinated debentures $25 Mortgate loans(risk-weight=50%) $600 Common Stock $45 Business Loans $430 Retained earnings $40 Total assets $1090 Total liabilities and equity $1090
Entity A is preparing its March 31, 20x1 bank reconciliation. The following information was determined: a. The cash balance per books is ₱280,000 while the cash balance per bank statement is ₱320,000. b. Credit memo – ₱20,000 c. Debit memo – ₱15,000d. Deposits in transit – ₱75,000 e. Outstanding checks – ₱25,000 f. The disbursements per books are overstated by ₱45,000. g. The bank debits are understated by ₱40,000. How much is the adjusted cash balance per bank?
Bank L's balance sheet(in millions) is provided below.The bank does not have any off-balance-sheet activity. Please calculate the total risk-based capital ratio of this bank Assets Liabilities and Equity Cash $20 Deposits $980 Treasury bonds(risk-weight=0) $40 Subordinated debentures $25 Mortgate loans(risk-weight=50%) $600 Common Stock $45 Business Loans $430 Retained earnings $40 Total assets $1090 Total liabilities and equity $1090
Below is the balance sheet for a bank. Under "Other" it has listed "$X" just think of this as the dollar amount needed to make the balance sheet balance. It is not important what that value is for this question. AssetsLiabilitiesReserves 40Deposits 215Loans 160 Securities 40Other $X Using the balance sheet above, find the level of excess reserves this bank is holding if the required reserve ratio = 8%(Give answers to 2 decimal places as needed)
Entity A is preparing its March 31, 20x1 bank reconciliation. The followinginformation was determined: a.The cash balance per books is₱280,000 while the cash balance per bank statement is₱320,000. b.Credit memo–₱20,000 c.Debit memo –₱15,000 d.Deposits in transit –₱75,000 e.Outstanding checks –₱25,000 f.The disbursements per books are overstated by₱45,000. g.The bank debits are understated by₱40,000. Requirement:Prepare the bank reconciliation.
.Entity A is preparing its March 31, 20x1 bank reconciliation. The following information was determined:a. The cash balance per books is ₱280,000 while the cash balance per bank statement is ₱320,000.b. Credit memo – ₱20,000c. Debit memo – ₱15,000d. Deposits in transit – ₱75,000e. Outstanding checks – ₱25,000f. The disbursements per books are overstated by ₱45,000.g. The bank debits are understated by ₱40,000.
In the accompanying tables you will find consolidated balance sheets for the commercial banking system and the 12 Federal Reserve Banks. Use columns 1 through 3 to indicate how the balance sheets would read after each of transactions a to c is completed. Do not cumulate your answers; that is, analyze each transaction separately, starting in each case from the figures provided. All accounts are in billions of dollars.a. A decline in the discount rate prompts commercial banks to borrow an additional $1 billion from the Federal Reserve Banks. Show the new balance-sheet figures in column 1 of each table.b. The Federal Reserve Banks sell $3 billion in securities to members of the public, who pay for the bonds with checks. Show the new balance-sheet figures in column 2 of each table.c. The Federal Reserve Banks buy $2 billion of securities from commercial banks. Show the new balance-sheet figures in column 3 of each table.d. Now review each of the above three transactions, asking yourself…
Problem 1 - Prepare a bank reconciliationThe following information relates to M Park Corporation for the month of March 2022:1. Cash balance per books, March 31 was $20,647.002. Deposits in transit, March 31 were $8,140.003. The March bank service charge was $34.00 and has not been recorded by the company.4. Outstanding checks, March 31 were $3,905.005. An electronic funds transfer (EFT) collected by the bank was $590. The collection has not been recorded by M Park Corporation.6. The bank made an error and recorded a $3,000 deposit twice.7. Cash balance per bank, March 31 was $19,968.00PurposeThe purpose of this problem is to demonstrate an understanding of preparing a bank reconciliation.InstructionsAfter analyzing the data, prepare a bank reconciliation for M Park Corporation at March 31st. Reconcile the cash balance per the bank firstand list items that increase the cash balance first. Also, round amounts to two decimal places. Please provide explainations, thanks! (