(The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. Current Year 1 Year Ago 2 Years 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 Common stock, $10 par value Retained earnings Total liabilities and equity $ 31,006 90,773 115,271 9,783 284,004 $ 530,837 $ 36,243 64,707 85,506 9,418 261, 744 $ 457,618 $ 38,516 50, 338 56,339 4,195 235,812 $ 385,200 $ 133,500 101,793 162,500 133,044 $ 530,837 $ 78, 111 106,305 162,500 110, 702 $ 457,618 $ 50,846 84,278 162,500 87,576 $ 385,200 For both the current year and one year ago, compute the following ratios: Exercise 17-8 (Algo) Analyzing and interpreting liquidity LO P3 The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: For Yoar Ended December 31 Current Year 1 Year Ago Sales $ 690,088 $ 544,565 Cost of goods sold $ 420,954 $ 353, 967 Other operating expenses 213,927 137,775 Interest expense 11,731 12,525 Income tax expense 8,971 8,168 Total costs and expenses 655,583 512,435 Net income $ 34,505 $ 32,130 Earnings per share $ 2.12 $ 1.98 Required information (1-a) Compute days' sales uncollected. (1-6) 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-6) 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 38 Required 4A Required 48 Compute days' sales uncollected. Days Sales Uncollected Denominator: Numerator: H Days x x - Days' Sales Uncollected Days' sales uncollected 0 days 0 days Current Year: 1 Year Ago:
(1-a) Compute days' sales uncollected. (1-1) 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-6) 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 1B Required 2A Required 2B Required 3A Required 38 Required 4A Required 4B Determine if days' sales uncollected improved or worsened in the current year. Days' sales uncollected Required information (1-a) Compute days' sales uncollected. 1-b) Determine if days' sales uncollected improved or worsened in the current year. (2-a) Compute accounts receivable turnover. (2-6) Determine if accounts receivable turnover ratio improved or worsened in the current year. (3-a) Compute inventory turnover. 13-b) Determine if Inventory turnover ratio improved or worsened in the current year. (4-a) Compute days' sales in Inventory. 14-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 Compute accounts receivable turnover. (Round your answers to the nearest whole number.) Accounts Recelvablo Turnover Numerator: Denominator: Accounts Receivable Turnover Accounts receivable turnover 0 times Current Year: 1 Year Ago: 0 times (Required 1B Required 2B > Required information LLIU Earnings per share $ 2.12 5 1.98 (1-a) Compute days' sales uncollected. (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-6) 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 38 Required 4A Required 48 Determine if accounts receivable turnover ratio improved or worsened in the current year. Accounts receivable turnover Required information (1-a) Compute days' sales uncollected. (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-6) 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 1B Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Compute inventory turnover. (Round your answers to the nearest whole number.) Inventory Turnover Denominator Numerator: Inventory Turnover Inventory turnover Current Year: = 0 times 1 Year Ago: = 0 times Required information (1-a) Compute days' sales uncollected, (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-6) 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 48 Compute days' sales in inventory. Days' Sales In Inventory Denominator: Numerator: X Days Days' Salos In Inventory Days' sales in inventory o days 0 days Current Year: 1 Year Ago: Required information Net Income WARAJU Earnings per share $ 2.12 $ 1.98 (1-a) Compute days' sales uncollected. (1-b) Determine if days' sales uncollected improved or worsened in the current year. (2-a) Compute accounts receivable turnover. (2-6) 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-6) 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 1B 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