Pick of ONE of these public companies, and access the 2019 annual report

1. Costco

2. Target

Find the financial statements in the annual report and create an Excel spreadsheet to calculate the following ratios:

Current ratio

AR Turnover

Inventory turnover

Debt to assets

Profit margin

Gross profit rate

Asset turnover

Then setup the past 2 years side by side in Excel and create a horizontal analysis, and vertical analysis.