QA: Cambridge Bancorp in us_state_banks/2019

Table of Contents

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

PDF Report 0000711772_2020_Cambridge_Bancorp.pdf

Logs

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 No stock price available subcommand.plot {}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47868008149549096, 'aggregate_val': 2569002000, 'exp_sum': 4927880000, 'exp_to_value': {'Deposits': 2358878000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 489477000, 'remainder_Liabilities': 2079525000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48960658056630113, 'aggregate_val': 3547565000, 'exp_sum': 6950648000, 'exp_to_value': {'Deposits': 3403083000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 699692000, 'remainder_Liabilities': 2847873000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49628540687772077, 'aggregate_val': 1801977000, 'exp_sum': 3577377000, 'exp_to_value': {'Deposits': 1775400000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 485955000, 'remainder_Liabilities': 1316022000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4835884123095718, 'aggregate_val': 1934358000, 'exp_sum': 3745768000, 'exp_to_value': {'Deposits': 1811410000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 461241000, 'remainder_Liabilities': 1473117000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47868008149549096, 'aggregate_val': 2569002000, 'exp_sum': 4927880000, 'exp_to_value': {'Deposits': 2358878000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 489477000, 'remainder_Liabilities': 2079525000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48960658056630113, 'aggregate_val': 3547565000, 'exp_sum': 6950648000, 'exp_to_value': {'Deposits': 3403083000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 699692000, 'remainder_Liabilities': 2847873000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0000711772')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0000711772, Cambridge Bancorp

  xvar xval
0 Deposits 2,358,878,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 489,477,000
3 remainder_Liabilities -279,353,000
4 LoansAndLeasesReceivable 2,208,548,000
5 AssetsAndSecurities 440,793,000
6 CashDepositsAndCashEquivalents 61,335,000
7 Goodwill 31,206,000
8 PropertyPlantAndEquipment 14,756,000
9 remainder_Assets 98,925,000
10 LaborExpense 47,494,000
11 OtherNoninterestExpense 3,199,000
12 Occupancy 10,855,000
13 Fees 3,914,000
14 ITAndEquipmentExpense 6,232,000
15 remainder_Expenses 15,142,000
16 remainder_Revenues 612,000
17 remainder_NetIncome 80,384,000
18 remainder_ComprehensiveNetIncome 4,006,000
  yvar yval
0 Liabilities 2,569,002,000
1 Assets 2,855,563,000
2 Expenses 86,836,000
3 Revenues 612,000
4 StockholdersEquity 286,561,000
5 NetIncome -5,840,000
6 ComprehensiveNetIncome -1,834,000
7 BaseVar 2,798,201,500
8 EconomicCapitalRatio 0.0817

Edgar->Model Mapping

Feature Distribution

Change over Time