teution oych Exam Re 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 pafto this area. If you complete with excellword 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 sales in receivables 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 is $45.00/ Share industry Average for Chapter 3 graded docx Financial statement for graded chapter 3 pdf 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 50.0 27.0 2017 544,846 296,324 248,522 Teacher Corporation Income Statement For the years ended December 31, 2018 and 2017 2018 Sales Revenue 573,522 Cost of goods Sold 302,371 Gross Profit 271,151 Operating Expenses Selling Expenses 55,491 General and Administrative Expenses 33,038 Total Operating Expenses 88,529 Operating Income 182,622 Other income (Expense) Interest and dividend revenue 26,400 Interest expense (14,522) Total other income and expense Net Income 52,387 35,185 87,572 160,950 25,000 (13,848) 11,152 11.878 172,102 2017 544,846 296,324 248,522 Teacher Corporation Income Statement For the years ended December 31, 2018 and 2017 2018 Sales Revenue 573,522 Cost of goods Sold 302,371 Gross Profit 271,151 Operating Expenses Selling Expenses 55,491 General and Administrative Expenses 33,038 Total Operating Expenses 88,529 Operating Income 182,622 Other income (Expense) Interest and dividend revenue 26,400 Interest expense (14,522) Total other income and expense 11,878 Net Income 194,500 $2,387 35,185 87,572 160,950 25,000 [13.848) 11,152 172,102 there is no palance sheet. What do we do then? teution oych Exam Re 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 pafto this area. If you complete with excellword 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 sales in receivables 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 is $45.00/ Share industry Average for Chapter 3 graded docx Financial statement for graded chapter 3 pdf 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 50.0 27.0 2017 544,846 296,324 248,522 Teacher Corporation Income Statement For the years ended December 31, 2018 and 2017 2018 Sales Revenue 573,522 Cost of goods Sold 302,371 Gross Profit 271,151 Operating Expenses Selling Expenses 55,491 General and Administrative Expenses 33,038 Total Operating Expenses 88,529 Operating Income 182,622 Other income (Expense) Interest and dividend revenue 26,400 Interest expense (14,522) Total other income and expense Net Income 52,387 35,185 87,572 160,950 25,000 (13,848) 11,152 11.878 172,102 2017 544,846 296,324 248,522 Teacher Corporation Income Statement For the years ended December 31, 2018 and 2017 2018 Sales Revenue 573,522 Cost of goods Sold 302,371 Gross Profit 271,151 Operating Expenses Selling Expenses 55,491 General and Administrative Expenses 33,038 Total Operating Expenses 88,529 Operating Income 182,622 Other income (Expense) Interest and dividend revenue 26,400 Interest expense (14,522) Total other income and expense 11,878 Net Income 194,500 $2,387 35,185 87,572 160,950 25,000 [13.848) 11,152 172,102 there is no palance sheet. What do we do then