QA: MGM Resorts International in us_hotels/2018

Table of Contents

See also this year's filing and all EDGAR filings for this company.

PDF Report 0000789570_2019_MGM_Resorts_International.pdf

Logs

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': 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.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.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.18711388475519247, 'aggregate_val': 30210706000, 'exp_sum': 37164746000, 'exp_to_value': {'PropertyPlantAndEquipment': 20729888000, 'AssetsNonCurrent': 6954040000, 'AssetsCurrent': 2526778000, 'IntangibleAssets': 5765855000, 'remainder_Assets': 1188185000}}
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 {}

Graph

Absolute values for 0000789570, MGM Resorts International

  xvar xval
0 PropertyPlantAndEquipment 20,729,888,000
1 AssetsNonCurrent 6,954,040,000
2 AssetsCurrent 2,526,778,000
3 IntangibleAssets 5,765,855,000
4 remainder_Assets -5,765,855,000
5 LongTermLiabilities 0
6 LiabilitiesCurrent 2,948,882,000
7 remainder_Liabilities 0
8 GeneralAndAdministrativeExpense 0
9 DepreciationDepletionAndAmortization 0
10 CostOfGoodsAndServicesSold 0
11 OperatingExpenses 0
12 remainder_Expenses 10,491,412,000
13 remainder_Revenues 11,763,096,000
14 remainder_NetIncome -687,790,000
15 remainder_ComprehensiveNetIncome -122,068,000
  yvar yval
0 Assets 30,210,706,000
1 Liabilities 2,948,882,000
2 Expenses 10,491,412,000
3 Revenues 11,763,096,000
4 StockholdersEquity 27,261,824,000
5 NetIncome 583,894,000
6 ComprehensiveNetIncome 461,826,000
7 BaseVar 89,001,903,240
8 EconomicCapitalRatio 1.38

Edgar->Model Mapping

Feature Distribution

Change over Time