QA: Hills Bancorporation in us_state_banks/2021

Table of Contents

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

PDF Report 0000732417_2022_Hills_Bancorporation.pdf

Logs

error Aggregate label 'OtherNoninterestExpense' starts with 'Other' input.sec.calculation_linkbase.edgar_model_mapping {}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49844113469315565, 'aggregate_val': 3556099000, 'exp_sum': 7090093000, 'exp_to_value': {'Deposits': 3533994000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2917734000, 'remainder_Liabilities': 638365000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4895136410949385, 'aggregate_val': 3501210000, 'exp_sum': 6858577000, 'exp_to_value': {'Deposits': 3357367000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2725875000, 'remainder_Liabilities': 775335000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.480805981485088, 'aggregate_val': 2873850000, 'exp_sum': 5535214000, 'exp_to_value': {'Deposits': 2661364000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2298764000, 'remainder_Liabilities': 575086000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49042685660055174, 'aggregate_val': 3317206000, 'exp_sum': 6509774000, 'exp_to_value': {'Deposits': 3192568000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2678283000, 'remainder_Liabilities': 638923000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49844113469315565, 'aggregate_val': 3556099000, 'exp_sum': 7090093000, 'exp_to_value': {'Deposits': 3533994000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2917734000, 'remainder_Liabilities': 638365000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4895136410949385, 'aggregate_val': 3501210000, 'exp_sum': 6858577000, 'exp_to_value': {'Deposits': 3357367000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2725875000, 'remainder_Liabilities': 775335000}}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000732417, Hills Bancorporation

  xvar xval
0 Deposits 3,533,994,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 2,917,734,000
3 remainder_Liabilities -2,895,629,000
4 LoansAndLeasesReceivable 2,625,062,000
5 AssetsAndSecurities 560,153,000
6 CashDepositsAndCashEquivalents 781,918,000
7 Goodwill 2,500,000
8 PropertyPlantAndEquipment 34,290,000
9 remainder_Assets 40,639,000
10 LaborExpense 42,458,000
11 OtherNoninterestExpense 9,949,000
12 Occupancy 0
13 Fees 1,043,000
14 ITAndEquipmentExpense 7,276,000
15 remainder_Expenses 34,622,000
16 remainder_Revenues 0
17 remainder_NetIncome 118,138,000
18 remainder_ComprehensiveNetIncome -7,305,000
  yvar yval
0 Liabilities 3,556,099,000
1 Assets 4,044,562,000
2 Expenses 95,348,000
3 Revenues 0
4 StockholdersEquity 488,463,000
5 NetIncome 22,790,000
6 ComprehensiveNetIncome 15,485,000
7 BaseVar 3,910,726,000
8 EconomicCapitalRatio 0.104

Edgar->Model Mapping

Feature Distribution

Change over Time