QA: First Interstate Bancsystem INC in us_state_banks/2018

Table of Contents

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

PDF Report 0000860413_2019_First_Interstate_Bancsystem_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 Similarly named company. Duplicate? None {'details': [{'other_company': 'First Financial Corp In', 'shared_tokens': {'first'}}]}
warning NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping {}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000860413', 'EntityCommonStockSharesOutstanding': 21747983, 'Assets': 8609936000, 'AssetsAndSecurities': 2360605000, 'CashDepositsAndCashEquivalents': 798670000, 'Deposits': 7006212000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 205574000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 7701012000, 'LiabilitiesAndBorrowings': 0, 'LiabilitiesAndStockholdersEquity': 8609936000, 'LoansAndLeasesReceivable': 4823243000, 'LongTermDebt': 0, 'NetIncome': 84401000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 195212000, 'Revenues': 0, 'remainder_Assets': 226632000, 'remainder_ComprehensiveNetIncome': 13507000, 'remainder_Expenses': 0, 'remainder_Liabilities': 694800000, 'remainder_LiabilitiesAndStockholdersEquity': 908924000, '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.4792345313411406, 'aggregate_val': 11606300000, 'exp_sum': 22287000000, 'exp_to_value': {'Deposits': 10680700000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 7522400000, 'remainder_Liabilities': 4083900000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.480101919008142, 'aggregate_val': 12630300000, 'exp_sum': 24293800000, 'exp_to_value': {'Deposits': 11663500000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 8237000000, 'remainder_Liabilities': 4393300000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47061998575614317, 'aggregate_val': 6554507000, 'exp_sum': 12381478000, 'exp_to_value': {'Deposits': 5826971000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4555262000, 'remainder_Liabilities': 1999245000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47236527235741527, 'aggregate_val': 6970575000, 'exp_sum': 13210986000, 'exp_to_value': {'Deposits': 6240411000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4745102000, 'remainder_Liabilities': 2225473000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Expenses', 'missing_ratio': 0.0001358590770845877, 'aggregate_val': 323821000, 'exp_sum': 323865000, 'exp_to_value': {'LaborExpense': 122751000, 'OtherNoninterestExpense': 57087000, 'Occupancy': 22410000, 'Fees': 11452000, 'ITAndEquipmentExpense': 11467000, 'remainder_Expenses': 98698000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 1.097156571366064e-05, 'aggregate_val': 12213255000, 'exp_sum': 12213389000, 'exp_to_value': {'LoansAndLeasesReceivable': 0, 'AssetsAndSecurities': 2838953000, 'CashDepositsAndCashEquivalents': 758986000, 'Goodwill': 444704000, 'PropertyPlantAndEquipment': 241900000, 'remainder_Assets': 7928846000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47947114312657874, 'aggregate_val': 10785639000, 'exp_sum': 20720540000, 'exp_to_value': {'Deposits': 9934900000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 7034829000, 'remainder_Liabilities': 3750811000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Expenses', 'missing_ratio': 0.0001358590770845877, 'aggregate_val': 323821000, 'exp_sum': 323865000, 'exp_to_value': {'LaborExpense': 122751000, 'OtherNoninterestExpense': 57087000, 'Occupancy': 22410000, 'Fees': 11452000, 'ITAndEquipmentExpense': 11467000, 'remainder_Expenses': 98698000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 1.097156571366064e-05, 'aggregate_val': 12213255000, 'exp_sum': 12213389000, 'exp_to_value': {'LoansAndLeasesReceivable': 0, 'AssetsAndSecurities': 2838953000, 'CashDepositsAndCashEquivalents': 758986000, 'Goodwill': 444704000, 'PropertyPlantAndEquipment': 241900000, 'remainder_Assets': 7928846000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47947114312657874, 'aggregate_val': 10785639000, 'exp_sum': 20720540000, 'exp_to_value': {'Deposits': 9934900000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 7034829000, 'remainder_Liabilities': 3750811000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4792345313411406, 'aggregate_val': 11606300000, 'exp_sum': 22287000000, 'exp_to_value': {'Deposits': 10680700000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 7522400000, 'remainder_Liabilities': 4083900000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.480101919008142, 'aggregate_val': 12630300000, 'exp_sum': 24293800000, 'exp_to_value': {'Deposits': 11663500000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 8237000000, 'remainder_Liabilities': 4393300000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0000860413')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000860413, First Interstate Bancsystem INC

  xvar xval
0 Deposits 10,680,700,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 7,522,400,000
3 remainder_Liabilities -6,596,800,000
4 LoansAndLeasesReceivable 0
5 AssetsAndSecurities 2,836,600,000
6 CashDepositsAndCashEquivalents 822,000,000
7 Goodwill 546,700,000
8 PropertyPlantAndEquipment 245,200,000
9 remainder_Assets 8,849,700,000
10 LaborExpense 146,400,000
11 OtherNoninterestExpense 63,600,000
12 Occupancy 25,400,000
13 Fees 12,500,000
14 ITAndEquipmentExpense 41,400,000
15 remainder_Expenses 71,600,000
16 remainder_Revenues 0
17 remainder_NetIncome 423,800,000
18 remainder_ComprehensiveNetIncome -55,600,000
  yvar yval
0 Liabilities 11,606,300,000
1 Assets 13,300,200,000
2 Expenses 360,900,000
3 Revenues 0
4 StockholdersEquity 1,693,900,000
5 NetIncome 62,900,000
6 ComprehensiveNetIncome 7,300,000
7 BaseVar 12,873,400,000
8 EconomicCapitalRatio 0.107

Edgar->Model Mapping

Feature Distribution

Change over Time