QA: Melrose Bancorp Inc in us_state_banks/2018

Table of Contents

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

PDF Report 0001600890_2019_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.42974253009953045, 'aggregate_val': 278739000, 'exp_sum': 488795000, 'exp_to_value': {'Deposits': 244056000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 227264000, 'remainder_Liabilities': 17475000}}
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 Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.42974253009953045, 'aggregate_val': 278739000, 'exp_sum': 488795000, 'exp_to_value': {'Deposits': 244056000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 227264000, 'remainder_Liabilities': 17475000}}
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 244,056,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 227,264,000
3 remainder_Liabilities -192,581,000
4 LoansAndLeasesReceivable 268,211,000
5 AssetsAndSecurities 881,000
6 CashDepositsAndCashEquivalents 15,870,000
7 Goodwill 0
8 PropertyPlantAndEquipment 2,645,000
9 remainder_Assets 36,347,000
10 LaborExpense 0
11 OtherNoninterestExpense 0
12 Occupancy 0
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 605,000
16 remainder_Revenues 0
17 remainder_NetIncome 2,375,000
18 remainder_ComprehensiveNetIncome -597,000
  yvar yval
0 Liabilities 278,739,000
1 Assets 323,954,000
2 Expenses 605,000
3 Revenues 0
4 StockholdersEquity 45,215,000
5 NetIncome 1,770,000
6 ComprehensiveNetIncome 1,173,000
7 BaseVar 303,135,000
8 EconomicCapitalRatio 0.121

Edgar->Model Mapping

Feature Distribution

Change over Time