QA: Middlefield Banc Corp in us_state_banks/2017

Table of Contents

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

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

Graph

Absolute values for 0000836147, Middlefield Banc Corp

  xvar xval
0 Deposits 878,194,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 113,055,000
3 remainder_Liabilities -4,776,000
4 LoansAndLeasesReceivable 916,486,000
5 AssetsAndSecurities 0
6 CashDepositsAndCashEquivalents 39,886,000
7 Goodwill 15,071,000
8 PropertyPlantAndEquipment 11,853,000
9 remainder_Assets 123,040,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 4,222,000
16 remainder_Revenues 0
17 remainder_NetIncome 13,677,000
18 remainder_ComprehensiveNetIncome -110,000
  yvar yval
0 Liabilities 986,473,000
1 Assets 1,106,336,000
2 Expenses 4,222,000
3 Revenues 0
4 StockholdersEquity 119,863,000
5 NetIncome 9,455,000
6 ComprehensiveNetIncome 9,345,000
7 BaseVar 1,055,409,000
8 EconomicCapitalRatio 0.0983

Edgar->Model Mapping

Feature Distribution

Change over Time