Download the excel version of the quarterly (e.g. 26-week ended July 30, 2022) reports of Target Corporation for the four quarter-periods ended from 2019 to 2022. The quarter of interest is the two-quarter results ended on July 30, 2022 while the prior period figures (2019 to 2021) are used to develop a trend for the ratios. See note 1 on the various types of reports available on EDGAR.

You are required to:

(a) Calculate the following ten ratios for the four periods.

(b) With seasonality factor controlled (same quarters last year), study the performance and financial position over time and comment on liquidity, profitability and solvency accordingly. Include a word count on the narrative part (not exceeding 300 words).

Calculate 10 ratios:

Current ratio

Current Cash Debt coverage

Inventory turnover

Gross Profit ratio

Profit Margin

Asset Turnover

Free Cash Flow

Debt to Asset ratio

Cash Debt coverage