I need help with the Inventory Turnover, Days in Inventory, Account Receivable Turnover, and Times Interest Earned please.
forme Itsel Dr Page Layout fumulus Dul Review Ven Help Tell me what you want to do 2 Share = - - more Nurite AYO . Colibri un v BIU. HA. Piste roser Ex Delete Format Cola Comiattirg Taule - Styles 50l & Fiter - find & Select - . Cisto Romer 128 X 43549 M Dec 31, 2018 Dec. 21, 2017 3 Dec. 31. 2016 $135.987 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cesh and cash equivalerils Marketable securities Inventories Accounts receivablr, nct and other Total current assets Property and equipment, net 3,265 12,619 7,223 16,085 531,750 9,500 17,174 16,677 75,101 61,797 S 20.522 10,467 15.014/ 12.144 GO, 197 26.365 Consolidated Statements of Cash Flows - L Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS, AND RESTRICTED CASH. BEGINNIN OPERATING ACTIVITIES: Not income Adjustments to reconcile net income ta net cash from operat Depreciation of property and equipment and other amortizatic 10 2,132 11.518 11,202 162,648 13,350 8,897 131,310 131,801 12 13 14 15 4,186 100 1841 34 516 38,192 23.663 18.170 56 17 (294) 3,892 (1,4251 18 Stock-based compensation Other operating expense, net Other expense (incanci, net Deferred income taxes Changes in operating assets and liabilities: Inventories Accounts recelvable net and other Accounts payable Accrued expenses and other Urearned revenue Net cash provided by used in operating activities INVESTING ACTIVITIES: Purchases of property and equipment Praceeds from property and equipment incentives 22,495 27,213 24,743 20,975 Goodwill Other assets Total assets Current liabilities: Aucunts payable Accrued expenses and other Linearned revenue Total current liabilities Lang-term debt Oliver long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity Preferrer stork, SC.D1 par valur: Autharord shares-500 issued an outstanding chares-none Cammon stock, $0.01 par value: Authorzed shares - 5,000 Issued shares-507 and 514 Outstanding shares - 484 and 491 Treasury stock, al cost Additional cald-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Tulal liabilities and stockholders' eyuicy 20 $ 2,371 $5.01 $ 4.90 (1.337) 21 389 (1,837) 26,791 (1,025) 19,625 41.549 $ 162.643 $94.6ES L 43,549 27,709 $131 310 541,322 Acquisitions, el of cusht acquired, and other Sales and matures of marketable securities Purchases of marketable securitas Net cash provided by used in) investing activities FINANCING ACTIVITIES: Proceeds from bland uther Repayments of long-term debt and other Principal repayments of capital lease obligations Principal repayments of finance case obligations Net cash provided by used in financing activities Toreign currency ellect unicar, cash equivalents, and restrict Net increase idecrease in cesh, cash equivalents, and restricte CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF THE SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on lang term debt 23 Info and Instructions Amazon Walmart Ratios Ratio Formulas + Testly T E [ -=_ = + 97 rile Hoi I D4* Per Layout Forms Dulo even View Help Tell me what you want to do Share v # 47 0 Caliar B v . . A - = Number $ % te Paste Inset . Delete Format - U Cerditional ramat Formatting Tante . cel Styles Sort & Filter Mind & Select Clipboard Font Alignment Number Styles Edrea 128 - X 13519 N 2 Dec 31, 2019 Dec. 21, 2017 Dec. 31, 2018 12 Manths Ended Dec 31, 2017 Dec 31, 2016 $21,846 $ 19,434 $ 15,175 $31.750 9,900 17,174 16.677 75,101 61,792 $ 20,522 11,464 16 047 13 164 60,197 48 264 Consolidated Statements of Cash Flows - USD ($I $ in Millions Statement of Cash Flows [Abstract] CASH, CASH FQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: Nul in curie Adjustments to reconcile net income to net cash from operating activities: Depreciation of property and equipment and other amortization, including capitalized content costs 10,073 3,033 2,371 11,474 8116 13.350 5,418 14.54B 11,2012 162,649 4.215 2012 (292) 129) 8,807 131 310 2 2.975 1601 (20) 1245) 219 31,515 15 38,192 23,63 GBG 68.191 23,195 27,913 17 18,171 5,097 57,383 21,743 70,975 Stock-besed conversation Other operating expense, net Other cone (income), net Deferred incorre taxes Changes in operating assets and liabilities: Inventories Accounts receivable, nct and other Mccounts payable Accrued expenses and other Unearned mynnin Net cash provided by used in operating activities INVESTING ACTIVITIES: Purchases of property and equipment Proceeds from property and equipment incentives 18,983) 14.780) 7.100 (2,426 5,030 11,814) (4,6151 3,253 172 1,151 20,722 1,724 1,955 17,203 18.265 13.427 (11,955) 1,897 2,104 (7. 80) 1,067 12.1861 (13,972) 1116 (7,100) 112,3591 (12,731) (27.084) (7.240) (9.516) 11.8371 (1.837) Acouisitions, net of cash acquired, and other 26,791 21 389 Sales and maturities of marketable securitas (1,035) Purchases af marketable securitics 19.625 8.535 Net cash provided by used in investing activities 13,549 27,709 FINANCING ACTIVITIES: $112,144 $ 131 310 Pracoads from Inng term debt and other Repayments allong term debt and other Principal repayments of capital lease ulipations Principal repayments of finance lease ob leations Net cash provided hyrd in Financing activities Foreign currency effect on cash, cash equivalents, and restricted cash Net increase idecrease) in Casil, cesh equivalents, and restricted cesh CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for incurest on long-term debt Info and Instructions Amazon Walmart Ratins Ratio Formulas # 16,728 11,201) 14.799) (200) 32 16581 17,4491 13371 (7,686) 13541 20.317 32,1/3 (327) (3,360) (117) (3,716) (2:2) 3.759 19,934 713 1.922 21,855 27 38 854 328 290 Read F - L + 975 Excel Ahmad Eltarase F - b File 5 lome X Share Incit Drm Page Layout Data Review View ACC 3910 Pro 3 Fall 2019 14 Telewiat you want to do Help Formulas A ren A 2. A Number Colibri B V11 U - Cerditional Formatas I Call . I A - = - . $ - % Formatting Tools Slyles - Delete Format Sort & Fille Find a 5 Cipbar Bort Alamint Sopics Cels Editing 128 - X 43549 K L N 245) 38. 192 23,663 34,616 13.170 13.583; 5,097 57,892 11.3141 14,6151 3.242 48,291 23.495 27,213 24,743 Deferred Income taxes Changes in operating assets and liabilities: Inventories Accounts recelvable net and other Accounts payable ccrued experies and other Uneamed revenue Net cash provided hy (und in operating activities INVESTING ACTIVITIES: Purchases of property and equipment Proceeds from property and equipment Incentives 472 1.151 11.4261 13.4361 5,030 1.724 1.955 17,202 7.100 283 738 18,265 20075 (11,955) 17.8011 13,427 2,104 11,8371 (11,972) 12161 12.837) 26,791 11.035) 19.625 13,519 $ 16:2,6:49 1444) 3.636 12.1861 8,240 17,1001 112,3591 (12,721) (27,084) 4,577 17,2401 19,5161 27.709 $ 131,310 OSB 17,4491 13271 13.8501 1141) Acquisitions, relo Casacuired, and other Sales and maturities of Marketable securities Purchases af marketable securities Nel cast provided by used in investing activities FINANCING ACTIVITIES: Procards fram long term debt and other Regayments of long-term dubt and other Principal repayments of capital lease obligations Principal renaments of financa lasa obligations Net cash provided by (used in financing activites Foreign currency ellel on cash, cash equivalerils, and restricted cash Net Increase decrease in cath, cash equivalents, and restricted cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH. END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on lore-term debt Cash paid far interest on capital and finance case phligations Cash paid far incere taxes, net af refunds Property and equipment acquired under capital leases Property and equipment arquired under build ta-suilt lenses 16.228 14,301) ,799) (21X1 9,928 713 1,922 21,456 7.626) 13521 10,317 32.172 (3.716) 12121 3,759 19.934 328 200 851 525 2016 412 1.104 10.615 $3,641 319 957 9,537 52,141 5.701 $ 1,2015 18 50 Info and Instructions Amazon Walmart Rates Ratio Formulas E -- ENG .... Type here to search A . 8:38 FM 2015 Home Desa Review View Help D Tell me what you want to do 2. Share sert Dr Page Layout Formula Calibri 11 A BIU... A . Numbe AT - = O - = - = . ab E Wh Conditional Fornat a Cell - Inset Dolcta rel E . $ % $ Formatting Table Styles - Sort & Filter Fird & Select Cited Sint Rumber Editing 128 - X 43549 1 Amazon Financial Statement Consolidated Statements of Operations - USD ($1 shares in Millions $ in Millions 12 Months Ended Dec. 31, 2018 Dec. 31. 2017 $ 232,887 $177,866 Dec. 31. 2016 $135,987 4 Totul nel Sales 5 Operatine expenses: 6 Coat of sales 7 Fulfillment 8 Marketing Cuense Technology and content Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and casi equivalents Marketable securities Inventarias Accounts receivabla, net and other Totalcurrent assets Procery and equieren het 134,156 34,027 13,814 28,837 111,934 25,249 10,069 22,620 84,25 17,619 7,233 15,085 2,674 Goodwill Other assets 214 4,386 296 220,466 12.421 440 1,417 : " 2,432 167 131.801 4,186 100 173,760 4,106 202 90 10 General and administrative 11 Other operating expense, net 12 Taual operating expenses 13 Operating income loss) 14 Interest income 15 Intrast expenso 16 Other income (expensel.net 17 Toual noit-operating income lexpense! 18 Income before income taxes 19 Provision for income taxes 20 Equity method investment activity, not of tax 21 Net incare 22 Basketnim per share Diluted earnines per share 1848) 346 1300 3,806 1/691 (1,160 11.261 12941 3.892 $ 10,073 $20.68 $ 20.11 $ 3,023 $6.32 $6.15 (1.4251 (961 $ 2,371 $5.01 51.90 Current liabilities Accounts payable Accrurd w ars and ather Unearned revenue Tolel currenL liabilities Long-term debt Other long-term labilities Commitments and contingencies Note 7 Stockholders' equity: Preferred stock, $0.01 var value: Authorized shales - 500 Issued and outstanding in Common stock, 30.01 par value: Authorized shares - 5,000 Issued shares - 507 and 5 shares AXA and 491 Treasury stack, at cost Additional paid-in capital Accumulaled other curnpretensive loss Retained earnings otal streholders' equity Total liabilities and stackholders' equity 487 474 500 24 Weighted average shares used in computation of earnings per share: 25 Basic in shares) 25 Diluled (in shares) 27 Net product sales 2 latal net sales 29 Net service salcs 20 Total net sales 31 32 $ 141,915 $118,573 $ 94,615 $ 90,972 $59,293 $ 41,322 24 35 Info and Instructions Amazon Walmart Ratios latio Formulas + Inventory Turnover 385,301 139,156 37 Cost of Goods Sold 38 Average Inventory Days in Inventory 44 Number Of Days 365 365 365 Inventory Turnover Accounts Receivable Turnover 51 Net Credit Sales 52 Average Net Accounts Receivable 56 Times Interest Earned
