QA: Middlefield Banc Corp in us_state_banks/2020

Table of Contents

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

PDF Report 0000836147_2021_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': '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.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 Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000836147, Middlefield Banc Corp

  xvar xval
0 Deposits 1,225,200,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 212,760,000
3 remainder_Liabilities -189,791,000
4 LoansAndLeasesReceivable 1,091,504,000
5 AssetsAndSecurities 114,360,000
6 CashDepositsAndCashEquivalents 112,417,000
7 Goodwill 15,100,000
8 PropertyPlantAndEquipment 18,333,000
9 remainder_Assets 40,265,000
10 LaborExpense 15,835,000
11 OtherNoninterestExpense 3,764,000
12 Occupancy 2,158,000
13 Fees 1,782,000
14 ITAndEquipmentExpense 3,958,000
15 remainder_Expenses 3,692,000
16 remainder_Revenues 427,000
17 remainder_NetIncome 34,934,000
18 remainder_ComprehensiveNetIncome 2,442,000
  yvar yval
0 Liabilities 1,248,169,000
1 Assets 1,391,979,000
2 Expenses 31,189,000
3 Revenues 427,000
4 StockholdersEquity 143,810,000
5 NetIncome 4,172,000
6 ComprehensiveNetIncome 6,614,000
7 BaseVar 1,354,570,000
8 EconomicCapitalRatio 0.0900

Edgar->Model Mapping

Feature Distribution

Change over Time