Can you please help me finding Vertical and horizontal analysis for 2017, 2018, 2019. please
AutoSave . OFF Ac 445 project Part 1 and 2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Liberation Sans1 11 AA ab Wrap Text v Custom IX V v ZNAY- O. Paste BIU BY OvAv E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Ideas Formatting as Table Styles Filter Select FO B C D E G H Amazon.com Inc. Consolidated Balance Sheet: Assets VERTICAL ANALYSIS HORIZONTAL ANALYSIS USS in millions Assets Dee 31, 2015 Dee 31, 2018 Dee 31, 2017 Dee 31, 2019 Dec 31, 2018 Dec 31, 2017 Dee 31, 2015 Dec 31, 2018 Dec 31, 2017 Cash and cash equivalents 36,092 $1,750 20 522 Marketable securities 18,929 9.500 10,464 Inventories 20,497 17,174 16,047 Accounts receivable, net 17,663 13,310 9.692 Other 3.153 3 367 3.47 11 Accounts receivable, net and other 20,816 16,677 13,164 Current assets 96 334 75,101 60,197 Property and equipment, net 61,197 48.865 Operating leases 25,141 Goodwill 14,754 14.548 13,350 Other assets 16314 11,202 $.897 Long-term assets 128,914 87,547 71,113 Total assets 225,24 162.648 131.310 20 LIABILITIES AND SHAREHOLDERS' EQUITY 21 38,192 34,616 22 47,183 Current portion of lease liabilities, operating leases 3.139 Current portion of lease liabilities, finance leases 9.884 5,839 Current portion of long-term debt 1,307 3,320 25 1.371 100 26 Other 18,109 14 572 12 231 Accrued expenses and other 32.439 13,663 18,170 28 Unearned revenue 8,190 6.536 5,097 29 Current liabilities 87.812 68 391 57.853 Long-term lease liabilities, operating leases, excluding current portion 22 696 Long-term lease liabilities, finance leases, excluding current portion 17.095 31 9,850 8,435 Long-term lease liabilities, excluding current portion 39,791 9,650 8,438 Long-term debt, exchading current portion 23,414 24,743 Other long-term liabilities 12171 23,495 17563 12.537 35 Long-term Mabilities 75 376 50,708 45,718 36 Total liabilities 163,188 103,601 37 Preferred stock, 50.01 par value; issued and outstanding shares - none 19,09 38 Common stock, 50.01 par value stock, at cost (1,837) 13,658 (1,837) (1,837) Additional paid-in capital 26,191 21.389 Accumulated other comprehensive loss (985) (1,035) (484) Retained carni 1,220 19,625 8,636 Stockholders' equity 62.050 43.549 27.709 Total liabilities and stockholders' equity 225,248 162,648 131 310 45 46 47 Net product saks 160,408 141,915 118 573 48 Net services saks 120,11 90,972 39.293 49 Net sales 280 522 232,887 177,86 Cost of sales (165.536) (139,156) Gross profit 11 1,934) 114,986 93,731 65,932 Fulfillment (40.232) 25,249) Technology and content (35.931) (34.027) (28,837) (22 620) Marketing 18,878) 13.814 (10.069 General and administrative (5.203) (4 336) (3,674) Other operating expense, net (201) (296) (214) ST Operating income 14.541 2.421 4,106 Interest income 832 440 202 Assets + Ready + 75%
