QA: First Interstate Bancsystem INC in us_state_banks/2017

Table of Contents

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

PDF Report 0000860413_2018_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': '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.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 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 9,934,900,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 7,034,829,000
3 remainder_Liabilities -6,184,090,000
4 LoansAndLeasesReceivable 0
5 AssetsAndSecurities 2,838,953,000
6 CashDepositsAndCashEquivalents 758,986,000
7 Goodwill 444,704,000
8 PropertyPlantAndEquipment 241,900,000
9 remainder_Assets 7,928,712,000
10 LaborExpense 122,751,000
11 OtherNoninterestExpense 57,087,000
12 Occupancy 22,410,000
13 Fees 11,452,000
14 ITAndEquipmentExpense 11,467,000
15 remainder_Expenses 98,654,000
16 remainder_Revenues 141,753,000
17 remainder_NetIncome 338,790,000
18 remainder_ComprehensiveNetIncome -54,036,000
  yvar yval
0 Liabilities 10,785,639,000
1 Assets 12,213,255,000
2 Expenses 323,821,000
3 Revenues 141,753,000
4 StockholdersEquity 1,427,616,000
5 NetIncome 156,722,000
6 ComprehensiveNetIncome 102,686,000
7 BaseVar 11,928,647,000
8 EconomicCapitalRatio 0.106

Edgar->Model Mapping

Feature Distribution

Change over Time