QA: TWO River Bancorp in us_state_banks/2018

Table of Contents

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

PDF Report 0001343034_2019_TWO_River_Bancorp.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 The EntityCommonStockSharesOutstanding does not exist industry.us_generic {}
warning No stock price available subcommand.plot {}
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': '0001343034', 'Assets': 1039798000, 'AssetsAndSecurities': 5753000, 'CashDepositsAndCashEquivalents': 48219000, 'Deposits': 861557000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 18109000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 933227000, 'LiabilitiesAndBorrowings': 703052000, 'LiabilitiesAndStockholdersEquity': 1039798000, 'LoansAndLeasesReceivable': 842787000, 'LongTermDebt': 0, 'NetIncome': 6502000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 6239000, 'Revenues': 0, 'remainder_Assets': 118691000, 'remainder_ComprehensiveNetIncome': 87000, 'remainder_Expenses': 0, 'remainder_Liabilities': -631382000, 'remainder_LiabilitiesAndStockholdersEquity': 106571000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 4.4688946690646695e-05, 'aggregate_val': 1096419000, 'exp_sum': 1096468000, 'exp_to_value': {'LoansAndLeasesReceivable': 911399000, 'AssetsAndSecurities': 7207000, 'CashDepositsAndCashEquivalents': 48126000, 'Goodwill': 18109000, 'PropertyPlantAndEquipment': 5917000, 'remainder_Assets': 105710000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4835113518071972, 'aggregate_val': 979921000, 'exp_sum': 1897275000, 'exp_to_value': {'Deposits': 917354000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 751322000, 'remainder_Liabilities': 228599000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48532066042133226, 'aggregate_val': 587420000, 'exp_sum': 1141332000, 'exp_to_value': {'Deposits': 553912000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 469386000, 'remainder_Liabilities': 118034000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48592135821254107, 'aggregate_val': 641930000, 'exp_sum': 1248700000, 'exp_to_value': {'Deposits': 606770000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 498904000, 'remainder_Liabilities': 143026000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48438858509675936, 'aggregate_val': 674280000, 'exp_sum': 1307729000, 'exp_to_value': {'Deposits': 633449000, 'LongTermDebt': 17500000, 'LiabilitiesAndBorrowings': 509095000, 'remainder_Liabilities': 147685000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48312568532866446, 'aggregate_val': 687264000, 'exp_sum': 1329654000, 'exp_to_value': {'Deposits': 642390000, 'LongTermDebt': 16000000, 'LiabilitiesAndBorrowings': 507469000, 'remainder_Liabilities': 163795000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4789545205627632, 'aggregate_val': 770694000, 'exp_sum': 1479130000, 'exp_to_value': {'Deposits': 708436000, 'LongTermDebt': 26500000, 'LiabilitiesAndBorrowings': 570080000, 'remainder_Liabilities': 174114000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4805304499456085, 'aggregate_val': 839495000, 'exp_sum': 1616062000, 'exp_to_value': {'Deposits': 776567000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 624221000, 'remainder_Liabilities': 215274000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4800372855745165, 'aggregate_val': 933227000, 'exp_sum': 1794796000, 'exp_to_value': {'Deposits': 861557000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 703052000, 'remainder_Liabilities': 230187000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 4.4688946690646695e-05, 'aggregate_val': 1096419000, 'exp_sum': 1096468000, 'exp_to_value': {'LoansAndLeasesReceivable': 911399000, 'AssetsAndSecurities': 7207000, 'CashDepositsAndCashEquivalents': 48126000, 'Goodwill': 18109000, 'PropertyPlantAndEquipment': 5917000, 'remainder_Assets': 105710000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4835113518071972, 'aggregate_val': 979921000, 'exp_sum': 1897275000, 'exp_to_value': {'Deposits': 917354000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 751322000, 'remainder_Liabilities': 228599000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 4.4688946690646695e-05, 'aggregate_val': 1096419000, 'exp_sum': 1096468000, 'exp_to_value': {'LoansAndLeasesReceivable': 911399000, 'AssetsAndSecurities': 7207000, 'CashDepositsAndCashEquivalents': 48126000, 'Goodwill': 18109000, 'PropertyPlantAndEquipment': 5917000, 'remainder_Assets': 105710000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4835113518071972, 'aggregate_val': 979921000, 'exp_sum': 1897275000, 'exp_to_value': {'Deposits': 917354000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 751322000, 'remainder_Liabilities': 228599000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('EntityCommonStockSharesOutstanding')"}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0001343034')"}
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 0001343034, TWO River Bancorp

  xvar xval
0 Deposits 917,354,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 751,322,000
3 remainder_Liabilities -688,755,000
4 LoansAndLeasesReceivable 911,399,000
5 AssetsAndSecurities 7,207,000
6 CashDepositsAndCashEquivalents 48,126,000
7 Goodwill 18,109,000
8 PropertyPlantAndEquipment 5,917,000
9 remainder_Assets 105,661,000
10 LaborExpense 15,941,000
11 OtherNoninterestExpense 1,684,000
12 Occupancy 0
13 Fees 2,100,000
14 ITAndEquipmentExpense 738,000
15 remainder_Expenses 5,223,000
16 remainder_Revenues 5,531,000
17 remainder_NetIncome 35,351,000
18 remainder_ComprehensiveNetIncome -4,111,000
  yvar yval
0 Liabilities 979,921,000
1 Assets 1,096,419,000
2 Expenses 25,686,000
3 Revenues 5,531,000
4 StockholdersEquity 116,498,000
5 NetIncome 15,196,000
6 ComprehensiveNetIncome 11,085,000
7 BaseVar 1,073,509,500
8 EconomicCapitalRatio 0.0982

Edgar->Model Mapping

Feature Distribution

Change over Time