6 Part 5 of 6 Required Information [The following Information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. 0.42 points Skipped At December 31 Assets Current Year 1 Year Ago 2 Years Ago Cash $ 25,451 Accounts receivable, net Merchandise inventory 73,028 90,892 8,032 233,978 eBook Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable $ 431,381 $ 107,414 Long-term notes payable. Hint Common stock, $10 par value Retained earnings Total liabilities and equity 79,478 163,500 80,989 $ 29,453 51,022 70,862 7,731 212,812 $ 371,880 $ 62,848 88,098 163,500 57,434 $ 431,381 $ 371,880 $ 31,294 41,316 44,446 3,409 189,435 $ 309,900 $ 41,316 67,803 163,500 37,281 $ 309,900 Print References For both the current year and one year ago, compute the following ratios: $ 442,537 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 Current Year $ 342,085 173,846 9,534 7,290 1 Year Ago $ 560,795 $ 287,649 111,962 10,178 6,638 532,755 $ 28,040 416,427 Earnings per share $ 1.73 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. $ 26,110 $ 1.61 (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 1B Required 2 Required 3A Required 3B Compute profit margin ratio for the current year and one year ago. Current Year: 1 Year Ago: Numerator: Profit Margin Ratio Denominator: = Profit Margin Ratio = Profit margin ratio = %6 = % Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2 Required 3A Required 3B Did profit margin improve or worsen in the Current Year versus 1 Year Ago? Profit margin Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2 Required 3A Required 38 Compute total asset turnover for the current year and one year ago. Current Year: 1 Year Ago: Total Asset Turnover Numerator: Denominator: = Total Asset Turnover = Total asset turnover = times = times Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2 Required 3A Required 3B Compute return on total assets for the current year and one year ago. Current Year: 1 Year Ago: Numerator: Return On Total Assets Denominator: = Return On Total Assets = Return on total assets = % = % Complete this question by entering your answers in the tabs below. Required 1A Required 1B 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