4 Part 3 of 6 Required Information [The following Information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. 0.42 points Skipped At December 31 Assets Current Year 1 Year Ago 2 Years Ago Cash $ 25,451 Accounts receivable, net 73,028 Merchandise inventory Prepaid expenses Plant assets, net eBook Total assets Liabilities and Equity Accounts payable Long-term notes payable. Print References Common stock, $10 par value Retained earnings Total liabilities and equity For both the current year and one year ago, compute the following ratios: 90,892 8,032 233,978 $ 431,381 $ 107,414 79,478 163,500 80,989 $ 29,453 51,022 70,862 7,731 212,812 $ 371,880 $ 62,848 88,098 163,500 57,434 $ 431,381 $ 371,880 $ 31,294 41,316 44,446 3,409 189,435 $ 309,900 $ 41,316 67,803 163,500 37,281 $ 309,900 The company's Income statements for the current year and one 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 Earnings per share (1-a) Compute days' sales uncollected. Current Year 1 Year Ago $ 560,795 $ 442,537 $ 287,649 $ 342,085 173,846 9,534 7,290 111,962 10,178 6,638 532,755 416,427 $ 26,110 $ 1.61 $ 28,040 $ 1.73 (1-b) Determine if days' sales uncollected Improved or worsened in the current year. (2-a) Compute accounts receivable turnover. (2-b) Determine if accounts receivable turnover ratio Improved or worsened in the current year. (3-a) Compute Inventory turnover. (3-b) Determine if Inventory turnover ratio Improved or worsened in the current year. (4-a) Compute days' sales in Inventory. (4-b) For each ratio, determine if days' sales in Inventory Improved or worsened in the current year. Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Days' Sales Uncollected Numerator: Denominator: Compute days' sales uncollected. Current Year: 1 Year Ago: xxx x Days Days' Sales Uncollected = Days' sales uncollected = 0 days 0 days Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Determine if days' sales uncollected improved or worsened in the current year. Days' sales uncollected Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Compute accounts receivable turnover. (Round your answers to the nearest whole number.) Current Year: 1 Year Ago: Numerator: Accounts Receivable Turnover Denominator: = Accounts Receivable Turnover = Accounts receivable turnover = 0 times = 0 times Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Determine if accounts receivable turnover ratio improved or worsened in the current year. Accounts receivable turnover Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 38 Compute inventory turnover. (Round your answers to the nearest whole number.) Numerator: Inventory Turnover Denominator: = Required 4A Inventory Turnover Current Year: 1 Year Ago: = Inventory turnover 0 times 0 times Required 4B Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 2A Required 2B Required 3A Required 38 Determine if inventory turnover ratio improved or worsened in the current year. Inventory turnover Required 4A Required 4B Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Compute days' sales in inventory. Current Year: 1 Year Ago: Required 3B Required 4A Required 4B Days' Sales In Inventory Numerator: 1 Denominator: x Days = Days' Sales In Inventory 1 = Days' sales in inventory 1 x = 0 days 1 = 0 days Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B For each ratio, determine if days' sales in inventory improved or worsened in the current year. Days' sales in inventory