QA: MGM Resorts International in us_hotels/2020

Table of Contents

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

PDF Report 0000789570_2021_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': 1.8569505402222903, 'aggregate_val': 7739679000, 'exp_sum': 2709070000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 2507239000, 'DepreciationDepletionAndAmortization': 1150610000, 'CostOfGoodsAndServicesSold': 422777000, 'OperatingExpenses': 0, 'remainder_Expenses': -1371556000}}
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': 1.8569505402222903, 'aggregate_val': 7739679000, 'exp_sum': 2709070000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 2507239000, 'DepreciationDepletionAndAmortization': 1150610000, 'CostOfGoodsAndServicesSold': 422777000, 'OperatingExpenses': 0, 'remainder_Expenses': -1371556000}}
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 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.3289347583654315, 'aggregate_val': 40899116000, 'exp_sum': 60946557000, 'exp_to_value': {'PropertyPlantAndEquipment': 14435493000, 'AssetsNonCurrent': 20047441000, 'AssetsCurrent': 6416182000, 'IntangibleAssets': 7097382000, 'remainder_Assets': 12950059000}}
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.3289347583654315, 'aggregate_val': 40899116000, 'exp_sum': 60946557000, 'exp_to_value': {'PropertyPlantAndEquipment': 14435493000, 'AssetsNonCurrent': 20047441000, 'AssetsCurrent': 6416182000, 'IntangibleAssets': 7097382000, 'remainder_Assets': 12950059000}}
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 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 14,632,091,000
1 AssetsNonCurrent 15,912,184,000
2 AssetsCurrent 5,950,659,000
3 IntangibleAssets 5,735,026,000
4 remainder_Assets -5,735,026,000
5 LongTermLiabilities 0
6 LiabilitiesCurrent 1,856,583,000
7 remainder_Liabilities 0
8 GeneralAndAdministrativeExpense 2,122,333,000
9 DepreciationDepletionAndAmortization 1,210,556,000
10 CostOfGoodsAndServicesSold 460,148,000
11 OperatingExpenses 0
12 remainder_Expenses 1,862,845,000
13 remainder_Revenues 5,162,082,000
14 remainder_NetIncome -826,107,000
15 remainder_ComprehensiveNetIncome 258,366,000
  yvar yval
0 Assets 36,494,934,000
1 Liabilities 1,856,583,000
2 Expenses 5,655,882,000
3 Revenues 5,162,082,000
4 StockholdersEquity 34,638,351,000
5 NetIncome -1,319,907,000
6 ComprehensiveNetIncome -1,061,541,000
7 BaseVar 56,549,410,680
8 EconomicCapitalRatio 0.971

Edgar->Model Mapping

Feature Distribution

Change over Time