Please I need a help or any type of guidance on this project.

I need to generate:

1. A Pro Forma Income Statement for MGM Resorts for the next Fiscal year

2. A Pro Forma Balance Sheet for the next Fiscal Year End

3. A Written Memo of Information and Assumptions

Attached:

- a spreadsheet of the numbers I came up with for MGM Resorts thus far

	Company: MGM Resorts (MGM)		Competitor: Caesars Entertainment (CZR)
	Past Fiscal Year	Latest Fiscal Year	Latest Fiscal Year Only
Profitability & Performance Ratios
Gross Profit Margin	42.77	41.18	52.58
Operating (EBIT) Profit Margin	14.66	11.31	9.74
Net Profit Margin	18.02	3.79	3.61
Return on Equity	28.08	6.31	9.36
Resource Management Ratios
Days Sales Outstanding	18.35	18.58	17.9
Days Inventory	5.92	5.62	3.67
Payables Period	14.96	14.71	32.89
Liquidity Ratios
Current Ratios	0.77	0.86	1.13
Quick Ratios	0.67	0.75	0.97
Debt Management Ratios
Debt-to-Equity Ratios	1.68	2.32	7.93

- Sample spreadsheet format using Ford as the company This is format the professor would like the project in:

Please any help would be greatly appreciated!

Project 2B Ford Motor Company- SEE ACCOMPANYING ASSUMPTIONS MEMO FOR DETAILS Assumptions 2017 Revenue 156,776 million Growth rate COGS % of Sales Operating Expense % of Sales Dividend Payout ratio Cash balance f sales 1.66% 78.37% 11.61 % 54.50% $18,492 million utstanding Inventory Days 26.65 days 61.95 days Pavables Period Depreciation (% of PP&E) 12.96% Interest expense $1,013 Interest rate $1,682 million Net Fixed Assets to be Acquired Tax rate 21% Beg. Accounts Receivable Beg Inventory Beg, Accounts Payable Beg. Equity $10.599 million $10,277 million $23.282 million $34.890 million Beg. Gross PP&E $65,189 $35.327 million Beg. Net PP&E Ford Motor Company Pro Forma Income Statement 2018 (in millions) Ford Motor Company Represents calculated values Pro Forma Balance Sheet 2018 (in millions) 378.482 Assets Sales Cost of Good Sold 124.904.916 Current assets 34,473.566 Gross Profit Cash 18.492 Operating expenses 18,503.842 Marketable Securities 20.435 Depreciation Total operating expenses Earnings Before Interest & Taxes Interest Expense Earnings Before Taxes Receivables 11.029.864 8,666.482 Inventories 27.170.323 9.119.77 Other current assets 56.099 7,303.242 115.175.634 1,013| 6,290.242 Total current assets Non-current assets 28,342.518 Net property, plant and equipment Taxes Net income 4,9 tments Deferred income taxes Other long-term assets 10.973 Dividends Annual Retained Earnings 2,708.264 2.261.028 64.286 Total non-current assets 134,921.518 Total assets 250,097.153 Liabilities and stockholders' equity Liabilities Cost f goods sold: Beg. Inventory Current liabilities $10.277 Short-term deht 51.621 1.00 134 035 Cort af a Accrued liabilities savailable $9.120 $124.905 Less ending inventory Cost fgoods sold Deferred revenues 2,107 Other current liabilities 16.533 92,321.203 iabilities Long-term debt 94,972.922 plug Deferred taxes liabilities 815 Deferred revenues 3,829 15,753 and other benefits Other long-term liabilities 5.227 Total non-current liabilities Total liabilities 120.624.922 212.946.125 ders equity A1 Additional paid-in capital Retained earnings 21,843 3,479.028 Treasury stock 1.25 Accumulated other comprehensive income -6,959 37,151.028 N nd stockholders' equity Calculation- Long term debt 212,-4 Aes- Total Equity lotl iabilities Project 2B Ford Motor Company- SEE ACCOMPANYING ASSUMPTIONS MEMO FOR DETAILS Assumptions 2017 Revenue 156,776 million Growth rate COGS % of Sales Operating Expense % of Sales Dividend Payout ratio Cash balance f sales 1.66% 78.37% 11.61 % 54.50% $18,492 million utstanding Inventory Days 26.65 days 61.95 days Pavables Period Depreciation (% of PP&E) 12.96% Interest expense $1,013 Interest rate $1,682 million Net Fixed Assets to be Acquired Tax rate 21% Beg. Accounts Receivable Beg Inventory Beg, Accounts Payable Beg. Equity $10.599 million $10,277 million $23.282 million $34.890 million Beg. Gross PP&E $65,189 $35.327 million Beg. Net PP&E Ford Motor Company Pro Forma Income Statement 2018 (in millions) Ford Motor Company Represents calculated values Pro Forma Balance Sheet 2018 (in millions) 378.482 Assets Sales Cost of Good Sold 124.904.916 Current assets 34,473.566 Gross Profit Cash 18.492 Operating expenses 18,503.842 Marketable Securities 20.435 Depreciation Total operating expenses Earnings Before Interest & Taxes Interest Expense Earnings Before Taxes Receivables 11.029.864 8,666.482 Inventories 27.170.323 9.119.77 Other current assets 56.099 7,303.242 115.175.634 1,013| 6,290.242 Total current assets Non-current assets 28,342.518 Net property, plant and equipment Taxes Net income 4,9 tments Deferred income taxes Other long-term assets 10.973 Dividends Annual Retained Earnings 2,708.264 2.261.028 64.286 Total non-current assets 134,921.518 Total assets 250,097.153 Liabilities and stockholders' equity Liabilities Cost f goods sold: Beg. Inventory Current liabilities $10.277 Short-term deht 51.621 1.00 134 035 Cort af a Accrued liabilities savailable $9.120 $124.905 Less ending inventory Cost fgoods sold Deferred revenues 2,107 Other current liabilities 16.533 92,321.203 iabilities Long-term debt 94,972.922 plug Deferred taxes liabilities 815 Deferred revenues 3,829 15,753 and other benefits Other long-term liabilities 5.227 Total non-current liabilities Total liabilities 120.624.922 212.946.125 ders equity A1 Additional paid-in capital Retained earnings 21,843 3,479.028 Treasury stock 1.25 Accumulated other comprehensive income -6,959 37,151.028 N nd stockholders' equity Calculation- Long term debt 212,-4 Aes- Total Equity lotl iabilities