warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.5671552503187451, 'aggregate_val': 5655882000, 'exp_sum': 2203171000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 2122333000, 'DepreciationDepletionAndAmortization': 1210556000, 'CostOfGoodsAndServicesSold': 460148000, 'OperatingExpenses': 0, 'remainder_Expenses': -1589866000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.607252278879646, 'aggregate_val': 9711323000, 'exp_sum': 2107834000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 2101217000, 'DepreciationDepletionAndAmortization': 1304649000, 'CostOfGoodsAndServicesSold': 464642000, 'OperatingExpenses': 0, 'remainder_Expenses': -1762674000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.5671552503187451, 'aggregate_val': 5655882000, 'exp_sum': 2203171000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 2122333000, 'DepreciationDepletionAndAmortization': 1210556000, 'CostOfGoodsAndServicesSold': 460148000, 'OperatingExpenses': 0, 'remainder_Expenses': -1589866000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 3.607252278879646, 'aggregate_val': 9711323000, 'exp_sum': 2107834000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 2101217000, 'DepreciationDepletionAndAmortization': 1304649000, 'CostOfGoodsAndServicesSold': 464642000, 'OperatingExpenses': 0, 'remainder_Expenses': -1762674000}} |
warning |
Ignoring company because Liabilities is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000789570', 'EntityCommonStockSharesOutstanding': 573366718, 'Assets': 28173301000, 'AssetsCurrent': 2229587000, 'AssetsNonCurrent': 7518691000, 'CostOfGoodsAndServicesSold': 312774000, 'DepreciationDepletionAndAmortization': 849527000, 'Expenses': 7925251000, 'GeneralAndAdministrativeExpense': 1378617000, 'IntangibleAssets': 5904825000, 'Liabilities': 0, 'LiabilitiesAndStockholdersEquity': 28173301000, 'LiabilitiesCurrent': 0, 'LongTermLiabilities': 0, 'NetIncome': 1236878000, 'OperatingExpenses': 0, 'PropertyPlantAndEquipment': 18425023000, 'RedeemableEquity': 54139000, 'Revenues': 9455123000, 'remainder_Assets': -5904825000, 'remainder_ComprehensiveNetIncome': -135481000, 'remainder_Expenses': 5384333000, 'remainder_Liabilities': 0, 'remainder_LiabilitiesAndStockholdersEquity': 18149850000, 'remainder_NetIncome': -292994000, 'remainder_Revenues': 9455123000, 'remainder_StockholdersEquity': 9969312000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3036263890718051, 'aggregate_val': 36494934000, 'exp_sum': 52407118000, 'exp_to_value': {'PropertyPlantAndEquipment': 14632091000, 'AssetsNonCurrent': 15912184000, 'AssetsCurrent': 5950659000, 'IntangibleAssets': 5735026000, 'remainder_Assets': 10177158000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.1346767618523012, 'aggregate_val': 18961045000, 'exp_sum': 21912095000, 'exp_to_value': {'PropertyPlantAndEquipment': 14554350000, 'AssetsNonCurrent': 2951050000, 'AssetsCurrent': 1455645000, 'IntangibleAssets': 429157000, 'remainder_Assets': 2521893000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.26647457012075176, 'aggregate_val': 27766276000, 'exp_sum': 37853188000, 'exp_to_value': {'PropertyPlantAndEquipment': 14866644000, 'AssetsNonCurrent': 10086912000, 'AssetsCurrent': 2812720000, 'IntangibleAssets': 7944726000, 'remainder_Assets': 2142186000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.26717591176381045, 'aggregate_val': 26284738000, 'exp_sum': 35867732000, 'exp_to_value': {'PropertyPlantAndEquipment': 14194652000, 'AssetsNonCurrent': 9582994000, 'AssetsCurrent': 2507092000, 'IntangibleAssets': 7640680000, 'remainder_Assets': 1942314000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2569492090453335, 'aggregate_val': 26702511000, 'exp_sum': 35936320000, 'exp_to_value': {'PropertyPlantAndEquipment': 14441542000, 'AssetsNonCurrent': 9233809000, 'AssetsCurrent': 3027160000, 'IntangibleAssets': 7261966000, 'remainder_Assets': 1971843000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2277083249361436, 'aggregate_val': 25215178000, 'exp_sum': 32649812000, 'exp_to_value': {'PropertyPlantAndEquipment': 15371795000, 'AssetsNonCurrent': 7434634000, 'AssetsCurrent': 2408749000, 'IntangibleAssets': 5595548000, 'remainder_Assets': 1839086000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.21065484380922198, 'aggregate_val': 28173301000, 'exp_sum': 35691992000, 'exp_to_value': {'PropertyPlantAndEquipment': 18425023000, 'AssetsNonCurrent': 7518691000, 'AssetsCurrent': 2229587000, 'IntangibleAssets': 5904825000, 'remainder_Assets': 1613866000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.19689982475066975, 'aggregate_val': 29159178000, 'exp_sum': 36308270000, 'exp_to_value': {'PropertyPlantAndEquipment': 19635459000, 'AssetsNonCurrent': 7149092000, 'AssetsCurrent': 2374627000, 'IntangibleAssets': 5684491000, 'remainder_Assets': 1464601000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.18711388475519247, 'aggregate_val': 30210706000, 'exp_sum': 37164746000, 'exp_to_value': {'PropertyPlantAndEquipment': 20729888000, 'AssetsNonCurrent': 6954040000, 'AssetsCurrent': 2526778000, 'IntangibleAssets': 5765855000, 'remainder_Assets': 1188185000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.25479424741345313, 'aggregate_val': 33876356000, 'exp_sum': 45459064000, 'exp_to_value': {'PropertyPlantAndEquipment': 18285955000, 'AssetsNonCurrent': 11582708000, 'AssetsCurrent': 4007693000, 'IntangibleAssets': 5911068000, 'remainder_Assets': 5671640000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3036263890718051, 'aggregate_val': 36494934000, 'exp_sum': 52407118000, 'exp_to_value': {'PropertyPlantAndEquipment': 14632091000, 'AssetsNonCurrent': 15912184000, 'AssetsCurrent': 5950659000, 'IntangibleAssets': 5735026000, 'remainder_Assets': 10177158000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.25479424741345313, 'aggregate_val': 33876356000, 'exp_sum': 45459064000, 'exp_to_value': {'PropertyPlantAndEquipment': 18285955000, 'AssetsNonCurrent': 11582708000, 'AssetsCurrent': 4007693000, 'IntangibleAssets': 5911068000, 'remainder_Assets': 5671640000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000789570')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |