Please help me finish this with formulas. I need to know how to do it.

Thank you!!!!

$160,400 105,500 $54,900 Zach Industries Income Statement for the Year Ended December, 31, 2019 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after taxes $15,600 9,800 1,010 9,800 $36,210 $18,690 6,100 $12,590 4,360 $8,230 Zach Industries Balance Sheet December 31, 2019 Assets Cash Marketable securities Accounts receivable Inventories Total current assets $550 970 24,700 45,700 $71,920 $25,900 90,000 38,500 $77,400 $149,320 Land Buildings and equipment Less: Accumulated depreciation Net fixed assets Total assets Liabilities and Stockholders' Equity Accounts payable Notes payable Total current liabilities Long-term debt Common stock* Retained earnings $22,500 46,900 $69,400 $22,940 $31,100 $25,880 Financial statement analysis The financial statements of Zach Industries for the year ended December 31, 2019, follow? a. Use the financial statements to complete the following table 2. Assume the industry averages given in the table are applicable for both 2018 and 2019, b. Analyze Zach Industries' financial condition as it is related to (1) liquidity, (2) activity. (3) debt, (4) profitability, and (5) market. Summarize the company's overall financial condition. a. a. The current ratio is 1.04 (Round to two decimal places.) The quick ratio is .38 (Round to two decimal places.) The inventory turnover is 2.31 (Round to two decimal places.) The average collection period is 56.2 days. (Round to one decimal place.) The debt ratio is 61.8 %. (Round to one decimal place.) The times interest earned ratio is 3.1 (Round to one decimal place.) The gross profit margin is 34.2 %. (Round to one decimal place.) The net profit margin is 5.1 %. (Round to one decimal place.) The return on assets is 5.5 %. (Round to one decimal place) The return on common equity is %. (Round to one decimal place.) The market/book value is (Round to two decimal places.) b. Analyze Zach Industries' financial condition as it is related to (1) liquidity, (2) activity. (3) debt, (4) profitability, and (5) market. Summarize the company's overall financial condition. (Select all the answers that apply.) A. Liquidity: Zach Industries' liquidity position has deteriorated from 2018 to 2019 and is inferior to the industry average. The firm may not be able to satisfy short-term obligations as they come due B. Activity: Zach Industries' ability to convert assets into cash has deteriorated from 2018 to 2019. Examination into the cause of the 20.5-day increase in the average collection period is warranted. Inventory tumover has also decreased for the period under review and is fair compared to industry. The firm may be holding slightly excessive inventory. C. Debt: Zach Industries' debt position has improved since 2018 and is below average. Zach Industries' ability to service interest payments has deteriorated and is below the industry average. D. Profitability: Although Zach Industries' gross profit margin is below its industry average, indicating high cost of goods sold, the firm has a superior net profit margin in comparison to average. The firm has lower than average operating expenses. The firm has a superior return on investment and return on equity in comparison to the industry and shows an upward trend. E. Market: Zach Industries' increase in their market price relative to their book value per share indicates that the firm's performance has been interpreted as more positive in 2019 than in 2018 and it is a little higher than the industry