warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.41361688948536623, 'aggregate_val': 5680000000, 'exp_sum': 9686500000, 'exp_to_value': {'LaborExpense': 1709300000, 'SellingAndGeneralAdministrativeExpense': 404200000, 'CostOfGoodsSold': 1893000000, 'OperatingExpenses': 5309200000, 'DepreciationInterestAndFeesExpenses': 135700000, 'remainder_Expenses': 235100000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.42997645243798466, 'aggregate_val': 5616100000, 'exp_sum': 9852400000, 'exp_to_value': {'LaborExpense': 1807900000, 'SellingAndGeneralAdministrativeExpense': 480800000, 'CostOfGoodsSold': 1947600000, 'OperatingExpenses': 5225200000, 'DepreciationInterestAndFeesExpenses': 129300000, 'remainder_Expenses': 261600000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.43463652290781674, 'aggregate_val': 2355700000, 'exp_sum': 4166700000, 'exp_to_value': {'LaborExpense': 950800000, 'SellingAndGeneralAdministrativeExpense': 166800000, 'CostOfGoodsSold': 693400000, 'OperatingExpenses': 2143000000, 'DepreciationInterestAndFeesExpenses': 64500000, 'remainder_Expenses': 148200000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.22244237594970992, 'aggregate_val': 10909600000, 'exp_sum': 14030600000, 'exp_to_value': {'Investments': 1968000000, 'CashAndCurrentAssets': 3121000000, 'IntangibleAssets': 6606700000, 'remainder_Assets': 2334900000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.411368843069874, 'aggregate_val': 3288800000, 'exp_sum': 5587200000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1283000000, 'Debt': 745700000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 2298400000, 'remainder_Liabilities': 1260100000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.43463652290781674, 'aggregate_val': 2355700000, 'exp_sum': 4166700000, 'exp_to_value': {'LaborExpense': 950800000, 'SellingAndGeneralAdministrativeExpense': 166800000, 'CostOfGoodsSold': 693400000, 'OperatingExpenses': 2143000000, 'DepreciationInterestAndFeesExpenses': 64500000, 'remainder_Expenses': 148200000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.22244237594970992, 'aggregate_val': 10909600000, 'exp_sum': 14030600000, 'exp_to_value': {'Investments': 1968000000, 'CashAndCurrentAssets': 3121000000, 'IntangibleAssets': 6606700000, 'remainder_Assets': 2334900000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.411368843069874, 'aggregate_val': 3288800000, 'exp_sum': 5587200000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1283000000, 'Debt': 745700000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 2298400000, 'remainder_Liabilities': 1260100000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.41798000640364297, 'aggregate_val': 3272000000, 'exp_sum': 5621800000, 'exp_to_value': {'LaborExpense': 1114900000, 'SellingAndGeneralAdministrativeExpense': 262200000, 'CostOfGoodsSold': 972700000, 'OperatingExpenses': 2897800000, 'DepreciationInterestAndFeesExpenses': 58600000, 'remainder_Expenses': 315600000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.17292646023642116, 'aggregate_val': 20444100000, 'exp_sum': 24718600000, 'exp_to_value': {'Investments': 8501400000, 'CashAndCurrentAssets': 4274500000, 'IntangibleAssets': 8317400000, 'remainder_Assets': 3625300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.2275277570621075, 'aggregate_val': 11083200000, 'exp_sum': 14347700000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1295400000, 'Debt': 7181100000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 3264500000, 'remainder_Liabilities': 2606700000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.41798000640364297, 'aggregate_val': 3272000000, 'exp_sum': 5621800000, 'exp_to_value': {'LaborExpense': 1114900000, 'SellingAndGeneralAdministrativeExpense': 262200000, 'CostOfGoodsSold': 972700000, 'OperatingExpenses': 2897800000, 'DepreciationInterestAndFeesExpenses': 58600000, 'remainder_Expenses': 315600000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.17292646023642116, 'aggregate_val': 20444100000, 'exp_sum': 24718600000, 'exp_to_value': {'Investments': 8501400000, 'CashAndCurrentAssets': 4274500000, 'IntangibleAssets': 8317400000, 'remainder_Assets': 3625300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.2275277570621075, 'aggregate_val': 11083200000, 'exp_sum': 14347700000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1295400000, 'Debt': 7181100000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 3264500000, 'remainder_Liabilities': 2606700000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4309563412735957, 'aggregate_val': 3729000000, 'exp_sum': 6553100000, 'exp_to_value': {'LaborExpense': 1246200000, 'SellingAndGeneralAdministrativeExpense': 295400000, 'CostOfGoodsSold': 1282500000, 'OperatingExpenses': 3194100000, 'DepreciationInterestAndFeesExpenses': 61800000, 'remainder_Expenses': 473100000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.16539767310438244, 'aggregate_val': 19347000000, 'exp_sum': 23181100000, 'exp_to_value': {'Investments': 7872500000, 'CashAndCurrentAssets': 3834100000, 'IntangibleAssets': 8230700000, 'remainder_Assets': 3243800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.22561021860161715, 'aggregate_val': 10209400000, 'exp_sum': 13183800000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1243500000, 'Debt': 6582500000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 2974400000, 'remainder_Liabilities': 2383400000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4309563412735957, 'aggregate_val': 3729000000, 'exp_sum': 6553100000, 'exp_to_value': {'LaborExpense': 1246200000, 'SellingAndGeneralAdministrativeExpense': 295400000, 'CostOfGoodsSold': 1282500000, 'OperatingExpenses': 3194100000, 'DepreciationInterestAndFeesExpenses': 61800000, 'remainder_Expenses': 473100000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.16539767310438244, 'aggregate_val': 19347000000, 'exp_sum': 23181100000, 'exp_to_value': {'Investments': 7872500000, 'CashAndCurrentAssets': 3834100000, 'IntangibleAssets': 8230700000, 'remainder_Assets': 3243800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.22561021860161715, 'aggregate_val': 10209400000, 'exp_sum': 13183800000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1243500000, 'Debt': 6582500000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 2974400000, 'remainder_Liabilities': 2383400000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4343559195830231, 'aggregate_val': 3798300000, 'exp_sum': 6715000000, 'exp_to_value': {'LaborExpense': 1297700000, 'SellingAndGeneralAdministrativeExpense': 307200000, 'CostOfGoodsSold': 1311800000, 'OperatingExpenses': 3305500000, 'DepreciationInterestAndFeesExpenses': 52300000, 'remainder_Expenses': 440500000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.1825981308411215, 'aggregate_val': 17492400000, 'exp_sum': 21400000000, 'exp_to_value': {'Investments': 5704200000, 'CashAndCurrentAssets': 3907600000, 'IntangibleAssets': 8335900000, 'remainder_Assets': 3452300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.2431788031981643, 'aggregate_val': 8443400000, 'exp_sum': 11156400000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1153600000, 'Debt': 5085400000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 2713000000, 'remainder_Liabilities': 2204400000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4343559195830231, 'aggregate_val': 3798300000, 'exp_sum': 6715000000, 'exp_to_value': {'LaborExpense': 1297700000, 'SellingAndGeneralAdministrativeExpense': 307200000, 'CostOfGoodsSold': 1311800000, 'OperatingExpenses': 3305500000, 'DepreciationInterestAndFeesExpenses': 52300000, 'remainder_Expenses': 440500000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.1825981308411215, 'aggregate_val': 17492400000, 'exp_sum': 21400000000, 'exp_to_value': {'Investments': 5704200000, 'CashAndCurrentAssets': 3907600000, 'IntangibleAssets': 8335900000, 'remainder_Assets': 3452300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.2431788031981643, 'aggregate_val': 8443400000, 'exp_sum': 11156400000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 1153600000, 'Debt': 5085400000, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 2713000000, 'remainder_Liabilities': 2204400000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4438943894389439, 'aggregate_val': 4246200000, 'exp_sum': 7635600000, 'exp_to_value': {'LaborExpense': 1537400000, 'SellingAndGeneralAdministrativeExpense': 365500000, 'CostOfGoodsSold': 1486500000, 'OperatingExpenses': 3883200000, 'DepreciationInterestAndFeesExpenses': 94800000, 'remainder_Expenses': 268200000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.43364925911397373, 'aggregate_val': 4475700000, 'exp_sum': 7902700000, 'exp_to_value': {'LaborExpense': 1494400000, 'SellingAndGeneralAdministrativeExpense': 324400000, 'CostOfGoodsSold': 1608200000, 'OperatingExpenses': 4109200000, 'DepreciationInterestAndFeesExpenses': 111500000, 'remainder_Expenses': 255000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.41361688948536623, 'aggregate_val': 5680000000, 'exp_sum': 9686500000, 'exp_to_value': {'LaborExpense': 1709300000, 'SellingAndGeneralAdministrativeExpense': 404200000, 'CostOfGoodsSold': 1893000000, 'OperatingExpenses': 5309200000, 'DepreciationInterestAndFeesExpenses': 135700000, 'remainder_Expenses': 235100000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.42997645243798466, 'aggregate_val': 5616100000, 'exp_sum': 9852400000, 'exp_to_value': {'LaborExpense': 1807900000, 'SellingAndGeneralAdministrativeExpense': 480800000, 'CostOfGoodsSold': 1947600000, 'OperatingExpenses': 5225200000, 'DepreciationInterestAndFeesExpenses': 129300000, 'remainder_Expenses': 261600000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |