Question 1' Loolr up your bank's end-of-year dollar data for 21MB and 2m 9 for the following ve balance sheet items: [1} Total assets, {2} cash. {3}: securities. [4} deposits, and {5] equity capital. a. [6] Based on the data for E and 2319; calculate the following ratios: a. \"M assets ratio" {the sum of cash plus securities divided by total assets], b. the \"deposits ratio\" {total deposits divided by total assets}, and c. "M capital ratio\" (equity capital divided by total assets}. You should calculate six ratios altogether. We suggest that you present these as a table. b. [B] Ein'etly explain the connection between each ofthese three ratios and bank liquidity rislr. andr'or insolvency risk. For example, you may want to explain 1what would happen to the related rislrtsjr as the given ratio increases and why. c. [4] 1Ir'lr'as your bank better or worse prepared for the 2D2 CDVID'l Q shock as compared with the EMTEDGE! episode of Great Financial Crisis? Explain your thinking. Assignment Setting For this assignment, you will work 1with the acoounting data for the US. bank. ch Cert # US. Bank NA. 6548 To complete this assignment, you must retrieve accounting data for your selected LLB. Bank on the FDIC's Bank Find Suite website (httgs:iibanks.data.fdic.goyibankndsuitei'l. At this website: I Click on "Run Financial Reports by Institution; I Then click on the "Banks" {tab located in the blue box under \"Search for Institutions" m I Click on \"Bank NameiCert\" menu, select search type of \"FDIC Cert #1 and enter your selected ban k's number {from the table above; ' I Finally, select "2619\" as the search year and choose \"4'\" Quarter\" in the \"Reporting Period" eld; and I Click \"Sea rch\". There are three things to note about this assignment. I First. in the FDIC data. the balance sheet is called \"Assets, Liabiiitiea and Capitaf' and the income statement is called "income and Expense." I Second: when questions refer to \"2019 data\" this means the end-ofyear 2019 [iei as of December 31: 2019] balance sheet data and the income statement data over 2:319 {i.e__. income and expense occurring over the four quarters of calendar year 2m 9]. I Third. when we refer to \"your bank\". this will be the bank your team has selected from the above table. When we refer to the "peer bank\": this will be the competitor bank that your team will discuss in Question 2 [and some of the subsequent questions}