practice Due Date: March 30, 2020 11:59:00 PM EDT Graded Assignment Ratios Attached les financial statement for graded chapter 3 pdf 169.554 KB) Industry Average for Chapter 3 graded docx (12276 KB) Using the financial statement in the attached file, complete the ratio analysis either in excel OR on paper. If on paper you must scan then upload the pdf to this area. If you complete with exceword please save and upload the file to this area. Specifically you will calculate the ratio, explain what the ratio means and then compare it to the industry average and discuss that comparison. I would like to see you use a separate column for each item Ratio Calculation Explain what it means Explain how company compares to industry average Ratios 1. Current ratio 2. Acid test ratio 3. Inventory turnover 4. Days sales in inventory 5. Accounts Receivable turnover 6. Days Wales in recewables 7. Profit margin 8. Rate of return on assets 9. Rate of return on Stockholder's Equity 10. Rate of return on common stockholders equity 11. Debt Ratio 12. Times Interest Earned Ratio 13. Earnings per share 14. Price Earnings Ratio Market Price of the company's stock at 12/31/18 145.00/ Share Extra Credit Chapter 3 parts b&c 4 parts practice Due Date: April 18, 2020 11 59.00 PM EDT acer Ratio Industry Average Current Ratio Acid test Ratio Inventory Turnover Days sales in Inventory Accounts Receivable Turnover Days Sales in Receivables Profit Margin Rate of Return on Total Assets Rate of Return on Stockholders' Equity Rate of Return on Common Stockholders' Equity Earnings Per Share Debt Ratio Times Interest Earned Ratio Price Earning's Ratio 1.8 0.9 2.0 187.2 3.1 117.7 0.3 0.2 Teacher Corporation Income Statement For the years ended December 31, 2018 and 2017 2018 573,522 2017 302,371 544,846 296,324 248,522 271,151 Sales Revenue Cost of goods Sold Gross Profit Operating Expenses Selling Expenses General and Administrative Expenses Total Operating Expenses Operating income Other income (Expense) Interest and dividend revenue Interest expense Total other income and expense Net Income 55,491 33,038 88,529 182,622 52,387 35,185 87.572 160,950 26,400 (14.522) 11,878 25,000 (13,848 11,152 172.102 194,500 arer practice Due Date: March 30, 2020 11:59:00 PM EDT Graded Assignment Ratios Attached les financial statement for graded chapter 3 pdf 169.554 KB) Industry Average for Chapter 3 graded docx (12276 KB) Using the financial statement in the attached file, complete the ratio analysis either in excel OR on paper. If on paper you must scan then upload the pdf to this area. If you complete with exceword please save and upload the file to this area. Specifically you will calculate the ratio, explain what the ratio means and then compare it to the industry average and discuss that comparison. I would like to see you use a separate column for each item Ratio Calculation Explain what it means Explain how company compares to industry average Ratios 1. Current ratio 2. Acid test ratio 3. Inventory turnover 4. Days sales in inventory 5. Accounts Receivable turnover 6. Days Wales in recewables 7. Profit margin 8. Rate of return on assets 9. Rate of return on Stockholder's Equity 10. Rate of return on common stockholders equity 11. Debt Ratio 12. Times Interest Earned Ratio 13. Earnings per share 14. Price Earnings Ratio Market Price of the company's stock at 12/31/18 145.00/ Share Extra Credit Chapter 3 parts b&c 4 parts practice Due Date: April 18, 2020 11 59.00 PM EDT acer Ratio Industry Average Current Ratio Acid test Ratio Inventory Turnover Days sales in Inventory Accounts Receivable Turnover Days Sales in Receivables Profit Margin Rate of Return on Total Assets Rate of Return on Stockholders' Equity Rate of Return on Common Stockholders' Equity Earnings Per Share Debt Ratio Times Interest Earned Ratio Price Earning's Ratio 1.8 0.9 2.0 187.2 3.1 117.7 0.3 0.2 Teacher Corporation Income Statement For the years ended December 31, 2018 and 2017 2018 573,522 2017 302,371 544,846 296,324 248,522 271,151 Sales Revenue Cost of goods Sold Gross Profit Operating Expenses Selling Expenses General and Administrative Expenses Total Operating Expenses Operating income Other income (Expense) Interest and dividend revenue Interest expense Total other income and expense Net Income 55,491 33,038 88,529 182,622 52,387 35,185 87.572 160,950 26,400 (14.522) 11,878 25,000 (13,848 11,152 172.102 194,500 arer