Worksheet A: Balance Sheet Analysis Use your company's 10K's to complete the following abbreviated Balance Sheet for the most recent year end and the 3 previous year ends. Year-37 (in millions) Year-end Company Name CONDENSED BALANCE SHEET Fiscal Year Ended (Month/Day) Most recent year? Year-1? 2020 2019 $ 3,216,7525 3,030,229 $ $ 386,261 $ 346,298 $ $ 4,872,592S 4,579,0335 $ 415,017$ 513,662 $ Year-22 2018 2.758,477 $ 327,166 S 4,187,243 $ 706,6765 2017 2,929,849 258,831 3,644,959 373,893 Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Longterm Assets Total Assets $ $ 95,5465 761,323 S 97,552$ 497.580$ 100,069 $ 14,058,015$ 195,871 12,883,808 Current liabilities Longterm Liabilities Total Liabilities $ 851,116 $ 1,354,242 $ 1,320,505 Contributed capital Retained earnings Treasury stock Other SE/AOCI Total Company Stockholders' Equity Noncontrolling Interest - if applies Total Stockholders' Equity Total Liabilities & Stockholders' Equity Other plus any items that are not provided in the categories above. Note: Contributed Capital - include common stock, Preferred stock, and Additional Paid in Capital Most recent year? Year-1? Year-2? Year-3? 2020 2019 2018 2017 Show the following ratio: (use CA & CL above) Working Capital Current Ratio VERTICAL ANALYSIS Company Name CONDENSED COMMON SIZE BALANCE SHEET Fiscal Year Ended (Month/Day) Most recent year? Year -1? Year-end 2020 2019 Year -3? Year -22 2018 2017 Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Long-term Assets Total Assets 100.00% 100.00% 100.00% 100.00% Current liabilities Noncurrent Liabilities Total Liabilities Contributed capital Retained earnings Treasury stock Other SE/AOCI Total Company Stockholders' Equity Noncontrolling Interest - if applies Total Stockholders' Equity Total Liabilities & Stockholders' Equity HORIZONTAL ANALYSIS Company Name CONDENSED TREND ANALYSIS BALANCE SHEET Fiscal Year Ended (Month/Day) Most recent year? Year-end Year -1? 2020 2019 Base Year? Year -2? 2018 Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Long-term Assets Total Assets 2017 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 Current liabilities Longterm Liabilities Total Liabilities 100.00 100.00 100.00 Contributed capital Retained earnings Treasury stock Other SE/AOCI Total Company Stockholders' Equity Noncontrolling Interest - if applies Total Stockholders' Equity 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 Total Liabilities & Stockholders' Equity Feb. 01, 2020 Feb. 02, 2019 $3,216,752 386,261 4.872,592 415,017 $ 3,030,229 346,298 4,579,033 513,662 8,469,222 5,255,208 6,467 8.890,622 5.325,048 12,132 9,060,332 95,546 761,323 24. 145.003 97,552 497 580 14,326,029 2.672.557 2,644 143 2.733,076 3,041,774 ment Consolidated Balance Sheets - USD ($) Sin Thousands Current assets: Cash and cash equivalents Accounts receivable, net Merchandise inventories Prepaid expenses and other current assets Total current assets Net property at cost Non-current deferred income taxes, net Operating lease right of use assets Goodwill Other assets TOTAL ASSETS Current liabilities: Accounts payable Accrued expenses and other current liabilities Current portion of operating lease liabilities Federal state and foreign income taxes payable Total current liabilities Other long-term liabilities Non-current deferred income taxes, net Long-term operating lease liabilities Aggregate maturities of long-term debt Commitments and contingencies (See Note N) SHAREHOLDERS' EQUITY Preferred stock, authonzed 5,000,000 shares, par value 51 no shares issued Common stock, authorized 1,800.000.000 shares, par value $1. issued and outstanding 1.199,099.768 and 1 217.182,508, respectively Additional paid-in capital Accumulated other comprehensive (los) incomo Retained earnings Total shareholders equity TOTAL LIABILITIES AND SHAREHOLDERS EQUITY 1.411 216 154, 155 24,700 7,150,247 851 116 142.170 7 816,633 2,236,625 5,531,374 1.354,242 158.191 2.233.616 0 0 1199.100 1 217.183 0 0 (630,321) (673,171) 5.422 283 5.948,212 $24. 145.000 4.461.744 5,048,606 $ 14,326.029 Feb. 03, 2018 Jan. 28, 2017 $ 2,758,477 506,165 327,166 4,187,243 706,676 8.485,727 5,006,053 6,558 100,069 459,608 14.058,015 $ 2,929,849 543,242 258,831 3,644,959 373,893 7,750,774 4,532,894 6,193 195,871 398,076 12,883,808 2 488,373 ment Consolidated Balance Sheets - USD ($) Sin Thousands Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net Merchandise inventories Prepaid expenses and other current assets Total current assets Net property at cost Non-current deferred income taxes, net Goodwill Other assets TOTAL ASSETS Current liabilities: Accounts payable Accrued expenses and other current liabilities Federal, state and foreign income taxes payable Total current liabilities Other long-term liabilities Non-current deferred income taxes, net Long-term debt Commitments and contingencies (See Note L and Note N) SHAREHOLDERS' EQUITY Preferred stock authorized 5,000,000 shares, par value $1, no shares issued Common stock, authorized 1.200,000,000 shares, par value S1, issued and outstanding 628,009,022 and 646,319,046, respectively Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings Total shareholders' equity TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 2.230,904 2.320,464 2.522,961 114 203 206.288 5,125.537 1.320.505 233,057 2,230,607 4.757,656 1,073,954 314,000 2,227,599 628,009 646,319 0 0 (441,859) 4.982 159 5,148,309 (694.226) 4,558,506 4.510.599 5 14.058.015 $ 12.883 808