Help answering the following based on the balance sheet and income statement:
Current ratio
Working capital (not really a ratio)
Inventory turnover ratio
Accounts Receivable turnover ratio
Debt tototal assets ratio
Return on assets
Asset turnover ratio
Return on equity
Gross profit ratio
Profit margin ratio
?
7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what yr"; want to do. A Manry, Danielle Shy H X Cut TA Y2 EB) Copy Arial - 10 - A A Wrap Text General Normal Bad Good AutoSum Fill AY O Paste Format Painter BIU - - LA EE EE Merge & Center . Conditional Format as |Neutral Calculation Check Cell nsert Delete Format Formatting * Table Clear Sort & Find & Filter . Select Clipboard Font Alignment G Number Styles Cells Editing A1 X V Created by EDGAR Online, Inc. C D E G H K Table Of Content Consolidated Balance Sheets 11 12 $ in millions, except per share and share amounts 13 February 2, 2019 February 3, 2018 Assets 14 Current assets 15 Cash and cash equivalents $ 1,980 $ 1,101 16 Short-term investments 2,032 17 Receivables, net 1,015 1,049 18 Merchandise inventories 5.409 5.209 19 Other current assets 466 438 20 21 Total current assets 8,870 9.829 Property and equipment Land and buildings 637 623 Leasehold improvements 2,119 2,327 Fixtures and equipment 5.865 5,410 Property under capital and financing leases 579 340 Gross property and equipment 9,200 8,700 Less accumulated depreciation 6,690 6,279 28 Net property and equipment 2,510 2,421 29 915 425 30 Goodwill 31 Other assets 606 374 Total assets 12,901 $ 13,049 32 33 34 Liabilities and equity 35 Current liabilities 36 Accounts payable $ 5,257 $ 290 4,873 385 37 Unredeemed gift card liabilities Deferred revenue 446 453 38 39 Accrued compensation and related expenses 482 561 Accrued liabilities 982 1,001 40 41 Current portion of long-term debt 56 544 7,513 7,817 42 Total current liabilities 43 Long-term liabilities 750 809 1,332 811 44 Long-term debt 45 Contingencies and commitments (Note 13) 46 Equity 47 Best Buy Co., Inc. Shareholders' Equity 48 Preferred stock, $1.00 par value: Authorized - 400,000 shares; Issued and outstanding - none 49 50 Common stock, $0.10 par value: Authorized - 1.0 billion 51 shares; Issued and outstanding - 265,703,000 and 282,988,000 shares, respectively 27 28 52 53 Additional paid-in capital Retained earnings 2,985 1,270 54 294 314 55 Accumulated other comprehensive income Total equity 3,306 3,612 56 57 Total liabilities and equity 12,901 $ 13,049 ... TABLE28 TABLE29 TABLE30 TABLE31 BALANCE SHEET INCOME_STATEMENT INCOME_STATEMENT2 CASH_FLOW STOCKHOLDERS_EQUITY ... (+) Ready # 0 J -- - + 90%7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what you want to do... A Manry, Danielle Share 16 Cut Arial - 10 * A" A" Wrap Text General Normal Bad Good AutoSum AY O BB) Copy Fill Paste BIU . . LABE Merge & Center . $ - % " $68 428 Conditional Format as |Neutral Calculation Check Cell Format Painter 41 nsert Delete Format Sort & Find & Formatting * Table Clear Filter . Select Clipboard Font Alignment G Number Styles Cells Editing A1 X V Created by EDGAR Online, Inc. B C D E G H W N Created by EDGAR Online, Inc. BEST BUY CO INC 4 BALANCE_SHEET2 5 Form Type: 10-K Period End: Feb 02, 2019 7 Date Filed: Mar 28, 2019 8 Table Of Contents 10 February 2, 2019 11 Balances without 12 Adoption of Effect of Change 13 Impact of Changes to Consolidated Balance Sheets As Reported ASU 2014-09 Higher/(Lower)(1) 14 Assets 15 Other current assets $ 466 $ 410 $ 56 16 Other assets 606 625 (19) 17 Liabilities 18 Unredeemed gift card liabilities 290 352 (62) 19 Deferred revenue 446 470 (24 ) 20 Accrued liabilities 982 923 59 21 Equity 22 Retained earnings 2,985 2,921 64 27 28 * ... TABLE31 BALANCE SHEET INCOME_STATEMENT INCOME_STATEMENT2 CASH_FLOW STOCKHOLDERS_EQUITY TABLE32 BALANCE SHEET2 ... + Ready # 0 J -- - + 100%7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what you want to do... A Manry, Danielle & Share 16 Cut Arial - 10 - A" A" = = Wrap Text General Normal Bad Good AutoSum BB) Copy AY O Paste Format Painter BIU . . A BEBE Merge & Center . Conditional Format as |Neutral Fill Calculation Check Cell nsert Delete Format Sort & Find & Formatting * Table 41 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing A1 X V Created by EDGAR Online, Inc. B D G H K M 7 Date Filed: Mar 28, 2019 E & Table Of Contents 10 11 Consolidated Statements of Cash Flows 12 $ in millions 13 Fiscal Years Ended February 2, 2019 February 3, 2018 January 28, 2017 14 Operating activities Net earnings S 1,000 5 1,228 15 1,464 $ Adjustments to reconcile net earnings to total cash 16 provided by operating activities: 17 Depreciation and amortization 770 583 18 Stock-based compensation 123 10 654 Restructuring charges 46 39 19 129 108 20 Deferred income taxes 10 162 201 Other, net (25) (13 ) (17) Changes in operating assets and liabilities, net of acquired assets and liabilities Receivables 28 315 (193) Merchandise inventories (194) 335) 199 Other assets (34) (21) 10 Accounts payable 432 196) 518 29 Other liabilities (234) 117 23 30 Income taxes 22 290 (213) 31 Total cash provided by operating activities 2,40 2,141 2,557 nvesting activities Additions to property and equipment, net of $53, $123 and $48, respectively, of non-cash capital expenditures 819 (688) (580) Purchases of investments 4,325) 2,098 4.018 (3,045) Sales of investments 2.689 Acquisition of businesses, net of cash acquired (787) Other, net 16 (7 Total cash provided by (used in) investing activities 508 (1,002) (877) 41 42 Financing activities 43 Repurchase of common stock (1,505 (2.004) (698) Issuance of common stock 38 163 171 Dividends paid (497) 409) (505) Borrowings of debt 498 Repayments of debt 546) (394) Other, net ( 6 (46) (1 ) 8 49 Total cash used in financing activities 2,018 2,297) 1,418) Effect of exchange rate changes on cash (14) 25 10 50 Increase (decrease) in cash, cash equivalents and 52 restricted cash 884 (1,133) 272 Cash, cash equivalents and restricted cash at beginning of period 1,300 2,433 2,16 55 Cash, cash equivalents and restricted cash at end 56 of period S 2,184 $ ,300 $ 2,433 57 58 Supplemental disclosure of cash flow information 59 Income taxes paid 891 5 366 5 Interest paid 81 328 76 ... TABLE28 TABLE29 TABLE30 TABLE31 BALANCE SHEET INCOME_STATEMENT INCOME_STATEMENT2 CASH_FLOW STOCKHOLDERS_EQUITY ... + Ready + 80%7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what you want to do... A Manry, Danielle Share 16 Cut AutoSum BB) Copy Arial - 10 - A" A" Ex Wrap Text Number Normal Bad Good Fill AY O Paste BIU. . LA =3 E Merge & Center Calculation Check Cell 41 nsert Delete Format Format Painter Conditional Format as |Neutral Formatting * Table Clear Sort & Find & Filter . Select Clipboard Font Alignment Number Styles Cells Editing C15 X V 9961 B C D E F G H 2 3 BEST BUY CO INC 4 INCOME_STATEMENT 5 Form Type: 10-K 6 Period End: Feb 02, 2019 7 Date Filed: Mar 28, 2019 8 Table Of Contents 9 10 solidated S 11 $ and shares in millions, except per share amounts 12 Fiscal Years Ended February 2, 2019 February 3, 2018 January 28, 2017 13 Revenue $ 42,879 $ 42, 151 $ 39,403 14 Cost of goods sold 32,918 32.275 29,963 15 Gross prof 9,961 9,876 9,440 16 Selling, general and administrative expenses 8,015 8.023 7 547 17 Restructuring charges 46 10 39 18 Operating income 1,900 1,843 1,854 19 Other income (expense): Gain on sale of investments 12 Investment income and other 49 48 3 31 22 Interest expense ( 73) (75) ( 72) Earnings from continuing operations before income tax expense 1.888 1,817 1,816 Income tax expense 424 818 609 Net earnings from continuing operations 1,464 999 1.207 Gain from discontinued operations (Note 3), net of tax expense of $0, $0 and $7, respectively 21 Net earnings $ 1,464 $ 1,000 $ 1,228 30 Basic earnings per share Continuing operations 5.30 $ 3.33 $ 3.79 33 CA Discontinued operations 0.07 34 Basic earnings per share 5.30 $ 3.33 $ 3 86 35 36 37 Diluted earnings per share Continuing operations $ 5.20 $ 3.26 $ 3.74 38 Discontinued operations 0.07 39 Diluted earnings per share 5.20 $ 3.26 $ 3.81 40 41 Weighted-average common shares outstanding 42 Basic 276.40 300.40 318.50 43 Diluted 281.40 307.10 322.60 44 45 Table_Of_Contents TABLE1 TABLE2 TABLE3 TABLE4 TABLES TABLE6 TABLE7 TABLE8 TABLE9 NAME_AN ... + Ready D J -- - + 100%7830eela-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X Home nsert Page Layout Formulas Data Review View DYMO Label ? Tell me what yr" want to do... Manry, Danielle File FI & Cut M A Y2 General Normal Bad E AutoSum ~ A O EB Copy Arial 10 A E Be Wrap Text Fill Paste Format Painter BIU - - LA Merge & Center $ + % " Conditional Format as Good Neutral Insert Delete Format Sort & Find & Formatting * Table _ Clear Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing A1 X v fx Created by EDGAR Online, Inc. B C D E F G H Created by EDGAR Online, Inc. 3 BEST BUY CO INC 4 INCOME_STATEMENT2 5 Form Type: 10-K 6 Period End: Feb 02, 2019 7 Date Filed: Mar 28, 2019 8 Table Of Contents 9 10 Consolidated Statements of Comprehensive Income $ in millions 12 Fiscal Years Ended February 2, 2019 February 3, 2018 January 28, 2017 13 Net earnings $ 1,464 $ 1,000 $ 1,228 14 Foreign currency translation adjustn (20) 35 10 15 Reclassification of foreign currency translation 16 adjustments into earnings due to sale of business (2 17 Comprehensive income $ 1,444 $ 1,035 $ 1,236 18 19 20 21 22 23 24 25 26 40 42 43 M ... TABLE28 TABLE29 TABLE30 0 TABLE31 BALANCE SHEET INCOME_STATEMENT INCOME_STATEMENT2 CASH_FLOW STOCKHOL ... + Q J -- + 100% Ready7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what you want to do... A Manry, Danielle & Share 16 Cut Arial Bad AutoSum BB) Copy - 10 * A" A" Ex Wrap Text General Normal Good Fill AY O Paste Check Cell nsert Delete Format Sort & Find & Format Painter BIU . . LABBE Merge & Center . $ - % " $68 428 Conditional Format as |Neutral Calculation Formatting * Table 41 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing A1 X V Created by EDGAR Online, Inc. B C D E F G H K Created by EDGAR Online, Inc. WN BEST BUY CO INC 4 INCOME_STATEMENT3 5 Form Type: 10-K Period End: Feb 02, 2019 7 Date Filed: Mar 28, 2019 8 Table Of Contents 10 Fiscal Year Ended February 2, 2019 11 Balances without 12 Impact of Changes to Consolidated Statements Adoption of Effect of Change 13 of Earnings As Reported ASU 2014-09 Higher/(Lower) 14 Revenue $ 42,879 $ 42,830 $ 15 Cost of goods sold 32,918 49 32,860 58 16 Gross profit 9,961 9 970 (9) 17 Operating income 1.900 1 909 (9) 18 Income tax expense 424 426 ( 2 ) 19 Net earnings 1,464 1,471 (7 ) 20 21 Basic earnings per share 5.30 $ 5.32 $ (0.02) 22 5.20 $ 5.23 $ (0.03) 23 Diluted earnings per share 27 28 * ... INCOME_STATEMENT INCOME_STATEMENT2 CASH_FLOW STOCKHOLDERS_EQUITY Y TABLE32 BALANCE SHEET2 INCOME STATEMENT3 TABL ... + Ready # 0 J -- - + 100%7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what you want to do.. A Manry, Danielle Share 16 Cut BB) Copy Arial - 10 - A" A" = = Wrap Text General Normal Bad Good AutoSum Fill AY O Paste Format Painter BIU . . ABEBE Merge & Center . $ - % " $68 428 Conditional Format as |Neutral Calculation Check Cell nsert Delete Format Formatting * Table Clear Sort & Find & Filter . Select Clipboard Font Alignment Number Styles Cells Editing A1 X V Created by EDGAR Online, Inc. F G H K M N 0 6 Period End: Feb 02, 2019 7 Date Filed: Mar 28, 2019 9 Table Of Contents 10 Additional Accumulated Other 11 Common Common Prepaid Share Paid-In Retained Comprehensive Total 12 Shares Stock Repurchase Capital Earnings Income (Loss) Equity 13 14 Balances at January 30, 2016 324 S 32 S (55) S S 4,130 5 271 S ,378 Net earnings 1,228 1,228 15 Other comprehensive income 16 17 (loss), net of tax: Foreign currency translation 18 10 10 19 adjustments 20 Reclassification of foreign 21 currency translation adjustments into earnings (2) (2) 23 Settlement of accelerated share repurchase 55 Tax benefits from stock options exercised, restricted stock vesting and employee stock 28 purchase plan 17 Stock-based compensation 108 108 29 Issuance of common stock Co 170 171 31 Common stock dividends, $1.57 (505 32 per share 33 Repurchase of common stock (21 Balances at January 28, 2017 1 2 295) (505 ( 454 ) (751) 34 311 1,399 1.709 Adoption of ASU 2016-09 10 (12 (2 Net earnings 1.000 1,000 37 Other comprehensive income, net of tax: 39 Foreign currency translation 40 adjustments 35 35 Stock-based compensation 129 41 Issuance of common stock 163 42 Common stock dividends, $1.36 43 per share Repurchase of common stock (35 (4 (299) (411) (411) 1,706) (2,009) Other ( 2 (2) 47 Balances at February 3, 2018 283 28 3,270 314 3,612 Adoption of ASU 2014-09 73 73 48 Net earnings 1,464 1,464 49 50 Other comprehensive loss, net 51 of tax: 52 Foreign currency translation 53 adjustments (20 Stock-based compensation (20) 38 38 55 Issuance of common stock 56 Common stock dividends, $1.80 per share 6 (497 (491) 58 Repurchase of common stock (21) (1) (167) (1,325) 1,493) Balances at February 2, 2019 66 5 27 S S S 2,985 S 294 S 3,306 ... TABLE29 TABLE30 TABLE31 BALANCE SHEET INCOME_STATEMENT INCOME_STATEMENT2 CASH_FLOW STOCKHOLDERS_EQUITY TABLE3: ... (+ Ready - + 80%7830ee1a-codf-41f8-8cc6-7bd4a25e4d29 [Compatibility Mode] - Excel X File Home Insert Page Layout Formulas Data Review View DYMO Label ? Tell me what you want to do... A Manry, Danielle & Share 16 Cut Arial - 10 * A" A" Wrap Text General Normal Bad Good AutoSum AY O BB) Copy Fill Paste BIU . . DABB= Merge & Center . Conditional Format as |Neutral Calculation Check Cell Format Painter Formatting * Table 41 nsert Delete Format Clear Sort & Find & Filter . Select Clipboard Font Alignment G Number Styles Cells Editing A1 X V Created by EDGAR Online, Inc. B D E F G H K Created by EDGAR Online, Inc. W N BEST BUY CO INC 4 TABLE32 5 Form Type: 10-K 6 Period End: Feb 02, 2019 7 Date Filed: Mar 28, 2019 8 Table Of Contents 9 10 ASU 2014-09 11 Adjustment on 12 February 3, 2018 February 4 February 4, 2018 13 As Reported 2018 Adjusted 14 Assets 15 Other assets $ 374 $ (19) $ 355 16 Liabilities 17 Unredeemed gift card liabilities 385 (69) 316 18 Deferred revenue 453 (26) 427 19 Accrued liabilities 1,001 3 1,004 20 Equity 21 Retained earnings 3,270 73 3,343 22 27 28 * ... TABLE30 TABLE31 BALANCE SHEET INCOME_STATEMENT INCOME STATEMENT2 CASH FLOW STOCKHOLDERS_EQUITY TABLE32 BALANCE # 0 J -- - + 100% Ready