QA: Commerce Bancshares INC Mo in us_state_banks/2018

Table of Contents

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

PDF Report 0000022356_2019_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.4742938634436422, 'aggregate_val': 22526693000, 'exp_sum': 42850352000, 'exp_to_value': {'Deposits': 20323659000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13888273000, 'remainder_Liabilities': 8638420000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47230117788426795, 'aggregate_val': 22927317000, 'exp_sum': 43447732000, 'exp_to_value': {'Deposits': 20520415000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 14028618000, 'remainder_Liabilities': 8898699000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47324865265029603, 'aggregate_val': 22237544000, 'exp_sum': 42216397000, 'exp_to_value': {'Deposits': 19978853000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13093437000, 'remainder_Liabilities': 9144107000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47695374017093994, 'aggregate_val': 23140292000, 'exp_sum': 44241387000, 'exp_to_value': {'Deposits': 21101095000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13469986000, 'remainder_Liabilities': 9670306000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48013918537309597, 'aggregate_val': 22115231000, 'exp_sum': 42540677000, 'exp_to_value': {'Deposits': 20425446000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13189405000, 'remainder_Liabilities': 8925826000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4742938634436422, 'aggregate_val': 22526693000, 'exp_sum': 42850352000, 'exp_to_value': {'Deposits': 20323659000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 13888273000, 'remainder_Liabilities': 8638420000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47230117788426795, 'aggregate_val': 22927317000, 'exp_sum': 43447732000, 'exp_to_value': {'Deposits': 20520415000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 14028618000, 'remainder_Liabilities': 8898699000}}
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 20,323,659,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 13,888,273,000
3 remainder_Liabilities -11,685,239,000
4 LoansAndLeasesReceivable 14,001,060,000
5 AssetsAndSecurities 9,084,180,000
6 CashDepositsAndCashEquivalents 1,197,768,000
7 Goodwill 138,921,000
8 PropertyPlantAndEquipment 333,119,000
9 remainder_Assets 708,794,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 105,949,000
16 remainder_Revenues 0
17 remainder_NetIncome 544,163,000
18 remainder_ComprehensiveNetIncome -53,061,000
  yvar yval
0 Liabilities 22,526,693,000
1 Assets 25,463,842,000
2 Expenses 105,949,000
3 Revenues 0
4 StockholdersEquity 2,937,149,000
5 NetIncome 438,214,000
6 ComprehensiveNetIncome 385,153,000
7 BaseVar 24,346,854,000
8 EconomicCapitalRatio 0.112

Edgar->Model Mapping

Feature Distribution

Change over Time