Need Help!

INSTRUCTIONS: Use the Target (TGT) 2021 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal places. Formula is started for you.

Welcome to our To explore key stories of the past year 2021 Annual Report and find out what's ahead, visit Target.com/abullseyeview. You can view our Annual Report online at Target.com/annualreport. Financial Highlights (Note: Reflects amounts attributable to continuing operations. 2017 was a 53-week year.) Total 2021 Sales: $104,611 Million Financial Summary A Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS: Use the 2021 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal 3 places. Formula is started for you. Total Revenue Cost of sales Gross margin Selling, general, and administrative expenses Depreciation and amortization Operating Income Net interest expense Net other (income)/ expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings/(loss) A B CD E 1 Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Use the 2021 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal 3 places. Formula is started for you. \begin{tabular}{c|c|c|c} FY 2021 & & FY 2020 & \\ 1.29.2022 & % & 1.30.2021 & % \\ \hline \end{tabular} 4 ASSETS 5 Cash and cash equivalents 6 Inventory 7 Other current assets 8 Total current assets 9 Property and equipment 10 Land 11 Buildings and improvements 12 Fixtures and equipment 13 Computer hardware and software 14 Construction-in-progress 15 Accumulated depreciation 16 Property and equipment, net 17 Operating Lease Assets 18 Other noncurrent assets 19 Total assets 20 LIABILITIES 21 Accounts payable 22 Accrued and other current liabilities 23 Current portion of long-term debt and other borrowings 24 Total current liabilities 25 Long-term debt and other borrowings 26 Noncurrent operating lease liabilities 27 Deferred income taxes 28 Other noncurrent liabilities 29 Total noncurrent liabilities 30 Total liabilities 31 SHAREHOLDERS' INVESTMENT 32 Common stock 33 Additional paid-in capital 34 Retained earnings 35 Accumulated other comprehensive loss 36 Total shareholders' investment 37 Total liabilities and shareholders' investment Welcome to our To explore key stories of the past year 2021 Annual Report and find out what's ahead, visit Target.com/abullseyeview. You can view our Annual Report online at Target.com/annualreport. Financial Highlights (Note: Reflects amounts attributable to continuing operations. 2017 was a 53-week year.) Total 2021 Sales: $104,611 Million Financial Summary A Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS: Use the 2021 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal 3 places. Formula is started for you. Total Revenue Cost of sales Gross margin Selling, general, and administrative expenses Depreciation and amortization Operating Income Net interest expense Net other (income)/ expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings/(loss) A B CD E 1 Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Use the 2021 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal 3 places. Formula is started for you. \begin{tabular}{c|c|c|c} FY 2021 & & FY 2020 & \\ 1.29.2022 & % & 1.30.2021 & % \\ \hline \end{tabular} 4 ASSETS 5 Cash and cash equivalents 6 Inventory 7 Other current assets 8 Total current assets 9 Property and equipment 10 Land 11 Buildings and improvements 12 Fixtures and equipment 13 Computer hardware and software 14 Construction-in-progress 15 Accumulated depreciation 16 Property and equipment, net 17 Operating Lease Assets 18 Other noncurrent assets 19 Total assets 20 LIABILITIES 21 Accounts payable 22 Accrued and other current liabilities 23 Current portion of long-term debt and other borrowings 24 Total current liabilities 25 Long-term debt and other borrowings 26 Noncurrent operating lease liabilities 27 Deferred income taxes 28 Other noncurrent liabilities 29 Total noncurrent liabilities 30 Total liabilities 31 SHAREHOLDERS' INVESTMENT 32 Common stock 33 Additional paid-in capital 34 Retained earnings 35 Accumulated other comprehensive loss 36 Total shareholders' investment 37 Total liabilities and shareholders' investment