QA: Commerce Bancshares INC Mo in us_state_banks/2013

Table of Contents

See also this year's filing and all EDGAR filings for this company.

PDF Report 0000022356_2014_Commerce_Bancshares_INC_Mo.pdf

Logs

error Aggregate label 'OtherNoninterestExpense' starts with 'Other' input.sec.calculation_linkbase.edgar_model_mapping {}
warning The EntityCommonStockSharesOutstanding does not exist industry.us_generic {}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4773174841530458, 'aggregate_val': 20857639000, 'exp_sum': 39904987000, 'exp_to_value': {'Deposits': 19047348000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 11811217000, 'remainder_Liabilities': 9046422000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47345067601923113, 'aggregate_val': 21660034000, 'exp_sum': 41135812000, 'exp_to_value': {'Deposits': 19475778000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 12725857000, 'remainder_Liabilities': 8934177000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.477920121140939, 'aggregate_val': 16478875000, 'exp_sum': 31563896000, 'exp_to_value': {'Deposits': 15085021000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 11471715000, 'remainder_Liabilities': 5007160000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4762021559125629, 'aggregate_val': 18479006000, 'exp_sum': 35278889000, 'exp_to_value': {'Deposits': 16799883000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 10501247000, 'remainder_Liabilities': 7977759000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.478618877363051, 'aggregate_val': 19988015000, 'exp_sum': 38336668000, 'exp_to_value': {'Deposits': 18348653000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 11353595000, 'remainder_Liabilities': 8634420000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4773174841530458, 'aggregate_val': 20857639000, 'exp_sum': 39904987000, 'exp_to_value': {'Deposits': 19047348000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 11811217000, 'remainder_Liabilities': 9046422000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47345067601923113, 'aggregate_val': 21660034000, 'exp_sum': 41135812000, 'exp_to_value': {'Deposits': 19475778000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 12725857000, 'remainder_Liabilities': 8934177000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('EntityCommonStockSharesOutstanding')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000022356, Commerce Bancshares INC Mo

  xvar xval
0 Deposits 19,047,348,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 11,811,217,000
3 remainder_Liabilities -10,000,926,000
4 LoansAndLeasesReceivable 10,795,304,000
5 AssetsAndSecurities 9,359,375,000
6 CashDepositsAndCashEquivalents 518,420,000
7 Goodwill 138,921,000
8 PropertyPlantAndEquipment 349,654,000
9 remainder_Assets 1,910,362,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 122,230,000
16 remainder_Revenues 0
17 remainder_NetIncome 383,347,000
18 remainder_ComprehensiveNetIncome -126,769,000
  yvar yval
0 Liabilities 20,857,639,000
1 Assets 23,072,036,000
2 Expenses 122,230,000
3 Revenues 0
4 StockholdersEquity 2,214,397,000
5 NetIncome 261,117,000
6 ComprehensiveNetIncome 134,348,000
7 BaseVar 22,281,010,500
8 EconomicCapitalRatio 0.0848

Edgar->Model Mapping

Feature Distribution

Change over Time