Homework Assignment AA

For the following section, you will need to provide your calculations in excel and a brief write-up of the results.  Please be sure that the calculations are available for review for partial credit.

SOURCE:

https://www.sec.gov/ix?doc=/Archives/edgar/data/47111/000004711119000010/a2018form10-kq4.htm

Ratio analysis:

• Calculate the ratios below for each year you are able to based on the current financial statements, using the formulas in the text:
  • Working capital
  • Current ratio
  • Quick ratio
  • Accounts receivable turnover
  • Number of days' sales in receivables
  • Inventory turnover
  • Number of days' sales in inventory
  • The ratio of fixed assets to long-term liabilities
  • The ratio of liabilities to stockholders' equity
  • The number of times interest charges are earned
  • Ratio of net sales to assets
  • Rate earned on total assets
  • Rate earned on stockholders' equity
  • Earnings per share on common stock – this should be given to you in the financial statements and not a calculation you need to make.
  • Dividends per share – this should be given to you in the financial statements and not a calculation you need to make
• Provide a brief analysis of what the ratio indicates for your company
• Calculate the common-sized balance sheet and income statement (vertical analysis)
• Based on the calculations, how do you feel your company is doing?