Current Yr 1 Yr Ago 2 Yrs Ago 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 Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 31,515 89, 200 113,500 10,149 274,227 $518,591 $ 36,838 $ 36,883 62,800 50,200 82,800 56,000 9,670 4,098 255,753 214,519 $ 447,061 $ 361,700 $133,003 $ 77,820 $ 49, 177 100, 420 162,500 122,668 $518,591 105,999 82,334 162,500 162,500 100,832 67,689 $ 447,061 $ 361,700 The company's income statements for the Current Year and 1 Year Ago, follow. Assume that all sales are on credit: For Year Ended December 31 Current Yr 1 Yr Ago Sales $ 674,168 $ 532,683 Cost of goods sold $ 411,242 $ 345, 802 Other operating expenses 208,992 134,597 Interest expense 11,461 12,236 Income tax expense 8,764 7,98 Total costs and expenses 640, 459 500,615 Net income $ 33,709 $ 31,388 $ 2.07 $ Earnings per share 1.93 (1-a) Compute days' sales uncollected. (1-b) For each ratio, determine if it improved or worsened in the current year Choose Numerator: Days' Sales Uncollected 1 Choose Denominator: / X Days X Days' Sales Uncollected Days' Sales Uncollected o days 0 days 1 Current Yr: 1 Yr Ago: X For each ratio, determine if it improved or worsened in the current year. Days' sales uncollected (2-a) Compute accounts receivable turnover. (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. Choose Numerator: Accounts Receivable Turnover Choose Denominator: 1 Accounts Receivable Turnover Accounts receivable turnover times times 1 Current Yr: 1 Yr Ago: For each ratio, determine if it improved or worsened in the current year. Accounts receivable turnover (3-a) Compute inventory turnover. (3-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 3A Required 3B Compute inventory turnover. Inventory Turnover 1 Choose Denominator: Choose Numerator: Inventory Turnover 11 1 Inventory turnover times Current Yr: = times 1 Yr Ago: 1 For each ratio, determine if it improved or worsened in the current year- Inventory turnover (4-a) Compute days' sales in inventory. (4-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 4A Required 4B Compute days' sales in inventory. Days' Sales In Inventory Choose Numerator: Choose Denominator: 1 Days X Days' Sales In Inventory Days' sales in inventory days X = 1 Current Yr: 1 Yr Ago: 1 days For each ratio, determine if it improved or worsened in the current year. Days' sales in inventory