Please answer the following question in Word Excel.

g. Total h. Accounts receivable P323 Cross-sectional ratio analysis Use the accompanying financial statements for Fox Manufacturing Company for the year ended December 31, 2019, along with the industry average ratios below, to do the following: a. Prepare and interpret a complete ratio analysis of the firm's 2019 operations. b. Summarize your findings and make recommendations. Fox Manufacturing Company Income Statement for the Year Ended December 31, 2019 $600,000 460,000 $140,000 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses General and administrative expenses Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after taxes (Hint: Earnings available for common stockholders as there are no preferred stockholders) $ 30,000 30,000 $ 60,000 $ 80,000 10,000 $ 70,000 27,100 $ 42,900 $2.15 Earnings per share (EPS) Ratio Current ratio Quick ratio Inventory turnovera Average collection period Total asset turnover Debt ratio Times interest earned ratio Gross profit margin Operating profit margin Net profit margin Return on total assets (ROA) Return on common equity (ROE) Earnings per share (EPS) Industry average, 2019 2.35 0.87 4.55 35.8 days 1.09 0.300 12.3 0.202 0.135 0.091 0.099 0.167 $3.10 Based on a 365-day year and on end-of-year figures. Fox Manufacturing Company Balance Sheet December 31, 2019 Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets $ 15,000 7,200 34,100 82,000 $138,300 270,000 $408,300 Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Common stock equity (20,000 shares outstanding) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 57,000 13,000 5,000 $ 75,000 $150,000 $110,200 73,100 $183,300 $408,300