QA: Middlefield Banc Corp in us_state_banks/2019

Table of Contents

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

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

Graph

Absolute values for 0000836147, Middlefield Banc Corp

  xvar xval
0 Deposits 1,020,843,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 120,669,000
3 remainder_Liabilities -96,812,000
4 LoansAndLeasesReceivable 978,710,000
5 AssetsAndSecurities 105,733,000
6 CashDepositsAndCashEquivalents 35,113,000
7 Goodwill 15,071,000
8 PropertyPlantAndEquipment 17,874,000
9 remainder_Assets 29,974,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 2,592,000
16 remainder_Revenues 0
17 remainder_NetIncome 15,303,000
18 remainder_ComprehensiveNetIncome 1,996,000
  yvar yval
0 Liabilities 1,044,700,000
1 Assets 1,182,475,000
2 Expenses 2,592,000
3 Revenues 0
4 StockholdersEquity 137,775,000
5 NetIncome 12,711,000
6 ComprehensiveNetIncome 14,707,000
7 BaseVar 1,123,533,000
8 EconomicCapitalRatio 0.110

Edgar->Model Mapping

Feature Distribution

Change over Time