QA: Cambridge Bancorp in us_state_banks/2021

Table of Contents

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

PDF Report 0000711772_2022_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.49302464615539077, 'aggregate_val': 4453707000, 'exp_sum': 8784859000, 'exp_to_value': {'Deposits': 4331152000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 835362000, 'remainder_Liabilities': 3618345000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4884956836686073, 'aggregate_val': 5042185000, 'exp_sum': 9857561000, 'exp_to_value': {'Deposits': 4815376000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1003145000, 'remainder_Liabilities': 4039040000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49302464615539077, 'aggregate_val': 4453707000, 'exp_sum': 8784859000, 'exp_to_value': {'Deposits': 4331152000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 835362000, 'remainder_Liabilities': 3618345000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4884956836686073, 'aggregate_val': 5042185000, 'exp_sum': 9857561000, 'exp_to_value': {'Deposits': 4815376000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1003145000, 'remainder_Liabilities': 4039040000}}
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 4,331,152,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 835,362,000
3 remainder_Liabilities -712,807,000
4 LoansAndLeasesReceivable 3,284,610,000
5 AssetsAndSecurities 1,251,230,000
6 CashDepositsAndCashEquivalents 180,153,000
7 Goodwill 51,912,000
8 PropertyPlantAndEquipment 17,326,000
9 remainder_Assets 106,313,000
10 LaborExpense 65,127,000
11 OtherNoninterestExpense 2,267,000
12 Occupancy 13,898,000
13 Fees 6,709,000
14 ITAndEquipmentExpense 8,829,000
15 remainder_Expenses 22,745,000
16 remainder_Revenues 801,000
17 remainder_NetIncome 134,255,000
18 remainder_ComprehensiveNetIncome -3,644,000
  yvar yval
0 Liabilities 4,453,707,000
1 Assets 4,891,544,000
2 Expenses 119,575,000
3 Revenues 801,000
4 StockholdersEquity 437,837,000
5 NetIncome 15,481,000
6 ComprehensiveNetIncome 11,837,000
7 BaseVar 4,801,763,000
8 EconomicCapitalRatio 0.0756

Edgar->Model Mapping

Feature Distribution

Change over Time