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 Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001069157', 'EntityCommonStockSharesOutstanding': 137767583, 'Assets': 24730068000, 'AssetsAndSecurities': 533759000, 'CashDepositsAndCashEquivalents': 895820000, 'Deposits': 20412918000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 337438000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 22365843000, 'LiabilitiesAndBorrowings': 14591019000, 'LiabilitiesAndStockholdersEquity': 24730068000, 'LoansAndLeasesReceivable': 17600613000, 'LongTermDebt': 226868000, 'NetIncome': 295045000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 177710000, 'Revenues': 0, 'remainder_Assets': 5184728000, 'remainder_ComprehensiveNetIncome': -35128000, 'remainder_Expenses': 0, 'remainder_Liabilities': -12864962000, 'remainder_LiabilitiesAndStockholdersEquity': 2364225000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001069157', 'EntityCommonStockSharesOutstanding': 149051662, 'Assets': 21968667000, 'AssetsAndSecurities': 500640000, 'CashDepositsAndCashEquivalents': 1431185000, 'Deposits': 17453002000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 337438000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 19656924000, 'LiabilitiesAndBorrowings': 13960207000, 'LiabilitiesAndStockholdersEquity': 21968667000, 'LoansAndLeasesReceivable': 13984930000, 'LongTermDebt': 212178000, 'NetIncome': 245234000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 118926000, 'Revenues': 0, 'remainder_Assets': 5595548000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': -11968463000, 'remainder_LiabilitiesAndStockholdersEquity': 2311743000, 'remainder_NetIncome': 245234000, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001069157', 'EntityCommonStockSharesOutstanding': 137767583, 'Assets': 24730068000, 'AssetsAndSecurities': 533759000, 'CashDepositsAndCashEquivalents': 895820000, 'Deposits': 20412918000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 337438000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 22365843000, 'LiabilitiesAndBorrowings': 14591019000, 'LiabilitiesAndStockholdersEquity': 24730068000, 'LoansAndLeasesReceivable': 17600613000, 'LongTermDebt': 226868000, 'NetIncome': 295045000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 177710000, 'Revenues': 0, 'remainder_Assets': 5184728000, 'remainder_ComprehensiveNetIncome': -35128000, 'remainder_Expenses': 0, 'remainder_Liabilities': -12864962000, 'remainder_LiabilitiesAndStockholdersEquity': 2364225000, '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.47602088242878116, 'aggregate_val': 20153988000, 'exp_sum': 38463342000, 'exp_to_value': {'Deposits': 18309354000, 'LongTermDebt': 137178000, 'LiabilitiesAndBorrowings': 13793477000, 'remainder_Liabilities': 6223333000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.47717412853541974, 'aggregate_val': 22365843000, 'exp_sum': 42778761000, 'exp_to_value': {'Deposits': 20412918000, 'LongTermDebt': 226868000, 'LiabilitiesAndBorrowings': 14591019000, 'remainder_Liabilities': 7547956000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4703054918514254, 'aggregate_val': 19656924000, 'exp_sum': 37109926000, 'exp_to_value': {'Deposits': 17453002000, 'LongTermDebt': 212178000, 'LiabilitiesAndBorrowings': 13960207000, 'remainder_Liabilities': 5484539000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.47602088242878116, 'aggregate_val': 20153988000, 'exp_sum': 38463342000, 'exp_to_value': {'Deposits': 18309354000, 'LongTermDebt': 137178000, 'LiabilitiesAndBorrowings': 13793477000, 'remainder_Liabilities': 6223333000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.47717412853541974, 'aggregate_val': 22365843000, 'exp_sum': 42778761000, 'exp_to_value': {'Deposits': 20412918000, 'LongTermDebt': 226868000, 'LiabilitiesAndBorrowings': 14591019000, 'remainder_Liabilities': 7547956000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001069157')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |