QA: Equity Bancshares INC in us_state_banks/2019

Table of Contents

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

PDF Report 0001227500_2020_Equity_Bancshares_INC.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'}}, {'other_company': 'Trico Bancshares', 'shared_tokens': {'bancshares'}}, {'other_company': 'Southside Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'First Us Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Civista Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Kentucky Bancshares INC Ky', 'shared_tokens': {'bancshares'}}, {'other_company': 'Prosperity Bancshares INC', 'shared_tokens': {'bancshares'}}]}
warning Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic {'missing_ratio': 0.6315908124047807, 'aggregate_val': 1418494000, 'exp_sum': 3850322000, 'exp_to_value': {'Deposits': 1215914000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1078842000, 'remainder_Liabilities': 1555566000}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0001227500', 'EntityCommonStockSharesOutstanding': 7150017, 'Assets': 1585727000, 'AssetsAndSecurities': 11206000, 'CashDepositsAndCashEquivalents': 62074000, 'Deposits': 1215914000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 18130000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 1418494000, 'LiabilitiesAndBorrowings': 1078842000, 'LiabilitiesAndStockholdersEquity': 1585727000, 'LoansAndLeasesReceivable': 958353000, 'LongTermDebt': 0, 'NetIncome': 10300000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 39147000, 'Revenues': 0, 'remainder_Assets': 496817000, 'remainder_ComprehensiveNetIncome': -90000, 'remainder_Expenses': 0, 'remainder_Liabilities': -876262000, 'remainder_LiabilitiesAndStockholdersEquity': 167233000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
info NetIncome node detected by tax heuristic input.sec.calculation_linkbase.edgar_model_mapping {'net_inc_node': 'NetIncomeLossAvailableToCommonStockholdersBasic'}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4687834829933555, 'aggregate_val': 3471518000, 'exp_sum': 6535034000, 'exp_to_value': {'Deposits': 3063516000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2617926000, 'remainder_Liabilities': 853592000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4887912702385849, 'aggregate_val': 3605707000, 'exp_sum': 7053297000, 'exp_to_value': {'Deposits': 3447590000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2691980000, 'remainder_Liabilities': 913727000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4573906935238769, 'aggregate_val': 1934228000, 'exp_sum': 3564679000, 'exp_to_value': {'Deposits': 1630451000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1443420000, 'remainder_Liabilities': 490808000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4599921056361664, 'aggregate_val': 2796365000, 'exp_sum': 5178378000, 'exp_to_value': {'Deposits': 2382013000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2052975000, 'remainder_Liabilities': 743390000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4641616816921778, 'aggregate_val': 3605775000, 'exp_sum': 6729222000, 'exp_to_value': {'Deposits': 3123447000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2669684000, 'remainder_Liabilities': 936091000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4687834829933555, 'aggregate_val': 3471518000, 'exp_sum': 6535034000, 'exp_to_value': {'Deposits': 3063516000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2617926000, 'remainder_Liabilities': 853592000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4887912702385849, 'aggregate_val': 3605707000, 'exp_sum': 7053297000, 'exp_to_value': {'Deposits': 3447590000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2691980000, 'remainder_Liabilities': 913727000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0001227500')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0001227500, Equity Bancshares INC

  xvar xval
0 Deposits 3,063,516,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 2,617,926,000
3 remainder_Liabilities -2,209,924,000
4 LoansAndLeasesReceivable 2,550,353,000
5 AssetsAndSecurities 167,289,000
6 CashDepositsAndCashEquivalents 91,789,000
7 Goodwill 136,432,000
8 PropertyPlantAndEquipment 84,478,000
9 remainder_Assets 919,237,000
10 LaborExpense 52,122,000
11 OtherNoninterestExpense 8,906,000
12 Occupancy 8,674,000
13 Fees 5,962,000
14 ITAndEquipmentExpense 10,124,000
15 remainder_Expenses 21,125,000
16 remainder_Revenues 5,604,000
17 remainder_NetIncome 107,518,000
18 remainder_ComprehensiveNetIncome 4,864,000
  yvar yval
0 Liabilities 3,471,518,000
1 Assets 3,949,578,000
2 Expenses 106,913,000
3 Revenues 5,604,000
4 StockholdersEquity 478,060,000
5 NetIncome 6,209,000
6 ComprehensiveNetIncome 11,073,000
7 BaseVar 3,822,997,500
8 EconomicCapitalRatio 0.103

Edgar->Model Mapping

Feature Distribution

Change over Time