A Ratio Analysis

 The Financial Statements  For 2017 To Do A Ratio Analysis For His Company. Please Complete Part 1 And Part 2.

PART 1

You are to show the formulas for each of the ratio analysis listed below (you do not need to do all of the calculations, however), and choose the 3 that you feel will provide the most information to the owner. Using the financial statements provided, do the calculations for those 3 ratios, and show your work in an Excel document. 

• Current ratio
• Acid-test (quick) ratio
• Debt ratio
• Inventory turnover
• Accounts receivable turnover
• Return on net sales
• Return on total assets
• Return on common stockholder’s equity
• Earnings per share