QA: Hills Bancorporation in us_state_banks/2022

Table of Contents

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

PDF Report 0000732417_2023_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.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.46175802201845806, 'aggregate_val': 3826528000, 'exp_sum': 7109308000, 'exp_to_value': {'Deposits': 3282780000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2699270000, 'remainder_Liabilities': 1127258000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.46175802201845806, 'aggregate_val': 3826528000, 'exp_sum': 7109308000, 'exp_to_value': {'Deposits': 3282780000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2699270000, 'remainder_Liabilities': 1127258000}}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000732417, Hills Bancorporation

  xvar xval
0 Deposits 3,357,367,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 2,725,875,000
3 remainder_Liabilities -2,582,032,000
4 LoansAndLeasesReceivable 3,066,981,000
5 AssetsAndSecurities 783,722,000
6 CashDepositsAndCashEquivalents 36,641,000
7 Goodwill 2,500,000
8 PropertyPlantAndEquipment 33,518,000
9 remainder_Assets 57,119,000
10 LaborExpense 43,468,000
11 OtherNoninterestExpense 2,363,000
12 Occupancy 0
13 Fees 1,079,000
14 ITAndEquipmentExpense 6,937,000
15 remainder_Expenses 34,842,000
16 remainder_Revenues 0
17 remainder_NetIncome 111,512,000
18 remainder_ComprehensiveNetIncome -42,537,000
  yvar yval
0 Liabilities 3,501,210,000
1 Assets 3,980,481,000
2 Expenses 88,689,000
3 Revenues 0
4 StockholdersEquity 479,271,000
5 NetIncome 22,823,000
6 ComprehensiveNetIncome -19,714,000
7 BaseVar 3,862,214,500
8 EconomicCapitalRatio 0.0947

Edgar->Model Mapping

Feature Distribution

Change over Time