Analyzing the Annual Report - for Banks
Analyze Bank Stocks
Click here if using Excel 2000-2003 Click here if using Excel 2007 (Requires Excel or OpenOffice) Download this spreadsheet to analyze the Annual Report data of Banks. Data reported by Banks, and the analysis of that data, are different from that of a manufacturing company. The data are harder to locate for banks too, and some report important data while others do not. Helps are built into the spreadsheet to aid in finding the elusive data.
This form is designed to help analyze those data, along with suggestions as to where to get the data banks don't provide. The information analyzed in the form is that suggested by a very good friend, Bob Stewart, who started and owned a bank for a number of years and knows banking well. I make no claims about knowing banking analysis other than what my friend has taught me.
Example Annual Report data for analyzing Bank Stocks. (Requires
Adobe Acrobat Reader) Download this file to see an example of the Annual Report financial data used in analyzing Bank and Thrift companies. It contains keys to the above spreadsheet, providing help in locating the various data required for the spreadsheet analysis.
A useful Website for analyzing banks is
http://www.bankrx.com. It contains some free information that is useful, and more via a subscription. The format of the free area of the site is a little clunky in my opinion but useful. I have not tried the subscription area.