A B LIQUIDITY RATIOS Current ratio Acid test (or quick ratio) 2020 2021 1.93 1.53 0.81...

Transcribed Image Text:

A B LIQUIDITY RATIOS Current ratio Acid test (or quick ratio) 2020 2021 1.93 1.53 0.81 0.54 E F 2022 2023 SOLVENCY RATIOS Debt to equity ratio 1.95 2.23 Times interest earned ratio (0.92) 5.69 PROFITABILITY RATIOS Return on assets (%) -1.09% 6.17% Return on equity (%) -3.06% 19.03% 0 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. 9 (Dollars in Millions) Assets 10 11 12 13 14 15 16 17 18 19 20 21 Current asse Cash and cash equivalents Merchandise inventories Income taxes receivable Prepaids Other Total current assets Property and equipment, net Operating leases Other assets Accounts receivables Total assets Liabilities and Shareholders' Equity Current liabilities: Total shareholders' equity Total liabilities and shareholders' equity KOHL'S CORPORATION A 1 2 B CONSOLIDATED BALANCE SHEETS 3 Period End: Jan 28, 2023 4 Date Filed: Mar 16, 2023 29 39 -234567OODWILIPPTPP&Z~~~3~~2385833386883+*3*4FGF 30 Accounts payable Accrued liabilities Borrowings under revolving credit facility Current portion of Long-term debt 31 Finance leases and financing obligations Operating leases Total current liabilities Long-term debt Finance leases and financing obligations Operating leases Deferred income taxes Other long-term liabilities Total liabilities 40 Shareholders' equity: 41 Common stock - 378,377,377, and 375 million shares issued, respectively Paid-in capital D E F G KOHL'S CORPORATION CONSOLIDATED BALANCE SHEETS 2022 2021 2020 2019 $ 153 $ 1,587 $ 2,271 $ 723 3,189 3,067 2,590 3,537 27 15 610 15 183 175 179 182 170 164 172 171 14 15 13 21 3,736 5,023 5,835 4,649 7,926 7,304 6,689 7,352 2,304 2,248 2,398 2,391 379 479 415 163 $ 14,345 $ 15,054 $ 15,337 $ 14,555 $ 1,330 $ 1,683 $ 1,476 $ 1,206 1,220 1,340 1,270 1,281 85 275 94 118 115 124 111 145 161 158 3,115 3,286 3,022 2,769 1,637 1,910 2,451 1,856 2,786 2,133 1,387 1,367 2,578 2,479 2,625 2,619 129 206 302 260 337 379 354 234 10,582 10,393 10,141 9,105 4 4 4 4 Treasury stock, at cost, 267,246, 219, and 219 million shares, respectively Retained earnings 3,479 (13,715) 3,375 3,319 3,272 (12,975) (11,595) (11,571) 13,995 14,257 13,468 13,745 $ 3,763 $ 4,661 $ 5,196 $ 5,450 $ 14,345 $ 15,054 $ 15,337 $ 14,555 A 1 KOHLS CORP 2 INCOME_STATEMENT 3 Period End: Jan 28, 2023 4 Date Filed: Mar 16, 2023 45678 B D E KOHL'S CORPORATION CONSOLIDATED STATEMENTS OF OPERATIONS 9 (Dollars in Millions, Except per Share Data) 2022 2021 2020 10 Net sales $ 17,161 $ 18,471 $ 15,031 11 Other revenue 937 962 924 12 Total revenue 18,098 19,433 15,955 13 Cost of merchandise sold 11,457 11,437 10,360 14 Operating expenses: 15 Selling, general, and administrative 5,587 5,478 5,021 16 Depreciation and amortization 808 838 874 17 Impairments, store closing, and other costs 89 18 (Gain) on sale of real estate - (127) 23 28 29 22222222222 19 Operating income (loss) 246 1,680 (262) 20 Interest expense, net 304 260 284 21 Loss on extinguishment of debt (Loss) income before income taxes (Benefit) provision for income taxes 24 Net (loss) income 201 (58) 1,219 (546) (39) 281 (383) $ 69 (19) S 938 $ (163) 25 Net (loss) income per share: 26 Basic 27 Diluted SAS $ (0.15) $ 6.41 $ (1.06) $ (0.15) $ 6.32 $ (1.06) B 1 Created by EDGAR Online, Inc. 2 3 KOHLS CORP 4 KOHLS CORP 5 STOCKHOLDERS_EQUITY 6 Period End: Jan 28, 2023 E 2020 7 Date Filed: Mar 16, 2023 8 9 10 KOHL'S CORPORATION CONSOLIDATED STATEMENTS OF CHANGES IN SHAREHOLDERS' EQUITY 11 12 (Dollars in Millions, Except per Share Data) 13 Common stock 14 Balance, beginning of period 15 Stock-based awards 16 Balance, end of period 2022 2021 $4 $4 $4 $4 17 18 Paid-in capital 19 Balance, beginning of period 20 Stock-based awards 6222222222223223M3RGE Final settlement of accelerated share repurchase Balance, end of period 24 Treasury stock 25 Balance, beginning of period Treasury stock purchases 27 28 Stock-based awards Dividends paid 29 Balance, end of period 30 31 Retained earnings Balance, beginning of period Net (loss) earnings Dividends paid 35 Balance, end of period 37 Total shareholders' equity, end of period 38 39 Common stock 40 Shares, beginning of period 41 Stock-based awards FL 69 69 SA 69 3,375 $ 39 3,319 $ 56 3,272 47 65 3,479 $ 3,375 $ 3,319 (12,975) $ (11,595) $ (11,571) (723) (1,355) (8) (21) (27) (22) 4 2 6 (13,715) $ (12,975) $ (11,595) $ 14,257 $ 13,468 $ 13,745 (19) 938 (163) (243) (149) (114) $ 69 13,995 $ 14,257 $ 13,468 SA 3,763 $ 4,661 $ 5,196 377 377 375 1 39 Common stock 40 Shares, beginning of period 41 Stock-based awards 42 Shares, end of period 43 Treasury stock 44 Shares, beginning of period 46 45 Treasury stock purchases Shares, end of period 47 Total shares outstanding, end of period 48 49 Dividends paid per common share 50 51 377 1 - 377 375 2 378 377 377 (246) (219) (219) (21) (27) (267) (246) (219) 111 131 158 69 $ 2.00 $ 1.00 $ 0.70 1234567820 1 KOHLS CORP 2 CASH FLOW 3 Period End: Jan 28, 2023 4 Date Filed: Mar 16, 2023 9 (Dollars in Millions) KOHL'S CORPORATION CONSOLIDATED STATEMENTS OF CASH FLOWS Operating activities 11 Net (loss) income 69 2022 2021 2020 (19) $ 938 $ (163) 12 Adjustments to reconcile net (loss) income to 13 14 15 16 17 net cash provided by operating activities: Depreciation and amortization Share-based compensation Deferred income taxes Impairments, store closing, and other costs 808 838 874 30 48 40 (84) (92) 18 64 18 (Gain) on sale of real estate (127) 19 Loss on extinguishment of debt 201 20 Non-cash inventory costs - 187 21 Non-cash lease expense 22 Other non-cash expense 23 Changes in operating assets and liabilities: 24 Merchandise inventories (116) 25 Other current and long-term assets 26 Accounts payable (353) 27 Accrued and other long-term liabilities 28 Operating lease liabilities (108) 29 Net cash provided by operating activities 30 Investing activities 31 Acquisition of property and equipment (826) 32 Proceeds from sale of real estate 33 34 Net cash used in investing activities Financing activities (783) 35 Proceeds from issuance of debt 36 Net borrowings under credit facilities 37 Deferred financing costs 139 149 12 22 (467) 768 569 (813) 206 270 (99) 21 199 (142) (150) 2,271 1,338 (605) (334) 35 197 (570) (137) 500 2,097 (6) (8) (19) 38 Treasury stock purchases (658) (1,355) (8) 39 Shares withheld for taxes on vested restricted 40 shares (21) (27) (22) 41 Dividends paid (239) (147) (108) 41 Dividends paid (239) (147) (108) 42 Reduction of long-term borrowing (1,044) (1,497) 43 Premium paid on redemption of debt (192) 44 Finance lease and financing obligation payments (106) (125) (105) 45 Proceeds from financing obligations 11 15 9 46 47 48 49 50 51 52 53 54 55 56 57 Proceeds from stock option exercises Other Net cash (used in) provided by financing activities Net (decrease) increase in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid 1 1 - (3) (933) (2,385) 347 (1,434) (684) 1,548 1,587 2,271 723 SA 69 153 $ 1,587 $ 2,271 284 $ 246 $ 254 111 370 419 58 59 60 A B LIQUIDITY RATIOS Current ratio Acid test (or quick ratio) 2020 2021 1.93 1.53 0.81 0.54 E F 2022 2023 SOLVENCY RATIOS Debt to equity ratio 1.95 2.23 Times interest earned ratio (0.92) 5.69 PROFITABILITY RATIOS Return on assets (%) -1.09% 6.17% Return on equity (%) -3.06% 19.03% 0 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. 9 (Dollars in Millions) Assets 10 11 12 13 14 15 16 17 18 19 20 21 Current asse Cash and cash equivalents Merchandise inventories Income taxes receivable Prepaids Other Total current assets Property and equipment, net Operating leases Other assets Accounts receivables Total assets Liabilities and Shareholders' Equity Current liabilities: Total shareholders' equity Total liabilities and shareholders' equity KOHL'S CORPORATION A 1 2 B CONSOLIDATED BALANCE SHEETS 3 Period End: Jan 28, 2023 4 Date Filed: Mar 16, 2023 29 39 -234567OODWILIPPTPP&Z~~~3~~2385833386883+*3*4FGF 30 Accounts payable Accrued liabilities Borrowings under revolving credit facility Current portion of Long-term debt 31 Finance leases and financing obligations Operating leases Total current liabilities Long-term debt Finance leases and financing obligations Operating leases Deferred income taxes Other long-term liabilities Total liabilities 40 Shareholders' equity: 41 Common stock - 378,377,377, and 375 million shares issued, respectively Paid-in capital D E F G KOHL'S CORPORATION CONSOLIDATED BALANCE SHEETS 2022 2021 2020 2019 $ 153 $ 1,587 $ 2,271 $ 723 3,189 3,067 2,590 3,537 27 15 610 15 183 175 179 182 170 164 172 171 14 15 13 21 3,736 5,023 5,835 4,649 7,926 7,304 6,689 7,352 2,304 2,248 2,398 2,391 379 479 415 163 $ 14,345 $ 15,054 $ 15,337 $ 14,555 $ 1,330 $ 1,683 $ 1,476 $ 1,206 1,220 1,340 1,270 1,281 85 275 94 118 115 124 111 145 161 158 3,115 3,286 3,022 2,769 1,637 1,910 2,451 1,856 2,786 2,133 1,387 1,367 2,578 2,479 2,625 2,619 129 206 302 260 337 379 354 234 10,582 10,393 10,141 9,105 4 4 4 4 Treasury stock, at cost, 267,246, 219, and 219 million shares, respectively Retained earnings 3,479 (13,715) 3,375 3,319 3,272 (12,975) (11,595) (11,571) 13,995 14,257 13,468 13,745 $ 3,763 $ 4,661 $ 5,196 $ 5,450 $ 14,345 $ 15,054 $ 15,337 $ 14,555 A 1 KOHLS CORP 2 INCOME_STATEMENT 3 Period End: Jan 28, 2023 4 Date Filed: Mar 16, 2023 45678 B D E KOHL'S CORPORATION CONSOLIDATED STATEMENTS OF OPERATIONS 9 (Dollars in Millions, Except per Share Data) 2022 2021 2020 10 Net sales $ 17,161 $ 18,471 $ 15,031 11 Other revenue 937 962 924 12 Total revenue 18,098 19,433 15,955 13 Cost of merchandise sold 11,457 11,437 10,360 14 Operating expenses: 15 Selling, general, and administrative 5,587 5,478 5,021 16 Depreciation and amortization 808 838 874 17 Impairments, store closing, and other costs 89 18 (Gain) on sale of real estate - (127) 23 28 29 22222222222 19 Operating income (loss) 246 1,680 (262) 20 Interest expense, net 304 260 284 21 Loss on extinguishment of debt (Loss) income before income taxes (Benefit) provision for income taxes 24 Net (loss) income 201 (58) 1,219 (546) (39) 281 (383) $ 69 (19) S 938 $ (163) 25 Net (loss) income per share: 26 Basic 27 Diluted SAS $ (0.15) $ 6.41 $ (1.06) $ (0.15) $ 6.32 $ (1.06) B 1 Created by EDGAR Online, Inc. 2 3 KOHLS CORP 4 KOHLS CORP 5 STOCKHOLDERS_EQUITY 6 Period End: Jan 28, 2023 E 2020 7 Date Filed: Mar 16, 2023 8 9 10 KOHL'S CORPORATION CONSOLIDATED STATEMENTS OF CHANGES IN SHAREHOLDERS' EQUITY 11 12 (Dollars in Millions, Except per Share Data) 13 Common stock 14 Balance, beginning of period 15 Stock-based awards 16 Balance, end of period 2022 2021 $4 $4 $4 $4 17 18 Paid-in capital 19 Balance, beginning of period 20 Stock-based awards 6222222222223223M3RGE Final settlement of accelerated share repurchase Balance, end of period 24 Treasury stock 25 Balance, beginning of period Treasury stock purchases 27 28 Stock-based awards Dividends paid 29 Balance, end of period 30 31 Retained earnings Balance, beginning of period Net (loss) earnings Dividends paid 35 Balance, end of period 37 Total shareholders' equity, end of period 38 39 Common stock 40 Shares, beginning of period 41 Stock-based awards FL 69 69 SA 69 3,375 $ 39 3,319 $ 56 3,272 47 65 3,479 $ 3,375 $ 3,319 (12,975) $ (11,595) $ (11,571) (723) (1,355) (8) (21) (27) (22) 4 2 6 (13,715) $ (12,975) $ (11,595) $ 14,257 $ 13,468 $ 13,745 (19) 938 (163) (243) (149) (114) $ 69 13,995 $ 14,257 $ 13,468 SA 3,763 $ 4,661 $ 5,196 377 377 375 1 39 Common stock 40 Shares, beginning of period 41 Stock-based awards 42 Shares, end of period 43 Treasury stock 44 Shares, beginning of period 46 45 Treasury stock purchases Shares, end of period 47 Total shares outstanding, end of period 48 49 Dividends paid per common share 50 51 377 1 - 377 375 2 378 377 377 (246) (219) (219) (21) (27) (267) (246) (219) 111 131 158 69 $ 2.00 $ 1.00 $ 0.70 1234567820 1 KOHLS CORP 2 CASH FLOW 3 Period End: Jan 28, 2023 4 Date Filed: Mar 16, 2023 9 (Dollars in Millions) KOHL'S CORPORATION CONSOLIDATED STATEMENTS OF CASH FLOWS Operating activities 11 Net (loss) income 69 2022 2021 2020 (19) $ 938 $ (163) 12 Adjustments to reconcile net (loss) income to 13 14 15 16 17 net cash provided by operating activities: Depreciation and amortization Share-based compensation Deferred income taxes Impairments, store closing, and other costs 808 838 874 30 48 40 (84) (92) 18 64 18 (Gain) on sale of real estate (127) 19 Loss on extinguishment of debt 201 20 Non-cash inventory costs - 187 21 Non-cash lease expense 22 Other non-cash expense 23 Changes in operating assets and liabilities: 24 Merchandise inventories (116) 25 Other current and long-term assets 26 Accounts payable (353) 27 Accrued and other long-term liabilities 28 Operating lease liabilities (108) 29 Net cash provided by operating activities 30 Investing activities 31 Acquisition of property and equipment (826) 32 Proceeds from sale of real estate 33 34 Net cash used in investing activities Financing activities (783) 35 Proceeds from issuance of debt 36 Net borrowings under credit facilities 37 Deferred financing costs 139 149 12 22 (467) 768 569 (813) 206 270 (99) 21 199 (142) (150) 2,271 1,338 (605) (334) 35 197 (570) (137) 500 2,097 (6) (8) (19) 38 Treasury stock purchases (658) (1,355) (8) 39 Shares withheld for taxes on vested restricted 40 shares (21) (27) (22) 41 Dividends paid (239) (147) (108) 41 Dividends paid (239) (147) (108) 42 Reduction of long-term borrowing (1,044) (1,497) 43 Premium paid on redemption of debt (192) 44 Finance lease and financing obligation payments (106) (125) (105) 45 Proceeds from financing obligations 11 15 9 46 47 48 49 50 51 52 53 54 55 56 57 Proceeds from stock option exercises Other Net cash (used in) provided by financing activities Net (decrease) increase in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid 1 1 - (3) (933) (2,385) 347 (1,434) (684) 1,548 1,587 2,271 723 SA 69 153 $ 1,587 $ 2,271 284 $ 246 $ 254 111 370 419 58 59 60