QA: Cambridge Bancorp in us_state_banks/2020

Table of Contents

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

PDF Report 0000711772_2021_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.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.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 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 3,403,083,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 699,692,000
3 remainder_Liabilities -555,210,000
4 LoansAndLeasesReceivable 3,117,632,000
5 AssetsAndSecurities 567,941,000
6 CashDepositsAndCashEquivalents 75,785,000
7 Goodwill 51,912,000
8 PropertyPlantAndEquipment 18,158,000
9 remainder_Assets 117,869,000
10 LaborExpense 58,975,000
11 OtherNoninterestExpense 3,832,000
12 Occupancy 13,004,000
13 Fees 5,182,000
14 ITAndEquipmentExpense 7,662,000
15 remainder_Expenses 20,834,000
16 remainder_Revenues 747,000
17 remainder_NetIncome 107,047,000
18 remainder_ComprehensiveNetIncome 4,915,000
  yvar yval
0 Liabilities 3,547,565,000
1 Assets 3,949,297,000
2 Expenses 109,489,000
3 Revenues 747,000
4 StockholdersEquity 401,732,000
5 NetIncome -1,695,000
6 ComprehensiveNetIncome 3,220,000
7 BaseVar 3,859,530,000
8 EconomicCapitalRatio 0.0845

Edgar->Model Mapping

Feature Distribution

Change over Time