QA: Connectone Bancorp Inc in us_state_banks/2019

Table of Contents

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

PDF Report 0000712771_2020_Connectone_Bancorp_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 Ignoring company because Assets is zero pre-agg {'balance_sheet': {'company_id': '0000712771', 'EntityCommonStockSharesOutstanding': 16290700, 'Assets': 0, 'AssetsAndSecurities': 0, 'CashDepositsAndCashEquivalents': 0, 'Deposits': 0, 'Expenses': 7411000, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 0, 'LiabilitiesAndBorrowings': 0, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 13926000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 0, 'Revenues': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 7411000, 'remainder_Liabilities': 0, 'remainder_NetIncome': 21337000, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Assets is zero pre-agg {'balance_sheet': {'company_id': '0000712771', 'EntityCommonStockSharesOutstanding': 16347088, 'Assets': 0, 'AssetsAndSecurities': 0, 'CashDepositsAndCashEquivalents': 0, 'Deposits': 0, 'Expenses': 7677000, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 0, 'LiabilitiesAndBorrowings': 0, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 17507000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 0, 'Revenues': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 10509000, 'remainder_Expenses': 7677000, 'remainder_Liabilities': 0, 'remainder_NetIncome': 25184000, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Assets is zero pre-agg {'balance_sheet': {'company_id': '0000712771', 'EntityCommonStockSharesOutstanding': 16369012, 'Assets': 0, 'AssetsAndSecurities': 0, 'CashDepositsAndCashEquivalents': 0, 'Deposits': 0, 'Expenses': 7484000, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 0, 'LiabilitiesAndBorrowings': 0, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 19925000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 0, 'Revenues': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 7484000, 'remainder_Liabilities': 0, 'remainder_NetIncome': 27409000, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4669307246426775, 'aggregate_val': 5442842000, 'exp_sum': 10210384000, 'exp_to_value': {'Deposits': 4767542000, 'LongTermDebt': 500293000, 'LiabilitiesAndBorrowings': 3935487000, 'remainder_Liabilities': 1007062000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47328284166794204, 'aggregate_val': 6632029000, 'exp_sum': 12591253000, 'exp_to_value': {'Deposits': 5959224000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4646293000, 'remainder_Liabilities': 1985736000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4519213356797056, 'aggregate_val': 3002353000, 'exp_sum': 5477960000, 'exp_to_value': {'Deposits': 2475607000, 'LongTermDebt': 495553000, 'LiabilitiesAndBorrowings': 1983091000, 'remainder_Liabilities': 523709000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.44088701038790473, 'aggregate_val': 3539377000, 'exp_sum': 6330343000, 'exp_to_value': {'Deposits': 2790966000, 'LongTermDebt': 671587000, 'LiabilitiesAndBorrowings': 2140191000, 'remainder_Liabilities': 727599000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.46194223510263777, 'aggregate_val': 3895316000, 'exp_sum': 7239587000, 'exp_to_value': {'Deposits': 3344271000, 'LongTermDebt': 476280000, 'LiabilitiesAndBorrowings': 2649294000, 'remainder_Liabilities': 769742000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.45515320995719305, 'aggregate_val': 4543005000, 'exp_sum': 8338133000, 'exp_to_value': {'Deposits': 3795128000, 'LongTermDebt': 670077000, 'LiabilitiesAndBorrowings': 3018285000, 'remainder_Liabilities': 854643000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.45771525359953297, 'aggregate_val': 4848165000, 'exp_sum': 8940257000, 'exp_to_value': {'Deposits': 4092092000, 'LongTermDebt': 600001000, 'LiabilitiesAndBorrowings': 3323508000, 'remainder_Liabilities': 924656000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4669307246426775, 'aggregate_val': 5442842000, 'exp_sum': 10210384000, 'exp_to_value': {'Deposits': 4767542000, 'LongTermDebt': 500293000, 'LiabilitiesAndBorrowings': 3935487000, 'remainder_Liabilities': 1007062000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47328284166794204, 'aggregate_val': 6632029000, 'exp_sum': 12591253000, 'exp_to_value': {'Deposits': 5959224000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4646293000, 'remainder_Liabilities': 1985736000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0000712771')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000712771, Connectone Bancorp Inc

  xvar xval
0 Deposits 4,767,542,000
1 LongTermDebt 500,293,000
2 LiabilitiesAndBorrowings 3,935,487,000
3 remainder_Liabilities -3,760,480,000
4 LoansAndLeasesReceivable 5,108,484,000
5 AssetsAndSecurities 59,465,000
6 CashDepositsAndCashEquivalents 201,483,000
7 Goodwill 162,574,000
8 PropertyPlantAndEquipment 19,236,000
9 remainder_Assets 622,790,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 20,631,000
16 remainder_Revenues 0
17 remainder_NetIncome 94,026,000
18 remainder_ComprehensiveNetIncome 7,642,000
  yvar yval
0 Liabilities 5,442,842,000
1 Assets 6,174,032,000
2 Expenses 20,631,000
3 Revenues 0
4 StockholdersEquity 731,190,000
5 NetIncome 73,395,000
6 ComprehensiveNetIncome 81,037,000
7 BaseVar 5,869,586,500
8 EconomicCapitalRatio 0.112

Edgar->Model Mapping

Feature Distribution

Change over Time