Financial Statement Case 17-1

Requirements - Please note for this assignment you must use spreadsheet software as required in your Excel Assignments.

1. Compute trend analyses for both Sales and Net earnings / (loss). Use 2019 as the base year. Make sure this report is in the proper format. What is the most notable aspect of these data?
2. Using the proper format, perform a vertical analysis for Target Corporations balance sheet as of January 29, 2022 (fiscal year 2021), and January 30, 2021 (fiscal year 2020). Include only these main categories:

Assets:

Total current assets

Property and equipment, net

Operating lease assets

Other noncurrent assets

Total assets

Liabilities and shareholders investment:

Total current liabilities

Total noncurrent liabilities

Total shareholders investment

Total liabilities and shareholders investment