With the information provided in the balance sheets and journals please help me find the average inventory for 2022 and 2021, the inventory turnover for both years, the net plant assets for both years and long term liabilities for both years. Circled the areas that I need to fill in, the rest of the slides are just orbiting the information beefed for the answers

X V fx Cells 2021:365/ Editing Analysis A B. Calculation 2022:365/ C D E F G H SOLVENCY to assets 2021:365/ 2022 2021 2020 2019 0.79 0.76 Formula Total liabilities / total assets Calculate Total A 53335 409 /12335 53811 51248 Total E 11232 to equity 12827 14440 3.75 3.20 Total L 42103 40984 Form total liabilities / total equity EBIT 3418 8907 Calc 2022:42103/11232 Int exp 478 421 ber d 2021:40984/12827 15 21.16 ormula EBIT / Interest expense Calculation 2022:3418/478 assets to long-term liabilities 2021:8907/421 + Formula Net plant assets / Long-term liabilities (debt and borrowings) Calculation PROFITABILITY margin (return on sales) 0.03 2022 2021 2020 2019 Formula Net incomeet sales NI 2780 6946 4368 Calculation 2092.2700 /400490 net sales 109120 106005 93561 .04 2.02 avg total assets 53573 52529.5 25624 Formula Net sales / average total assets - 1 .. ... SECTION 1 - B SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - ... + Accessibility: InvestigateA B C D E F G INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert 3 additional rows based on the actual Target Consolidated statement. FY 2022 % FY 2021 % 4 Sales $ 109,120 100.00% 106,005 100.00% 5 Cost of sales 82,229 75.36% 74,963 70.72% 6 Gross margin $ 26,891 24.64% $ 31,042 29.28% Selling, general, and administrative expenses 20,658 18.93% 19,752 18.63% 8 Depreciation and amortization 2,385 2.19% 2,344 2.21% 9 Gain on sale 0.00% 0.00% 10 Earnings from continuing operations before interest and taxes $ 3,848 3.53% $ 8,946 8.44% 11 Net interest expense S 478 0.44% 421 0.40% 12 Net other (income)/ expense (48) -0.04% S (382) -0.36% 13 Earnings from continuing operations before income taxes 3,418 3.13% $ 8,907 8.40% 14 Provision for income taxes S 638 0.58% S 1,961 1.85% 15 Net earnings from continuing operations $ 2,780 2.55% S 6,946 6.55% + 16 Discontinued operations, net of tax S 0:00% S 0.00% 17 Net earnings/(loss) $ 2,780 2.55% $ 6,946 6.55% 18D E F Vertical Analysis - Balance Sheets 2 Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. You may have to insert additional rows based on the actual Target 3 Consolidated statement. FY 2022 % FY 2021 % 4 ASSETS 5 Cash and cash equivalents $ 2,229 4.18% S 5,911 10.98% Inventory $ 13,499 25.31% $ 13,902 25.83% 7 Assets of discontinued operations 0.00% S 0.00% Other current assets $ 2,118 3.97% S 1,760 3.27% 9 Total current assets S 17,846 33.46% S 21,573 40.09% 10 Property and equipment 0.00% 0.00% 11 Land S 6,231 11.68% 6,164 11.45% Buildings and equipment $ 34,746 65.15% 32,985 61.30% 12 13 Fixtures and equipment S 7,439 13.95% S 6,407 11.91% 3,039 5.70% S 2,505 4.66% 14 Computer hardware and software S 2 688 5 049% 1 257 2 34% 15 Construction-in-progress SECTION 1B SECTION 1 SECTION 1- SECTION 2 - Ratio Analysis.A B C D E F G 14 Computer hardware and software S 3,039 5.70% S 2,505 4.66% 15 Construction-in-progress S 2,688 5.04% S 1,257 2.34% 16 Accumulated depreciation $ (22,631) -42.43% $ (21,137) 17 Property and equipment, net S 31,512 59.08% $ 28,181 52.37% 18 Operating lease assets S 2,657 4.98% 2,556 4.75% 19 Other noncurrent assets S 1,320 2.47% $ 1,501 2.79% 20 Total assets 53,335 100.00% $ 53,811 UHHUH 21 LIABILITIES 22 Accounts payable 13,487 25.29% $ 15,478 28.76% 23 Accrued and other current liabilities 5,883 11.03% S 6,098 11.33% 24 Current portion of long-term debt and other borrowings S 130 0.24% 171 0.32% 25 Liabilities of discontinued operations 0.00% S 0.00% 26 Total current liabilities 19,500 36.56% $ 21,747 40.41% 27 Long-term debt and other borrowings S 16,009 30.02% $ 13,549 25.18% 28 Deferred income taxes $ 2,638 4.95% $ 1,566 2.91% 29 Noncurrent liabilities of discontinued operations S 2,196 4.1.2% $ 2,493 4.63%B C D E F 29 Noncurrent liabilities of discontinued operations 2,196 4.12% S 2,493 4.63% 30 Other noncurrent liabilities $ 1,760 3.30% S 1,629 3.03% 31 Total noncurrent liabilities S 22,603 42.38% S 19,237 35.75% 32 Total liabilities 42,103 78.94% $ 40,984 76.16% 33 SHAREHOLDERS' INVESTMENT 0.00% 0.00% Common stock S 38 0.07% S 39 0.07% 35 Additional paid-in capital 6,608 12.39% S 6,421 11.93% 36 Retained earnings 5,005 9.38% S 6,920 12.86% 37 Accumulated other comprehensive loss S (419) 0.79% S (553) -1.03% 38 Total shareholders' investment 11,232 21.06% S 12,827 23.84% 39 Total liabilities and shareholders investment 53,335 100.00% S 53,811 40 41 42 43 44 45Target Corporation INSTRUCTIONS: Change XX to the year of the report you are analyzing. FY 2022 FY 2021 $ Change % Change FY 2020 $ Change % Cha Total Revenue $ 109,120 $106,005 S 3,115 2.94% $ 93,561 $ 12,444 Cost of sales (82,229) $ (74,963) $ (7,266) 9.69% S (66,177) $ (8,786) Selling, general, and administrative expenses (20,658) $ (19,752) (906) 4.59% S (18,615) $ (1,137) Depreciation and amortization (2,385) $ (2,344) S (41) 1.75% $ (2,230) S (114) Operating Income $ 3,848 $ 8,946 S (5,098) -56.99% S 6,539 S 2,407 Net other (income)/ expense S (478) $ (421) S (57) 0.00% S (16) S (405) Net interest expense S 48 S 382 S (334) -87.43% S (977) S 1,359 Earnings from continuing operations before income taxes S 3,418 $ 8,907 S (5,489) -61.63% $ 5,546 3,361 Provision for income taxes S 638 $ 1,961 S (1,323) -67.47% S 1,178 783 Net earnings from continuing operations S 2,780 $ 6,946 S (4,166) -59.98% S 4,368 2,578 Discontinued operations, net of tax S S S #DIV/O! S #DI 2,780 6,946 S (4,166) -59.98% $ 4,368 S Net earnings/(loss) 2,578Horizontal Analysis of the Balance Sheets N Target Corporation 3 INSTRUCTIONS: Change XX to the year of the report you are analyzing. FY 2022 FY 2021 $ Change % Change FY 2020 $ Change % Change 4 ASSETS 5 Cash and cash equivalents 2,229 $ 5,911 $ (3,682) -62.29% $ 8,511 $ (2,600) -30.55% 6 Inventory 13,499 S 13,902 (403) -2.90% $ 10,653 3,249 30.50% 7 Assets of discontinued operations S 0.00% $ 0.00% 8 Other current assets S 2,118 S +60 358 20.34% $ 1,592 $ 168 10.55% 9 Total current assets 17,846 $ 21,573 S (3,727) -17.28% $ 20,756 $ 817 3.94% 10 Property and equipment 11 Land 6,231 $ 6,164 67 1.09% $ 6, 141 $ 23 0.37% 12 Buildings and equipment 34,746 32,985 S 1,761 5.34% $ 31,557 $ 1,428 4.53% 13 Fixtures and equipment 7,439 6,407 S 1,032 16.11% $ 5,914 $ 493 8.34% 14 Computer hardware and software S 3,039 S 2,505 U . 534 21.32% $ 2,765 S (260) -9.40% 15 Construction-in-progress 2,688 S 1,257 1,431 113.84% S 780 S 477 61.15% 16 Accumulated depreciation S (22,631) $ (21,137) $ (1,494) 7.07% S (20.278) $ (859) 4.24% SECTION 1 -A B C 15 D Construction-m-progress E F G H 2,688 1, 257 1,431 113.840 5 180 5 477 61.15% 16 Accumulated depreciation S (22,631) $ (21,137) (1,494) 7.07% $ (20,278) $ (859 4.24% 17 Property and equipment, net 31,512 $ 28,181 3,331 11.82% $ 26,879 $ 1,302 4.84% 18 Noncurrent assets of discontinued operations 0.00% S 0.00% 19 Operating Lease Assets S 2,657 2,556 101 0.00% $ 2,227 $ 0.00% 20 Other noncurrent assets S 1,320 S 1,501 (181) -12.06% $ 1,386 S 115 8.30% 21 Total assets $ 53,335 53,811 S (476) -0.88% 51,248 2,563 5.00% 22 LIABILITIES 23 Accounts payable $ 13,487 $ 15-478 $ (1,991) -12.86% $ 12,859 $ 2,619 20.37% 24 Accrued and other current liabilities 5,883 S 6,098 (215) -3.53% $ 6,122 (24) -0.39% 25 Current portion of long-term debt and other borrowings S 130 S 171 S (41) -23.98% $ 1,144 (973) -85.05% 26 Liabilities of discontinued operations 0.00% $ #DIV/O! 27 Total current liabilities S 19,500 $ 21,747 S (2,247) -10.33% $ 20,125 1,622 8.06% 28 Long-term debt and other borrowings S 16,009 13,549 S 2,460 18.16% S 11,536 $ 2,013 17.45% 29 Noncurrent operating lease liabilities S 2,638 S 2,493 $ 145 0.00% S 2,218 275 0.00% 30 Deferred income taxes S 2,196 S 1,566 US . 630 40.23% S 990 S 576 58.18% 21 Noncurrent liabilities of discontinued Anorations n nnok n nnow SECTION 1 - A SECTION 1 - B SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis.. + Ready Accessibility. InvestigateA B C D E F G 29 Noncurrent operating lease liabilities H S 2,638 | $ 2,493 $ 145 0.00% S 2,218 $ 275 0.00% 30 Deferred income taxes S 2,196 S 1,566 S 630 40.23% $ 990 S 576 58.18% 31 Noncurrent liabilities of discontinued operations 0.00% 0.00% 32 Other noncurrent liabilities S 1,760 $ 1,629 131 8.04% $ 1,939 $ (310) -15.99% 33 Total noncurrent liabilities S 22,603 $ 19,237 S 3,366 17.50% $ 16,683 S 2,554 15.31% 34 Total liabilities S 42,103 40,984 S 1,119 2.73% $ 36,808 $ 4,176 11.35% 35 SHAREHOLDERS' INVESTMENT 36 Common stock S 38 S 89 (1) -2.56% 42 (3) -7.14% 37 Additional paid-in capital S 6,608 S 6,421 187 2.91% $ 6,329 92 1.45% 38 Retained earnings S 5,005 S 6,920 S (1,915) -27.67% 8,825 (1,905) -21.59% 39 Accumulated other comprehensive loss (419 (553) 134 -24.23% (756) $ 203 0.00% 40 Total shareholders' investment 11,232 $ 12,827 S (1,595) -12.43% S 14,440 S (1,613) -11.17% 41 Total liabilities and shareholders' investment S 53,335 $ 53,811 (476) -0.88% $ 51,248 $ 2,563 5.00% 42 43B C D E F G 5 FY 2021 FY 2020 FY 2019 FY 2018 6 Sales FY 2017 % change 2017-2018 106,005 S 93,561 $ 78,112 $ 75,356 $ 72,714 7 Relevant expenses: 3. Co Cost of sales $ 74,963 $ 66,177 S 54,864 53,299 51,125 4. Selling, general, and administrative expense 19,752 S 18,615 S 16,233 S 15,723 $ 15,140 3. 10 Depreciation and amortization S 2,344 S 2,230 S 2,357 S 2,224 S 2,225 -0.( 11 Total relevant expenses S 97,059 S 87,022 $ 73,454 $ 71,246 | $ 68,490 4. 12 Budgeted and actual income statement accounts FY 2020-2021 13 Actual 2021 Average % change 2017-2021 Budget 2022 Actual 2022 Difference difference from budgeted ar 14 Sales $ 106,005 10.09% $ 116,703 S 109,120 S (7,583 -6. 15 Relevant expenses: 16 Cost of sales S 74,963 10.27% S 82,663 S 82,229 S (434) -0 .! 17 Selling, general, and adminstrative expense S 19,752 6.97% 21,129 S 20,658 S 471 -2.. 18 Depreciation and amortization S 2,344 1.41% 2,377 S 2,385 S 8 O.. Total relevant expenses S 97,059 9.28% $ 106,068 S 105,272 (796) -0. ... SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget + 100% Ready 8% Accessibility. Investigate 9:07 PMG K M N O 4 5 17 % change 2017-2018 change 2018-201%% change 2019-202 % change 2020-2021 verage % change 2017-2021 6 714 3.63% 3.66% 19.78% 13.30% 10.09% 7 8 125 4.25% 2.94% 20.62% 13.28% 10.27% 9 140 3.85% 3.24% 14.67% 6.11% 6.97% 10 225 -0.04% 5.98% -5.39% 5.11% 1.41% 11 490 4.02% 3.10% 18.47% 11.53% 9.28% 12 13 nce difference from budgeted amount 14 583 -6.50% 15 16 434 0.52% 17 471 -2.23% 18 0.33% 19 796 -0.75% ... SECTION 1 - C SECTION 1 - D SECTION 2 - Ratio Analysis SECTION 3 - Budget + Ready 8% Accessibility. Investigate8 Current ratio B. 2021:21573-21747 9 Formula curr liab 19500 current assets / current liabilities 21747 10 COGS 82729 Calculation 2022:17846/19500 74963 11 Quick ratio inventory 13499 13902 2021:21573/21747 12 Formula current assets - inventory / current liabilities 13 Calculation 2022:17846/19500 14 Inventory turnover 24747 15 Formula Cost of goods sold / average inventory 16 Calculation 2022:82229/ 17 Average days to sell inventory 2021:74963/ 18 Formula 365 / inventory turnover 19 Calculation 2022:365/ 20 SOLVENCY 2022 2021 2020 21 Debt to assets 2021:365/ 0.76 Formula Total liabilities / total assets Total A 53335 53811 51248 22 2022:42103/53335 Total E 11232 12827 14440 23 4/53811 3.75 3.20 Total L 42103 40984 24 Debt to equity equity EBIT 3418 8907 25 Formula total liabilities / to Int exp 478 421 26 Calculati 2022:42103/11232 27 Number of times interest is earn 2021:40984/12827 7.15 21.16