Required information [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,800 89,500 112,500 10,700 278,500 $ 523,000 $ 35,625 62,500 82,500 9,375 255,000 $ 445,000 $ 37,800 50,200 54,000 5,000 230,500 $ 377,500 $ 129,900 98,500 163,500 131, 100 $ 523,000 $ 75,250 101,500 163,500 104,750 $ 445,000 $ 51,250 83,500 163,500 79,250 $ 377,500 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 Current Year $ 673,500 $ 411,225 209,550 12,100 9,525 642,400 $ 31,100 1 Year Ago $ 532,000 $ 345,500 134,980 13,300 8,845 502,625 $ 29,375 Earnings per share $ 1.90 $ 1.80 (1-a) Compute days' sales uncollected. (1-b) For each ratio, determine if it improved or worsened in the current year. Complete this question by entering your answers in the tabs below. Required 1A Required 1B Compute days' sales uncollected. = Numerator: Accounts receivable, net Days' Sales Uncollected 1 Denominator: 1 Net sales 1 62,500 1 Days 365 x = Days' Sales Uncollected Days' sales uncollected 0 days X = Current Year: 1 Year Ago: $ X 0 days (2-b) For each ratio, determine if it improved or worsened in the current year. Complete this question by entering your answers in the tabs below. Required 2A Required 2B Compute accounts receivable turnover. Numerator: Accounts Receivable Turnover 1 Denominator: 1 = = = Accounts Receivable Turnover Accounts receivable turnover 0 times 0 times Current Year: 1 Year Ago: / 11 (3-a) Compute inventory turnover. (3-6) For each ratio, determine if it improved or worsened in the current year. Complete this question by entering your answers in the tabs below. Required 3A Required 3B Compute inventory turnover. Numerator: Inventory Turnover Denominator: 1 = Inventory Turnover Inventory turnover times times / Current Year: 1 Year Ago: / 11 (4-a) Compute days' sales in inventory. (4-b) For each ratio, determine if it improved or worsened in the current year. Complete this question by entering your answers in the tabs below. Required 4A Required 4B Compute days' sales in inventory. Days' Sales In Inventory Numerator: Denominator: x x 1 1 Days = Days' Sales In Inventory Days' sales in inventory 0 days 0 days X Current Year: 1 Year Ago: X 11