error |
Negative Expenses, ignoring company. |
pre-agg |
{'expenses': -112247000} |
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 |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 15.209371916600618, 'aggregate_val': 6012672000, 'exp_sum': 370938000, 'exp_to_value': {'LoansAndLeasesReceivable': 0, 'AssetsAndSecurities': 49111000, 'CashDepositsAndCashEquivalents': 0, 'Goodwill': 0, 'PropertyPlantAndEquipment': 46343000, 'remainder_Assets': 275484000}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000701347', 'EntityCommonStockSharesOutstanding': 41749116, 'Assets': 4132865000, 'AssetsAndSecurities': 1508031000, 'CashDepositsAndCashEquivalents': 257072000, 'Deposits': 3443528000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 3666445000, 'LiabilitiesAndBorrowings': 64585000, 'LiabilitiesAndStockholdersEquity': 4132865000, 'LoansAndLeasesReceivable': 1942354000, 'LongTermDebt': 158298000, 'NetIncome': 36571000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 51414000, 'Revenues': 0, 'remainder_Assets': 373994000, 'remainder_ComprehensiveNetIncome': 16729000, 'remainder_Expenses': 0, 'remainder_Liabilities': 34000, 'remainder_NetIncome': 36571000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 466420000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000701347', 'EntityCommonStockSharesOutstanding': 41859920, 'Assets': 4370368000, 'AssetsAndSecurities': 1730025000, 'CashDepositsAndCashEquivalents': 177375000, 'Deposits': 3680772000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 3855589000, 'LiabilitiesAndBorrowings': 66536000, 'LiabilitiesAndStockholdersEquity': 4370368000, 'LoansAndLeasesReceivable': 2107531000, 'LongTermDebt': 108281000, 'NetIncome': 47421000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 48759000, 'Revenues': 0, 'remainder_Assets': 306678000, 'remainder_ComprehensiveNetIncome': -2994000, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_NetIncome': 47421000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 514779000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.001999255053987939, 'aggregate_val': 4852987000, 'exp_sum': 4843304000, 'exp_to_value': {'LoansAndLeasesReceivable': 2858158000, 'AssetsAndSecurities': 1600235000, 'CashDepositsAndCashEquivalents': 86007000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 49214000, 'remainder_Assets': 249690000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000701347')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |