show work please.

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 10 Plant assets, net 11 Total assets 12 Liabilities and Equity 13 Accounts payable 14 Long-term notes payable 15 Common stock, $10 par value 16 Retained earnings 17. 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 S523,000 $75,250 1,01,500 163,500 104,750 $343,500 $$1,250 83,500 163,500 79,250 $377,500 18 19 20 The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: Current Year 1 Year Ago 22 23 $673,500 $532,000 SSSSSSSSSS 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 $411,225 209,550 12,100 9,525 $345,500 134,980 13,300 8,845 28 20 642,400 $31 100 $ 1.90 502,625 $29.375 $1.80 Required: 2 (1-a) Compute days sales uncollected. Graded Worksheet Required: (1-a) Compute days' sales uncollected (Use cells A4 to E29 from the given information to complete this question.) Days' Sales Uncollected Denominator Numerator: Days XXX Days' Sales Uncollected Days' sales uncollected days days DO X Current Year: 1 Year Ago: 1 12 (1-6) Determine if days' sales uncollected improved or worsened in the current year, 13 14 Days' sales uncollected 46 (2-a) Compute accounts receivable turnover 47 AB (Use cells A4 to 629 from the given information to complete this question.) 40 Accounts Receivable Turnover 51 Numerator: Denominator: 5 53 Current Year 54 1 Year Agor 33 56 (2.b) Determine if accounts receivable turnover ratio improved or worsened in the current year 57 58 Accounts receivable turnover 50 (a) Compute inventory turnover 6 3. Use cells A4 to E29 from the given information to complete this question) Accounts Receivable Turnover Accounts receivable turnover times times E F G H D 56 (2-5) Determine if accounts receivable turnover ratio improved or worsened in the current year. 57 58 Accounts receivable turnover 59 60 (3-a) Compute inventory turnover. 61 62 (Use cells A4 to E29 from the given information to complete this question.) 63 64 Inventory Turnover 65 Numerator Denominator 66 67 Current Year: 68 1 Year Ago 69 70 (3-6) Determine if inventory turnover to improved or worsened in the current year, 7 72 Inventory turnover 23 74 (4-a) Compute days sales in inventory TS 70 (Use cells A4 to 29 from the given information to complete this question.) Inventory Turnover Inventory Turnover times times Numerator: Days Sales Uncollected Denominator Days Days Sales In Inventory Days' sales in inventory days days Current Year: 1 Year Ago: B3 34 (4-6) For each ratio, determine if days' sales in inventory improved or worsened in the current year, 36 Days' sales in inventory 0 0