Help finding the following based on the given income statement and balance sheet:

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 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%