For this part of your company project, you'll download the Excel file and fill in the Project Part 3' sheet of the workbook. Fill in all blue cells in the sheet and upload when complete. You may email me drafts for review prior to the weekend. For one of the questions, you will need the market price of shares. Use the values listed below. Do not use current prices for shares; we want the share price that represents the reporting period. Share prices: Amazon: $1,847.84 Apple: $218.82 Walmart: $113.02 Microsoft: $133.96 Note: Once these are graded update the values in your Excel file. You will use the same spreadsheet to complete parts d and later in the semester Email me with any questions, Company Annual Report Links: Amazon Apple Microsoft Walmart Company Project ExcelFile.xlsx August 19 2020, 7:07 PM Submission status A For the following items, provide the most recent values as well as which statement they are listed on "Most values are listed as 'n millions' or similar. Leave them this way, and note it at the bottom of the valves column Statement Item Value le: IS, BS 7 Net Income 8 Total abilities 9 Total Assets 10 Total Current Assets 11 Total Current Liabilities 12 Cash & Equivalents 13 Short-Term Invesments 14 Net Current Receivables 15 Net Credit Sales (or Net Sales/Revenues) 16 Net Sales /Revenues 17 Income Tax Expense 18 Interest Expense 19 Preferred Dividends (o if none) 20 Market Price per Share of Stock S 1,847.84 (Use the value provided on the assignment page) 21 Average Total Assets (Show calculation, average of the two most recent years) 22 Cost of Goods Sold cost of sales) 23 Average Merchandise Inventory (Show calculation, average of the two most recent years) 24 Average Net Accounts Receivable (Show calculation, average of the two most recent years) 25 Average Common Shares Outstanding (Show calculation, average of the two most recent years) 26 Average Shareholder's Equity (Show calculation, average of the two most recent years) 2017 19,934 2018 21,856 $ 2019 32,173 $ 3,033 10,073 11,588 11,478 4,215 202 (292) (29) 15,341 5,418 274 21,789 6,864 164 (249) 796 219 (1.314) (4,615) 3.263 (3,583) (4,780) 7.100 283 738 18.365 (3,278) (7.681) 8,193 (1,383) 1,711 38,514 472 1,151 30,723 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: Net income Adjustments to reconcile net income to net cash from operating activities: Depreciation and amortization of property and equipment and capitalized content costs, operating lease assets, and other Stock-based compensation Other operating expense (income), net Other expense (income), et Deferred income taxes Changes in paling utan liabilities Inventories Acounts receivable, net and other Accounts payable Accrued expenses and other Uncond revenue Net cash provided by used in) operating activities INVESTING ACTIVITIES Purchases of property and equipment Proceeds from property and equipment sales and incentives Acquisitions, net of cash acquired, and other Sales and matutes of marketable securities Purchases of marketable securities Nel cas provided by used in) investing activities FINANCING ACTIVITIES: Proceeds from long-term debt and other Repayments of long-term debt and other Principal repayment of finance lees Principal repayments of financing obligations Nel cash provided by (used) financing activities Foreign currency effect on cash, cash equivalents, and restricted each Net is decrease in casa yurvalets and restricted cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENTAL. CASH FLOW INFORMATION Cash paid for so long-term det Cath paid for operating Cashpond for interest on finances Cash paid for restening obligations Cash power income taxes, et of refunde Audi acquired under operates Property and played under finance Pupicity and cupait quited under build.-utattament (11,935) 1,897 (13,972) 9,677 (12,731) (27.084) (13,427) 2,104 (2,186) 8.240 (7.100) (12.169) (16,861) 4172 (2.461) 22,681 (31,812) (24.281) 16,228 (1.101 (4.799) (2001 768 (668) 17449) (337) (7686) (351) 10,317 32,173 2.273 (2.684) 19,628) (27) 10,066) 70 4,237 36,410 9,928 1.922 21.856 S 32 $ 154 875 1:361 200 119 957 381 194 1184 39 881 7870 10,615 4637 3.941 2019 s 2017 118,573 59,293 177,866 Year Ended December 31, 2018 $ 141,915 s 90,972 232,887 160,408 120,114 280,522 111934 25,249 22,620 10,009 3,674 214 173,760 4,106 Net product sales Net service sales Total net sales Operating expenses Cost of sales Fulfillment Technology and content Marketing General and administrative Other operating expense (income), net Total operating expenses Operating income Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income before income taxes Provision for income taxes Equity-method investment activity, net of tax Net income Basic earnings per share Diluted earnings per share Weighted average stures used in computation of earnings per share Basic Diluted 202 (848) 346 139,156 34,027 28,837 13,814 4,336 296 220,466 12,421 440 (1.417) (183) (1,160) 11,261 (1.197) 9 10,073 5 20.68 $ 20.14 5 165,536 40,232 35.931 18,878 5.203 201 265,981 14,541 832 (1.600) 203 (565) 13,976 (2,374) (14) 11,588 13.46 23.01 (300) 3,806 (769) $ 3,033 6.32 6.15 $ s 5 $ S 480 487 494 493 500 504 I Year Ended December JI, 2018 2017 s 3,033 2019 11 588 s 10,073 S 533 (538) 78 533 Net income Other comprehensive income (loss): Net change in foreign currency translation adjustments Foreign currency translation adjustments, net of tax of 55, 56, and S(5) Reclassification adjustment for foreign currency translation included in Other operating expense (income), net," net of tax of 50, 50, and 529 Net foreign currency translation adjustments Net change in unrealwed gains (losses) on available-for-sale debt securities: Unrealized gains (losses), net of tax of $5, 50, and S(12) Reclassification adjustment for losses gains) included in the income texpense) net net of lux of S0, Sand 50 Ner unrealized grains (lossen) on available for sale delt securities Total other comprehensive income (1) Comprehensive income (108) (30) (538) (39) - 7 (2) 501 3.534 (9) (547) 9.526 (4) 70 29 11.637 s $ AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) December 31, 2018 2019 $ 31.750 9,500 17.174 16,677 75,101 61,797 36,092 18,929 20,497 20,816 96,334 72,705 25,141 14,754 16,314 225,248 14,548 11,202 162,648 5 5 ASSETS Current assets: Cash and cash equivalents Marketable secunities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Operating leases Goodwill Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Accrued expenses and other Uncanned revenue Total current liabilities Long-term lease liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity Preferred stock, So 01 par value Authorized shares - 500 Issued and outstanding slures -- none Common stock, 5001 par value: Authorized shares - 5,000 Issued shares - 514 and 521 Outstanding shares 491 and 498 Treasury stock, cost Additional paid in capital Accumulated other comprehensive income fosse Retailed carings Total stockholders' equity Total liabilities and stockholders equity 38,192 23,663 6,536 68,391 9,650 23,495 17,563 47.183 32,439 8.190 87.812 39.791 23.414 12,171 3 26,791 (1035) 19.625 1.837) 13,658 1980 31220 62,060 225,248 5 162.648 S See accompanying notes to consolidated financial statements Cm Stock Shares A Tremory Stock (1,837) $ Additional Paldia Capital 17,186 Aramalate Other Comprehensive ) Income (985) 5 Retained Erlep 4916 Total Steckboken' Equity 19,285 477 S 5 s S 687 3,033 687 3,033 S01 1 501 SII 7 4,202 21,389 484 5 (1.837) (484) 4,202 27,709 8,636 (4) Balance as of January 1, 2017 Cumulative effect of a change in accounting principle related to stock-based compensation Net income Other comprehensive income (los) Exercise of common stock options Stock-based compensation and wance of employee benefit plan stock Balunoc w of December 31, 2017 Cumulative effect of change in accounting principles related to revenue recognition, income taxes, and financial instruments Net income Other comprehensive income foss) Exercise of common stock option Stock-based compation and issuance of employee benefit plan stock Balance as of December 31, 2018 Cumulative effect of change in accounting principle related to less Net income Other comprehensive income foss) Exercise of common stock options Stockheed comic and ince of employee benefit plan stock Balance of December 31, 2019 916 10,073 TITI 912 10,073 (547) (547) 491 5,402 26,791 5,402 43,549 S (1,837) (1.035) 19,625 11,588 7 11,588 49 19 6,867 33.658 5 498 $ 5 5 (1.837) 5 6.867 62,060 (986) S 31,220 5 See accompanying notes to consolidated financial statements