please do in Excel and include an income statement and a balance sheet. thank you so much!
14,000 11,500 7,488 20,000 9,870 -4,000 20,000 8,580 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 Cost of Sales: Accounts Receivable Food 24,960 Inventory Beverage 5,280 Prepaid Rent Others 660 Total Current Assets Total Cost of Sales 30,900 Fixed Assets: Gross Profit: Furniture, Fixture & Equipment Food 53,040 (FF&E) Beverage 18,720 Accumulated Depreciation (FF&E) Others 540 Total Gross Profit Building Operating (Controllable) Expenses: Long term Investments 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 Repairs and Maintenance 1.857.60 Accrued Payroll Music and Entertainment 2,889,60 Accrued Taxes Total Operating Expenses 58,493.50 Total Current Liabilities Operating Income Other (Non-controllable) Expenses: Long Term Debt Rent 7,000 Total Liabilities Depreciation 500 Owner's Equity Interest 500 Retained Earnings Total Non-controllable Expenses 8.000 Total Owner's Equity Income Before Income Taxes Income Taxes (1.161.30) Total Liabilities and Owner's Equity Net Income 6,790 6,540 3.500 12,000 40,620 17,988 14,000 11,500 7,488 20,000 9,870 -4,000 20,000 8,580 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 Cost of Sales: Accounts Receivable Food 24,960 Inventory Beverage 5,280 Prepaid Rent Others 660 Total Current Assets Total Cost of Sales 30,900 Fixed Assets: Gross Profit: Furniture, Fixture & Equipment Food 53,040 (FF&E) Beverage 18,720 Accumulated Depreciation (FF&E) Others 540 Total Gross Profit Building Operating (Controllable) Expenses: Long term Investments 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 Repairs and Maintenance 1.857.60 Accrued Payroll Music and Entertainment 2,889,60 Accrued Taxes Total Operating Expenses 58,493.50 Total Current Liabilities Operating Income Other (Non-controllable) Expenses: Long Term Debt Rent 7,000 Total Liabilities Depreciation 500 Owner's Equity Interest 500 Retained Earnings Total Non-controllable Expenses 8.000 Total Owner's Equity Income Before Income Taxes Income Taxes (1.161.30) Total Liabilities and Owner's Equity Net Income 6,790 6,540 3.500 12,000 40,620 17,988
