Provide common-size analysis for companys income statement and balance sheet for the 2 most years. (MUST be done using excel formulas)

Consolidated Balance Sheets S and shares in millions, except per share amounts January 30, 2021 February 1, 2020 5.494 1.061 5.612 373 12.540 2.229 1.149 5.174 305 8.857 Assets Current assets Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Property and equipment Land and buildings Leasehold improvements Fixtures and equipment Property under finance leases Gross property and equipment Less accumulated depreciation Net property and equipment Operating lease assets Goodwill Other assets Total assets 658 2. 192 6.333 9.256 6.996 2.260 2.612 986 669 650 2 203 6.286 89 9 228 6.900 2.328 2.709 984 713 19.067 15.591 s 5.288 Liabilities and equity Current liabilities Accounts payable Unredeemed gift card liabilities Deferred revenue Accrued compensation and related expenses Accrued liabilities Short-term debt Current portion of operating lease liabilities Current portion of long-term debt Total current liabilities Long-term operating lease liabilities Long-term liabilities Long-term debt Contingencies and commitments (Note 13) Equity Best Buy Co., Inc. Shareholders' Equity Preferred stock. $1.00 par value: Authorized - 400,000 shares; Issued and outstanding - none Common stock, So. 10 par value: Authorized - 1.0 billion shares; Issued and outstanding - 257 and 256 shares, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive income Total equity Total liabilities and equity 6,979 317 711 725 972 110 693 14 10.521 2.012 694 1.253 8.060 2.138 657 1.257 26 26 4.233 328 4.587 19.067 3.158 295 3,479 15.591 See Notes to Consolidated Financial Statements Consolidated Statements of Cash Flows $ in millions January 30, 2021 February 1, 2020 February 2, 2019 S 1.798 S 1.541 S 1.464 839 254 135 (36 812 41 143 70 21 770 46 123 10 (25) Fiscal Years Ended Operating activities Net earnings Adjustments to reconcile net earnings to total cash provided by operating activities Depreciation and amortization Restructuring charges Stock-based compensation Deferred income taxes Other, net Changes in operating assets and liabilities, net of acquired assets and liabilities: Receivables Merchandise inventories Other assets Accounts payable Income taxes Other liabilities Total cash provided by operating activities Investing activities Additions to property and equipment, net of 532. $10 and $53, respectively, of non-cash capital expenditures Purchases of investments Sales of investments Acquisitions, net of cash acquired Other, net Total cash provided by (used in) investing activities Financing activities Repurchase of common stock Issuance of common stock Dividends paid Borrowings of debt Repayments of debt Other, net Total cash used in financing activities 73 (435) (51) 1,676 173 498 4.927 (131) 237 16 47 (132) (100) 2.565 28 (194) (34) 432 22 (234) 2.408 (819) (713) (620) ( 546 (743) (330) 322 (145) 0 (788) 2.098 (787) 16 508 (895) ( (312) 28 (568) 1.892 1,916 (1.003) 48 (527) (1,505 38 497) 498 (546) (6) (2.018) (15) (1) (1.498) (876) Effect of exchange rate changes on cash Increase in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of period Cash, cash equivalents and restricted cash at end of period 3.270 2.355 5.625 (1) 171 2.184 2.355 (14 884 1.300 2.184 S S S Supplemental cash flow information Income taxes paid Interest paid S S 442 50 S s 514 62 S S 391 71 See Notes to Consolidated Financial Statements. Consolidated Statements of Comprehensive Income Sin millions January 30, 2021 February 1, 2020 February 2, 2019 1.541 1.798 (4) Fiscal Years Ended Net earnings Foreign currency translation adjustments, net of tax Cash flow hedges Reclassification of cumulative translation adjustments into earnings due to exit of business Comprehensive income 1.464 20) 1.831 1.542 1.444 See Notes to Consolidated Financial Statements. Consolidated Statements of Changes in Shareholders' Equity S and shares in millions, except per share amounts Accumulated Other Comprehensive Income (Loss) Common Shares 283 Additional Paid-In Capital Common Stock Total Equity S 28 s S Retained Earnings 3.270 73 1.464 S 314 s 3.612 73 1.464 (20) - 123 38 (1) (20) 123 38 (491) (1,493 3.306 (22) 1.541 (167) (497) (1,325) 2.985 (22) 1.541 (21) 266 294 Balances as of February 3, 2018 Adoption of ASU 2014-09 Net earnings Other comprehensive loss Foreign currency translation adjustments, net of tax Stock-based compensation Issuance of common stock Common stock dividends, S1.80 per share Repurchase of common stock Balances as of February 2, 2019 Adoption of ASU 2016-02 Net earnings Other comprehensive income: Foreign currency translation adjustments, net of tax Stock-based compensation Issuance of common stock Common stock dividends, $2.00 per share Repurchase of common stock Other Balances as of February 1, 2020 1, Net earnings Other comprehensive income (loss): Foreign currency translation adjustments, net of tax Cash flow hedges Reclassification of cumulative translation adjustments into earnings due to exit of business Stock-based compensation Issuance of common stock Common stock dividends, $220 per share Repurchase of common stock Balances as of January 30, 2021 143 48 . palalalal, (14) (536) (810) (1) 198) (2 143 48 ( (527) (1,009) (2) 3.479 1.798 256 26 295 3.158 1.798 - C[8] 39 135 28 12 (175) (4) 2 39 135 28 (568) (318) 4.587 (580) (143) 4.233 257 S 26 S S 328 S See Notes to Consolidated Financial Statements Consolidated Statements of Earnings $ and shares in millions, except per share amounts January 30, 2021 February 1, 2020 February 2, 2019 S S 47.262 36.689 10.573 7.928 254 2.391 43.638 33,590 10.048 7,998 41 2009 42.879 32.918 9.961 8.015 46 1.900 Fiscal Years Ended Revenue Cost of sales Gross profit Selling general and administrative expenses Restructuring charges Operating income Other income (expense) Gain on sale of investments Investment income and other Interest expense Earnings before income tax expense Income tax expense Net earnings 1 47 (64 1 37 (52) 2.377 579 1,798 1.993 12 49 (73) 1.888 424 1.464 452 1.541 S Basic eamings per share Diluted eamings per share S S 6.93 6.84 S S 5.82 5.75 S S 5.30 5.20 Weighted-average common shares outstanding: Basic Diluted 259.6 263.0 264.9 268.1 276.4 281.4 See Notes to Consolidated Financial Statements