QA: Commerce Bancshares INC Mo in us_state_banks/2020

Table of Contents

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

PDF Report 0000022356_2021_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.47718905133398243, 'aggregate_val': 29523002000, 'exp_sum': 56469747000, 'exp_to_value': {'Deposits': 26946745000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 17180713000, 'remainder_Liabilities': 12342289000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47281933056667114, 'aggregate_val': 33240764000, 'exp_sum': 63053837000, 'exp_to_value': {'Deposits': 29813073000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 20025776000, 'remainder_Liabilities': 13214988000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47718905133398243, 'aggregate_val': 29523002000, 'exp_sum': 56469747000, 'exp_to_value': {'Deposits': 26946745000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 17180713000, 'remainder_Liabilities': 12342289000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47281933056667114, 'aggregate_val': 33240764000, 'exp_sum': 63053837000, 'exp_to_value': {'Deposits': 29813073000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 20025776000, 'remainder_Liabilities': 13214988000}}
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 26,946,745,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 17,180,713,000
3 remainder_Liabilities -14,604,456,000
4 LoansAndLeasesReceivable 16,153,896,000
5 AssetsAndSecurities 13,212,941,000
6 CashDepositsAndCashEquivalents 2,184,926,000
7 Goodwill 138,921,000
8 PropertyPlantAndEquipment 371,083,000
9 remainder_Assets 861,207,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 87,293,000
16 remainder_Revenues 0
17 remainder_NetIncome 441,178,000
18 remainder_ComprehensiveNetIncome 221,105,000
  yvar yval
0 Liabilities 29,523,002,000
1 Assets 32,922,974,000
2 Expenses 87,293,000
3 Revenues 0
4 StockholdersEquity 3,399,972,000
5 NetIncome 353,885,000
6 ComprehensiveNetIncome 574,990,000
7 BaseVar 31,597,776,000
8 EconomicCapitalRatio 0.103

Edgar->Model Mapping

Feature Distribution

Change over Time