QA: Commerce Bancshares INC Mo in us_state_banks/2022

Table of Contents

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

PDF Report 0000022356_2023_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.47115139896348074, 'aggregate_val': 29394354000, 'exp_sum': 55581794000, 'exp_to_value': {'Deposits': 26187440000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 18333895000, 'remainder_Liabilities': 11060459000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4688272869668725, 'aggregate_val': 28736831000, 'exp_sum': 54100729000, 'exp_to_value': {'Deposits': 25363898000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 17885206000, 'remainder_Liabilities': 10851625000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47115139896348074, 'aggregate_val': 29394354000, 'exp_sum': 55581794000, 'exp_to_value': {'Deposits': 26187440000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 18333895000, 'remainder_Liabilities': 11060459000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4688272869668725, 'aggregate_val': 28736831000, 'exp_sum': 54100729000, 'exp_to_value': {'Deposits': 25363898000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 17885206000, 'remainder_Liabilities': 10851625000}}
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,187,440,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 18,333,895,000
3 remainder_Liabilities -15,126,981,000
4 LoansAndLeasesReceivable 16,157,959,000
5 AssetsAndSecurities 13,428,767,000
6 CashDepositsAndCashEquivalents 841,636,000
7 Goodwill 138,921,000
8 PropertyPlantAndEquipment 418,909,000
9 remainder_Assets 889,739,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 132,358,000
16 remainder_Revenues 0
17 remainder_NetIncome 632,378,000
18 remainder_ComprehensiveNetIncome -1,175,565,000
  yvar yval
0 Liabilities 29,394,354,000
1 Assets 31,875,931,000
2 Expenses 132,358,000
3 Revenues 0
4 StockholdersEquity 2,481,577,000
5 NetIncome 500,020,000
6 ComprehensiveNetIncome -675,545,000
7 BaseVar 31,605,293,000
8 EconomicCapitalRatio 0.0411

Edgar->Model Mapping

Feature Distribution

Change over Time