Business Finance Homework Help

Community Bank Analysis

Analyze

Harvest Community Bank

Pennsville

NJ

34951

First-Citizens Bank & Trust Company

January 13, 2017

(see the FDIC website at page 2 (see the FDIC web site at www.fdic.gov/bank/individual/failed/banklist.html (Links to an external site.)

Obtain 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:

1. Interest income, interest expense, net interest income (both in millions and as a fraction of average total assets);
2. Net Interest Margin, ROA, ROE;
3. Non-interest income, non-interest expense, Burden Ratio, Efficiency Ratio;
4. Past due loans, non-performing loans, provision for credit losses (both in millions and as a faction of average total assets);
5. Loans per employee, personnel expenses per employee;
6. Liquidity & funding ratios: core/brokered deposits;
7. Credit concentration;
8. (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:

1. Page length: greater than 9 (title page does not count);
2. No more than double space;
3. Font size equal to or smaller than 12;
4. Submission: word or PDF for the report; attach raw data in excel.