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.32447216846479515, 'aggregate_val': 14695500000, 'exp_sum': 21754100000, 'exp_to_value': {'AssetsCurrent': 7636900000, 'AssetsNoncurrent': 7058600000, 'PropertyPlantAndEquipmentNet': 2977400000, 'Goodwill': 1737900000, 'remainder_Assets': 2343300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3278919452443354, 'aggregate_val': 14027500000, 'exp_sum': 20870900000, 'exp_to_value': {'AssetsCurrent': 7184100000, 'AssetsNoncurrent': 6843400000, 'PropertyPlantAndEquipmentNet': 2833400000, 'Goodwill': 1699200000, 'remainder_Assets': 2310800000}} |
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 |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3309996992830274, 'aggregate_val': 12680700000, 'exp_sum': 18954700000, 'exp_to_value': {'AssetsCurrent': 6406700000, 'AssetsNoncurrent': 6274000000, 'PropertyPlantAndEquipmentNet': 2704200000, 'Goodwill': 1614300000, 'remainder_Assets': 1955500000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.32730562421956627, 'aggregate_val': 13198600000, 'exp_sum': 19620500000, 'exp_to_value': {'AssetsCurrent': 6776700000, 'AssetsNoncurrent': 6421900000, 'PropertyPlantAndEquipmentNet': 2736200000, 'Goodwill': 1655800000, 'remainder_Assets': 2029900000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.33035768019418643, 'aggregate_val': 13352400000, 'exp_sum': 19939600000, 'exp_to_value': {'AssetsCurrent': 6765200000, 'AssetsNoncurrent': 6587200000, 'PropertyPlantAndEquipmentNet': 2720100000, 'Goodwill': 1657900000, 'remainder_Assets': 2209200000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3296772339627604, 'aggregate_val': 13763000000, 'exp_sum': 20531900000, 'exp_to_value': {'AssetsCurrent': 6994100000, 'AssetsNoncurrent': 6768900000, 'PropertyPlantAndEquipmentNet': 2854000000, 'Goodwill': 1660600000, 'remainder_Assets': 2254300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.32447216846479515, 'aggregate_val': 14695500000, 'exp_sum': 21754100000, 'exp_to_value': {'AssetsCurrent': 7636900000, 'AssetsNoncurrent': 7058600000, 'PropertyPlantAndEquipmentNet': 2977400000, 'Goodwill': 1737900000, 'remainder_Assets': 2343300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3278919452443354, 'aggregate_val': 14027500000, 'exp_sum': 20870900000, 'exp_to_value': {'AssetsCurrent': 7184100000, 'AssetsNoncurrent': 6843400000, 'PropertyPlantAndEquipmentNet': 2833400000, 'Goodwill': 1699200000, 'remainder_Assets': 2310800000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000842162')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |