QA: MGM Resorts International in us_hotels/2017

Table of Contents

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

PDF Report 0000789570_2018_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 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.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.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.19689982475066975, 'aggregate_val': 29159178000, 'exp_sum': 36308270000, 'exp_to_value': {'PropertyPlantAndEquipment': 19635459000, 'AssetsNonCurrent': 7149092000, 'AssetsCurrent': 2374627000, 'IntangibleAssets': 5684491000, 'remainder_Assets': 1464601000}}
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 19,635,459,000
1 AssetsNonCurrent 7,149,092,000
2 AssetsCurrent 2,374,627,000
3 IntangibleAssets 5,684,491,000
4 remainder_Assets -5,684,491,000
5 LongTermLiabilities 0
6 LiabilitiesCurrent 3,092,382,000
7 remainder_Liabilities 0
8 GeneralAndAdministrativeExpense 1,559,915,000
9 DepreciationDepletionAndAmortization 993,480,000
10 CostOfGoodsAndServicesSold 356,875,000
11 OperatingExpenses 0
12 remainder_Expenses 5,161,468,000
13 remainder_Revenues 10,773,904,000
14 remainder_NetIncome -605,748,000
15 remainder_ComprehensiveNetIncome -154,893,000
  yvar yval
0 Assets 29,159,178,000
1 Liabilities 3,092,382,000
2 Expenses 8,071,738,000
3 Revenues 10,773,904,000
4 StockholdersEquity 26,066,796,000
5 NetIncome 2,096,418,000
6 ComprehensiveNetIncome 1,941,525,000
7 BaseVar 77,689,508,620
8 EconomicCapitalRatio 1.94

Edgar->Model Mapping

Feature Distribution

Change over Time