warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000842162', 'EntityCommonStockSharesOutstanding': 75302327, 'Assets': 9405800000, 'AssetsCurrent': 5286600000, 'AssetsNoncurrent': 4119200000, 'ComprehensiveNetIncome': 517400000, 'CostOfGoodsAndServicesSold': 0, 'Expenses': 0, 'Goodwill': 0, 'Liabilities': 6388100000, 'LiabilitiesAndStockholdersEquity': 9405800000, 'LiabilitiesCurrent': 3839600000, 'LiabilitiesNoncurrent': 2548500000, 'NetIncome': 795800000, 'PropertyPlantAndEquipmentNet': 0, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingGeneralAndAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -278400000, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 3017700000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000842162', 'EntityCommonStockSharesOutstanding': 70205735, 'Assets': 9900600000, 'AssetsCurrent': 5649300000, 'AssetsNoncurrent': 4251300000, 'ComprehensiveNetIncome': 869600000, 'CostOfGoodsAndServicesSold': 0, 'Expenses': 0, 'Goodwill': 0, 'Liabilities': 6707700000, 'LiabilitiesAndStockholdersEquity': 9900600000, 'LiabilitiesCurrent': 4182300000, 'LiabilitiesNoncurrent': 2525400000, 'NetIncome': 1040500000, 'PropertyPlantAndEquipmentNet': 0, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingGeneralAndAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -170900000, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 3192900000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000842162', 'EntityCommonStockSharesOutstanding': 79255325, 'Assets': 0, 'AssetsCurrent': 0, 'AssetsNoncurrent': 0, 'ComprehensiveNetIncome': 336500000, 'CostOfGoodsAndServicesSold': 0, 'Expenses': 0, 'Goodwill': 0, 'Liabilities': 6120900000, 'LiabilitiesAndStockholdersEquity': 9150200000, 'LiabilitiesCurrent': 3957800000, 'LiabilitiesNoncurrent': 2163100000, 'NetIncome': 702300000, 'PropertyPlantAndEquipmentNet': 0, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingGeneralAndAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -365800000, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 3029300000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3086383313656041, 'aggregate_val': 11945900000, 'exp_sum': 17278800000, 'exp_to_value': {'AssetsCurrent': 6613000000, 'AssetsNoncurrent': 5332900000, 'PropertyPlantAndEquipmentNet': 2459400000, 'Goodwill': 1401300000, 'remainder_Assets': 1472200000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.31441589986348245, 'aggregate_val': 11600700000, 'exp_sum': 16920900000, 'exp_to_value': {'AssetsCurrent': 6280500000, 'AssetsNoncurrent': 5320200000, 'PropertyPlantAndEquipmentNet': 2598100000, 'Goodwill': 1405300000, 'remainder_Assets': 1316800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.28837920223714036, 'aggregate_val': 8194100000, 'exp_sum': 11514700000, 'exp_to_value': {'AssetsCurrent': 4873500000, 'AssetsNoncurrent': 3320600000, 'PropertyPlantAndEquipmentNet': 1403100000, 'Goodwill': 746500000, 'remainder_Assets': 1171000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2903409913708654, 'aggregate_val': 8330900000, 'exp_sum': 11739300000, 'exp_to_value': {'AssetsCurrent': 4922500000, 'AssetsNoncurrent': 3408400000, 'PropertyPlantAndEquipmentNet': 1587200000, 'Goodwill': 757200000, 'remainder_Assets': 1064000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3086383313656041, 'aggregate_val': 11945900000, 'exp_sum': 17278800000, 'exp_to_value': {'AssetsCurrent': 6613000000, 'AssetsNoncurrent': 5332900000, 'PropertyPlantAndEquipmentNet': 2459400000, 'Goodwill': 1401300000, 'remainder_Assets': 1472200000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.31441589986348245, 'aggregate_val': 11600700000, 'exp_sum': 16920900000, 'exp_to_value': {'AssetsCurrent': 6280500000, 'AssetsNoncurrent': 5320200000, 'PropertyPlantAndEquipmentNet': 2598100000, 'Goodwill': 1405300000, 'remainder_Assets': 1316800000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000842162')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |