Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Current Year 1 Year Ago $ 30,442 88,230 107,638 9,706 274,842 $510,858 Interest expense Theone tax expense Total costs and expenses Net income Earnings per share Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity For both the current year and one year ago, compute the following ratios: $125,932 96,041 163,500 125,305 $ 510,858 Current Year $405,110 205,876 11,290 8,633 $ 34,527 59,806 82,288 9,526 254,248 $ 440,395 $ 664,115 630,909 $ 33,206 $2.04 2 Years Ago 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 $36,333 46,069 51,092 4,037 222,269 $ 359,800 $ 340,646 132,990 12,054 7,961 $ 75,915 101,291 162,500 100,609 $440,395 $ 359,800 $ 47,019 77,130 162,500 73,151 1 Year Ago $ 524,070 493,151 $ 30,919 $ 1.90 (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-b) For each ratio, determine if days' sales in inventory improved or worsened in the current year ces (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 Required 2A Compute days' sales und Required 18 Current Year: 1 Year Ago: Numerator: Required 28 Required 3A Required 38, Required 4A Days' Sales Uncollected Denominator: 1 Required 1A Days Required 1B > W Required 48- Days' Sales Uncollected Days' sales uncollected 0 days 0 days eBook Hint Print References (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-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 28 Required 3A Required 38 Required 4A Required 48 Compute accounts receivable turnover. (Round your answers to the nearest whole number.) Accounts Receivable Turnover Denominator: Current Year: 1 Year Ago: Numerator 1 < Required 18 Accounts Receivable Turnover Accounts receivable turnover 0 times 0 times Required 28 > eBook Hint Print References (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-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 28 Required 3A Required 38 Compute inventory turnover. (Round your answers to the nearest whole number.) Inventory Turnover Current Year: 1 Year Age: Numerator: Denominator: < Required 28 Required 4A Inventory Turnover Inventory turnover 0 times 0 times Required 3B > Required 48 ces (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-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 28 Required 3A Required 38 Compute days' sales in inventory. Current Year: 1 Year Ago: Numerator: 1 1 1 Days' Sales In Inventory Denominator: < Required 38 Days Required 4A Required 48 Days' Sales In Inventory Days' sales in inventory 0 days 0 days Required 48 >