Hello I need help with Inventory Turnover,Days in inventory, Account Receivable Turnover, and Times Interest Earned Please.

of Calibri un v BI U - - Number Paste Clipboard Font Alignment C46 B D 8.3780 34 35 Inventory Turnover 36 37 Cost of Goods Sold 38 39 Average Inventory 385,301 139,156 16,611 40 41 42 Days in Inventory 43.569 44 Number Of Days 365 365 45 46 Inventory Turnover 8.378 48 49 Accounts Receivable Turnover 15.609 50 51 Net Credit Sales 232887 52 53 Average Net Accounts Receivable 14,921 54 55 56 Times Interest Earned 16.874 58 Operating Income 12,421 59 1,417 60 Interest Expense 61 62 Net Income 63 10,073 - N. v Inset . 47 O - Caliari v n BIU- A - = = = 11 General $ - % Paste - , Carditional Format as Formatting Table Cell Styles Sort & Filtar Find Seech Format 30 Aliament 9 CE Ciocard - G X b Total revenues 1 Walmart Financial Statements 12 Months Ended Jan. 31, 2018 Jan. 31, 2019 Jan. 31, 2017 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 4 Revenues: 5 Net Sales Membership and other income Consolidated Balance Sheets - USC Current assets: Cash and cash equivalents Receivables, net Inventories $ 510,329 4,076 $495,761 4,582 $ 481,317 4,556 514,405 500,343 485,873 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 1,975 371 (217) 2.129 1,978 352 (152) 2,178 3,136 2,044 323 (100) 2,267 7 Total revenues 8 Costs and expenses: 9 Cost of sales 10 Operating, selling, general and administrative expenses 11 Operating income 12 Interest: 13 Debt 14 Capital lease and financing obligations 15 Interest income 16 Interest, net 17 Loss on extinguishment of debt 18 Other (gains) and losses 19 Income before income taxes 20 Provision for income taxes 21 Consolidated net income 22 Consolidated net income attributable to noncontrolling interest 23 Consolidated net income attributable to Walmart 24 Net Income per common share: 25 Basic net income per common share attributable to Walmart 26 Diluted net income per common share attributable to Walmart 27 Weighted average common shares outstanding: 28 Basic 29 Diluted 30 Dividends declared per common share 31 8,368 11,460 4,281 7,179 (509) $6,670 15,123 4,600 10,523 (661) $ 9,862 20,497 6,204 14,293 (650) $ 13,643 Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing ol Properly under capital lease and financing obli Less accumulated amortization Property under capital lease and financing obli Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due wit Total current liabilities Long-term debt Long-term capital lease and financing obligatio Deferred income taxes and other Commitments and contingencies Faulty $ 2.28 $ 2.26 $3.29 $ 3.28 $ 4.40 $ 4.38 2,929 2,945 $ 2.08 2,995 3,010 $ 2.04 3,101 3,112 $ 2 Info and Instructions Amazon Walmart Ratios Ratio Formulas Herie Insert Drew Page Layout Form Duta Review Vew Help Tell me what you want to do Share - D. membe 2. AYO General | Colibri vil v BI USA - AM teret. De ctc Fama Conditional Formelo Formattirg Taule Pasta Ce Styles Sort Filte. firda Select Aligere Nur Syko A7 - X Total revenues * * la 31, 2018 IAN 31, 2018 Cansalidated Statements of Cash Flows - USD ($I $ in Millions 12 Vantha Frded Jan. 31, 2018 * Jan 31, 2018 Consolidated Balance Sheuta - USD ($) $ in Millions Current assets: Cash and cach cuivalents Keceivables, ret Inventories * $4,756 $ 7,722 6,243 11,269 $/2/ 9 5 20.23 13,282 * * 10.579 3.623 51,897 3.511 59,664 10,678 3,516 = Cash flows from operating activities: Conso dated ret income Adjustments to reconcile income from continuing operations to net cash provided by operating activities: Depreciation and amortization Unrealized Gain Loos on Investments Gains and losses for disposal of business operations Deferred income taxes Lus on eatinguisment of debt Other pertine Activites Changes in certain assets and liabilities, Met of effects of acquisitions: Receivables, net = = 195.910 (31,1923 104,317 105.154 22,179 107,675 100! 3135 - 1,734 1210 " * 11.0741 11401 : 10,211] 12,760 19,692 7,078 31,181 14,822 219,295 12,703 9.500 2.1.13 10,212 11,708 294,522 A Prepaid cars and other Total current assets Property and equipment: Property and ecuipment Les acuinulle vepreciation Property and Pouipment, net Property under capital lease and financing obligatiana Praperty under capital lease and financing obligat ons Less accumulated amortizat on Property under capital lease and financing obligations, net Goudwill arberlone term assets Tatal assets Current liabilities: Shot-term borrowings Accounts payable Accueu lililities Accued income taxes Long term deat dua within one year Cap tal lease and firsning obligat ons duew thin one year I utal current liabilit es Long-ler veut lonelem capital lease and financing ab pations Deferred Income tancs and other Commitments and contingencies 183 1401 27,753 1857 28,337 10,944 17.060 22.159 16.092 22.122 519 876 200_1 378 1045 1.876 3,738 14,6551 4311 LGT 1375 177 19,0/9 4,521 C.C-15 .520 6,683 11,981 4,780 Accounts payable liabilities Armed income TAS Net cash provided by operating activities Cash flows from investing activities: Payments fo- property and equipment Proceeds from the disposal of property and equipment Picbeads from the p alaceilan operations Purchase of available for sale securities Payments for business acquistons, net af cash acquired Other invest ng sctv ties Net tash used in invest ng activ ties Cash flows from financing activities: Nel change in short-term Irrawires Pracoods from cance of lone term deat Repayments of long-term debt Premiums said to extinguish deat Didends paid Purt of Cuir any block Duidend paid to nontrolling interest Purchase of noncontrolling interest Other Financing activities Net cach used in financing activities Effect of Exchange Rate on Cash Cash Equivalents, and Restricted Cash Nel intenderin vuuvent and relleu Cash, Cash equivalents and restricted cash arginning of year Cash, cach cqulvalents and restricted cash at end of period CHIRAAmanta Hirlarurn nirach flau information: 8,354 1531 15,872 12,7841 Equity 7475 113,051 13,039 6,124 18.295 1600 6,202 17, 1101 2,648 85,107 (16,181) 14311 Common stock Capital in excesul al value Retained earnir ex Accumulated other comarchesive loss Total walmart shareholders' equit, Noncontroling nterest Total vuity Touloilies and equity 2.965 R9,785 (11,5421 72,496 2.14 79,624 $ 219.295 16291 1251 2.93 00,022 $ 204,522 1231 742 7,014 7,755 1130 7,144 7014 Info and Instructions Amazon Walmart Ratios Ratio Formulas O EL -- + S Home Insert Draw P age Layout Formuas Data tawon Viaw Help Tell me what you want to do Share . ' 9 General Caliar un v BIU... A - = - = Cerditional Fomates Formatting Table Cell Suves Inzet Boleta | Format Sort & Filter - Find & Select - Chord ml ALL Sias A7 - X o Total revenues MNC als 4 Cash Andra 5 Recclvables, net Inventories $7,727 6,283 $ 6,756 5,614 43. 72 $ 7,179 $ 10,523 $14,293 3,511 59,664 1, 63 61,897 10,678 3,516 10,529 10,000 105 VID (81,193) 195.159 77,479 107,675 1904 0,116 1,210 194,317 1,734 206 12681 1,311) 1,8.11 (1,074) (110) 12.700 (5.682) 7,078 31,181 14,922 219.295 12,709 (5.560) 7,143 18,242 11,798 204.522 (402) 1.022 3,042 1,280 492 31,673 401 27,759 24,337 10,344 11,619 5.725 47.66O 22,159 5,257 46,092 22.122 10,051 378 5:9 1.040 7 Prepaid expenses and other 9 Total current assets 9 Property and equipment: 10 Froperty and ecuipment 11 L u rulated depreciation 12 property and guipment, net 13 Property under capital lease and financing obligations: 74 Froperty under capital lease and Financing obligations 15 Les acumulated an orticat on 16 Pregarty under capital and Financine chiligations, | | 'll 10 other ong-term assets 19 Total assets 20 Current liabilities: 21 Short tar barrowing 22 Accounts payable 23 Accrued liablities 24 Act income taxes 25 lanetern riante wir in one year 26 Capital casc and financira obligations duc within ane year 27 Total current liabilites 28 Long-term vett 20 lanperin capitales and financing obliga ans 30 Deferred Income taxcs and other 31 Commitments and contingencies 32 Equity: 33 Curuxk 34 Capital in excess of ar Value Retaired carnings 36 Accumulated other comprehensive loss 37 Total Walishareholders' quity 38 NonControlle ras 39 Total culty 40 Total liabilites and equity Cash flows fram aperating activities: Consolidated net corre Adjustments to reconcile income from continuing operations to nct cash provided by operating activities: Depreciation and mortalin' Unrea zod Gain Loos on Investments (Gains and losses for disposal of Business operations Deferred income taxes LOS l extrement del Ocher operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, ret Inweiluries Acants payable Accrued liabilities Accrued Income taxes Net cash prov ded by operating activities Cash Flows from investing activities: Payment for aroperty and couipment Froceeds from the disposal of property and equiament Froceeds from the disposal of certain operation Pucluse of available for sale Securities Payments for als angustions, not of cash Arquired Other investing activities Net cash used in investing actities Cash flows from financing activities: Net chamer in Stellenbrawines Procecos from Issuance of long term debt Kepayments at ong-term cebt Fremiums paid to eating sideot Dividend peid Purchase of company stock Dividends paid to noncontrolling interest Fu chase of narcontrolling interest Other financing activities Netrash. In Hinancing Artivities Effect of Exchange Rate on Cash, Cash Equivalents, and Restricted Cash Net increase (decressel in cash, con cuivalents and restricted cach Cash.cash equivalents and restricted cash at begining of year Cash, cahuivalents and restitu e ndalid Supplemental disclosure of cash flow Information: Income taxes said Interest and 1,876 3,738 4/0 0 (14,8661 4311 (24,046 (375) (1.9010 (2,463) 1311 113,49G 771 (9,079) 79,521 30.015 19,520 1931 11,181 8,354 15,872 2,7841 7,476 (13,063) 0.0591 6,124 (8,216) 295 6.102 17,40 431) 630) 18 288 7,165 30,795 11.5420 72.196 7,138 79,634 $ 211,295 2,648 35,107 (10.1919 77.0ES 2,953 30,822 $ 204,522 6291 2,5271 4381 (261) (19,675) 6,216 (R.208) (475 90 981 (19,072) (452) (1,7471 ,992 7.144 (1901 2,111 7,014 7,756 45 3,982 $ 2,948 E,179 $2,450 4,507 $2,352 Info and instructions Amazon Walmart Ratios Ratio Formulas # F C - + 20