Please I need all the steps and formulas in Excel so that I can follow them correctly.

Q1 Ch I} {113%} The bank you own has the following balance sheet: Assets Liabilities Reserves $75 million Deposits $5M) million Loans $525 million Bank capital $l million If the bank suffers a deposit outow of $511] million with a required reserve ratio on deposits of 10%.. what actions should you take? Q2 (3?: 9' (Itlil) Go to the St. Louis Federal Reserve FRED database: and nd data for all commercial hanks on total assets {TMACEMUETSEUGL US. government and agency.r securities held [USGSECL other securities held {UTHSECL commercial and industrial loans (EUSLUANSL real estate loans (HEALLN), consumer loans {CONSUMER}, inter bank loans [IELACEMUETSEDG}, other loans [ULLACBMGZTSEUGL and other assets (UATACEMUETSBGGL Use the most recent month of data available across all indicators. a. What is the total amount of loans held by banks? What is this number as a percentage of total bank assets? b. \"lhat is the total amount of securities held by banks? What is this number as a percentage of total bank assets? c. 'W'hat is the total amount of reserves and cash items? What is this number as a per centage of total bank assets? qs Ch 10 {10%) At the height of the global nancial crisis in Clctober sons, the ILLS. TrEasury forced nine of the largest US. banks to accept capital injections in exchange for nonvoting ownership stoclc1 even though some ofthe banks did not need the capital and did not want to participate. iu-'n'hat could be the Treasury's rationale for doing this? Q4 Ch it] (10%} Consider a failing hank. A deposit of $3513,\" is worth how much to the de- positor if the FDIC uses the payoff method given the typical recovery rate?r How much is the same deposit worth to the depositor if the purchase-and-assumption method is used? "Which is more costly to taxpayers?r Q5 Ch it] (1.5%} Suppose Universal Bank holds $1M million in assets1 which are composed of the following: Assets m Excess Deserves: $ 5 million Mortgage loans: $20 million Corporate bonds: $15 million Stocks: $25 million Commodities: $25 million a Do you think it is a good idea for Universal Bank to hold stocks1 corporate bonds1 and commodities as assets? 1u'u'hy or 1why not? h. It the housing marlaet suddenly crashed, would Universal Bank be better off using a mark-to-market accounting system or the historical-cost system? off the price of commodities suddenly increased sharply1 would Universal Bank be better off using a mark-to-market accounting system or the historical-cost system? d. 'Wbat do your ansvmrs to parts {b} and {c} tell you about the tradeoffs between the two accounting systems? (.16 Ch 11 {10%) \"The invention of the computer is the major Eactor behind the decline of the banking industry.11 Is this statement true1 false? or uncertain? Explain your answer. Q? Ch 11 (15%} \"if ination had not risen in the l and lTs. the banking industry might be healthier today.\" Is this statement true... false, or uncertain? Ehcplain your answer. Q3 Ch I1 {20%} Go to the St. Louis Federal Reserve F RED database? and nd data on the level of money market mutual fund assets {MMMFFAQUETS}. Download the data into a spreadsheet. a. When did assets start entering money market mutual funds? What 1was the total worth of assets in money market mutual funds at the end of 19TH"? b. For each decade period1 calculate the total percentage change in assets from the be ginning of the decade to the end of the decade: li 1990121; 1990:Q1 Zl; EQUEQI Ell. For each decade period, divide the total percentage change by 1D to get the average yearly percentage increase. Which decade had the largest average yearly growth in money market mutual funds? c. Calculate the growth rate from the most recent quarter of data available to the same quarter a year prior. How does this growth rate compare to the highat average yearly growth rate for the decades from part [b]