warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
No stock price available |
subcommand.plot |
{} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.765971714370304, 'aggregate_val': 1093065000, 'exp_sum': -395183000, 'exp_to_value': {'InvestmentIncome': -395183000, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 0}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.643354762780142, 'aggregate_val': 5327552000, 'exp_sum': 2015451000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 738516000, 'LoansPayable': 33545000, 'OperatingAndEmployeeLiabilities': 45933000, 'remainder_Liabilities': 1197457000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 4.854465398077836, 'aggregate_val': 15789259000, 'exp_sum': 2696960000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 750000000, 'LoansPayable': 38159000, 'OperatingAndEmployeeLiabilities': 41711000, 'remainder_Liabilities': 1867090000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.7953528523289762, 'aggregate_val': 7975873000, 'exp_sum': 4442510000, 'exp_to_value': {'Investments': 1857465000, 'CashAndCurrentAssets': 915419000, 'IntangibleAssets': 130740000, 'remainder_Assets': 1538886000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.2428454427509186, 'aggregate_val': 22477981000, 'exp_sum': 6931561000, 'exp_to_value': {'Investments': 2393883000, 'CashAndCurrentAssets': 1395367000, 'IntangibleAssets': 144170000, 'remainder_Assets': 2998141000}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001411494', 'EntityCommonStockSharesOutstanding': 130024284, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 0, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 14933475000, 'LiabilitiesAndStockholdersEquity': 20636858000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 0, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 2128265000, 'remainder_Expenses': 0, 'remainder_Liabilities': 14933475000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 5703383000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001411494', 'EntityCommonStockSharesOutstanding': 163043604, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 104423000, 'Expenses': 1190808000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 740559000, 'Liabilities': 17235376000, 'LiabilitiesAndStockholdersEquity': 23178837000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 729922000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 1043563000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 1560083000, 'SellingAndGeneralAdministrativeExpense': 97663000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -632099000, 'remainder_Expenses': -795400000, 'remainder_Liabilities': 17235376000, 'remainder_NetIncome': 360647000, 'remainder_Revenues': 1560083000, 'remainder_StockholdersEquity': 5943461000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001411494', 'EntityCommonStockSharesOutstanding': 181050106, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 98184000, 'Expenses': 857708000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 537429000, 'Liabilities': 3170827000, 'LiabilitiesAndStockholdersEquity': 4559808000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 350495000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 830975000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 1041670000, 'SellingAndGeneralAdministrativeExpense': 102255000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -223312000, 'remainder_Expenses': -711135000, 'remainder_Liabilities': 3170827000, 'remainder_NetIncome': 166533000, 'remainder_Revenues': 1041670000, 'remainder_StockholdersEquity': 1388981000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44395721819315137, 'aggregate_val': 1685994000, 'exp_sum': 3032130000, 'exp_to_value': {'LaborExpense': 1035405000, 'SellingAndGeneralAdministrativeExpense': 257858000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1360049000, 'DepreciationInterestAndFeesExpenses': 52873000, 'remainder_Expenses': 325945000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.23463411593153014, 'aggregate_val': 6991070000, 'exp_sum': 5662463000, 'exp_to_value': {'Investments': 1730904000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 107694000, 'remainder_Assets': 3823865000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.3756347139506505, 'aggregate_val': 4093274000, 'exp_sum': 2975553000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 428013000, 'Debt': 1362402000, 'LoansPayable': 68873000, 'OperatingAndEmployeeLiabilities': 62474000, 'remainder_Liabilities': 1053791000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4766789943998683, 'aggregate_val': 988960000, 'exp_sum': 1889777000, 'exp_to_value': {'LaborExpense': 574999000, 'SellingAndGeneralAdministrativeExpense': 266444000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 902939000, 'DepreciationInterestAndFeesExpenses': 59374000, 'remainder_Expenses': 86021000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2612856004314553, 'aggregate_val': 5991654000, 'exp_sum': 4750434000, 'exp_to_value': {'Investments': 2722612000, 'CashAndCurrentAssets': 609747000, 'IntangibleAssets': 107751000, 'remainder_Assets': 1310324000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.41956991989836306, 'aggregate_val': 3539814000, 'exp_sum': 2493582000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 536532000, 'Debt': 1360448000, 'LoansPayable': 70878000, 'OperatingAndEmployeeLiabilities': 73583000, 'remainder_Liabilities': 452141000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4766789943998683, 'aggregate_val': 988960000, 'exp_sum': 1889777000, 'exp_to_value': {'LaborExpense': 574999000, 'SellingAndGeneralAdministrativeExpense': 266444000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 902939000, 'DepreciationInterestAndFeesExpenses': 59374000, 'remainder_Expenses': 86021000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2612856004314553, 'aggregate_val': 5991654000, 'exp_sum': 4750434000, 'exp_to_value': {'Investments': 2722612000, 'CashAndCurrentAssets': 609747000, 'IntangibleAssets': 107751000, 'remainder_Assets': 1310324000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.41956991989836306, 'aggregate_val': 3539814000, 'exp_sum': 2493582000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 536532000, 'Debt': 1360448000, 'LoansPayable': 70878000, 'OperatingAndEmployeeLiabilities': 73583000, 'remainder_Liabilities': 452141000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.48747670244904756, 'aggregate_val': 1594379000, 'exp_sum': 3110842000, 'exp_to_value': {'LaborExpense': 1340778000, 'SellingAndGeneralAdministrativeExpense': 75558000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1582450000, 'DepreciationInterestAndFeesExpenses': 100127000, 'remainder_Expenses': 11929000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4683244136293492, 'aggregate_val': 2049284000, 'exp_sum': 3854388000, 'exp_to_value': {'LaborExpense': 1594235000, 'SellingAndGeneralAdministrativeExpense': 98202000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1941715000, 'DepreciationInterestAndFeesExpenses': 112667000, 'remainder_Expenses': 107569000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4418400592841745, 'aggregate_val': 1190808000, 'exp_sum': 2133453000, 'exp_to_value': {'LaborExpense': 740559000, 'SellingAndGeneralAdministrativeExpense': 97663000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1043563000, 'DepreciationInterestAndFeesExpenses': 104423000, 'remainder_Expenses': 147245000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.46244616364247143, 'aggregate_val': 857708000, 'exp_sum': 1595576000, 'exp_to_value': {'LaborExpense': 537429000, 'SellingAndGeneralAdministrativeExpense': 102255000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 830975000, 'DepreciationInterestAndFeesExpenses': 98184000, 'remainder_Expenses': 26733000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4755964835700461, 'aggregate_val': 1256625000, 'exp_sum': 2396294000, 'exp_to_value': {'LaborExpense': 849187000, 'SellingAndGeneralAdministrativeExpense': 247000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1165918000, 'DepreciationInterestAndFeesExpenses': 43482000, 'remainder_Expenses': 90707000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2184106291934888, 'aggregate_val': 5629553000, 'exp_sum': 4620407000, 'exp_to_value': {'Investments': 1494744000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 111573000, 'remainder_Assets': 3014090000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.29392772901027225, 'aggregate_val': 3762025000, 'exp_sum': 2907446000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 638126000, 'Debt': 1352447000, 'LoansPayable': 57465000, 'OperatingAndEmployeeLiabilities': 52754000, 'remainder_Liabilities': 806654000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4755964835700461, 'aggregate_val': 1256625000, 'exp_sum': 2396294000, 'exp_to_value': {'LaborExpense': 849187000, 'SellingAndGeneralAdministrativeExpense': 247000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1165918000, 'DepreciationInterestAndFeesExpenses': 43482000, 'remainder_Expenses': 90707000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2184106291934888, 'aggregate_val': 5629553000, 'exp_sum': 4620407000, 'exp_to_value': {'Investments': 1494744000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 111573000, 'remainder_Assets': 3014090000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.29392772901027225, 'aggregate_val': 3762025000, 'exp_sum': 2907446000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 638126000, 'Debt': 1352447000, 'LoansPayable': 57465000, 'OperatingAndEmployeeLiabilities': 52754000, 'remainder_Liabilities': 806654000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44395721819315137, 'aggregate_val': 1685994000, 'exp_sum': 3032130000, 'exp_to_value': {'LaborExpense': 1035405000, 'SellingAndGeneralAdministrativeExpense': 257858000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1360049000, 'DepreciationInterestAndFeesExpenses': 52873000, 'remainder_Expenses': 325945000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.23463411593153014, 'aggregate_val': 6991070000, 'exp_sum': 5662463000, 'exp_to_value': {'Investments': 1730904000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 107694000, 'remainder_Assets': 3823865000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.3756347139506505, 'aggregate_val': 4093274000, 'exp_sum': 2975553000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 428013000, 'Debt': 1362402000, 'LoansPayable': 68873000, 'OperatingAndEmployeeLiabilities': 62474000, 'remainder_Liabilities': 1053791000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44395721819315137, 'aggregate_val': 1685994000, 'exp_sum': 3032130000, 'exp_to_value': {'LaborExpense': 1035405000, 'SellingAndGeneralAdministrativeExpense': 257858000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1360049000, 'DepreciationInterestAndFeesExpenses': 52873000, 'remainder_Expenses': 325945000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.23463411593153014, 'aggregate_val': 6991070000, 'exp_sum': 5662463000, 'exp_to_value': {'Investments': 1730904000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 107694000, 'remainder_Assets': 3823865000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.3756347139506505, 'aggregate_val': 4093274000, 'exp_sum': 2975553000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 428013000, 'Debt': 1362402000, 'LoansPayable': 68873000, 'OperatingAndEmployeeLiabilities': 62474000, 'remainder_Liabilities': 1053791000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4766789943998683, 'aggregate_val': 988960000, 'exp_sum': 1889777000, 'exp_to_value': {'LaborExpense': 574999000, 'SellingAndGeneralAdministrativeExpense': 266444000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 902939000, 'DepreciationInterestAndFeesExpenses': 59374000, 'remainder_Expenses': 86021000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2612856004314553, 'aggregate_val': 5991654000, 'exp_sum': 4750434000, 'exp_to_value': {'Investments': 2722612000, 'CashAndCurrentAssets': 609747000, 'IntangibleAssets': 107751000, 'remainder_Assets': 1310324000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.41956991989836306, 'aggregate_val': 3539814000, 'exp_sum': 2493582000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 536532000, 'Debt': 1360448000, 'LoansPayable': 70878000, 'OperatingAndEmployeeLiabilities': 73583000, 'remainder_Liabilities': 452141000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4766789943998683, 'aggregate_val': 988960000, 'exp_sum': 1889777000, 'exp_to_value': {'LaborExpense': 574999000, 'SellingAndGeneralAdministrativeExpense': 266444000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 902939000, 'DepreciationInterestAndFeesExpenses': 59374000, 'remainder_Expenses': 86021000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2612856004314553, 'aggregate_val': 5991654000, 'exp_sum': 4750434000, 'exp_to_value': {'Investments': 2722612000, 'CashAndCurrentAssets': 609747000, 'IntangibleAssets': 107751000, 'remainder_Assets': 1310324000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.41956991989836306, 'aggregate_val': 3539814000, 'exp_sum': 2493582000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 536532000, 'Debt': 1360448000, 'LoansPayable': 70878000, 'OperatingAndEmployeeLiabilities': 73583000, 'remainder_Liabilities': 452141000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001411494')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |