please answer all of them
Exercise 17-9 Analyzing risk and capital structure LO P3 [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 $ 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 $ 75,250 $ 51, 250 98,500 163, 500 131, 100 $523,000 101, 500 163, 500 104, 750 $445, 000 83, 500 163, 500 79, 250 $ 377,500 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 Yr $ 673, 500 $ 411, 225 209, 550 12, 100 9,525 642, 400 $ 31, 100 $ 1.90 1 Yr Ago $ 532, 000 $ 345, 500 134, 980 13, 300 8, 845 502, 625 $ 29, 375 $ 1.80 For both the Current Year and 1 Year Ago, compute the following ratios: Exercise 17-9 Part 1 (1) Debt and equity ratios. Debt Ratio Choose Denominator: Choose Numerator: Debt Ratio Debt ratio Current Year: 1 Year Ago: Equity Ratio Choose Denominator: Choose Numerator: Equity Ratio Equity ratio I Current Year: 1 Year Ago: = = Exercise 17-9 Part 2 (2) Debt-to-equity ratio Debt-To-Equity Ratio I Choose Denominator: Choose Numerator: = Debt-To-Equity Ratio Debt-to-equity ratio 0 to 1 0 to 1 Current Year: 1 Year Ago: 1 I = = 13 Exercise 17-9 Part 3 (3-a) Times interest earned. (3-b) Based on times interest earned, is the company more or less risky for creditors in the Current Year versus 1 Year Ago? Complete this question by entering your answers in the tabs below. Required 3A Required 3B Times interest earned. Times Interest Earned 1 Choose Denominator: Choose Numerator: = Times Interest Earned Times interest earned times times ces Current Year: 1 Year Ago: Required 3A Required 3B > Exercise 17-10 Part 1 (1-a) Profit margin ratio. (1-b) Did profit margin 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 Profit margin ratio. Profit Margin Ratio 1 Choose Denominator: Choose Numerator: Profit Margin Ratio Profit margin ratio Current Year: 1 Year Ago: Required 1A Required 1B > Exercise 17-10 Part 2 (2) Total asset turnover. Total Asset Turnover 1 Choose Denominator: Choose Numerator: Total Asset Turnover Total asset turnover times Current Year: 1 Year Ago: times Exercise 17-10 Part 3 (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 3A Required 3B Return on total assets Return On Total Assets Choose Numerator: Choose Denominator: Return On Total Assets Return on total assets Current Year: 1 Year Ago: Required 3A Required 3B >
