QA: Trico Bancshares in us_state_banks/2021

Table of Contents

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

PDF Report 0000356171_2022_Trico_Bancshares.pdf

Logs

error Aggregate label 'OtherNoninterestExpense' starts with 'Other' input.sec.calculation_linkbase.edgar_model_mapping {}
warning The stock price does not exist industry.us_generic {}
warning Similarly named company. Duplicate? None {'details': [{'other_company': 'Commerce Bancshares INC Mo', 'shared_tokens': {'bancshares'}}]}
warning NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping {}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 16076662, 'Assets': 2744066000, 'AssetsAndSecurities': 35880000, 'CashDepositsAndCashEquivalents': 598368000, 'Deposits': 2410483000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 15519000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 2493120000, 'LiabilitiesAndBorrowings': 1659071000, 'LiabilitiesAndStockholdersEquity': 2744066000, 'LoansAndLeasesReceivable': 1633762000, 'LongTermDebt': 0, 'NetIncome': 27399000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 31612000, 'Revenues': 0, 'remainder_Assets': 428925000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -1576434000, 'remainder_LiabilitiesAndStockholdersEquity': 250946000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 22714964, 'Assets': 3916458000, 'AssetsAndSecurities': 51735000, 'CashDepositsAndCashEquivalents': 610728000, 'Deposits': 3380423000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 63462000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 3498286000, 'LiabilitiesAndBorrowings': 2354991000, 'LiabilitiesAndStockholdersEquity': 3916458000, 'LoansAndLeasesReceivable': 2245939000, 'LongTermDebt': 0, 'NetIncome': 26108000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 43493000, 'Revenues': 0, 'remainder_Assets': 901101000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -2237128000, 'remainder_LiabilitiesAndStockholdersEquity': 418172000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 22764295, 'Assets': 4220722000, 'AssetsAndSecurities': 48591000, 'CashDepositsAndCashEquivalents': 303461000, 'Deposits': 3631266000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 63462000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 3768606000, 'LiabilitiesAndBorrowings': 2553192000, 'LiabilitiesAndStockholdersEquity': 4220722000, 'LoansAndLeasesReceivable': 2486926000, 'LongTermDebt': 0, 'NetIncome': 43818000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 43811000, 'Revenues': 0, 'remainder_Assets': 1274471000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -2415852000, 'remainder_LiabilitiesAndStockholdersEquity': 452116000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 22827277, 'Assets': 4517968000, 'AssetsAndSecurities': 74743000, 'CashDepositsAndCashEquivalents': 305612000, 'Deposits': 3895560000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 64311000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 4040621000, 'LiabilitiesAndBorrowings': 2704672000, 'LiabilitiesAndStockholdersEquity': 4517968000, 'LoansAndLeasesReceivable': 2727090000, 'LongTermDebt': 0, 'NetIncome': 44811000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 48406000, 'Revenues': 0, 'remainder_Assets': 1297806000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -2559611000, 'remainder_LiabilitiesAndStockholdersEquity': 477347000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 22941464, 'Assets': 4761315000, 'AssetsAndSecurities': 55051000, 'CashDepositsAndCashEquivalents': 205428000, 'Deposits': 4009131000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 64311000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 4255507000, 'LiabilitiesAndBorrowings': 2826337000, 'LiabilitiesAndStockholdersEquity': 4761315000, 'LoansAndLeasesReceivable': 2984842000, 'LongTermDebt': 0, 'NetIncome': 40554000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 57742000, 'Revenues': 0, 'remainder_Assets': 1393941000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -2579961000, 'remainder_LiabilitiesAndStockholdersEquity': 505808000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000356171', 'EntityCommonStockSharesOutstanding': 30417818, 'Assets': 6352441000, 'AssetsAndSecurities': 65986000, 'CashDepositsAndCashEquivalents': 227533000, 'Deposits': 5366466000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 220972000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 5525068000, 'LiabilitiesAndBorrowings': 3705449000, 'LiabilitiesAndStockholdersEquity': 6352441000, 'LoansAndLeasesReceivable': 3989432000, 'LongTermDebt': 0, 'NetIncome': 68320000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 89347000, 'Revenues': 0, 'remainder_Assets': 1759171000, 'remainder_ComprehensiveNetIncome': -11620000, 'remainder_Expenses': 0, 'remainder_Liabilities': -3546847000, 'remainder_LiabilitiesAndStockholdersEquity': 827373000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4917418258279634, 'aggregate_val': 7614603000, 'exp_sum': 14981762000, 'exp_to_value': {'Deposits': 7367159000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4549434000, 'remainder_Liabilities': 3065169000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4838628308818681, 'aggregate_val': 8884570000, 'exp_sum': 17213583000, 'exp_to_value': {'Deposits': 8329013000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 5251264000, 'remainder_Liabilities': 3633306000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4835949110888776, 'aggregate_val': 2339156000, 'exp_sum': 4529692000, 'exp_to_value': {'Deposits': 2190536000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1752228000, 'remainder_Liabilities': 586928000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4903409533811374, 'aggregate_val': 2379910000, 'exp_sum': 4669612000, 'exp_to_value': {'Deposits': 2289702000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1649188000, 'remainder_Liabilities': 730722000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49157384886174516, 'aggregate_val': 2493120000, 'exp_sum': 4903603000, 'exp_to_value': {'Deposits': 2410483000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1659071000, 'remainder_Liabilities': 834049000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49143276739864994, 'aggregate_val': 3498286000, 'exp_sum': 6878709000, 'exp_to_value': {'Deposits': 3380423000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2354991000, 'remainder_Liabilities': 1143295000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4907201097532498, 'aggregate_val': 3768606000, 'exp_sum': 7399872000, 'exp_to_value': {'Deposits': 3631266000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2553192000, 'remainder_Liabilities': 1215414000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4908607805189927, 'aggregate_val': 4040621000, 'exp_sum': 7936181000, 'exp_to_value': {'Deposits': 3895560000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2704672000, 'remainder_Liabilities': 1335949000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4850945679653483, 'aggregate_val': 4255507000, 'exp_sum': 8264638000, 'exp_to_value': {'Deposits': 4009131000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2826337000, 'remainder_Liabilities': 1429170000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4927190237848957, 'aggregate_val': 5525068000, 'exp_sum': 10891534000, 'exp_to_value': {'Deposits': 5366466000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3705449000, 'remainder_Liabilities': 1819619000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4909612083495516, 'aggregate_val': 5564611000, 'exp_sum': 10931605000, 'exp_to_value': {'Deposits': 5366994000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3644767000, 'remainder_Liabilities': 1919844000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49211514764095865, 'aggregate_val': 6714415000, 'exp_sum': 13220349000, 'exp_to_value': {'Deposits': 6505934000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4045928000, 'remainder_Liabilities': 2668487000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4917418258279634, 'aggregate_val': 7614603000, 'exp_sum': 14981762000, 'exp_to_value': {'Deposits': 7367159000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4549434000, 'remainder_Liabilities': 3065169000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4838628308818681, 'aggregate_val': 8884570000, 'exp_sum': 17213583000, 'exp_to_value': {'Deposits': 8329013000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 5251264000, 'remainder_Liabilities': 3633306000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0000356171')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000356171, Trico Bancshares

  xvar xval
0 Deposits 7,367,159,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 4,549,434,000
3 remainder_Liabilities -4,301,990,000
4 LoansAndLeasesReceivable 4,831,248,000
5 AssetsAndSecurities 2,316,963,000
6 CashDepositsAndCashEquivalents 768,421,000
7 Goodwill 220,872,000
8 PropertyPlantAndEquipment 78,687,000
9 remainder_Assets 398,596,000
10 LaborExpense 106,351,000
11 OtherNoninterestExpense 71,924,000
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 0
16 remainder_Revenues 50,416,000
17 remainder_NetIncome 291,562,000
18 remainder_ComprehensiveNetIncome -57,347,000
  yvar yval
0 Liabilities 7,614,603,000
1 Assets 8,614,787,000
2 Expenses 178,275,000
3 Revenues 50,416,000
4 StockholdersEquity 1,000,184,000
5 NetIncome 163,703,000
6 ComprehensiveNetIncome 106,356,000
7 BaseVar 8,403,495,000
8 EconomicCapitalRatio 0.109

Edgar->Model Mapping

Feature Distribution

Change over Time