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 |
{} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.5380509688403643, 'aggregate_val': 113825000000, 'exp_sum': 74006000000, 'exp_to_value': {'Investments': 58390000000, 'CashAndCurrentAssets': 5063000000, 'IntangibleAssets': 1173000000, 'remainder_Assets': 9380000000}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000804269', 'EntityCommonStockSharesOutstanding': 503, 'Assets': 0, 'CashAndCurrentAssets': 0, 'ComprehensiveNetIncome': 93000000, 'CostOfGoodsSold': 0, 'Debt': 37431000000, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 1426000000, 'Expenses': 4317000000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 40332000000, 'LiabilitiesAndStockholdersEquity': 47724000000, 'LoansIncome': 0, 'LoansPayable': 1002000000, 'NetIncome': 537000000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 1162000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 4854000000, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -444000000, 'remainder_Expenses': 1729000000, 'remainder_Liabilities': 1899000000, 'remainder_LiabilitiesAndStockholdersEquity': 7392000000, 'remainder_NetIncome': 0, 'remainder_Revenues': 4854000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000804269', 'Assets': 0, 'CashAndCurrentAssets': 0, 'ComprehensiveNetIncome': -25000000, 'CostOfGoodsSold': 0, 'Debt': 54346000000, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 1616000000, 'Expenses': 5924000000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 57852000000, 'LiabilitiesAndStockholdersEquity': 65904000000, 'LoansIncome': 0, 'LoansPayable': 1218000000, 'NetIncome': 646000000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 1293000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 6454000000, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -671000000, 'remainder_Expenses': 3015000000, 'remainder_Liabilities': 2288000000, 'remainder_LiabilitiesAndStockholdersEquity': 8052000000, 'remainder_NetIncome': 116000000, 'remainder_Revenues': 6454000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000804269', 'Assets': 0, 'CashAndCurrentAssets': 0, 'ComprehensiveNetIncome': 620000000, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 2108000000, 'Expenses': 8955000000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 79072000000, 'LiabilitiesAndStockholdersEquity': 87765000000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 754000000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 1490000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 9558000000, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -134000000, 'remainder_Expenses': 5357000000, 'remainder_Liabilities': 79072000000, 'remainder_LiabilitiesAndStockholdersEquity': 8693000000, 'remainder_NetIncome': 151000000, 'remainder_Revenues': 9558000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000804269', 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 2566000000, 'Expenses': 11239000000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 86721000000, 'LiabilitiesAndStockholdersEquity': 97015000000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 661000000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 1390000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 12151000000, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 470000000, 'remainder_Expenses': 7283000000, 'remainder_Liabilities': 86721000000, 'remainder_LiabilitiesAndStockholdersEquity': 10294000000, 'remainder_NetIncome': -251000000, 'remainder_Revenues': 12151000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.00010145074566298062, 'aggregate_val': 9856000000, 'exp_sum': 9857000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 3668000000, 'OperatingExpenses': 1662000000, 'DepreciationInterestAndFeesExpenses': 2881000000, 'remainder_Expenses': 1646000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 8.1602010673543e-06, 'aggregate_val': 122545000000, 'exp_sum': 122546000000, 'exp_to_value': {'Investments': 107215000000, 'CashAndCurrentAssets': 4005000000, 'IntangibleAssets': 1171000000, 'remainder_Assets': 10155000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.00010145074566298062, 'aggregate_val': 9856000000, 'exp_sum': 9857000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 3668000000, 'OperatingExpenses': 1662000000, 'DepreciationInterestAndFeesExpenses': 2881000000, 'remainder_Expenses': 1646000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 8.1602010673543e-06, 'aggregate_val': 122545000000, 'exp_sum': 122546000000, 'exp_to_value': {'Investments': 107215000000, 'CashAndCurrentAssets': 4005000000, 'IntangibleAssets': 1171000000, 'remainder_Assets': 10155000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.00041185407552488514, 'aggregate_val': 109217000000, 'exp_sum': 109262000000, 'exp_to_value': {'Investments': 95573000000, 'CashAndCurrentAssets': 3311000000, 'IntangibleAssets': 1185000000, 'remainder_Assets': 9193000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.00010145074566298062, 'aggregate_val': 9856000000, 'exp_sum': 9857000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 3668000000, 'OperatingExpenses': 1662000000, 'DepreciationInterestAndFeesExpenses': 2881000000, 'remainder_Expenses': 1646000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 8.1602010673543e-06, 'aggregate_val': 122545000000, 'exp_sum': 122546000000, 'exp_to_value': {'Investments': 107215000000, 'CashAndCurrentAssets': 4005000000, 'IntangibleAssets': 1171000000, 'remainder_Assets': 10155000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.00010145074566298062, 'aggregate_val': 9856000000, 'exp_sum': 9857000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 3668000000, 'OperatingExpenses': 1662000000, 'DepreciationInterestAndFeesExpenses': 2881000000, 'remainder_Expenses': 1646000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 8.1602010673543e-06, 'aggregate_val': 122545000000, 'exp_sum': 122546000000, 'exp_to_value': {'Investments': 107215000000, 'CashAndCurrentAssets': 4005000000, 'IntangibleAssets': 1171000000, 'remainder_Assets': 10155000000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000804269')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |