Tell me what you want to do. View Review Data Formulas Page Layout Insert Home le Amazon Financial Statement 12 Months Ended Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions Dec. 31, 2016 Dec. 31, 2017 Dec. 31, 2018 $ 177,866 $ 135,987 $ 232,887 Total net sales 5 Operating expenses: 6 Cost of sales 7 Fulfillment 8 Marketing Expense 88,265 111,934 139,156 17,619 25,249 10,069 34,027 7,233 13,814 16,085 28,837 22,620 Technology and content 10 General and administrative 11 Other operating expense, net 12 Total operating expenses 13 Operating income (loss) 14 Interest income 15 Interest expense 16 Other income (expense), net 17 Total non-operating income (expense) 18 Income before income taxes 3,674 2,432 4,336 214 167 296 173,760 131,801 220,466 4,106 4,186 12,421 440 202 100 (848) (484) 1,417 (183) 346 90 (1,160) (300) (294) 11,261 3,806 3,892 19 Provision for income taxes 1,197 (769) (1,425) (96) $ 2,371 $ 5.01 $ 4.90 20 Equity method investment activity, net of tax 21 Net income (4) $ 10,073 $ 20.68 $ 20.14 $ 3,033 22 Basic earnings per share Diluted earnings per share 23 $6.32 $6.15 24 Weighted-average shares used in computation of earnings per share: 25 Basic (in shares) 26 Diluted (in shares) 27 Net product sales 28 Total net sales 29 Net service sales 487 480 474 493 484 $ 141,915 $ 118,573 S 94,665 B0 Total net sales $ 90,972 $ 59,293 31 $41.322 ACC 3010 Project 3 Part 3 Fall 2019.xlsx - Excel Tell me what you want to do. Review View Data Page Layout Formulas sert H. Dec. 31, 2017 Dec. 31, 2018 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: $ 31,750 $ 20,522 Cash and cash equivalents Marketable securities 10,464 9,500 17,174 16,047 Inventories Accounts receivable, net and other 13,164 16,677 75,101 60,197 Total current assets 48,866 Property and equipment, net 61,797 14,548 11,202 Goodwill 13,350 Other assets 8,897 Total assets 131,310 162,648 Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities 34,616 38,192 23,663 18,170 6,536 5,097 68,391 57,883 Long term debt 23,495 24,743 Other long-term liabilities Commitments and contingencies (Note 7) 27,213 20,975 Stockholders' equity: Preferred stock, $0.01 par value: Authorized shares - 500 Issued and outstanding shares - none Common stock, $0.01 par value: Authorized shares - 5,000 Issued shares 507 and 514 Outstanding shares-484 and 491 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity (1,837) (1,837) 26,791 21,389 (484) 8,636 (1,035) 19,625 43,549 27,709 $ 162,648 $ 131,310 tnfo and instructions Ratio FormulaS Amazon Walmart Ratios M. 12 Months Ended Consolidated Statements of Cash Flows- USD (S) Sin Millions Dec. 31, 2017 Dec. 31, 2016 Dec. 31, 2018 Statement of Cash Flows (Abstract] CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITES: $ 16,175 $ 19,934 $21,856 2,371 3,033 10,073 Net income Adjustments to reconcile net income to net cash from operating activities: Depreciation of property and equipment and other amortization, including capitalized 8,116 15,341 11,478 content costs 2,975 4,215 5,418 Stock-based compensation Other operating expense, net Other expense (income), net Deferred income taxes 202 160 274 (292) (20) (246) 219 (29) 441 Changes in operating assets and liabilities: (3,583) (4,780) 7.100 (1,426) (3,436) (1,314) Inventories (4,615) Accounts receivable, net and other Accounts payable Accrued expenses and other Unearned revenue Net cash provided by (used in) operating activities 5,030 3.263 1,724 283 472 1,955 1,151 738 30,723 18,365 17,203 INVESTING ACTIVITIES: (11,955) Purchases of property and equipment Proceeds from property and equipment incentives 13,427 (7,804) 2,104 1,067 1,897 (13,972) 9,677 Acquisitions, net of cash acquired, and other Sales and maturities of marketable securities Purchases of marketable securities Net cash provided by (used in) investing activities (2,186) (116) 8,240 4,577 (7.100) (12,369) (12,731) (7,240 (27,084) (9,516) FINANCING ACTIVITIES: 16.228 768 618 Proceeds from long-term debt and other Repayments of long-term debt and other Principal repayments of capital lease obligations Principal repayments of finance lease obligations Net cash provided by (used inj financing ectivities Foreign currency effect on cash, cash equlvalents, and restricted cash Net increase (decrease) in cash, cash equivalents, and restricted cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD (668) (1,301) (327) (3,860) (147) (3,716) (7449) (337) (7,686) (351) (4,799) (200 9,928 713 (212) 20.317 1.922 3,759 32.173 21,856 19.934 SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on long-term debr Cash paid for interest on capital and finance lease obligations 854 328 290 575 319 206 Cash paid for income taxes, net of refunds Property and equipment acquired under capita leases Property and equipment acquired under buiid-to-suit leses 1.184 957 412 10,615 9,637 5.704 $3.641 S1.209 $3,541 8:33 AM 4x 12/6/2019 SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Determine what amounts are needed to calculate the ratios requested. For example you need Current Assets and Current Liabilities to compute the Current Ratio. Enter the names of the items needed in the boxes in column A for each of the ratios. See Ratios Tab, column A for Current Ratio. Next, use the cell reference function and any other necessary formulas to enter the numbers for each of the items for each of the companies in the boxes under the requested ratios. Again see Ratios Tab Columns C and E for the Current Ratio for Walmart and for Amazon. Next use the numbers you have entered to calculate the ratios requested. Again see the Ratios Tab Columns C and E for Current Ratio for Walmart and for Amazon. ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES Repeat the steps for each of the ratios listed on the Ratio Tab Assume all sales were on credit where necessary. Final step - So that we can see your use of formulas you must use the following steps to display your formulas for the ratios on the Ratios Formula Tab. Copy all of the Ratios information from the Ratios Tab to the Ratios formulas tab. Highlight the entire ratios information area and press the "ctrl" key and the "-" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed on the Ratio Formulas Tab page and the numbers displayed on the Ratios Tab. POSSIBLE 5 POINTS EXTRA CREDIT ACC 3010 Project 3 Part O Tell me what you want to do View Data Review Formulas Home Page Layout Insert File H10 Ratios 2. AMAZON WALMART 3 4. 5 Current Ratio 0.799 1.098 6. 8 Current Assets 61,897 75,101 9. 10 Current Liabilities 77,477 68,391 11 12 13 Debt to Asset Ratio 14 15 16 17 18 19 20 21 Return on Equity 22 23 24 25 26 27 28 Return on Assets 29 30 31 Info and Instructions Amazon Walmart Ratios Ready Ratio Formulas H10 28 Return on Assets 29 30 31 32 33 34 35 Inventory Turnover 36 37 38 39 40 41 42 Days in Inventory 43 44 45 46 47 48 49 Accounts Receivable Turnover 50 51 52 53 54 55 56 Times Interest Earned 57 58 59 Info and Instructions Amazon Walmart Ratios Ratio Formulas Peady B. H10 58 59 60 61 62 63 64 65 Free Cash Flow 66 67 68 69 70 71 72 73 74 75 Gross Profit Rate 76 77 78 79 80 81 82 Profit Margin 83 84 85 86 87 88 89 Asset Turnover Info and Instructions Amazon Ready Walmart Ratios Ratio Formulas 87 88 89 Asset Turnover 90 91 92 93 94 95 96