QA: Cambridge Bancorp in us_state_banks/2022

Table of Contents

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

PDF Report 0000711772_2023_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.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,815,376,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 1,003,145,000
3 remainder_Liabilities -776,336,000
4 LoansAndLeasesReceivable 4,025,082,000
5 AssetsAndSecurities 1,310,703,000
6 CashDepositsAndCashEquivalents 30,719,000
7 Goodwill 64,539,000
8 PropertyPlantAndEquipment 23,297,000
9 remainder_Assets 105,397,000
10 LaborExpense 70,109,000
11 OtherNoninterestExpense 3,270,000
12 Occupancy 14,364,000
13 Fees 6,573,000
14 ITAndEquipmentExpense 10,706,000
15 remainder_Expenses 24,412,000
16 remainder_Revenues 1,808,000
17 remainder_NetIncome 142,925,000
18 remainder_ComprehensiveNetIncome -19,589,000
  yvar yval
0 Liabilities 5,042,185,000
1 Assets 5,559,737,000
2 Expenses 129,434,000
3 Revenues 1,808,000
4 StockholdersEquity 517,552,000
5 NetIncome 15,299,000
6 ComprehensiveNetIncome -4,290,000
7 BaseVar 5,447,839,000
8 EconomicCapitalRatio 0.0753

Edgar->Model Mapping

Feature Distribution

Change over Time