warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.2962728734640043, 'aggregate_val': 3016280000, 'exp_sum': 702069000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 255025000, 'LoansPayable': 33200000, 'OperatingAndEmployeeLiabilities': 181805000, 'remainder_Liabilities': 232039000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.905661140023531, 'aggregate_val': 2705471000, 'exp_sum': 692705000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 253412000, 'LoansPayable': 38756000, 'OperatingAndEmployeeLiabilities': 200837000, 'remainder_Liabilities': 199700000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 4.169071020045533, 'aggregate_val': 465449000, 'exp_sum': 90045000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 25176000, 'OperatingAndEmployeeLiabilities': 47885000, 'remainder_Liabilities': 16984000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 11.179122000393392, 'aggregate_val': 1981397000, 'exp_sum': 162688000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 29607000, 'OperatingAndEmployeeLiabilities': 86658000, 'remainder_Liabilities': 46423000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 13.554687762099345, 'aggregate_val': 2169187000, 'exp_sum': 149037000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 27926000, 'OperatingAndEmployeeLiabilities': 93339000, 'remainder_Liabilities': 27772000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 13.097836387968318, 'aggregate_val': 2454532000, 'exp_sum': 174107000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 23308000, 'OperatingAndEmployeeLiabilities': 101377000, 'remainder_Liabilities': 49422000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 12.629199394831195, 'aggregate_val': 2630490000, 'exp_sum': 193004000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 25357000, 'OperatingAndEmployeeLiabilities': 122514000, 'remainder_Liabilities': 45133000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.9986119820949746, 'aggregate_val': 2958589000, 'exp_sum': 739904000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 266346000, 'LoansPayable': 48496000, 'OperatingAndEmployeeLiabilities': 187449000, 'remainder_Liabilities': 237613000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.2962728734640043, 'aggregate_val': 3016280000, 'exp_sum': 702069000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 255025000, 'LoansPayable': 33200000, 'OperatingAndEmployeeLiabilities': 181805000, 'remainder_Liabilities': 232039000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.905661140023531, 'aggregate_val': 2705471000, 'exp_sum': 692705000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 253412000, 'LoansPayable': 38756000, 'OperatingAndEmployeeLiabilities': 200837000, 'remainder_Liabilities': 199700000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.6278863516005334, 'aggregate_val': 58321000, 'exp_sum': 156729000, 'exp_to_value': {'LaborExpense': 92543000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 190749000, 'DepreciationInterestAndFeesExpenses': 5865000, 'remainder_Expenses': -132428000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.237149260978666, 'aggregate_val': 3952934000, 'exp_sum': 932923000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 99274000, 'IntangibleAssets': 791355000, 'remainder_Assets': 42294000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.717540496375563, 'aggregate_val': 3678629000, 'exp_sum': 989533000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 109076000, 'IntangibleAssets': 829217000, 'remainder_Assets': 51240000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.7635726155475613, 'aggregate_val': 824388000, 'exp_sum': 219044000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 118566000, 'IntangibleAssets': 45215000, 'remainder_Assets': 55263000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.1809201196835777, 'aggregate_val': 2590799000, 'exp_sum': 814481000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 299113000, 'IntangibleAssets': 472107000, 'remainder_Assets': 43261000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.0434001272264632, 'aggregate_val': 2870535000, 'exp_sum': 943200000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 271752000, 'IntangibleAssets': 629178000, 'remainder_Assets': 42270000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.5204579373072766, 'aggregate_val': 3204634000, 'exp_sum': 708918000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 74132000, 'IntangibleAssets': 600757000, 'remainder_Assets': 34029000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 4.104789039320921, 'aggregate_val': 3466943000, 'exp_sum': 679155000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 84499000, 'IntangibleAssets': 570630000, 'remainder_Assets': 24026000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.9555568291044807, 'aggregate_val': 3934181000, 'exp_sum': 994596000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 123873000, 'IntangibleAssets': 838977000, 'remainder_Assets': 31746000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.237149260978666, 'aggregate_val': 3952934000, 'exp_sum': 932923000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 99274000, 'IntangibleAssets': 791355000, 'remainder_Assets': 42294000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.717540496375563, 'aggregate_val': 3678629000, 'exp_sum': 989533000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 109076000, 'IntangibleAssets': 829217000, 'remainder_Assets': 51240000}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000883237', 'EntityCommonStockSharesOutstanding': 8667666, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 338571000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 276408000, 'LiabilitiesAndStockholdersEquity': 859729000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 30671000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 301599000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 381977000, 'SellingAndGeneralAdministrativeExpense': 0, 'TemporaryEquity': 73864000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 3643000, 'remainder_Expenses': 36972000, 'remainder_Liabilities': 276408000, 'remainder_NetIncome': -12735000, 'remainder_Revenues': 381977000, 'remainder_StockholdersEquity': 509457000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.33224125186363807, 'aggregate_val': 746179000, 'exp_sum': 1117438000, 'exp_to_value': {'LaborExpense': 371259000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 688919000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 57260000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.35391486987742365, 'aggregate_val': 738872000, 'exp_sum': 1143614000, 'exp_to_value': {'LaborExpense': 404742000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 693784000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 45088000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3032916068826048, 'aggregate_val': 246671000, 'exp_sum': 354052000, 'exp_to_value': {'LaborExpense': 105571000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 219641000, 'DepreciationInterestAndFeesExpenses': 1810000, 'remainder_Expenses': 27030000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.29135646324987785, 'aggregate_val': 320489000, 'exp_sum': 452257000, 'exp_to_value': {'LaborExpense': 131768000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 275711000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 44778000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.2801581449033737, 'aggregate_val': 359227000, 'exp_sum': 499036000, 'exp_to_value': {'LaborExpense': 139809000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 319878000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 39349000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3166038396452121, 'aggregate_val': 292784000, 'exp_sum': 428425000, 'exp_to_value': {'LaborExpense': 135641000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 271740000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 21044000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3192794800619228, 'aggregate_val': 408062000, 'exp_sum': 599456000, 'exp_to_value': {'LaborExpense': 191394000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 367572000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 40490000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3356342123113209, 'aggregate_val': 472097000, 'exp_sum': 710598000, 'exp_to_value': {'LaborExpense': 238501000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 439136000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 32961000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3367537809737425, 'aggregate_val': 473713000, 'exp_sum': 714234000, 'exp_to_value': {'LaborExpense': 240521000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 438536000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 35177000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.34625747766093323, 'aggregate_val': 504667000, 'exp_sum': 771966000, 'exp_to_value': {'LaborExpense': 267299000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 460732000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 43935000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.32483353901983203, 'aggregate_val': 744581000, 'exp_sum': 1102811000, 'exp_to_value': {'LaborExpense': 358230000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 653746000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 90835000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.33224125186363807, 'aggregate_val': 746179000, 'exp_sum': 1117438000, 'exp_to_value': {'LaborExpense': 371259000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 688919000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 57260000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.35391486987742365, 'aggregate_val': 738872000, 'exp_sum': 1143614000, 'exp_to_value': {'LaborExpense': 404742000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 693784000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 45088000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000883237')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |