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': 2357.2705167173253, 'aggregate_val': 6982839000, 'exp_sum': 2961000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 2961000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1573.1351669017395, 'aggregate_val': 6696371000, 'exp_sum': 4254000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 4254000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.5684970952723212, 'aggregate_val': 2805274000, 'exp_sum': 1092185000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 136165000, 'Debt': 615179000, 'LoansPayable': 95390000, 'OperatingAndEmployeeLiabilities': 118921000, 'remainder_Liabilities': 126530000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.572124826409254, 'aggregate_val': 4720045000, 'exp_sum': 1321355000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 242986000, 'Debt': 579464000, 'LoansPayable': 79999000, 'OperatingAndEmployeeLiabilities': 278655000, 'remainder_Liabilities': 140251000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 604.5068707406994, 'aggregate_val': 5419892000, 'exp_sum': 8951000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 8951000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 283.14856851663114, 'aggregate_val': 6133631000, 'exp_sum': 21586000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 21586000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 2357.2705167173253, 'aggregate_val': 6982839000, 'exp_sum': 2961000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 2961000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1573.1351669017395, 'aggregate_val': 6696371000, 'exp_sum': 4254000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 4254000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 8.13401522076412, 'aggregate_val': 10432178000, 'exp_sum': 1142124000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 906522000, 'IntangibleAssets': 0, 'remainder_Assets': 235602000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 121.98574311049754, 'aggregate_val': 9264762000, 'exp_sum': 75332000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 65346000, 'IntangibleAssets': 0, 'remainder_Assets': 9986000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 4.541576439546683, 'aggregate_val': 7649110000, 'exp_sum': 1380313000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 959200000, 'IntangibleAssets': 0, 'remainder_Assets': 421113000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 6.720288847248723, 'aggregate_val': 9014796000, 'exp_sum': 1167676000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 959465000, 'IntangibleAssets': 0, 'remainder_Assets': 208211000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 8.13401522076412, 'aggregate_val': 10432178000, 'exp_sum': 1142124000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 906522000, 'IntangibleAssets': 0, 'remainder_Assets': 235602000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 121.98574311049754, 'aggregate_val': 9264762000, 'exp_sum': 75332000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 65346000, 'IntangibleAssets': 0, 'remainder_Assets': 9986000}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001403528', 'EntityCommonStockSharesOutstanding': 43479670, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 8003000, 'Expenses': 966013000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 651101000, 'Liabilities': 9822777000, 'LiabilitiesAndStockholdersEquity': 53344062000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 2175552000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 193894000, 'SellingAndGeneralAdministrativeExpense': 0, 'TemporaryEquity': 41681155000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -2049217000, 'remainder_Expenses': 306909000, 'remainder_Liabilities': 9822777000, 'remainder_NetIncome': 2947671000, 'remainder_Revenues': 193894000, 'remainder_StockholdersEquity': 1840130000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001403528', 'EntityCommonStockSharesOutstanding': 48671659, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 14022000, 'Expenses': 958457000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 632119000, 'Liabilities': 11829879000, 'LiabilitiesAndStockholdersEquity': 51811098000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -1532962000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RedeemableEquity': 38173125000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 201905000, 'SellingAndGeneralAdministrativeExpense': 110677000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 1604165000, 'remainder_Expenses': 201639000, 'remainder_Liabilities': 11829879000, 'remainder_NetIncome': -776410000, 'remainder_Revenues': 201905000, 'remainder_StockholdersEquity': 1808094000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.10695091781425252, 'aggregate_val': 43869998000, 'exp_sum': 39631385000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 458191000, 'IntangibleAssets': 0, 'remainder_Assets': 39173194000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.08584751574701562, 'aggregate_val': 45263254000, 'exp_sum': 41684724000, 'exp_to_value': {'Investments': 169927000, 'CashAndCurrentAssets': 390721000, 'IntangibleAssets': 0, 'remainder_Assets': 41124076000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001403528')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |