can someone help me with 4.32. needs to br completed on excel . thank you

does 4.31 need to be completed 1st before before getting the info for 4.32? unsure please help

e hrm's days' sales outstanding, total asset turnover ratio, and fixed asset turnover 136,042 on net sales of $4,063589. b. Calculate the ratio ng are the financial statements for Nederland Consumer Products Company for the fiscal year ended September 30, 20oer Nederland Consumer Products Com Income Statement for the Fiscal Year Ended September 30, 2014 Net sales Cost of products sold Gross profit Marketing, research, administrative exp. $51.407 25,076 $26,331 15,746 758 Operating income (loss) Interest expense Earnings (loss) before income taxes Income taxes Net earnings (loss) S 9,827 477 9,350 2,869 $ 6,481 Nederland Consumer Products Company Balance Sheet as of September 30, 2014 Assets: Liabilities and Equity: Accrued and other liabilities Debt due within one year Cash and marketable securities 5,469 Accounts payable S 3,617 Investment securities Accounts receivable Inventory Deferred income taxes Prepaid expenses and other 423 7,689 2,554 8,287 $22,147 12,554 4,062 Taxes payable 4,400 958 Total current liabilities Long-term debt Deferred income taxes Other noncurrent liabilities receivables 1,803 $17,115 25,304 2,261 Total current assets Property, plant, and equipment, 2,808 Total liabilities Convertible class A preferred $39,770 at cost Less: Accumulated depreciation Net property, plant, and equipment Net goodwill and other intangible 1,526 11,196 S14,108 23,900 stock Common stodk Retained earnings Total stockholders' equity 2,141 13,611 $17,278 assets Other noncurrent assets Total assets 1,925 $57,048 Total liabilities and equity 048 inte CORE 3 Analyzing Financial Statements ilable below, Calculate all the ratios,for which industry figures are ava the firmk ratios with the industry ratios. the ratios, for which industry figures are available below, for Neder Industry Average 2.05 0.78 23.9% 12.3% 0.23 0.98 5.62 5.3% 18.8% Ratio Current ratio Quick ratio Gross margin Net profit margin Debt ratio Long-term debt to equity Interest coverage ROA ROE 4.32 Refer to the preceding information for Nederland Consumer Products Company. Compute the firms ratios for the following categories and briefly evaluate the company's performance using these numbers. a. Efficiency ratios b. Asset turnover ratios c. Leverage ratios. d. Coverage ratios