EXCEL PROJECT: PART I INSTRUCTIONS Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4) Companies listed is Kohls Go to the Securities and Exchange Commission's EDGAR database and access your chosen company's most recent Form 10-K (annual report). (For help with this process, see the Module/Week 1 presentation, "Downloading Financial Statements from the SEC EDGAR Database.") Create an Excel workbook, including data for your chosen company as follows: The 1" tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included: Company Name and ticker symbol Industry . Products or services offered Major competitors . An example of this tab is provided in Exhibit A. The 2nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements. . Include the latest three years based on SEC filings. Ensure that the worksheet includes a header with: Company Name Financial Statement Name (Income Statements) Financial Statement Dates Denomination level ($s in millions or thousands, etc.) o The 3rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets. Include the latest three years based on SEC (10-K) filings. (Note: Some 10- Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.) Ensure that the worksheet includes a header with: Company Name Financial Statement Name Financial Statement Dates Denomination level ($s in millions or thousands, etc.) A partial balance sheet example is provided in Exhibit B. The 4th tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows. Include the latest three years based on SEC (10-K) filings. . Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows: Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows. Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet. Ensure that the worksheet includes a header with: Company Name Financial Statement Name Financial Statement Dates Denomination level ($s in millions or thousands, etc.) o Other instructions: The Excel workbook should be professionally formatted. Professional formatting includes: All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent. Dollar signs are included in the first and last numbers of each column. Subtotals and totals are preceded by a single underline. Totals are followed by a double underline. All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted. Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read. . All totals and subtotals should be calculated using formulas. For an example of which cells may need formulas, please see Exhibit B. A1 4 x vfx Document and Entity Information - USD ($) $ in Billions B D 12 Months Ended Jan. 30, 2021 Mar 10, 2021 Jul 31, 2020 10-K false Jan. 30, 2021 2020 FY KSS vou KOHL'S CORP 0000885639 -01-30 Yes 1 Document and Entity Information - USD ($) $ in Billions 2 Cover (Abstract] 4 Document Type 5 Amendment Flag Document Period End Date 6 7 Document Fiscal Year Focus 8 Document Fiscal Period Focus 9 Trading Symbols) ... 10 Entity Registrant Name 11 Entity Central Index Key 12 Current Fiscal Year End Date 13 Entity Well-known Seasoned Issuer 14 Entity Current Reporting Status 15 Entity Voluntary Filers 16 Entity Filer Category 17 Entity Emerging Growth Company . 18 Entity Small Business 19 ICFR Auditor Attestation Flag 20 Entity Shell Company 21 Entity File Number 22 Entity Tax Identification Number 23 Entity Address, Address Line One , 24 Entity Address, City or Town 25 Entity Address, State or Province wy 26 Entity Address, Postal Zip Code 27 City Area Code 28 Local Phone Number 29 Entity Interactive Data Current 30 Title of each class Yes No Large Accelerated Filer Balen false . false true false 1990 1-11084 39-1630919 N56 W17000 Ridgewood Drive Menomonee Falls WI 53051 (262) 703-7000 Yes Common Stock, $.01 par value A1 fx Document and Entity Information - USD ($) $ in Billions A B Common Stock, $.01 par value NYSE true false 30 Title of each class 31 Name of each exchange on which registered 32 Document Annual Report 33 Document Transition Report 34 Entity Incorporation, State or Country Code 35 Entity Common Stock, Shares Outstanding 36 Entity Public Float Documents Incorporated by Reference 37 WI 157,716,240 $3 Documents Incorporated by Reference: Portions of the Definitive Proxy Statement for the Registrant's 2021 Annual Meeting of Shareholders are incorporated into Part III. B14 xv fx A B D CONSOLIDATED BALANCE SHEETS- USD ($) $ in Millions Jan. 30, 2021 Feb. 01, 2020 [1] $ 2,271 2,590 974 5,835 6,689 2,398 415 15,337 $ 723 3,537 389 4,649 7,352 2,391 163 14,555 ther assets : 1,476 1,270 1,206 1,281 1 2 Current assets: 3 Cash and cash equivalents 4 Merchandise inventories Other 5 Other 6 Total current assets 7 Property and equipment, net 8 Operating leases 9 Other assets scote 10 Total assets 11 Current liabilities: 12 Accounts payable 13 Accrued liabilities 14 Current portion of: 15 Finance lease and financing obligations rotiles 16 Operating leases 17 Total current liabilities 18 Long-term debt 19 Finance lease and financing obligations 20 Operating lescos 20 Operating leases 21 Deferred income taxes 22 Other long-term liabilities 23 Shareholders' equity 24 Common stock - 377 and 375 million shares issued 25 Paid-in capital 25 Paid in capital 26 Treasury stock, at cost, 219 and 219 million shares 27 Retained earnings 28 Total shareholders' equity 29 Total liabilities and shareholders' equity 30 31 (1) > Document and Entity Information 115 161 3,022 2451 2,451 1,387 2,625 302 354 124 158 150 2,769 1,856 1,367 2,619 260 234 4 4 4 3,319 (11,595) 13,468 5,196 $ 15,337 3,272 (11,571) 13,745 5,450 $ 14,555 See Note 5 of Notes to Consolidated Financial Statements for further discussion on income taxes. CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa CONSOLIDATED + B E F G 375 A1 XV foc CONSOLIDATED BALANCE SHEETS (Parenthetical) - shares shares in Millions Name Box A 1 CONSOLIDATED BALANCE SHEETS (Parenthetical) - shares shares in Millions Jan. 30, 2021 Feb. 01, 2020 2 Statement of Financial Position (Abstract] 3 Common stock, shares issued 4 Treasury stock, shares 5 6 7 8 9 10 377 219 219 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Document and Entity Information CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa A1 fx CONSOLIDATED STATEMENTS OF OPERATIONS- USD ($) $ in Millions A B D Jan. 30, 2021 $ 15,955 $ 10,360 kss: MerchandisesCost Member 12 Months Ended Feb. 01, 2020 $ 19,974 $ 12,140 kss:MerchandisesCost Member Feb. 02, 2019 $ 20,229 $ 12,199 kss:MerchandisesCost Member $ 5,705 917 $ 5,601 964 113 104 $ 5,021 874 89 (127) (262) 284 CONSOLIDATED STATEMENTS OF OPERATIONS- USD ($) $ in Millions 3 Total revenue 4 Cost of merchandise sold 5 Type of Cost, Good or Service [Extensible List] 6 Operating expenses: 7 Selling, general, and administrative 8 Depreciation and amortization 9 Impairments, store closing, and other costs 10 (Gain) on sale of real estate 11 Operating (loss) income 12 Interest expense, net 13 (Gain) loss on extinguishment of debt 14 (Loss) income before income taxes 15 (Benefit) provision for income taxes 16 Net (Loss) income 17 Net (loss) income per share: 18 Basic 19 Diluted 20 Net Sales (Member) 21 Total revenue 22 Other Revenue (Member) 23 Total revenue 24 25 26 27 28 29 30 1,099 207 (9) 901 210 $ 691 1,361 256 63 1,042 241 $ 801 (546) (383) $ (163) $(1.06) $(1.06) $4.39 $ 4.37 $ 4.88 $4.84 $ 15,031 $ 18,885 $ 19,167 $924 $ 1,089 $ 1,062 31 CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa CONSOLIDATED STATEMENTS OF OPER EXCEL PROJECT: PART I INSTRUCTIONS Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4) Companies listed is Kohls Go to the Securities and Exchange Commission's EDGAR database and access your chosen company's most recent Form 10-K (annual report). (For help with this process, see the Module/Week 1 presentation, "Downloading Financial Statements from the SEC EDGAR Database.") Create an Excel workbook, including data for your chosen company as follows: The 1" tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included: Company Name and ticker symbol Industry . Products or services offered Major competitors . An example of this tab is provided in Exhibit A. The 2nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements. . Include the latest three years based on SEC filings. Ensure that the worksheet includes a header with: Company Name Financial Statement Name (Income Statements) Financial Statement Dates Denomination level ($s in millions or thousands, etc.) o The 3rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets. Include the latest three years based on SEC (10-K) filings. (Note: Some 10- Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.) Ensure that the worksheet includes a header with: Company Name Financial Statement Name Financial Statement Dates Denomination level ($s in millions or thousands, etc.) A partial balance sheet example is provided in Exhibit B. The 4th tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows. Include the latest three years based on SEC (10-K) filings. . Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows: Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows. Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet. Ensure that the worksheet includes a header with: Company Name Financial Statement Name Financial Statement Dates Denomination level ($s in millions or thousands, etc.) o Other instructions: The Excel workbook should be professionally formatted. Professional formatting includes: All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent. Dollar signs are included in the first and last numbers of each column. Subtotals and totals are preceded by a single underline. Totals are followed by a double underline. All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted. Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read. . All totals and subtotals should be calculated using formulas. For an example of which cells may need formulas, please see Exhibit B. A1 4 x vfx Document and Entity Information - USD ($) $ in Billions B D 12 Months Ended Jan. 30, 2021 Mar 10, 2021 Jul 31, 2020 10-K false Jan. 30, 2021 2020 FY KSS vou KOHL'S CORP 0000885639 -01-30 Yes 1 Document and Entity Information - USD ($) $ in Billions 2 Cover (Abstract] 4 Document Type 5 Amendment Flag Document Period End Date 6 7 Document Fiscal Year Focus 8 Document Fiscal Period Focus 9 Trading Symbols) ... 10 Entity Registrant Name 11 Entity Central Index Key 12 Current Fiscal Year End Date 13 Entity Well-known Seasoned Issuer 14 Entity Current Reporting Status 15 Entity Voluntary Filers 16 Entity Filer Category 17 Entity Emerging Growth Company . 18 Entity Small Business 19 ICFR Auditor Attestation Flag 20 Entity Shell Company 21 Entity File Number 22 Entity Tax Identification Number 23 Entity Address, Address Line One , 24 Entity Address, City or Town 25 Entity Address, State or Province wy 26 Entity Address, Postal Zip Code 27 City Area Code 28 Local Phone Number 29 Entity Interactive Data Current 30 Title of each class Yes No Large Accelerated Filer Balen false . false true false 1990 1-11084 39-1630919 N56 W17000 Ridgewood Drive Menomonee Falls WI 53051 (262) 703-7000 Yes Common Stock, $.01 par value A1 fx Document and Entity Information - USD ($) $ in Billions A B Common Stock, $.01 par value NYSE true false 30 Title of each class 31 Name of each exchange on which registered 32 Document Annual Report 33 Document Transition Report 34 Entity Incorporation, State or Country Code 35 Entity Common Stock, Shares Outstanding 36 Entity Public Float Documents Incorporated by Reference 37 WI 157,716,240 $3 Documents Incorporated by Reference: Portions of the Definitive Proxy Statement for the Registrant's 2021 Annual Meeting of Shareholders are incorporated into Part III. B14 xv fx A B D CONSOLIDATED BALANCE SHEETS- USD ($) $ in Millions Jan. 30, 2021 Feb. 01, 2020 [1] $ 2,271 2,590 974 5,835 6,689 2,398 415 15,337 $ 723 3,537 389 4,649 7,352 2,391 163 14,555 ther assets : 1,476 1,270 1,206 1,281 1 2 Current assets: 3 Cash and cash equivalents 4 Merchandise inventories Other 5 Other 6 Total current assets 7 Property and equipment, net 8 Operating leases 9 Other assets scote 10 Total assets 11 Current liabilities: 12 Accounts payable 13 Accrued liabilities 14 Current portion of: 15 Finance lease and financing obligations rotiles 16 Operating leases 17 Total current liabilities 18 Long-term debt 19 Finance lease and financing obligations 20 Operating lescos 20 Operating leases 21 Deferred income taxes 22 Other long-term liabilities 23 Shareholders' equity 24 Common stock - 377 and 375 million shares issued 25 Paid-in capital 25 Paid in capital 26 Treasury stock, at cost, 219 and 219 million shares 27 Retained earnings 28 Total shareholders' equity 29 Total liabilities and shareholders' equity 30 31 (1) > Document and Entity Information 115 161 3,022 2451 2,451 1,387 2,625 302 354 124 158 150 2,769 1,856 1,367 2,619 260 234 4 4 4 3,319 (11,595) 13,468 5,196 $ 15,337 3,272 (11,571) 13,745 5,450 $ 14,555 See Note 5 of Notes to Consolidated Financial Statements for further discussion on income taxes. CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa CONSOLIDATED + B E F G 375 A1 XV foc CONSOLIDATED BALANCE SHEETS (Parenthetical) - shares shares in Millions Name Box A 1 CONSOLIDATED BALANCE SHEETS (Parenthetical) - shares shares in Millions Jan. 30, 2021 Feb. 01, 2020 2 Statement of Financial Position (Abstract] 3 Common stock, shares issued 4 Treasury stock, shares 5 6 7 8 9 10 377 219 219 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Document and Entity Information CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa A1 fx CONSOLIDATED STATEMENTS OF OPERATIONS- USD ($) $ in Millions A B D Jan. 30, 2021 $ 15,955 $ 10,360 kss: MerchandisesCost Member 12 Months Ended Feb. 01, 2020 $ 19,974 $ 12,140 kss:MerchandisesCost Member Feb. 02, 2019 $ 20,229 $ 12,199 kss:MerchandisesCost Member $ 5,705 917 $ 5,601 964 113 104 $ 5,021 874 89 (127) (262) 284 CONSOLIDATED STATEMENTS OF OPERATIONS- USD ($) $ in Millions 3 Total revenue 4 Cost of merchandise sold 5 Type of Cost, Good or Service [Extensible List] 6 Operating expenses: 7 Selling, general, and administrative 8 Depreciation and amortization 9 Impairments, store closing, and other costs 10 (Gain) on sale of real estate 11 Operating (loss) income 12 Interest expense, net 13 (Gain) loss on extinguishment of debt 14 (Loss) income before income taxes 15 (Benefit) provision for income taxes 16 Net (Loss) income 17 Net (loss) income per share: 18 Basic 19 Diluted 20 Net Sales (Member) 21 Total revenue 22 Other Revenue (Member) 23 Total revenue 24 25 26 27 28 29 30 1,099 207 (9) 901 210 $ 691 1,361 256 63 1,042 241 $ 801 (546) (383) $ (163) $(1.06) $(1.06) $4.39 $ 4.37 $ 4.88 $4.84 $ 15,031 $ 18,885 $ 19,167 $924 $ 1,089 $ 1,062 31 CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa CONSOLIDATED STATEMENTS OF OPER