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': '0001325670', 'EntityCommonStockSharesOutstanding': 24574619, 'Assets': 3407353000, 'AssetsAndSecurities': 292807000, 'CashDepositsAndCashEquivalents': 530167000, 'ComprehensiveNetIncome': 28875000, 'Deposits': 2763216000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 101954000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 2995472000, 'LiabilitiesAndBorrowings': 2253702000, 'LiabilitiesAndStockholdersEquity': 3407353000, 'LoansAndLeasesReceivable': 2310881000, 'LongTermDebt': 0, 'NetIncome': 31248000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 30410000, 'Revenues': 0, 'remainder_Assets': 141134000, 'remainder_ComprehensiveNetIncome': -2373000, 'remainder_Expenses': 0, 'remainder_Liabilities': -2021446000, 'remainder_LiabilitiesAndStockholdersEquity': 411881000, 'remainder_NetIncome': 31248000, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4741251967314561, 'aggregate_val': 2698119000, 'exp_sum': 5130725000, 'exp_to_value': {'Deposits': 2432606000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2017813000, 'remainder_Liabilities': 680306000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.47983429558955093, 'aggregate_val': 2995472000, 'exp_sum': 5758688000, 'exp_to_value': {'Deposits': 2763216000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2253702000, 'remainder_Liabilities': 741770000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4702721803189278, 'aggregate_val': 620636000, 'exp_sum': 1171613000, 'exp_to_value': {'Deposits': 550977000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 507331000, 'remainder_Liabilities': 113305000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4699059942779126, 'aggregate_val': 609571000, 'exp_sum': 1149930000, 'exp_to_value': {'Deposits': 540359000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 500133000, 'remainder_Liabilities': 109438000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48050567895353735, 'aggregate_val': 802666000, 'exp_sum': 1545091000, 'exp_to_value': {'Deposits': 742425000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 679062000, 'remainder_Liabilities': 123604000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.47382626244068515, 'aggregate_val': 916471000, 'exp_sum': 1741765000, 'exp_to_value': {'Deposits': 825294000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 748321000, 'remainder_Liabilities': 168150000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4732730248237373, 'aggregate_val': 1016099000, 'exp_sum': 1929081000, 'exp_to_value': {'Deposits': 912982000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 832316000, 'remainder_Liabilities': 183783000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4487176649579131, 'aggregate_val': 2291480000, 'exp_sum': 4156636000, 'exp_to_value': {'Deposits': 1865156000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1564546000, 'remainder_Liabilities': 726934000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4713067099866198, 'aggregate_val': 2353005000, 'exp_sum': 4450605000, 'exp_to_value': {'Deposits': 2097600000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1794228000, 'remainder_Liabilities': 558777000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4753659517183348, 'aggregate_val': 2344929000, 'exp_sum': 4469647000, 'exp_to_value': {'Deposits': 2124718000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1806101000, 'remainder_Liabilities': 538828000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4741251967314561, 'aggregate_val': 2698119000, 'exp_sum': 5130725000, 'exp_to_value': {'Deposits': 2432606000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2017813000, 'remainder_Liabilities': 680306000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.47983429558955093, 'aggregate_val': 2995472000, 'exp_sum': 5758688000, 'exp_to_value': {'Deposits': 2763216000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2253702000, 'remainder_Liabilities': 741770000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001325670')"} |