I need the solution of this problem

Typed only please.. because I have issues with hand written

I will like directly the work

Thank you very much

Gulf Company LLC Comparative Income Statement Year Ended December 31, 2019 and 2020 2020 Net sales Cost of goods sold Gross profit(A) (IN USD) 758000 453000 305000 2019 (IN USD) 693000 429000 264000 Operating Expenses Selling expenses General Expenses Total Operating expenses(B) Income from operations(A-B) Interest revenue Interest expenses Income before Income Taxes Income Tax expenses NET INCOME 116000 108000 224000 81000 4000 (24000) 61000 27000 34000 98000 113000 211000 53000 0 (14000) 39000 17000 22000 Gulf Company LLC Comparative Balance Sheet December 31, 2019 and 2020 2020 2019 ASSETS Current Assets: Cash Accounts receivable Inventories Prepaid expenses Total current Assets 38000 98000 110000 6000 32000 85000 95000 8000 252000 220000 18000 12000 Long Term Investments Property,plant,and equipment net Total Assets 486000 756000 399000 631000 69000 27000 LIABILITIES Current Liabilities: Accounts payable Accrued liabilities Notes payable Total current Liabilities Long Term notes payable Total liabilities (C) 42000 57000 31000 27000 115000 198000 313000 138000 283000 421000 Stockholders'Equity Common stock Retained earnings Total Stockholders equity(D) Total Liabilities and Stockholders equity(C+D) 186000 149000 186000 132000 318000 631000 335000 756000 Question: You are required to Find out the following ratios and interpret the results after comparing the ratios with the industry average Ratios Industry Average Profitability ratios Industry average Return on capital employed (ROCE) NA Profit margin 1.70% Return on Equity (ROE) 10.50% Return on Asset (ROA) 6.00% Liquidity/solvency ratios 0.6 Current ratio Quick assets Acid test ratio 0.46 Efficiency/activity / asset utilization operational ratios Asset turnover 3.52 times 27.7 Inventory turnover Debtor days or average collection period 13 days Shareholder/Market prospects ratios Earnings per share Price earning (PE) ratio $ 9.76 17.79 Gearing/Leverage ratios 69% Debt ratio Debt to equity ratio Interest coverage ratio/time interest earned 2.23 7.8 (Note: Your should show your calculations separetly in an Excel Worksheet.)