QA: Cambridge Bancorp in us_state_banks/2018

Table of Contents

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

PDF Report 0000711772_2019_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.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.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 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 1,811,410,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 461,241,000
3 remainder_Liabilities -338,293,000
4 LoansAndLeasesReceivable 1,543,004,000
5 AssetsAndSecurities 479,073,000
6 CashDepositsAndCashEquivalents 18,473,000
7 Goodwill 0
8 PropertyPlantAndEquipment 8,578,000
9 remainder_Assets 52,256,000
10 LaborExpense 41,212,000
11 OtherNoninterestExpense 2,264,000
12 Occupancy 9,072,000
13 Fees 3,832,000
14 ITAndEquipmentExpense 5,177,000
15 remainder_Expenses 9,637,000
16 remainder_Revenues 526,000
17 remainder_NetIncome 65,107,000
18 remainder_ComprehensiveNetIncome 596,000
  yvar yval
0 Liabilities 1,934,358,000
1 Assets 2,101,384,000
2 Expenses 71,194,000
3 Revenues 526,000
4 StockholdersEquity 167,026,000
5 NetIncome -5,561,000
6 ComprehensiveNetIncome -4,965,000
7 BaseVar 2,086,582,500
8 EconomicCapitalRatio 0.0621

Edgar->Model Mapping

Feature Distribution

Change over Time