Please complete and show work in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. However, no need to show the explanatory notes like what is being provided in the Demo Exercise. Submit the Homework spreadsheet using this filename "RHIM4322-Last_Name-Homework 3" Calculate the 11 ratios for Gian's Italian Cuisine as of December 31, 2017 Revenues: Food 78,000 Beverage 24,000 Current Assets: Others 1,200 Cash Total Revenues 103,200 Accounts Receivable Cost of Sales: Food 24,960 Inventory Beverage 5,280 Prepaid Rent 14,000 11,500 7,488 20,000 Others 660 Total Current Assets Total Cost of Sales 30,900 Fixed Assets: Gross Profit: Furniture, Fixture & Equipment Food 53,040 9,870 (FF&E) Beverage 18,720 Others Accumulated Depreciation (FF&E) -4,000 540 Building 20,000 Total Gross Profit Operating (Controllable) Expenses: Long term Investments 8,580 Salaries and Wages 29,870 Net Fixed Assets Employee Benefits 7,467.50 Total Assets Direct Operating Expenses 6,192 Marketing 3,612 Utilities 4,024.80 Current Liabilities: Administration & General 2,580 Accounts Payable 6,790 Repairs and Maintenance 1,857.60 Accrued Payroll 6,540 Music and Entertainment 2,889.60 Accrued Taxes Total Operating Expenses 3,500 58,493.50 Operating Income Total Current Liabilities Other (Non-controllable) Expenses: Long Term Debt 12,000 Rent 7,000 Total Liabilities Depreciation 500 Owner's Equity 40,620 Interest 500 Retained Earnings 17,988 Total Non-controllable Expenses 8,000 Income Before Income Taxes Income Taxes Total Owner's Equity (1,161.30) Total Liabilities and Owner's Equity Net Income