please solve correclty

use this spreadsheet

this is an example of how to do with difffent imformation, please follow this example to complete the excercise

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" 14,000 11,500 7,488 20,000 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 Others 540 Accumulated Depreciation (FF&E) 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 Total Operating Expenses 58,493.50 Accrued Taxes Operating Income Total Current Liabilities Other (Non-controllable) Expenses: Long Term Debt Rent 7,000 Total Liabilities Depreciation 500 Interest Owner's Equity 500 Total Non-controllable Expenses Retained Earnings 8,000 Income Before Income Taxes Total Owner's Equity Income Taxes (1.161.30) Total Liabilities and Owner's Equity Net Income 9,870 4,000 20,000 8,580 6,790 6,540 3,500 12,000 40,620 17,988 fx Financial data from Demo Exercise 3_Info Sheet 412,000,000 101,352,000 310,648,000 1,502,153 2,985,000 3,850,000 2,034,000 1,100,000 11,471,153 107,120,000 23,484,000 This side is the balance sheet Current Assets: Cash Accounts Receivable Short-term Investments Food Inventory Prepaid Rent Total Current Assets Fixed Assets: Fumiture, Fixture & Equipment (FF&E) Accumulated Depreciation (FF&E) Buildings Long-term Investments Net Fixed Assets 76,045,230 1 Financial data from Demo Exercise 3 Info Sheet This side is the income statement 3 Revenues: Food 4 Cost of Sales: Food 5 Gross 6 Operating (Controllable) Expenses: i Salaries and Wages Employee Benefits 9 Direct Operating Expenses 10 Marketing 11 Utilities 12 Administrative & General 13 Repairs and Maintenance 14 Total Operating Expenses 15 Operating Income 16 Other (Non-controllable) Expenses: 17 Rent 18 Depreciation 19 Interest 20 Total Non-controllable Expenses 21 Income Before Income Taxes 22 Income Taxes 23 Net income 13,678,400 12,318,800 17,950,000 5,850,400 256,446,830 54,201,170 120,300,000 -160,000,000 190,290,000 495,600 151,085,600 162,556,753 Total Assets Current Liabilities: 22,660,000 16,502,000 8,450,000 47,612,000 6,589,170 4,944,000 1,645,170 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,500,000 23,900,500 118,050 36,518,550 28,000,000 64,518,550 8,771,000 89,267,203 98,038,203 162,556,753 Ratio Anlaysis Show your work for 2 decimal places Place your mouse within cell MS. you will see the procedure. Same with other cells Liity rates 1 current ratio - 03 dollars current current abilities 11,471,153 + 36,518,550 (CA-inventories) current liabilities (11.471,153 -2,034,000) - 1.518,550 Current Rato Current Assets/ Current Liabilities 11.471.153/36 518,550 -0.31 Dollars 2 quick ratio - 0.26 dollars Quick Ratio. Current Assets - Inventories)/Current Liabilities (11.471,153 -2,034,0001/36,518,550 -0.26 Dollars Solvency ratio total abilities to assets 162,556,753 3 detto 64.518,550 Debt Ratio - Total Labilities/Total Assets 64,516,550/162.556,753 39.60% operating income 54.201.170 Interest expen 450.000 4 times interest earned (TIE Times Interest Earned (TI) Operating income interest Expense 54,201,170/8,450,000 -6.41 Times Acthyst 5 very over COOS every 101,352,000 2034.000 rested 412,000,000 151,085,600 Inventory Turnover COGS / Inventory 101,352.000/ 2,014 000 - 49 83 Times 6 e urover Ford Asset Turnover Revenue / NetFeed Assets 412,000,000 / 151,085.600 2,73 Times Operating at cost of food 101,352,000 foods 412,000,000 7 food courage Food Cost Percentage Com of Food Sold/Food Sales 101,352,000/412,000,000 -24.60% Labor cost 107, 120.000 23.484,000 8 labor cost percentage 412,000,000 Labor Cost Percentage labor Cost(Wages & Benefits/Total Sales 107,120,000 23,484,0001/412,000,000 - 31.70% Profily ratios revenue 412,000,000 Net Profit Margins Net Income / Revenue 1645.170/412,000,000 -0.40% 9 te profit margin 1,645,170 met income 10 euro (ROA) 1.645,170 LOS net income 1,645,170 163,556,753 lequity 98,038 203 Retum en Assets (ROA) Net Income / Total Alett 1,645,170/162.555.753 1015 Return on Equity (ROE) - Net Income / Total Equity: 1645,170/58,038,203 - 1.68% Il return on equity (ROE)