Current Yr 1 Yr Ago 2 Yrs 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 secured by mortgages on plant assets 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 $ 37,800 62,50050,200 82,500 54,000 9,375 5,000 255,000 230, 500 $ 445,000 $ 377,500 $ 129,900 $ 75,250 $ 51,250 98,500 163,500 131,100 $ 523,000 101,500 83,500 163,500 163,500 104,750 79,250 $ 445,000 $ 377,500 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 Sales Cost of goods sold Other operating expenses Interest expense Income tax expense Total costs and expenses Net income Earnings per share Current Yr $ 673,500 $411,225 209,550 12,100 9,525 642,400 $ 31,100 $ 1.90 1 Yr Ago $ 532,000 $345,500 134,980 13,300 8,845 502,625 $ 29,375 $ 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. Choose Numerator: Days' Sales Uncollected 1 Choose Denominator: 1 Current assets Days Current liabilities = Days' Sales Uncollected = Days' Sales Uncollected 0 days o days Current Yr: 1 Yr Ago: XXX (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 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. Accounts Receivable Turnover Choose Denominator: Choose Numerator: - Accounts Receivable Turnover Accounts receivable turnover times times Current Yr: 1 Yr Ago: Required 2A Required 2B > (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 For each ratio, determine if it improved or worsened in the current year. Accounts receivable turnover Required 2A Required 2B (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 Choose Denominator: Choose Numerator: = Inventory Turnover Inventory turnover times times Current Yr: 1 Yr Ago: Required 3A Required 3B > (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 For each ratio, determine if it improved or worsened in the current year. Inventory turnover Required 4A Required 4B For each ratio, determine if it improved or worsened in the current year. Days' sales in inventory
