please do it in a table , like the problem! thank you :)
ork Saved Required information (The following information applies to the questions displayed below.) Simon Company's year-end balance sheets follow. 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 $ 38,267 89,000 113,000 12,323 377, 117 $629,707 $ 44,731 $ 44,785 62,600 50,000 83,500 53,000 11,742 4,976 340, 278 286,439 $ 542,851 $ 439,200 $ 94,494 $ 59,714 $161,501 121,936 162,500 183,770 $629,707 128, 601 99,975 162,500 162,500 157, 256 117,011 $ 542,851 $ 439,200 The company's income statements for the Current Year and 1 Year Ago, follow. Assume that all sales are on 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 $ 818,619 $ 499,358 253,772 13,917 10,642 777,689 $ 40,930 $ 2.52 1 Yr Ago $ 645,993 $ 419,895 163,436 14,858 9,690 607,879 $ 38, 114 $ 2.35 (4-a) Compute days' sales in inventory. (4-b) For each ratio, determine if it improved or worsened in the current year. work Saved Cost of goods sold Other operating expenses Interest expense Income tax expense Total costs and expenses Net income Earnings per share $ 499, 358 253,772 13,917 10,642 $ 419,895 163,436 14,858 9,690 777,689 $ 40,930 2.52 687,879 $ 38, 114 $ 2.35 (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 48 Compute days' sales In Inventory Days Sales In Inventory Choose Denominator Choose Numerator Days 1 Days' Sales In Inventory Days' sales in inventory o days O days Current Yr: 1 Ye Ago: X Required 40 > work i Saved 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 $ 818,619 $ 499,358 253,772 13,917 10,642 777,689 $ 40,930 $ 2.52 1 Yr Ago $ 645,993 $ 419,895 163,436 14,858 9,690 607,879 $ 38, 114 $ 2.35 (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 48 For each ratio, determine if it improved or worsened in the current year, Days' sales in inventory Required AA