QA: Sierra Bancorp in us_state_banks/2022

Table of Contents

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

PDF Report 0001130144_2023_Sierra_Bancorp.pdf

Logs

error Negative Expenses, ignoring company. pre-agg {'expenses': -344000}
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 Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0001130144', 'EntityCommonStockSharesOutstanding': 14101259, 'Assets': 1335405000, 'AssetsAndSecurities': 81602000, 'CashDepositsAndCashEquivalents': 63036000, 'Deposits': 1086268000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 5544000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 1166841000, 'LiabilitiesAndBorrowings': 803748000, 'LiabilitiesAndStockholdersEquity': 1335405000, 'LoansAndLeasesReceivable': 740929000, 'LongTermDebt': 15000000, 'NetIncome': 7780000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 20721000, 'Revenues': 0, 'remainder_Assets': 423573000, 'remainder_ComprehensiveNetIncome': 2950000, 'remainder_Expenses': 0, 'remainder_Liabilities': -738175000, 'remainder_LiabilitiesAndStockholdersEquity': 168564000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.46270271746587477, 'aggregate_val': 3305008000, 'exp_sum': 6151172000, 'exp_to_value': {'Deposits': 2846164000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1803105000, 'remainder_Liabilities': 1501903000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4487659121474746, 'aggregate_val': 3391702000, 'exp_sum': 6152925000, 'exp_to_value': {'Deposits': 2761223000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1817835000, 'remainder_Liabilities': 1573867000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48211959563429907, 'aggregate_val': 1166841000, 'exp_sum': 2253109000, 'exp_to_value': {'Deposits': 1086268000, 'LongTermDebt': 15000000, 'LiabilitiesAndBorrowings': 803748000, 'remainder_Liabilities': 348093000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4815473053204514, 'aggregate_val': 1264011000, 'exp_sum': 2438045000, 'exp_to_value': {'Deposits': 1174034000, 'LongTermDebt': 5000000, 'LiabilitiesAndBorrowings': 838836000, 'remainder_Liabilities': 420175000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4886804891387133, 'aggregate_val': 1228575000, 'exp_sum': 2402754000, 'exp_to_value': {'Deposits': 1174179000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 831650000, 'remainder_Liabilities': 396925000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.47694935400096067, 'aggregate_val': 1606197000, 'exp_sum': 3070825000, 'exp_to_value': {'Deposits': 1464628000, 'LongTermDebt': 2000000, 'LiabilitiesAndBorrowings': 1065718000, 'remainder_Liabilities': 538479000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48133069275899326, 'aggregate_val': 1826995000, 'exp_sum': 3522466000, 'exp_to_value': {'Deposits': 1695471000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1203033000, 'remainder_Liabilities': 623962000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48821801135451254, 'aggregate_val': 2084356000, 'exp_sum': 4072742000, 'exp_to_value': {'Deposits': 1988386000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1384284000, 'remainder_Liabilities': 700072000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.484752227417634, 'aggregate_val': 2249478000, 'exp_sum': 4365818000, 'exp_to_value': {'Deposits': 2116340000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1479725000, 'remainder_Liabilities': 769753000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4869568380932191, 'aggregate_val': 2284534000, 'exp_sum': 4452908000, 'exp_to_value': {'Deposits': 2168374000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1512928000, 'remainder_Liabilities': 771606000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4770751430713201, 'aggregate_val': 2876846000, 'exp_sum': 5501452000, 'exp_to_value': {'Deposits': 2624606000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1716020000, 'remainder_Liabilities': 1160826000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.48040203851683183, 'aggregate_val': 3008520000, 'exp_sum': 5790092000, 'exp_to_value': {'Deposits': 2781572000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1732596000, 'remainder_Liabilities': 1275924000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.46270271746587477, 'aggregate_val': 3305008000, 'exp_sum': 6151172000, 'exp_to_value': {'Deposits': 2846164000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1803105000, 'remainder_Liabilities': 1501903000}}
info Minor missing amount for aggregate added to remainder industry.us_generic {'aggregate': 'Liabilities', 'missing_ratio': 0.4487659121474746, 'aggregate_val': 3391702000, 'exp_sum': 6152925000, 'exp_to_value': {'Deposits': 2761223000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1817835000, 'remainder_Liabilities': 1573867000}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0001130144')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0001130144, Sierra Bancorp

  xvar xval
0 Deposits 2,846,164,000
1 LongTermDebt 0
2 LiabilitiesAndBorrowings 1,803,105,000
3 remainder_Liabilities -1,344,261,000
4 LoansAndLeasesReceivable 0
5 AssetsAndSecurities 1,060,542,000
6 CashDepositsAndCashEquivalents 77,131,000
7 Goodwill 27,357,000
8 PropertyPlantAndEquipment 22,478,000
9 remainder_Assets 2,421,082,000
10 LaborExpense 47,053,000
11 OtherNoninterestExpense 28,032,000
12 Occupancy 9,718,000
13 Fees 0
14 ITAndEquipmentExpense 0
15 remainder_Expenses 11,256,000
16 remainder_Revenues 9,211,000
17 remainder_NetIncome 99,439,000
18 remainder_ComprehensiveNetIncome -67,743,000
  yvar yval
0 Liabilities 3,305,008,000
1 Assets 3,608,590,000
2 Expenses 96,059,000
3 Revenues 9,211,000
4 StockholdersEquity 303,582,000
5 NetIncome 12,591,000
6 ComprehensiveNetIncome -55,152,000
7 BaseVar 3,593,025,000
8 EconomicCapitalRatio 0.0525

Edgar->Model Mapping

Feature Distribution

Change over Time