A LIQUIDITY RATIOS B C D E F G 2020 2021 Current ratio 1.03 0.99 Acid...

Transcribed Image Text:

A LIQUIDITY RATIOS B C D E F G 2020 2021 Current ratio 1.03 0.99 Acid test (or quick ratio) 0.45 0.31 SOLVENCY RATIOS Debt to equity ratio 2.55 3.20 Times interest earned ratio 6.68 22.16 PROFITABILITY RATIOS Return on assets (%) 9.29% 13.22% Return on equity (%) 33.25% 50.95% 2022 2023 Instructions: Column E --> Using the financial data provided in the different tabs, calculate the six missing financial ratios for fiscal year 2022. The financial ratios should be calculated using a formula and not keyed in. Input should look like this: "K120/D370" Input should NOT look like this: 0.49 Column F->Develop an estimate for the six missing financial ratios for fiscal year 2023. These inputs do not need to be formulas. 123 4 A Consolidated Statements of Financial Position 5 (millions, except footnotes) B D E F 2022 2021 2020 2019 6 Assets 7 Cash and cash equivalents 2,229 5,911 8,511 2,577 8 Inventory 9 Accounts receivables 10 Vendor income receivable 11 Prepaid expenses 12 Other 13 13,499 13,902 10,653 8,992 1,169 835 631 498 526 518 504 464 188 170 171 154 235 237 286 217 Total current assets 17,846 21,573 20,756 12,902 14 Property and equipment 15 Land 16 Buildings and improvements 17 Fixtures and equipment 6,231 6,164 6,141 6,036 34,746 32,985 31,557 30,603 7,439 6,407 5,914 6,083 18 Computer hardware and software 3,039 2,505 2,765 2,692 19 Construction-in-progress 20 Accumulated depreciation 2,688 1,257 780 533 (22,631) (21,137) (20,278) (19,664) 21 Property and equipment, net 31,512 28,181 26,879 26,283 22 Operating lease assets 2,657 2,556 2,227 2,236 23 Other noncurrent assets 1,320 1,501 1,386 1,358 24 Total assets 53,335 53,811 51,248 42,779 25 26 Liabilities and shareholders' investment 27 Accounts payable 28 Accrued and other current liabilities 13,487 15,478 12,859 9,920 5,883 6,098 6,122 4,406 29 Current portion of long-term debt and other borrowings 130 171 1,144 161 30 Total current liabilities 19,500 21,747 20,125 14,487 31 32 Long-term debt and other borrowings 16,009 13,549 11,536 11,338 33 Noncurrent operating lease liabilities 34 Deferred income taxes 2,638 2,493 2,218 2,275 2,196 1,566 990 1,122 35 Other noncurrent liabilities 1,760 1,629 1,939 1,724 36 Total noncurrent liabilities 22,603 19,237 16,683 16,459 37 38 Shareholders' investment 38 39 42 42 6,608 6,421 6,329 6,226 5,005 6,920 8,825 6,433 (419) (553) (756) (868) Total shareholders' investment 11,232 12,827 14,440 11,833 39 Common stock 40 Additional paid-in capital 41 Retained earnings 42 Accumulated other comprehensive loss 43 44 37 38 Shareholders' investment 39 Common stock 40 Additional paid-in capital 41 Retained earnings 38 39 42 42 6,608 6,421 6,329 6,226 5,005 6,920 8,825 6,433 42 Accumulated other comprehensive loss (419) (553) (756) (868) 43 44 Total shareholders' investment 11,232 12,827 14,440 11,833 45 Total liabilities and shareholders' investment 46 47 53,335 53,811 51,248 42,779 1 2 Consolidated Statements of Operations 3 st 4 5 (millions, except per share data) 2022 2021 2020 6 Sales 107,588 104,611 92,400 7 Other revenue 8 Total revenue 1,532 1,394 1,161 109,120 106,005 93,561 9 Cost of sales 82,229 74,963 66,177 10 Gross profit 26,891 31,042 27,384 11 12 Selling, general and administrative expenses 13 Depreciation and amortization 20,658 19,752 18,615 2,385 2,344 2,230 3,848 8,946 6,539 14 Operating income 15 16 Net interest expense 17 Net other (income) / expense 18 Earnings before income taxes 19 20 Provision for income taxes 21 Net earnings 22 478 421 977 (48) (382) 16 3,418 8,907 5,546 638 1,961 1,178 2,780 6,946 4,368 23 Basic earnings per share 24 Diluted earnings per share 6 14 9 6 14 9 25 26 Weighted average common shares outstanding 27 Basic 462 488 501 28 Diluted 465 493 505 29 Antidilutive shares 1 - - 30 31 A 1 2 Consolidated Statements of Comprehensive Income 1234 4 B C D E 5 (millions) 2022 2021 2020 6 7 Net earnings 2,780 6,946 4,368 8 Other comprehensive income/(loss), net of tax 9 Pension benefit liabilities (113) 152 102 10 Currency translation adjustment and cash flow hedges 247 51 10 11 Other comprehensive income 134 203 112 12 13 Comprehensive income 2,914 7,149 4,480 14 15 A B C D E 123 2 Consolidated Statements of Cash Flows 3 4 5 (millions) 2022 2021 2020 6 Operating activities 7 Net earnings 2,780 6,946 4,368 8 Adjustments to reconcile net earnings to cash provided by operations: 9 Depreciation and amortization 2,700 2,642 2,485 10 Share-based compensation expense 220 228 200 11 Deferred income taxes 582 522 (184) 12 Gain on Dermstore sale - (335) 13 Loss on debt extinguishment - 14 Noncash losses (gains) and other, net 512 172 67 86 15 Changes in operating accounts: 16 Inventory 17 Other assets 18 Accounts payable 403 (3,249) (1,661) 22 (78) (137) (2,237) 2,628 2,925 19 Accrued and other liabilities (624) (746) 1,931 20 21 Investing activities Cash provided by operating activities 4,018 8,625 10,525 22 Expenditures for property and equipment (5,528) (3,544) (2,649) 8 27 42 23 Proceeds from disposal of property and equipment 24 Proceeds from Dermstore sale 25 Other investments 26 27 - 16 356 (3,154) Cash required for investing activities (5,504) - 7 16 (2,591) 27 28 Financing activities 29 Additions to long-term debt 2,625 1,972 2,480 31 Dividends paid 30 Reductions of long-term debt 32 Repurchase of stock 33 Stock option exercises (163) (1,147) (2,415) (1,836) (1,548) (1,343) (2,826) (7,356) (745) 4 8 23 34 35 Cash required for financing activities (2,196) (8,071) (2,000) 36 Net (decrease) / increase in cash and cash equivalents (3,682) (2,600) 5,934 37 Cash and cash equivalents at beginning of period 5,911 8,511 2,577 2,229 5,911 8,511 38 Cash and cash equivalents at end of period 39 40 Supplemental information 41 Interest paid, net of capitalized interest 449 414 939 42 Income taxes paid 213 2,063 1,031 43 Leased assets obtained in exchange for new finance lease liabilities 224 288 428 44 Leased assets obtained in exchange for new operating lease liabilities 329 580 262 45 46 A 2 Consolidated Statements of Shareholders' Investment 3 4 5 (millions) 6 7 February 1, 2020 8 9 Net earnings 10 Other comprehensive income 11 Dividends declared 12 Repurchase of stock 13 Stock options and awards 14 January 30, 2021 (FY2020) 15 16 Net earnings 17 Other comprehensive income 18 Dividends declared 19 Repurchase of stock 20 Stock options and awards 21 January 29, 2022 (FY2021) 22 23 Net earnings 24 Other comprehensive income 25 Dividends declared 26 Repurchase of stock 27 Stock options and awards 28 January 28, 2023 (FY2022) 29 30 31 B C D E F G H Total (868) 11,833 Common Stock Par Retained Stock Shares Value APIC Earnings AOCI 504 6,226 6,433 4,368 - 4,368 112 112 | g | | |g (756) - 203 - (1,367) (609) 103 14,440 6,946 203 (1,655) (7,199) 92 (553) 12,827 3 | | |g | | | |g 2,780 2,780 - 134 134 (1,931) (2,646) 68 (419) 11,232 - (1,367) (609) - 103 6,329 - 8,825 6,946 - (1,655) (7,196) - 6,920 (1,931) (2,764) - | | | | | | | 6,421 (1) 460 38 6,608 5,005 ||||g || |ig (6) 2 501 (31) 2 471 g | | | + ; | | | A B C D E F G H J K L M N P R S T U V W X 1 2 Item 2. Properties 1234 Stores as of January 28, 2023 Montana 6,361 2,732 551 342 725 12,171 6,300 10,332 743 4,618 Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Total Stores as of 5 January 28, 2023 Stores Retail Square Feet (in thousands) 6 Alabama 7 Alaska 8 Arizona 9 Arkansas 10 California 11 Colorado 12 Connecticut 22 3,132 3 46 504 6,081 9 1,165 314 37,304 45 21 13 Delaware 4 14 District of Columbia 5 15 Florida 127 17,225 16 Georgia 17 Hawaii 18 Idaho 19 Illinois 20 Indiana 21 Iowa 22 Kansas 23 Kentucky 24 Louisiana 25 Maine 51 6,826 8 1,234 7 29 Minnesota 30 Mississippi 31 Missouri 32 26 Maryland 27 Massachusetts 28 Michigan 73 6 35 - 4,186 21 2,859 17 2,385 14 1,575 2,195 6 741 41 5,070 50 5,546 54 100 32 Stores N ' 1,948 Retail Square Feet (in thousands) 777 2,005 2,262 1,236 6,189 1,185 10,820 6,653 554 7,863 2,167 2,353 9,260 517 2,389 580 3,815 21,176 1,981 60 7,789 4,424 755 4,614 257 244,584 A LIQUIDITY RATIOS B C D E F G 2020 2021 Current ratio 1.03 0.99 Acid test (or quick ratio) 0.45 0.31 SOLVENCY RATIOS Debt to equity ratio 2.55 3.20 Times interest earned ratio 6.68 22.16 PROFITABILITY RATIOS Return on assets (%) 9.29% 13.22% Return on equity (%) 33.25% 50.95% 2022 2023 Instructions: Column E --> Using the financial data provided in the different tabs, calculate the six missing financial ratios for fiscal year 2022. The financial ratios should be calculated using a formula and not keyed in. Input should look like this: "K120/D370" Input should NOT look like this: 0.49 Column F->Develop an estimate for the six missing financial ratios for fiscal year 2023. These inputs do not need to be formulas. 123 4 A Consolidated Statements of Financial Position 5 (millions, except footnotes) B D E F 2022 2021 2020 2019 6 Assets 7 Cash and cash equivalents 2,229 5,911 8,511 2,577 8 Inventory 9 Accounts receivables 10 Vendor income receivable 11 Prepaid expenses 12 Other 13 13,499 13,902 10,653 8,992 1,169 835 631 498 526 518 504 464 188 170 171 154 235 237 286 217 Total current assets 17,846 21,573 20,756 12,902 14 Property and equipment 15 Land 16 Buildings and improvements 17 Fixtures and equipment 6,231 6,164 6,141 6,036 34,746 32,985 31,557 30,603 7,439 6,407 5,914 6,083 18 Computer hardware and software 3,039 2,505 2,765 2,692 19 Construction-in-progress 20 Accumulated depreciation 2,688 1,257 780 533 (22,631) (21,137) (20,278) (19,664) 21 Property and equipment, net 31,512 28,181 26,879 26,283 22 Operating lease assets 2,657 2,556 2,227 2,236 23 Other noncurrent assets 1,320 1,501 1,386 1,358 24 Total assets 53,335 53,811 51,248 42,779 25 26 Liabilities and shareholders' investment 27 Accounts payable 28 Accrued and other current liabilities 13,487 15,478 12,859 9,920 5,883 6,098 6,122 4,406 29 Current portion of long-term debt and other borrowings 130 171 1,144 161 30 Total current liabilities 19,500 21,747 20,125 14,487 31 32 Long-term debt and other borrowings 16,009 13,549 11,536 11,338 33 Noncurrent operating lease liabilities 34 Deferred income taxes 2,638 2,493 2,218 2,275 2,196 1,566 990 1,122 35 Other noncurrent liabilities 1,760 1,629 1,939 1,724 36 Total noncurrent liabilities 22,603 19,237 16,683 16,459 37 38 Shareholders' investment 38 39 42 42 6,608 6,421 6,329 6,226 5,005 6,920 8,825 6,433 (419) (553) (756) (868) Total shareholders' investment 11,232 12,827 14,440 11,833 39 Common stock 40 Additional paid-in capital 41 Retained earnings 42 Accumulated other comprehensive loss 43 44 37 38 Shareholders' investment 39 Common stock 40 Additional paid-in capital 41 Retained earnings 38 39 42 42 6,608 6,421 6,329 6,226 5,005 6,920 8,825 6,433 42 Accumulated other comprehensive loss (419) (553) (756) (868) 43 44 Total shareholders' investment 11,232 12,827 14,440 11,833 45 Total liabilities and shareholders' investment 46 47 53,335 53,811 51,248 42,779 1 2 Consolidated Statements of Operations 3 st 4 5 (millions, except per share data) 2022 2021 2020 6 Sales 107,588 104,611 92,400 7 Other revenue 8 Total revenue 1,532 1,394 1,161 109,120 106,005 93,561 9 Cost of sales 82,229 74,963 66,177 10 Gross profit 26,891 31,042 27,384 11 12 Selling, general and administrative expenses 13 Depreciation and amortization 20,658 19,752 18,615 2,385 2,344 2,230 3,848 8,946 6,539 14 Operating income 15 16 Net interest expense 17 Net other (income) / expense 18 Earnings before income taxes 19 20 Provision for income taxes 21 Net earnings 22 478 421 977 (48) (382) 16 3,418 8,907 5,546 638 1,961 1,178 2,780 6,946 4,368 23 Basic earnings per share 24 Diluted earnings per share 6 14 9 6 14 9 25 26 Weighted average common shares outstanding 27 Basic 462 488 501 28 Diluted 465 493 505 29 Antidilutive shares 1 - - 30 31 A 1 2 Consolidated Statements of Comprehensive Income 1234 4 B C D E 5 (millions) 2022 2021 2020 6 7 Net earnings 2,780 6,946 4,368 8 Other comprehensive income/(loss), net of tax 9 Pension benefit liabilities (113) 152 102 10 Currency translation adjustment and cash flow hedges 247 51 10 11 Other comprehensive income 134 203 112 12 13 Comprehensive income 2,914 7,149 4,480 14 15 A B C D E 123 2 Consolidated Statements of Cash Flows 3 4 5 (millions) 2022 2021 2020 6 Operating activities 7 Net earnings 2,780 6,946 4,368 8 Adjustments to reconcile net earnings to cash provided by operations: 9 Depreciation and amortization 2,700 2,642 2,485 10 Share-based compensation expense 220 228 200 11 Deferred income taxes 582 522 (184) 12 Gain on Dermstore sale - (335) 13 Loss on debt extinguishment - 14 Noncash losses (gains) and other, net 512 172 67 86 15 Changes in operating accounts: 16 Inventory 17 Other assets 18 Accounts payable 403 (3,249) (1,661) 22 (78) (137) (2,237) 2,628 2,925 19 Accrued and other liabilities (624) (746) 1,931 20 21 Investing activities Cash provided by operating activities 4,018 8,625 10,525 22 Expenditures for property and equipment (5,528) (3,544) (2,649) 8 27 42 23 Proceeds from disposal of property and equipment 24 Proceeds from Dermstore sale 25 Other investments 26 27 - 16 356 (3,154) Cash required for investing activities (5,504) - 7 16 (2,591) 27 28 Financing activities 29 Additions to long-term debt 2,625 1,972 2,480 31 Dividends paid 30 Reductions of long-term debt 32 Repurchase of stock 33 Stock option exercises (163) (1,147) (2,415) (1,836) (1,548) (1,343) (2,826) (7,356) (745) 4 8 23 34 35 Cash required for financing activities (2,196) (8,071) (2,000) 36 Net (decrease) / increase in cash and cash equivalents (3,682) (2,600) 5,934 37 Cash and cash equivalents at beginning of period 5,911 8,511 2,577 2,229 5,911 8,511 38 Cash and cash equivalents at end of period 39 40 Supplemental information 41 Interest paid, net of capitalized interest 449 414 939 42 Income taxes paid 213 2,063 1,031 43 Leased assets obtained in exchange for new finance lease liabilities 224 288 428 44 Leased assets obtained in exchange for new operating lease liabilities 329 580 262 45 46 A 2 Consolidated Statements of Shareholders' Investment 3 4 5 (millions) 6 7 February 1, 2020 8 9 Net earnings 10 Other comprehensive income 11 Dividends declared 12 Repurchase of stock 13 Stock options and awards 14 January 30, 2021 (FY2020) 15 16 Net earnings 17 Other comprehensive income 18 Dividends declared 19 Repurchase of stock 20 Stock options and awards 21 January 29, 2022 (FY2021) 22 23 Net earnings 24 Other comprehensive income 25 Dividends declared 26 Repurchase of stock 27 Stock options and awards 28 January 28, 2023 (FY2022) 29 30 31 B C D E F G H Total (868) 11,833 Common Stock Par Retained Stock Shares Value APIC Earnings AOCI 504 6,226 6,433 4,368 - 4,368 112 112 | g | | |g (756) - 203 - (1,367) (609) 103 14,440 6,946 203 (1,655) (7,199) 92 (553) 12,827 3 | | |g | | | |g 2,780 2,780 - 134 134 (1,931) (2,646) 68 (419) 11,232 - (1,367) (609) - 103 6,329 - 8,825 6,946 - (1,655) (7,196) - 6,920 (1,931) (2,764) - | | | | | | | 6,421 (1) 460 38 6,608 5,005 ||||g || |ig (6) 2 501 (31) 2 471 g | | | + ; | | | A B C D E F G H J K L M N P R S T U V W X 1 2 Item 2. Properties 1234 Stores as of January 28, 2023 Montana 6,361 2,732 551 342 725 12,171 6,300 10,332 743 4,618 Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Total Stores as of 5 January 28, 2023 Stores Retail Square Feet (in thousands) 6 Alabama 7 Alaska 8 Arizona 9 Arkansas 10 California 11 Colorado 12 Connecticut 22 3,132 3 46 504 6,081 9 1,165 314 37,304 45 21 13 Delaware 4 14 District of Columbia 5 15 Florida 127 17,225 16 Georgia 17 Hawaii 18 Idaho 19 Illinois 20 Indiana 21 Iowa 22 Kansas 23 Kentucky 24 Louisiana 25 Maine 51 6,826 8 1,234 7 29 Minnesota 30 Mississippi 31 Missouri 32 26 Maryland 27 Massachusetts 28 Michigan 73 6 35 - 4,186 21 2,859 17 2,385 14 1,575 2,195 6 741 41 5,070 50 5,546 54 100 32 Stores N ' 1,948 Retail Square Feet (in thousands) 777 2,005 2,262 1,236 6,189 1,185 10,820 6,653 554 7,863 2,167 2,353 9,260 517 2,389 580 3,815 21,176 1,981 60 7,789 4,424 755 4,614 257 244,584