hosp

profilewzy19961214
HOSP4060AssignmentFinancialStatementAnalysisMGM.xlsx
Home>English homework help>hosp

Sheet1

Section 1: 2019 Financial Statements Section 2: 2019 Financial Analysis
MGM Resorts MGM Resorts Use Excel formulas to compute the following 2019 ratios from Section 1: Financial Statements
Consolidated Balance Sheets Consolidated Statements of Income 2020 2019 Competitors 2020
Current Ratio 1.17
December 31, 2020 December 31, 2020 Inventory Turnover 20.4
2020 2019 2020 2019 Profit Margin -23.6%
Assets Revenues 5,162,082 12,899,672 Return on Assets -4.30%
Currrent Assets Operating Costs and Expenses Return on Stockholders Equity -896.0%
Cash 5,101,637 2,329,604 Cost of Goods Sold 1,548,625 3,869,902 Debt to Total Asset Ratio 73.20%
Accounts Receivable 316,502 612,717 Labor
Inventories 88,323 102,888 Other Operating Expenses Percent Changes Revenue Result
Deferred Taxes 243,415 27,167 General and Administrative Expenses Enter 2019 Revenue
Other Current Assets 200,782 935,317 Depreciation and Amortization Enter 2020 Revenue ERROR:#DIV/0!
Total Current Assets 5,950,659 4,007,693 Asset Impairment Expense Revenue Result
Property and Equipment 14,632,091 18,285,955 Preopening Expenses Enter 2019 Net Income
Goodwill and Trademarks 2,091,278 2,084,564 Total Operating Costs and Expenses 5,804,516 8,959,457 Enter 2020 Net Income ERROR:#DIV/0!
Other Intangible Assets 13,820,906 9,498,144 Operating Income -642,434 3,940,215
Other Assets 30,544,275 29,868,663 Other Expense
Total Asets 36,494,934 33,876,356 Interest Expense
Other
Liabilities and Stockholder Equity Income Before Income Tax
Current Liabilities Income Tax
Accounts Payable 172,672 310,171 Net Income -1,032,724 2,049,146
Accrued Liabilities 1,683,911 2,881,252
Income Taxes Payable
Current Portion of Long Term Notes
Total Current Liabilities 1,856,583 3,191,423
Long Term Notes 12,376,684 11,168,904
Deffered Taxes 2,153,016 2,106,506
Other Liabilities 8,928,743 4,746,604
Total Liabilities 25,315,026 21,213,437
Stockholders Equity
Common Stock ($0.1 Par Value,
60,000,000 shares authorized,
21,593,823 and 25,607,573
issued and outstanding, respectively) 4,943 5,031
Additional paid-in Capital 3,439,453 3,531,099
Deffered Stock Compensation 0 0
Retained Earnings 3,091,007 4,201,337
Total Stockholders Equity 11,179,908 12,662,919
Total Liabilities and Stockholders Equity 36,494,934 33,876,356