QA: Melrose Bancorp Inc in us_state_banks/2016

Table of Contents

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

PDF Report 0001600890_2017_Melrose_Bancorp_Inc.pdf

Logs

error Negative Expenses, ignoring company. pre-agg {'expenses': -181000}
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 The EntityCommonStockSharesOutstanding 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.4879847673752806, 'aggregate_val': 225342000, 'exp_sum': 440108000, 'exp_to_value': {'Deposits': 214766000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 197756000, 'remainder_Liabilities': 27586000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47011629737574023, 'aggregate_val': 262533000, 'exp_sum': 495454000, 'exp_to_value': {'Deposits': 232921000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 217353000, 'remainder_Liabilities': 45180000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4987938498283326, 'aggregate_val': 167879000, 'exp_sum': 334950000, 'exp_to_value': {'Deposits': 167071000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 154378000, 'remainder_Liabilities': 13501000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.49913846969496145, 'aggregate_val': 185164000, 'exp_sum': 369691000, 'exp_to_value': {'Deposits': 184527000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 171686000, 'remainder_Liabilities': 13478000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4879847673752806, 'aggregate_val': 225342000, 'exp_sum': 440108000, 'exp_to_value': {'Deposits': 214766000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 197756000, 'remainder_Liabilities': 27586000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47011629737574023, 'aggregate_val': 262533000, 'exp_sum': 495454000, 'exp_to_value': {'Deposits': 232921000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 217353000, 'remainder_Liabilities': 45180000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('EntityCommonStockSharesOutstanding')"}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0001600890')"}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('EntityCommonStockSharesOutstanding')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0001600890, Melrose Bancorp Inc

  xvar xval
0 Deposits 214,766,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 197,756,000
3 remainder_Liabilities -187,180,000
4 LoansAndLeasesReceivable 213,165,000
5 AssetsAndSecurities 199,000
6 CashDepositsAndCashEquivalents 13,792,000
7 Goodwill 0
8 PropertyPlantAndEquipment 1,248,000
9 remainder_Assets 40,242,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 796,000
16 remainder_Revenues 0
17 remainder_NetIncome 2,218,000
18 remainder_ComprehensiveNetIncome -450,000
  yvar yval
0 Liabilities 225,342,000
1 Assets 268,646,000
2 Expenses 796,000
3 Revenues 0
4 StockholdersEquity 43,304,000
5 NetIncome 1,422,000
6 ComprehensiveNetIncome 972,000
7 BaseVar 248,726,000
8 EconomicCapitalRatio 0.141

Edgar->Model Mapping

Feature Distribution

Change over Time