solved Community Bank AnalysisSelect a community bank that failed (see the

Community Bank AnalysisSelect a community bank that failed (see the FDIC web site at www.fdic.gov/bank/individual/failed/banklist.html (Links to an external site.) (Links to an external site.)).Note: Our group select the bank is The bank of Georgia, certification ID is 35259Obtain UBPR data from the FFIEC’s web site (https://cdr.ffiec.gov/public/ManageFacsimiles.aspx (Links to an external site.) (Links to an external site.)) and analyze the trend in the bank’s performance over four years before its failure.Elements that you MUST include in the analysis:Interest income, interest expense, net interest income (both in millions and as a fraction of average total assets);Net Interest Margin, ROA, ROE;Non-interest income, non-interest expense, Burden Ratio, Efficiency Ratio;Past due loans, non-performing loans, provision for credit losses (both in millions and as a faction of average total assets);Loans per employee, personnel expenses per employee;Liquidity & funding ratios: core/brokered deposits;Credit concentration;(bonus) Use Call Report Data to do GAP analysis for assets/liabilities using time buckets of 3 months, 12 months, 1 year, 3 years, etc.Use your calculation to shed light on the reasons for bank failure. Potential reasons may include, but not limited to, the bank’s credit policy, loan characteristics, management of interest rate risk, competition from peer banks or FinTech companies, and so on. You may also use newsletters to supplement your analysis with the UBPR data.Other Requirements:Page length: greater than 8 (title page does not count);No more than double space;Font size equal to or smaller than 12;Submission: word or PDF for the report; attach raw data in excel.