Compustat Bank Quarterly

Back to Main Page.
Department of Finance and Graduate Statistical Assistant Program, FMRC

Documentation of the Compustat Bank Quarterly

General Information:


The Compustat Bank Annual file contains data on approximately 638 of the leading United States banking institutions.
Data Range: 20 years, annually
Number of Banks:  782
Update Schedule: Quarterly
Cut Date: 10/18/2001

Specific Variables Information:

 
  Variable Name Type FORTRAN Format Variable Label
 
  DNUM num I4 Industry Classification Code
  CNUM char A6 CUSIP Issuer Code
  CIC char A3 CUSIP Issue Number and Check Digit
  FILE num I2 File Identification Code
  ZLIST num I2 Exchange Listing and S&P Major Index Cod
  CONAME char A28 Company Name
  INAME char A28 Industry Name
  SMBL char A8 Stock Ticker Symbol
  FTNT1 char A2 Cash and Due from Banks (DATA1)
  FTNT2 char A2 Total Investment Securities (DATA8)
  FTNT3 char A2 Loans (Gross) (DATA23)
  FTNT4 char A2 Other Deposits (DATA63)
  FTNT5 char A2 Total Assets (Gross) (DATA36)
  FTNT6 char A2 Time Deposits (Oth Than Savings)(DATA47)
  FTNT7 char A2 Total Deposits - Worldwide (DATA53)
  FTNT8 char A2 Total Borrowings (DATA69)
  FTNT9 char A2 Reserve - Bad Debt Loss on Loans(DATA78)
  FTNT10 char A2 Interest and Fees on Loans (DATA105)
  FTNT11 char A2 Fed Funds Sold & Sec Purchase...(DATA11)
  FTNT12 char A2 Interest and Fees on Loans (DATA166)
  FTNT13 char A2 Total Interest and Div. on Inv.(DATA115)
  FTNT14 char A2 Total Interest Expense (DATA137)
  FTNT15 char A2 Total Current Operating Revenue(DATA124)
  FTNT16 char A2 Foreign Loans (DATA13)
  FTNT17 char A2 Unearned Discount/Income (DATA24)
  FTNT18 char A2 "...Current Operating Expens(DATA143,144)"
  FTNT19 char A2 Com Shares Used in Calculati...(DATA200)
  FTNT20 char A2 Income Taxes Applicable to... (DATA146)
  FTNT21 char A2 Total Current Operating Revenue(DATA171)
  FTNT22 char A2 Interest Income on Fed Funds...(DATA106)
  FTNT23 char A2 Int. on Deposits and Borrowings(DATA173)
  FTNT24 char A2 Net Current Operating EPS... (DATA193)
  FTNT25 char A2 Com Shares Used in Calculati...(DATA196)
  FTNT26 char A2 Net Current Operating EPS... (DATA197)
  FTNT27 char A2 Total Interest Expense (DATA175)
  FTNT28 char A2 Total Current Operating Expense(DATA179)
  FTNT29 char A2 Inc. Taxes App. to Current...(DATA181)
  FTNT30 char A2 Source Document
  FTNT31 char A2 Net Current Operating EPS... (DATA184)
  FTNT32 char A2 Com Shares Used to Calc. EPS (DATA186)
  FTNT33 char A2 Average Loans (DATA210)
  FTNT34 char A2 Average Assets (DATA225)
  FTNT35 char A2 Avg. Deposits - Time & Savings (DATA226)
  FTNT36 char A2 Average Book Value (DATA231)
  FTNT37 char A2 Avg Reserv for Bad Debt Loss...(DATA207)
  FTNT38 char A2 Interest Inc on Fed Fund Sold...(DATA26)
  FTNT39 char A2 Average Loans - Foreign (DATA152)
  FTNT40 char A2 Avg Fed Funds Sold and Sec...(DATA154)
  DATA1 num F8.3 Cash and Due from Banks (MM$)
  DATA2 num F8.3 U.S. Treasury Securities (MM$)
  DATA3 num F8.3 Sec of Other US Gov Agencies & Corp(MM$)
  DATA4 num F8.3 Due from Banks (Memorandum Entry) (MM$)
  DATA5 num F8.3 Other Securities (Taxable) (MM$)
  DATA6 num F8.3 Total Taxable Investment Securities(MM$)
  DATA7 num F8.3 Oblig. of States & Polit. Subdiv. (MM$)
  DATA8 num F8.3 Total Investment Securities (MM$)
  DATA9 num F8.3 Geographic Designation Code
  DATA10 num F8.3 Trading Account Securities (MM$)
  DATA11 num F8.3 Fed Funds Sold and Sec Purchased...(MM$)
  DATA12 num F8.3 Treasury Stock - Dollar Amt - Com. (MM$)
  DATA13 num F8.3 Foreign Loans (MM$)
  DATA14 num F8.3 Real Estate Loans - Total (MM$)
  DATA15 num F8.3 Real Estate Loans - Insured or... (MM$)
  DATA16 num F8.3 Treasury Stock - Dollar Amt - Pref (MM$)
  DATA17 num F8.3 Loans to Financial Institutions (MM$)
  DATA18 num F8.3 Loans for Purchasing / Carrying Sec(MM$)
  DATA20 num F8.3 Commercial or Industrial Loans (MM$)
  DATA21 num F8.3 Loans to Individuals for Househo...(MM$)
  DATA22 num F8.3 Other Loans (MM$)
  DATA23 num F10.3 Loans (Gross) (MM$)
  DATA24 num F8.3 Unearned Discount/Income (MM$)
  DATA25 num F8.3 Interest on Due from Banks (MM$)
  DATA26 num F8.3 Interest Income on Fed Fund Sold...(MM$)
  DATA27 num F8.3 Other Interest Income (MM$)
  DATA28 num F8.3 "Bank Premises, Furniture & Fixtures(MM$)"
  DATA29 num F8.3 Real Estate Oth Than Bank Premises (MM$)
  DATA30 num F8.3 Investments in Nonconsol. Subsid. (MM$)
  DATA31 num F8.3 Direct Lease Financing (MM$)
  DATA32 num F8.3 Customers Liability to this Bank...(MM$)
  DATA33 num F8.3 Other Assets (MM$)
  DATA34 num F8.3 Intangible Assets (MM$)
  DATA35 num F8.3 Aggregate Miscellaneous Assets (MM$)
  DATA36 num F10.3 Total Assets (Gross) (MM$)
  DATA37 num F8.3 Trading Account Income (MM$)
  DATA38 num F8.3 Other Current Operating Revenue (MM$)
  DATA39 num F8.3 Interest Expense on Fed Fund Pur...(MM$)
  DATA41 num F8.3 Total Demand Deposits (MM$)
  DATA43 num F8.3 Consumer Type Time Deposits (MM$)
  DATA44 num F8.3 Total Savings Deposits (MM$)
  DATA45 num F8.3 Money Market Certificates of Deposi(MM$)
  DATA46 num F10.3 All Other Time Deposits (MM$)
  DATA47 num F10.3 Total Time Deposit(Oth Than Saving)(MM$)
  DATA49 num F8.3 Interest on Long-Term Debt and... (MM$)
  DATA50 num F8.3 Interest on Other Borrowed Money (MM$)
  DATA51 num F8.3 Other Interest Expense (MM$)
  DATA52 num F8.3 Salaries and Related Expenses (MM$)
  DATA53 num F10.3 Total Deposits - Worldwide (MM$)
  DATA54 num F8.3 Total Domestic Deposits (MM$)
  DATA55 num F8.3 Total Foreign Deposits (MM$)
  DATA56 num F8.3 Demand Deposits of IPC (MM$)
  DATA57 num F8.3 Time and Savings Deposits of IPC (MM$)
  DATA58 num F8.3 Deposits of U.S. Government (MM$)
  DATA59 num F8.3 Deposits of States and Polit Subdiv(MM$)
  DATA60 num F8.3 Deposits of Foreign Governments (MM$)
  DATA61 num F8.3 Deposits of Commercial Banks (MM$)
  DATA62 num F8.3 Certified and Officers' Checks (MM$)
  DATA63 num F8.3 Other Deposits (MM$)
  DATA65 num F8.3 Fed Funds Purchased and Sec Sold...(MM$)
  DATA66 num F8.3 Commercial Paper (MM$)
  DATA67 num F8.3 Long-Term Debt Not Classified as...(MM$)
  DATA68 num F8.3 Other Liab. for Borrowing Money (MM$)
  DATA69 num F8.3 Total Borrowings (MM$)
  DATA70 num F8.3 Valuation Portion of Reserve for...(MM$)
  DATA71 num F8.3 Mortgage Indebtedness (MM$)
  DATA72 num F8.3 Acceptances Executed by or for... (MM$)
  DATA73 num F8.3 Other Liab.(Ex. Valuation Reserves)(MM$)
  DATA74 num F8.3 Deferred Portion of Reserve for... (MM$)
  DATA75 num F8.3 Contingency Portion of Reserve... (MM$)
  DATA76 num F10.3 Total Liab.(Ex. Valuation Reserves)(MM$)
  DATA77 num F8.3 Minority Interest in Consolidate...(MM$)
  DATA78 num F8.3 Reserve for Bad Debt Loss on Loans (MM$)
  DATA80 num F8.3 Reserves on Securities (MM$)
  DATA81 num F8.3 Total Reserves on Loans and Sec. (MM$)
  DATA82 num F8.3 Fixed Expense (Occupancy and...) (MM$)
  DATA83 num F8.3 Other Current Operating Expense (MM$)
  DATA84 num F8.3 Capital Notes and Debentures (MM$)
  DATA85 num F8.3 Minority Interest (Income Account) (MM$)
  DATA86 num F8.3 Preferred Stock - Par Value (MM$)
  DATA87 num F8.3 Shares of Preferred Stock Outstandin(MM)
  DATA88 num F8.3 Common Stock - Par Value (MM$)
  DATA89 num F8.3 Number of Shares Authorized (MM)
  DATA90 num F8.3 Number of Shares Outstanding (MM)
  DATA91 num F8.3 Nmber of Shares Reserved for Conver.(MM)
  DATA92 num F8.3 Treasury Stock - Cost (MM$)
  DATA93 num F8.3 Number of Treasury Shares Held (MM)
  DATA95 num F8.3 Surplus (M)
  DATA96 num F8.3 Undivided Profits (MM$)
  DATA97 num F8.3 Reserves for Contingencies and... (MM$)
  DATA98 num F8.3 Total Extra. Items - Net of Taxes (MM$)
  DATA99 num F8.3 Total Book Value (MM$)
  DATA100 num F8.3 Net Income Per Share - Ex. Extra...($&c)
  DATA101 num F10.3 "Total Liab, Reserves & Capital Acc.(MM$)"
  DATA102 num F8.3 Total Capital Accounts and... (MM$)
  DATA103 num F8.3 Net Current Operating EPS - Ex... (MM$)
  DATA104 num F8.3 Foreign Exchange Gains and Losses (MM$)
  DATA105 num F8.3 Interest and Fees on Loans (MM$)
  DATA106 num F8.3 Interest Income on Fed Fund Sold...(MM$)
  DATA108 num F8.3 Interest and Disc. on US Treas. Sec(MM$)
  DATA109 num F8.3 Interest on Sec. of U.S. Gov... (MM$)
  DATA110 num F8.3 Interest and Dividends on Other... (MM$)
  DATA111 num F8.3 Total Taxable Investment Revenue (MM$)
  DATA112 num F8.3 Interest on Obligations of State...(MM$)
  DATA113 num F8.3 Other Interest Income (MM$)
  DATA114 num F8.3 Trading Account Interest... (MM$)
  DATA115 num F8.3 Total Interest and Dividends on Inv(MM$)
  DATA116 num F8.3 Aggregate Loan and Investment Reven(MM$)
  DATA117 num F8.3 Trust Department Income (MM$)
  DATA118 num F8.3 Service Charges on Deposit Accounts(MM$)
  DATA119 num F8.3 "Other Service Charges, Collectio...(MM$)"
  DATA120 num F8.3 Trading Account Income (MM$)
  DATA121 num F8.3 Other Current Operating Revenue (MM$)
  DATA122 num F8.3 Interest on Due from Banks (MM$)
  DATA123 num F8.3 Aggregate Oth Current Operating Rev(MM$)
  DATA124 num F8.3 Total Current Operating Revenue (MM$)
  DATA125 num F8.3 Number of Employees (MM)
  DATA126 num F8.3 Salaries and Wages of... Employees (MM$)
  DATA127 num F8.3 Pension and Employee Benefits (MM$)
  DATA128 num F8.3 Avg Fed Funds Purchased and Sec... (MM$)
  DATA129 num F8.3 Interest on Deposits (MM$)
  DATA130 num F8.3 Interest Expense on Fed Fund Pur...(MM$)
  DATA131 num F8.3 Interest on Other Borrowed Money (MM$)
  DATA132 num F8.3 Interest on Long-Term Debt - Not...(MM$)
  DATA133 num F8.3 Total Interest on Deposits & Borrow(MM$)
  DATA134 num F8.3 Interest on Capital Notes & Debentu(MM$)
  DATA135 num F8.3 Provision for Loan Losses (MM$)
  DATA136 num F8.3 Occupancy Expense of Bank Premeses (MM$)
  DATA137 num F8.3 Total Interest Expense (MM$)
  DATA138 num F8.3 Rental Income (MM$)
  DATA139 num F8.3 Furniture and Equipment: Deprec... (MM$)
  DATA140 num F8.3 Number of Employees (M)
  DATA141 num F8.3 Number of Domestic Offiers (M)
  DATA142 num F8.3 Other Current Operating Expense (MM$)
  DATA143 num F8.3 Aggregate Oth Cur. Operating Expens(MM$)
  DATA144 num F8.3 Total Current Operating Expense (MM$)
  DATA145 num F8.3 Current Operating Earnings befor...(MM$)
  DATA146 num F8.3 Income Taxes Applicable to Cur... (MM$)
  DATA147 num F8.3 Net Current Operating Earnings (MM$)
  DATA148 num F8.3 Minority Interest (Income Account) (MM$)
  DATA149 num F8.3 Net Current Operating Earn after...(MM$)
  DATA150 num F8.3 Average Cash and Due from Banks (MM$)
  DATA151 num F8.3 Average Loans - Domestic (MM$)
  DATA152 num F8.3 Average Loans - Foreign (MM$)
  DATA153 num F8.3 Net Pre-Tax Profit (Loss) on Sec...(MM$)
  DATA154 num F8.3 Avg Fed Funds Sold & Sec Purchas...(MM$)
  DATA155 num F8.3 Avg Trading Account Securitites (MM$)
  DATA156 num F10.3 Average Deposits (MM$)
  DATA157 num F8.3 Tax Effect on Profit or Loss on... (MM$)
  DATA158 num F8.3 Net After-Tax Profit or Loss on... (MM$)
  DATA159 num F8.3 Minority Interest in After-Tax... (MM$)
  DATA160 num F8.3 Net After-Tax and After-Minority...(MM$)
  DATA161 num F8.3 Net Income (MM$)
  DATA162 num F8.3 Preferred Dividend Deductions (MM$)
  DATA163 num F8.3 Saving Due to Common Stock Equiv...(MM$)
  DATA164 num F8.3 Net Income Available for Common (MM$)
  DATA165 num F8.3 Net Current Operating Earn Avail...(MM$)
  DATA166 num F8.3 Interest and Fees on Loans (MM$)
  DATA167 num F8.3 Taxable Investment Income (MM$)
  DATA168 num F8.3 Non-Taxable Investment Income (MM$)
  DATA169 num F8.3 Total Interest Income (MM$)
  DATA170 num F8.3 Trust Department Income (MM$)
  DATA171 num F8.3 Total Current Operating Revenue (MM$)
  DATA172 num F8.3 Interest on Deposits (MM$)
  DATA173 num F8.3 Total Interest on Deposits & Borrow(MM$)
  DATA174 num F8.3 Interest on Capital Notes & Debentu(MM$)
  DATA175 num F8.3 Total Interest Expense (MM$)
  DATA176 num F8.3 Provision for Loan Losses (MM$)
  DATA177 num F8.3 Cash Div. Declared on Common Stock (MM$)
  DATA178 num F8.3 Cash Div. Declared on Pref. Stock (MM$)
  DATA179 num F8.3 Total Current Operating Expense (MM$)
  DATA180 num F8.3 Cur Operating Earn before Inc Tax (MM$)
  DATA181 num F8.3 Income Taxes Applicable to Cur... (MM$)
  DATA182 num F8.3 Net After-Tax and After-Minority...(MM$)
  DATA183 num F8.3 Net Income (MM$)
  DATA184 num F8.3 Net Current Operating EPS ($&c)
  DATA185 num F8.3 Total Extra. Items Net of Taxes (MM$)
  DATA186 num F8.3 Common Shares Used in Calcul. EPS (MM)
  DATA187 num F8.3 Add. to Reserves for Bad Debts... (MM$)
  DATA188 num F8.3 Add. to Reserves for Bad Debts... (MM$)
  DATA189 num F8.3 Deductions from Reserves for Bad...(MM$)
  DATA190 num F8.3 Net Credit or Charge to Reserves...(MM$)
  DATA191 num F8.3 Transfers to Reserves for Bad... (MM$)
  DATA192 num F8.3 Avg Preferred Stock - Par Value (MM$)
  DATA193 num F8.3 Net Current Operating EPS - Excl...($&c)
  DATA194 num F8.3 Net Income per Share - Exc. Extr...($&c)
  DATA195 num F8.3 Net Income per Share - Inc. Extr...($&c)
  DATA196 num F8.3 Common Shares Used in Calcul. EPS (MM)
  DATA197 num F8.3 Net Current Operating EPS - Exc... ($&c)
  DATA198 num F8.3 Net Income per Share - Exc. Extr...($&c)
  DATA199 num F8.3 Net Income per Share - Inc. Extr...($&c)
  DATA200 num F8.3 Common Shares Used in Calculating...(MM)
  DATA201 num F8.3 Com. Div. Paid per Share by Ex-Date($&c)
  DATA202 num F8.3 Annualized Dividend Rate ($&c)
  DATA203 num F8.3 Market Price - High ($&c)
  DATA204 num F8.3 Market Price - Low ($&c)
  DATA205 num F8.3 Market Price - Close ($&c)
  DATA206 num F8.3 Common Shares Traded (MM)
  DATA207 num F8.3 Avg Reserve for Bad Debt Losses... (MM$)
  DATA208 num F8.3 Number of Domestic Offices (M)
  DATA209 num F8.3 Number of Foreign Offices (M)
  DATA210 num F10.3 Average Loans (MM$)
  DATA211 num F10.3 Average Assets (Gross) (MM$)
  DATA212 num F10.3 Average Loans (Gross) (MM$)
  DATA213 num F8.3 Average Cash and Due from Banks (MM$)
  DATA214 num F8.3 Average Taxable Investments (MM$)
  DATA215 num F8.3 Average Non-Taxable Investments (MM$)
  DATA216 num F10.3 Average Deposits (MM$)
  DATA217 num F10.3 Average Deposits - Time and Savings(MM$)
  DATA218 num F8.3 Average Deposits - Demand (MM$)
  DATA219 num F8.3 Average Borrowings (MM$)
  DATA220 num F8.3 Avg Fed Funds Sold and Sec Purch...(MM$)
  DATA221 num F8.3 Average Book Value (MM$)
  DATA222 num F8.3 Avg Fed Funds Purch and Sec Sold...(MM$)
  DATA223 num F8.3 Average Taxable Investments (MM$)
  DATA224 num F8.3 Average Non-Taxable Investments (MM$)
  DATA225 num F10.3 Average Assets (MM$)
  DATA226 num F10.3 Average Deposits - Time and Savings(MM$)
  DATA227 num F8.3 Average Deposits - Demand (MM$)
  DATA228 num F10.3 Average Deposits - Foreign (MM$)
  DATA229 num F8.3 Average Borrowings (MM$)
  DATA230 num F8.3 Average Long-Term Debt (MM$)
  DATA231 num F8.3 Average Book Value (MM$)
  DATA232 num F10.6 Adjustment Factor - Cum. by Ex-Date
  FYR num I2 Fiscal Year-End Month of Data
  YEAR num I2 Data Year

Missing Codes

 
  FORTRAN   SAS   Meaning
 
  -0.001 = . = Not Available Figure - data is not available
  -0.002 = .S = Semi-Annual Figure - appears in 1st and 3rd quarters of the year to indicate that data in the 2nd and 4th quarters represents semi-annual figures rather than quarterly figures.
  -0.003 = .A = Annual Figure - appears in the 1st, 2nd, and 3rd quarters of the year to indicate that data in the 4th quarter represents an annual figure rather than quarterly figures.
  -0.004 = .C = Combined Figure - appears if data has been combined into another data item.
  -0.007 = .M = Not Meaningful
  -0.008 = .I = Insignificant Figure - appears if data has been reported by the company as insignificant.

Units


Most data items are represented in units of $ millions. Data is rounded to the nearest thousand. Earnings per share items are presented in actual dollars and cents.
  M Thousands
  MM Millions
  MM$ Millions of Dollars
  $&c Dollars and cents

Up to this page.


Back to Main Page.
Updated:  November2001 , GSA.