5 ences 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 Liabilities and Equity Accounts payable $31,800 09,500 Current Year 1 Year Ago 2 Years Ago $35,625 62,500 $37,800 50,200 112,500 82,500 54,000 10,709 9,375 278,500 255,000 $445,000 5,000 230,500 5377,500 $25,250 $51,250 101,500 83,500 163,500 163,500 163,500 131,100 104,750 5523,000 $445,000 79,250 $377,500 Long-term notes payable Common stock, $10 par value Retained earnings 5523,000 $ 129,900 90,500 Total liabilities and equity For both the current year and one year ago, compute the following ratios 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 209,550 12,100 9,525 Current Year 1 Year Ago $573,500 $532,000 $ 411,225 $ 345,500 134,900 13,300 502,625 $29,375 $1.00 642,400 $ 31,100 51.90 Earnings per share (1-e) 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-6) 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 20 Required 3A Required 381 Required 4A Required 48 Compute days' sales uncollected. Days Sales Uncollected Numerator Denominator Days Accounts receivable, net Net sales X Current Year: $ 89,500 Days' Sales Uncollected Days' sales uncollected 0 days 1 Year Ago 0 days Complete this question by entering your answers in the tabs below. Required 1A1 Required 18 Required 2A Required 2B Required 3A Required 38 Required 4A Required 48 Compute accounts receivable turnover. Numerator:: Accounts Receivable Turnover Denominator: Current Year: 1 Year Ago: Accounts Receivable Turnover Accounts receivable turnover 0 times 0 times Current Year: 1 Year Ago: Numerator: Inventory Turnover Denominator: Inventory Turnover Inventory turnover < Required 28 Required 3B > 0 times 0 times 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. Current Year: 1 Year Ago: Days' Sales In Inventory Numerator: Denominator: Days Days' Sales In Inventory x x x Days' sales in inventory 0 days 0 days