Access the financial actuals; that is, historical financial data for the past five years for the bank of your choice, as well as your bank’s competitor.
This may be taken from the commercial bank’s web site, or from the SEC web site.

Develop a Microsoft Excel spreadsheet model using data given in the Statement of Financial Position. This should include:

the balance sheet,

income statement, and

five to 10 common industry specific financial ratios for both your selected commercial bank and its competitor.