Domeone please help me solve this question. would very much appreciate it.
15 Required information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below) Simon Company's year end balance sheets follow At December 31 Current Year 1 Year Ago 2 Years Ago Assets Cash $ 24,653 $ 29,111 $ 30,631 Accounts receivable.net 70,723 51,974 40,432 Merchandise inventory 88,921 68,000 44,374 Prepaid expenses 8,182 7,565 3,403 Plant assets, net 233,899 210,917 190,560 Total assets $426,378 $367,567 $ 309,400 Liabilities and Equity Accounts payable $ 188,291 $ 61,498 $ 41,249 Long-term notes payable 80, 159 84,548 67.010 Common stock, $10 par value 163,500 163,588 162,500 Retained earnings 74,428 58,029 38,641 Total liabilities and equity $426,378 $367,567 $ 389,400 For both the current year and one year ago, compute the following ratios: Exercise 13-10 (Algo) Analyzing efficiency and profitability LO P3 The company's income statements for the current year and 1 year ago, follow. For Year Ended December 31 Sales Cost of goods sold Current Year $ 554,291 5.338, 118 1 Year Ago $ 437,485 $ 284,313 Exercise 13-10 (Algo) Analyzing efficiency and profitability LO P3 The company's income statements for the current year and 1 year ago, follow 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 Year $ 554,291 $ 338, 118 171,830 9,423 7,206 526,577 $ 27,714 $ 1.71 1 Year Ago $ 437,405 $ 284,313 110,663 10,060 6,561 411, 597 $ 25,888 $ 1.59 For both the Current Year and 1 Year Ago, compute the following ratios: (-a) Profit margin ratio (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (3.a) Return on total assets. (3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago? Complete this question by entering your answers in the tabs below. Required information (7-a) Pront margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (3-a) Return on total assets. (3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago? Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 2 Required 3A Required 38 Compute profit margin ratio for the current year and one year ago Profit Margin Ratio Denominator: Numerator Protit Margin Ratio Profit margin ratio Current Year: 1 Year Ago: 4 of 5 (1-a) Profit margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover, (3-a) Return on total assets. (3-6) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago? whool Complete this question by entering your answers in the tabs below. Required 1A Required 15 Required 2 Required 3A Required 38 Did profit margin improve or worsen in the Current Year versus 1 Year Ago? Print Profit margin (2) Total asset turnover. ins (3-a) Return on total assets. (3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago? woor Complete this question by entering your answers in the tabs below. Hie Required 1A Required 1B Required 2 Required 3A Required 38 Compute total asset turnover for the current year and one year ago Print Total Asset Turnover Denominator cences Numerator: Current Year: 1 Year Ago: Total Asset Turnover Total asset tumover times times (1-a) Profit margin ratio. 11-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (3-a) Return on total assets (3-6) Based on return on total assets, did Simon's operating efficiency improve or worson in the Current Year versus 1 Year Ago? Complete this question by entering your answers in the tabs below. Required IA Required 1B Required 2 Required 3A Required 38 Compute return on total assets for the current year and one year ago. Return On Total Arts Denominator: Numerator Return On Total Assets Current Year: 1 Year Ago: Return on total assets % % For both the Current Year and 1 Year Ago, compute the following ratios: (1-a) Profit margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (3-a) Return on total assets (3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago? Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 2 Required 3A Required 38 Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago? Return on total assets