QA: Macatawa Bank Corp in us_state_banks/2016

Table of Contents

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

PDF Report 0001053584_2017_Macatawa_Bank_Corp.pdf

Logs

error Negative Expenses, ignoring company. pre-agg {'expenses': -18583000}
error Aggregate label 'OtherNoninterestExpense' starts with 'Other' input.sec.calculation_linkbase.edgar_model_mapping {}
warning The stock price does not exist industry.us_generic {}
warning Similarly named company. Duplicate? None {'details': [{'other_company': 'M T Bank Corp', 'shared_tokens': {'bank'}}, {'other_company': 'Independent Bank Corp Mi', 'shared_tokens': {'bank'}}, {'other_company': 'Bank Of Commerce Holdings', 'shared_tokens': {'bank'}}, {'other_company': 'Independent Bank Corp', 'shared_tokens': {'bank'}}, {'other_company': 'Isabella Bank Corp', 'shared_tokens': {'bank'}}, {'other_company': 'Mercantile Bank Corp', 'shared_tokens': {'bank'}}]}
warning No stock price available subcommand.plot {}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0001053584', 'EntityCommonStockSharesOutstanding': 27082823, 'Assets': 1507667000, 'AssetsAndSecurities': 6635000, 'CashDepositsAndCashEquivalents': 243042000, 'Deposits': 1215289000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 1413241000, 'LiabilitiesAndBorrowings': 1039639000, 'LiabilitiesAndStockholdersEquity': 1507667000, 'LoansAndLeasesReceivable': 1039334000, 'LongTermDebt': 41238000, 'NetIncome': 5829000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 55358000, 'Revenues': 0, 'remainder_Assets': 163298000, 'remainder_ComprehensiveNetIncome': 367000, 'remainder_Expenses': 0, 'remainder_Liabilities': -882925000, 'remainder_LiabilitiesAndStockholdersEquity': 94426000, 'remainder_NetIncome': 5829000, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.04905911629248342, 'aggregate_val': 1741013000, 'exp_sum': 1830832000, 'exp_to_value': {'LoansAndLeasesReceivable': 1263850000, 'AssetsAndSecurities': 67415000, 'CashDepositsAndCashEquivalents': 89819000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 50026000, 'remainder_Assets': 359722000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4785218685528446, 'aggregate_val': 1578774000, 'exp_sum': 3027498000, 'exp_to_value': {'Deposits': 1448724000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 947246000, 'remainder_Liabilities': 590290000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.07869916591078906, 'aggregate_val': 1890232000, 'exp_sum': 2051699000, 'exp_to_value': {'LoansAndLeasesReceivable': 1303709000, 'AssetsAndSecurities': 131161000, 'CashDepositsAndCashEquivalents': 161467000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 46629000, 'remainder_Assets': 408733000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4790313616418142, 'aggregate_val': 1717246000, 'exp_sum': 3296256000, 'exp_to_value': {'Deposits': 1579010000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 1088427000, 'remainder_Liabilities': 587581000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.07869916591078906, 'aggregate_val': 1890232000, 'exp_sum': 2051699000, 'exp_to_value': {'LoansAndLeasesReceivable': 1303709000, 'AssetsAndSecurities': 131161000, 'CashDepositsAndCashEquivalents': 161467000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 46629000, 'remainder_Assets': 408733000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4790313616418142, 'aggregate_val': 1717246000, 'exp_sum': 3296256000, 'exp_to_value': {'Deposits': 1579010000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 1088427000, 'remainder_Liabilities': 587581000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4623454934887561, 'aggregate_val': 1413241000, 'exp_sum': 2628530000, 'exp_to_value': {'Deposits': 1215289000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 1039639000, 'remainder_Liabilities': 332364000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47350423637718336, 'aggregate_val': 1430211000, 'exp_sum': 2716472000, 'exp_to_value': {'Deposits': 1286261000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 1038563000, 'remainder_Liabilities': 350410000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4743513003977428, 'aggregate_val': 1384883000, 'exp_sum': 2634617000, 'exp_to_value': {'Deposits': 1249734000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 995175000, 'remainder_Liabilities': 348470000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4754332062430031, 'aggregate_val': 1441327000, 'exp_sum': 2747652000, 'exp_to_value': {'Deposits': 1306325000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 902182000, 'remainder_Liabilities': 497907000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.09495798011531464, 'aggregate_val': 1729643000, 'exp_sum': 1911119000, 'exp_to_value': {'LoansAndLeasesReceivable': 1180851000, 'AssetsAndSecurities': 156356000, 'CashDepositsAndCashEquivalents': 201476000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 51456000, 'remainder_Assets': 320980000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47641128403300437, 'aggregate_val': 1577666000, 'exp_sum': 3013178000, 'exp_to_value': {'Deposits': 1435512000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 958480000, 'remainder_Liabilities': 577948000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.09495798011531464, 'aggregate_val': 1729643000, 'exp_sum': 1911119000, 'exp_to_value': {'LoansAndLeasesReceivable': 1180851000, 'AssetsAndSecurities': 156356000, 'CashDepositsAndCashEquivalents': 201476000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 51456000, 'remainder_Assets': 320980000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47641128403300437, 'aggregate_val': 1577666000, 'exp_sum': 3013178000, 'exp_to_value': {'Deposits': 1435512000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 958480000, 'remainder_Liabilities': 577948000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.04905911629248342, 'aggregate_val': 1741013000, 'exp_sum': 1830832000, 'exp_to_value': {'LoansAndLeasesReceivable': 1263850000, 'AssetsAndSecurities': 67415000, 'CashDepositsAndCashEquivalents': 89819000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 50026000, 'remainder_Assets': 359722000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4785218685528446, 'aggregate_val': 1578774000, 'exp_sum': 3027498000, 'exp_to_value': {'Deposits': 1448724000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 947246000, 'remainder_Liabilities': 590290000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.04905911629248342, 'aggregate_val': 1741013000, 'exp_sum': 1830832000, 'exp_to_value': {'LoansAndLeasesReceivable': 1263850000, 'AssetsAndSecurities': 67415000, 'CashDepositsAndCashEquivalents': 89819000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 50026000, 'remainder_Assets': 359722000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4785218685528446, 'aggregate_val': 1578774000, 'exp_sum': 3027498000, 'exp_to_value': {'Deposits': 1448724000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 947246000, 'remainder_Liabilities': 590290000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.07869916591078906, 'aggregate_val': 1890232000, 'exp_sum': 2051699000, 'exp_to_value': {'LoansAndLeasesReceivable': 1303709000, 'AssetsAndSecurities': 131161000, 'CashDepositsAndCashEquivalents': 161467000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 46629000, 'remainder_Assets': 408733000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4790313616418142, 'aggregate_val': 1717246000, 'exp_sum': 3296256000, 'exp_to_value': {'Deposits': 1579010000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 1088427000, 'remainder_Liabilities': 587581000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Assets', 'missing_ratio': 0.07869916591078906, 'aggregate_val': 1890232000, 'exp_sum': 2051699000, 'exp_to_value': {'LoansAndLeasesReceivable': 1303709000, 'AssetsAndSecurities': 131161000, 'CashDepositsAndCashEquivalents': 161467000, 'Goodwill': 0, 'PropertyPlantAndEquipment': 46629000, 'remainder_Assets': 408733000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4790313616418142, 'aggregate_val': 1717246000, 'exp_sum': 3296256000, 'exp_to_value': {'Deposits': 1579010000, 'LongTermDebt': 41238000, 'LiabilitiesAndBorrowings': 1088427000, 'remainder_Liabilities': 587581000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0001053584')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0001053584, Macatawa Bank Corp

  xvar xval
0 Deposits 1,448,724,000
1 LongTermDebt 41,238,000
2 LiabilitiesAndBorrowings 947,246,000
3 remainder_Liabilities -858,434,000
4 LoansAndLeasesReceivable 1,263,850,000
5 AssetsAndSecurities 67,415,000
6 CashDepositsAndCashEquivalents 89,819,000
7 Goodwill 0
8 PropertyPlantAndEquipment 50,026,000
9 remainder_Assets 269,903,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 6,231,000
16 remainder_Revenues 0
17 remainder_NetIncome 22,182,000
18 remainder_ComprehensiveNetIncome -1,831,000
  yvar yval
0 Liabilities 1,578,774,000
1 Assets 1,741,013,000
2 Expenses 6,231,000
3 Revenues 0
4 StockholdersEquity 162,239,000
5 NetIncome 15,951,000
6 ComprehensiveNetIncome 14,120,000
7 BaseVar 1,675,015,500
8 EconomicCapitalRatio 0.0847

Edgar->Model Mapping

Feature Distribution

Change over Time