Please be reminded – this project is to be done as a regular paper, with a header page – PLEASE DO NOT USE MEMO FORMAT

Please be reminded – this project is to be done as a regular paper, with a header page – PLEASE DO NOT USE MEMO FORMAT

Using the same company that you identified in previous assignments, continue your analysis of the companies by preparing the following:

1. Calculate the profitability ratios of gross profit margin and net profit margin for two years.

2. Calculate the liquidity ratios of current ratio and quick ratio for two years.

3. Calculate the solvency ratio of the debt-to-assets ratio for two years.

4. Calculate the efficiency ratios of inventory turnover, days in inventory, receivables turnover, days sales outstanding, payables turnover, and days payables outstanding for two years.

Submit your calculations (preferably in an Excel spreadsheet), (sample of the caculations from starbucks company is attached below). Make sure I can follow your calculations. Also, include your analysis of the data (should be at least 2-3 pages – not including a header/title page and reference page)

Reminder: This assignment is analyzing the TWO companies you have chosen in the industry of choice (10-k files attached below). So there should be separate files of submissions for each of the companies, meaning 2 excel spreadsheets of the calculations, and 2 analysis of the data files for each company.