QA: Middlefield Banc Corp in us_state_banks/2022

Table of Contents

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

PDF Report 0000836147_2023_Middlefield_Banc_Corp.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.48479050902313614, 'aggregate_val': 1489991000, 'exp_sum': 2892010000, 'exp_to_value': {'Deposits': 1402019000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 176736000, 'remainder_Liabilities': 1313255000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4686904938688562, 'aggregate_val': 1617202000, 'exp_sum': 3043804000, 'exp_to_value': {'Deposits': 1426602000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 217444000, 'remainder_Liabilities': 1399758000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4889182502145995, 'aggregate_val': 607298000, 'exp_sum': 1188260000, 'exp_to_value': {'Deposits': 580962000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 72684000, 'remainder_Liabilities': 534614000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4910957418808031, 'aggregate_val': 614851000, 'exp_sum': 1208186000, 'exp_to_value': {'Deposits': 593335000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 76885000, 'remainder_Liabilities': 537966000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4893410744348374, 'aggregate_val': 593617000, 'exp_sum': 1162453000, 'exp_to_value': {'Deposits': 568836000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 65350000, 'remainder_Liabilities': 528267000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48851785666657777, 'aggregate_val': 613664000, 'exp_sum': 1199776000, 'exp_to_value': {'Deposits': 586112000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 67001000, 'remainder_Liabilities': 546663000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4813502384215614, 'aggregate_val': 672835000, 'exp_sum': 1297282000, 'exp_to_value': {'Deposits': 624447000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 67158000, 'remainder_Liabilities': 605677000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.46982126275828895, 'aggregate_val': 710861000, 'exp_sum': 1340795000, 'exp_to_value': {'Deposits': 629934000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 68997000, 'remainder_Liabilities': 641864000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47096559332041593, 'aggregate_val': 986473000, 'exp_sum': 1864667000, 'exp_to_value': {'Deposits': 878194000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 113055000, 'remainder_Liabilities': 873418000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47564782847847203, 'aggregate_val': 1120108000, 'exp_sum': 2136175000, 'exp_to_value': {'Deposits': 1016067000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 126329000, 'remainder_Liabilities': 993779000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4942250052407527, 'aggregate_val': 1044700000, 'exp_sum': 2065543000, 'exp_to_value': {'Deposits': 1020843000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 120669000, 'remainder_Liabilities': 924031000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 2.0833213602220677e-05, 'aggregate_val': 1391979000, 'exp_sum': 1392008000, 'exp_to_value': {'LoansAndLeasesReceivable': 1091504000, 'AssetsAndSecurities': 114360000, 'CashDepositsAndCashEquivalents': 112417000, 'Goodwill': 15100000, 'PropertyPlantAndEquipment': 18333000, 'remainder_Assets': 40294000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4953567381171188, 'aggregate_val': 1248169000, 'exp_sum': 2473369000, 'exp_to_value': {'Deposits': 1225200000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 212760000, 'remainder_Liabilities': 1035409000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 2.0833213602220677e-05, 'aggregate_val': 1391979000, 'exp_sum': 1392008000, 'exp_to_value': {'LoansAndLeasesReceivable': 1091504000, 'AssetsAndSecurities': 114360000, 'CashDepositsAndCashEquivalents': 112417000, 'Goodwill': 15100000, 'PropertyPlantAndEquipment': 18333000, 'remainder_Assets': 40294000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4953567381171188, 'aggregate_val': 1248169000, 'exp_sum': 2473369000, 'exp_to_value': {'Deposits': 1225200000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 212760000, 'remainder_Liabilities': 1035409000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4959484007225327, 'aggregate_val': 1185671000, 'exp_sum': 2352281000, 'exp_to_value': {'Deposits': 1166610000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 209209000, 'remainder_Liabilities': 976462000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48479050902313614, 'aggregate_val': 1489991000, 'exp_sum': 2892010000, 'exp_to_value': {'Deposits': 1402019000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 176736000, 'remainder_Liabilities': 1313255000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4686904938688562, 'aggregate_val': 1617202000, 'exp_sum': 3043804000, 'exp_to_value': {'Deposits': 1426602000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 217444000, 'remainder_Liabilities': 1399758000}}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000836147, Middlefield Banc Corp

  xvar xval
0 Deposits 1,402,019,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 176,736,000
3 remainder_Liabilities -88,764,000
4 LoansAndLeasesReceivable 1,338,434,000
5 AssetsAndSecurities 164,967,000
6 CashDepositsAndCashEquivalents 53,809,000
7 Goodwill 31,735,000
8 PropertyPlantAndEquipment 21,961,000
9 remainder_Assets 76,776,000
10 LaborExpense 17,548,000
11 OtherNoninterestExpense 4,851,000
12 Occupancy 2,033,000
13 Fees 1,829,000
14 ITAndEquipmentExpense 4,775,000
15 remainder_Expenses 10,214,000
16 remainder_Revenues 459,000
17 remainder_NetIncome 51,653,000
18 remainder_ComprehensiveNetIncome -25,606,000
  yvar yval
0 Liabilities 1,489,991,000
1 Assets 1,687,682,000
2 Expenses 41,250,000
3 Revenues 459,000
4 StockholdersEquity 197,691,000
5 NetIncome 10,862,000
6 ComprehensiveNetIncome -14,744,000
7 BaseVar 1,648,320,500
8 EconomicCapitalRatio 0.0878

Edgar->Model Mapping

Feature Distribution

Change over Time