Bank & Credit Union Analyst

We are looking for a season investment bank analyst that may have experience in covering the retail banking sector. We are looking for the ability to quickly and efficiently analyze banks based on data available from FDIC and NCUA. We would like to analyze banks performance with the key metrics, ratios, asset concentration, etc. We need you to create a tool in excel and accompanying instructions we can build upon as we need to pivot. The goal is to create something by a senior banker or analyst that can be easily taught to an intern.