error |
Negative Expenses, ignoring company. |
pre-agg |
{'expenses': -344000} |
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': '0001130144', 'EntityCommonStockSharesOutstanding': 14101259, 'Assets': 1335405000, 'AssetsAndSecurities': 81602000, 'CashDepositsAndCashEquivalents': 63036000, 'Deposits': 1086268000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 5544000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 1166841000, 'LiabilitiesAndBorrowings': 803748000, 'LiabilitiesAndStockholdersEquity': 1335405000, 'LoansAndLeasesReceivable': 740929000, 'LongTermDebt': 15000000, 'NetIncome': 7780000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 20721000, 'Revenues': 0, 'remainder_Assets': 423573000, 'remainder_ComprehensiveNetIncome': 2950000, 'remainder_Expenses': 0, 'remainder_Liabilities': -738175000, 'remainder_LiabilitiesAndStockholdersEquity': 168564000, '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.4886804891387133, 'aggregate_val': 1228575000, 'exp_sum': 2402754000, 'exp_to_value': {'Deposits': 1174179000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 831650000, 'remainder_Liabilities': 396925000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48211959563429907, 'aggregate_val': 1166841000, 'exp_sum': 2253109000, 'exp_to_value': {'Deposits': 1086268000, 'LongTermDebt': 15000000, 'LiabilitiesAndBorrowings': 803748000, 'remainder_Liabilities': 348093000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4815473053204514, 'aggregate_val': 1264011000, 'exp_sum': 2438045000, 'exp_to_value': {'Deposits': 1174034000, 'LongTermDebt': 5000000, 'LiabilitiesAndBorrowings': 838836000, 'remainder_Liabilities': 420175000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4886804891387133, 'aggregate_val': 1228575000, 'exp_sum': 2402754000, 'exp_to_value': {'Deposits': 1174179000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 831650000, 'remainder_Liabilities': 396925000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001130144')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |