QA: Hills Bancorporation in us_state_banks/2017

Table of Contents

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

PDF Report 0000732417_2018_Hills_Bancorporation.pdf

Logs

error Aggregate label 'OtherNoninterestExpense' starts with 'Other' input.sec.calculation_linkbase.edgar_model_mapping {}
warning NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping {}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4673496564459849, 'aggregate_val': 2608336000, 'exp_sum': 4896901000, 'exp_to_value': {'Deposits': 2288565000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1948229000, 'remainder_Liabilities': 660107000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.476614599368956, 'aggregate_val': 2658712000, 'exp_sum': 5079836000, 'exp_to_value': {'Deposits': 2421124000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2069748000, 'remainder_Liabilities': 588964000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4612148864450968, 'aggregate_val': 1782042000, 'exp_sum': 3307519000, 'exp_to_value': {'Deposits': 1525477000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1319254000, 'remainder_Liabilities': 462788000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47415191796148304, 'aggregate_val': 1843809000, 'exp_sum': 3506353000, 'exp_to_value': {'Deposits': 1662544000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1404692000, 'remainder_Liabilities': 439117000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47439800527646214, 'aggregate_val': 1894432000, 'exp_sum': 3604309000, 'exp_to_value': {'Deposits': 1709877000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1469526000, 'remainder_Liabilities': 424906000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4730427336150345, 'aggregate_val': 2044219000, 'exp_sum': 3879288000, 'exp_to_value': {'Deposits': 1835069000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1567100000, 'remainder_Liabilities': 477119000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.46402468774634487, 'aggregate_val': 2183870000, 'exp_sum': 4074572000, 'exp_to_value': {'Deposits': 1890702000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1599005000, 'remainder_Liabilities': 584865000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4668265768858589, 'aggregate_val': 2325719000, 'exp_sum': 4362031000, 'exp_to_value': {'Deposits': 2036312000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1707741000, 'remainder_Liabilities': 617978000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4673496564459849, 'aggregate_val': 2608336000, 'exp_sum': 4896901000, 'exp_to_value': {'Deposits': 2288565000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1948229000, 'remainder_Liabilities': 660107000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.476614599368956, 'aggregate_val': 2658712000, 'exp_sum': 5079836000, 'exp_to_value': {'Deposits': 2421124000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2069748000, 'remainder_Liabilities': 588964000}}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000732417, Hills Bancorporation

  xvar xval
0 Deposits 2,288,565,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 1,948,229,000
3 remainder_Liabilities -1,628,458,000
4 LoansAndLeasesReceivable 2,431,165,000
5 AssetsAndSecurities 2,509,000
6 CashDepositsAndCashEquivalents 154,353,000
7 Goodwill 2,500,000
8 PropertyPlantAndEquipment 37,857,000
9 remainder_Assets 334,976,000
10 LaborExpense 33,197,000
11 OtherNoninterestExpense 2,673,000
12 Occupancy 0
13 Fees 845,000
14 ITAndEquipmentExpense 5,580,000
15 remainder_Expenses 17,217,000
16 remainder_Revenues 20,818,000
17 remainder_NetIncome 86,292,000
18 remainder_ComprehensiveNetIncome -18,624,000
  yvar yval
0 Liabilities 2,608,336,000
1 Assets 2,963,360,000
2 Expenses 59,512,000
3 Revenues 20,818,000
4 StockholdersEquity 355,024,000
5 NetIncome 47,598,000
6 ComprehensiveNetIncome 28,974,000
7 BaseVar 2,878,471,000
8 EconomicCapitalRatio 0.110

Edgar->Model Mapping

Feature Distribution

Change over Time