RHIM 4322 * Homework 3 * Ratio Analysis 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 Item Revenues: Food 78,000 Beverage 24,000 Others 1,200 Total Revenues 103.200 Cost of Sales: Food 24.960 Beverage 5,280 Others 660 Total Cost of Sales 30,900 Gross Profit: Food 53,040 Beverage 18,720 Others 540 Total Gross Profit Operating (Controllable) Expenses: Salaries and Wages 29.870 Employee Benefits 7,467.50 Direct Operating Expenses 6,192 Marketing 3,612 Utilities 4,024.80 Administration & General 2.580 Repairs and Maintenance 1.857.60 Music and Entertainment 2.889.60 Total Operating Expenses 58,493.50 Operating Income Other (Non-controllable) Expenses: Rent 7,000 Depreciation 500 Interest 500 Total Non-controllable Expenses 8,000 Income Before Income Taxes Income Taxes (1.161.30) Net Income Amount 14,000 11,500 7,488 20,000 Item Current Assets: Cash Accounts Receivable Inventory Prepaid Rent Total Current Assets Fixed Assets: Furniture, Fixture & Equipment (FF&E) Accumulated Depreciation (FF&E) Building Long term Investments Net Fixed Assets Total Assets 9,870 -4,000 20,000 8.580 6.790 6,540 3,500 Current Liabilities: Accounts Payable Accrued Payroll Accrued Taxes Total Current Liabilities Long Term Debt Total Liabilities Owner's Equity Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity 12,000 40,620 17,988 1