Please answer all 4 parts of the question, as they are 4 parts of ONE question.

5 Required information Exercise 17-8 Analyzing and interpreting liquidity LO P3 [The following information applies to the questions displayed below.] Part 1 of 4 Simon Company's year-end balance sheets follow. 0.66 points Current Yr 1 Yr Ago 2 Yrs Ago At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 30, 724 89, 300 111,500 9,894 284,596 $526,014 $ 35,914 $ 37,410 62,000 50,600 85,000 58,000 9,427 4,157 261,119 231,533 $ 453,460 $ 381,700 $129,668 $ 75,868 $ 49,881 97,902 162,500 135,944 $526,014 103, 253 83,512 162,500 162,500 111,839 85,807 $ 453,460 $ 381,700 The company's income statements for the Current Year and 1 Year Ago, follow. Assume that all sales are on credit: For Year Ended December 31 Sales Cost of goods sold Other operating expenses Interest expense Income tax expense Total costs and expenses Net income Current Yr $ 683, 818 $ 417,129 211,984 11,625 8,890 649, 628 $ 34, 190 1 Yr Ago $ 539, 617 $ 350, 751 136,523 12,411 8,094 507,779 $ 31,838 Earnings per share $ 2.10 $ 1.96 Exercise 17-8 Part 1 (1-a) Compute days' sales uncollected. (1-b) For each ratio, determine if it improved or worsened in the current year. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1A Required 1B Compute days' sales uncollected. Days' Sales Uncollected Choose Denominator: Choose Numerator: 1 Days = x / Average accounts receivable, net X X 365 = Days' Sales Uncollected Days' Sales Uncollected 60.0 days 57.5 days Cost of goods sold $ $ Current Yr: 1 Yr Ago: 365 112,500 85,000 X/ $ $ 683,818 x 539,617 365 = Required 1A Required 1B For each ratio, determine if it improved or worsened in the current year. Days' sales uncollected Worsened Required 1A Required 1B Simon Company's year-end balance sheets follow. Part 2 of 4 Current Yr 1 Yr Ago 2 Yrs Ago 0.66 points At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 30,724 89, 300 111,500 9,894 284,596 $526,014 $ 35,914 $ 37,410 62,000 50, 600 85,000 58,000 9, 427 4,157 261,119 231,533 $ 453,460 $ 381,700 $129,668 $ 75,868 $ 49,881 97,902 162,500 135,944 $526,014 103, 253 83,512 162,500 162,500 111,839 85,807 $ 453,460 $ 381,700 The company's income statements for the Current Year and 1 Year Ago, follow. Assume that all sales are on credit: For Year Ended December 31 Sales Cost of goods sold Other operating expenses Interest expense Income tax expense Total costs and expenses Net income Current Yr $ 683,818 $ 417,129 211,984 11,625 8,890 649,628 $ 34,190 1 Yr Ago $ 539,617 $ 350,751 136,523 12,411 8,094 507,779 $ 31,838 Earnings per share $ 2.10 $ 1.96 Exercise 17-8 Part 2 (2-a) Compute accounts receivable turnover. (2-b) For each ratio, determine if it improved or worsened in the current year. X Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 2A Required 2B Compute accounts receivable turnover. Accounts Receivable Turnover Choose Numerator: Choose Denominator: Accounts Receivable Turnover Net sales Cost of goods sold Accounts receivable turnover $ $ 98,250 X II 4.2 times Current Yr: 1 Yr Ago: 417,129 X 1 350,751 X 1 II 71,500 4.9 times Required 3A Required 3B For each ratio, determine if it improved or worsened in the current year. Inventory turnover