Required information [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets...

Transcribed Image Text:

Required information [The following information applies to the questions displayed below.] 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 Current Year 1 Year Ago 2 Years Ago $ 26,850 $ 32,373 Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity 74,738 95,906 8,561 244,527 $ 450,582 $113,317 83,862 $ 31,385 53,837 73,297 7,994 221,920 $ 388,433 89,340 162,500 69,635 162,500 90,903 $ 450,582 $ 388,433 For both the current year and one year ago, compute the following ratios: 42,728 47,841 3,561 203,797 $ 330,300 $ 43,164 72,266 163,500 51,370 $ 330,300 Accounts payable $ 66,958 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 Current Year $357,312 181,585 9,958 1 Year Ago $ 585,757 $462,235 $ 300,453 116,945 10,631 Income tax expense 7,615 6,934 Total costs and expenses Net income 556,470 $ 29,287 434,963 $ 27,272 $ 1.80 $ 1.68 Earnings per share (1-a) 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-a) Compute inventory turnover. (3-b) Determine if inventory turnover ratio improved or worsened in the current year. (3-a) 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 16 Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Compute days' sales uncollected. Current Year: 1 Year Ago: Days' Sales Uncollected Numerator: Denominator: x Days = Days' Sales Uncollected x Days' sales uncollected x x days days Required information [The following information applies to the questions displayed below.] 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 Current Year 1 Year Ago 2 Years Ago $ 26,850 $ 32,373 Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity 74,738 95,906 8,561 244,527 $ 450,582 $113,317 83,862 $ 31,385 53,837 73,297 7,994 221,920 $ 388,433 89,340 162,500 69,635 162,500 90,903 $ 450,582 $ 388,433 For both the current year and one year ago, compute the following ratios: 42,728 47,841 3,561 203,797 $ 330,300 $ 43,164 72,266 163,500 51,370 $ 330,300 Accounts payable $ 66,958 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 Current Year $357,312 181,585 9,958 1 Year Ago $ 585,757 $462,235 $ 300,453 116,945 10,631 Income tax expense 7,615 6,934 Total costs and expenses Net income 556,470 $ 29,287 434,963 $ 27,272 $ 1.80 $ 1.68 Earnings per share (1-a) 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-a) Compute inventory turnover. (3-b) Determine if inventory turnover ratio improved or worsened in the current year. (3-a) 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 16 Required 2A Required 2B Required 3A Required 3B Required 4A Required 4B Compute days' sales uncollected. Current Year: 1 Year Ago: Days' Sales Uncollected Numerator: Denominator: x Days = Days' Sales Uncollected x Days' sales uncollected x x days days