B C GO 4 AMAZON WAL-MART MOST FAVORABLE 7 8 5 6 LIQUIDITY RATIOS 1 Working Capital 2 Current Ratio 9 3 Receivables Turnover 10 4 Average Collection Period 5 Inventory Turnover 12 6 Days Inven on Hand 13 7 Payables Turnover 14 8 Days payable 15 1 1 3 6 1 1 2 16 17 CASH FLOW 18 9 Free Cash Flows 19 10 Quality of Income 20 21 22 PROFITABILITY RATIOS 23 11 Gross Profit Margin 24 12 Net Profit Margin 25 13 Total Asset Turnover 26 14 Return on Assets 27 15 Return on Equity RATIOS-BLANK PTS AMAZON Ready WALMART Data Formulas Review View File Home Insert Draw Page Layout M A2 F G E D A B C 20 21 22 PROFITABILITY RATIOS 23 11 Gross Profit Margin 24 12 Net Profit Margin 25 13 Total Asset Tumover 14 Return on Assets 27 15 Return on Equity 28 26 29 30 SOLVENCY RATIOS 31 16 Debt to Assets 32 17 Debt to Equity 33 34 35 MARKET STRENGTH 36 18 Earnings per Share 37 19 Dividends Per Share 38 20 Dividend Payout Ratio 39 40 41 42 F G D 202: AMAZON FINANCIAL STATEMENTS - PAGE 1 H 1 202: AMAZON FINANCIAL STATEMENTS - PAGE 2 2 AMAZON ***Calculate ratios based on 2018 numbers; only use 2017 when an average is needed*** 2018 2017 72,808 36.404.00 LIABILITIES & S/E CURRENT LIAB A/P ACCR OTHER LIAB UNEARN REV TOTAL CURRENT LIAB 38,192 23,663 6 536 68,391 34,616 18.170 5,097 57,883 3 AMAZON 4 55 **Calculate ratios based on 2018 numbers; only use 2017 when an average is needed*** 6 7 2018 2017 8 SALES 9 PROD SALES 141 915 118,573 10 SVC SALES 90.972 59.293 11 TOTAL NET SALES 232,887 177,866 12 12 C/G/S 139,156 111,934 13 GROSS MARGIN 93,731 65,932 14 FULFILMENT 34 027 25 249 IS MKTG 13,814 10,069 300 16 TECH & CONTENT 28.837 22,620 17 G&A 4.336 3,674 18 OTH OPER EXP 296 214 ca 19 TOT OPER EXP 81,310 61,826 20 INC B4 INTER & TAXES 12,421 4,106 21 INTER INC 440 202 22 NET INTER EXP (1.417) (848) 23 OTH OPER EXP (183) 346 24 TOT NON OPER EXP (1,160) (300) 25 INC B4 INC TX 11,261 3,806 RATIOS-BLANK PTS AMAZON WALMART Ready LONG TERM LIAB LTD OLTL TOTAL LTL TOTAL LIAB 23.495 27 213 50,708 119,099 24,743 20,975 45,718 103,601 S/E C/S, 01 PV TVS APIC RE 5.00 (1,837) 26,791 19.625 5.00 (1,837) 21 389 8,636 K11 X & ACCR OTHER LAB F G N O H TOTAL LIAB L 119,099 M 103,601 D 81,310 12,421 440 (1.417) (183) (1.160) 11,261 1,197 9 10,073 E E 61 826 4,106 202 (848) 346 (300) 3,806 S/E C/S, 01 PV T/S APIC RE 5.00 (1.837) 26,791 19.625 (1035) 43,549 162,648 5.00 (1,837) 21,389 8,636 (484) 27,709 131,310 769 (4 3,033 OTH COMP LOSS TOTAL S/E TOTAL LIAB & S/E 19 TOT OPER EXP 20 INC B4 INTER & TAXES 21 INTER INC 22 NET INTER EXP OTH OPER EXP 24 TOT NON-OPER EXP 25 INC B4 INC TX 26 INC TX EXP 27 EQ METH INVEST.NET 28 NI 29 ED ASSETS 31 CURRENT ASSETS B2 CASH 33 MKT SEOTYS 34 INVEN 25 AR 36 TOTAL CA 37 PPE 39 PPE, NET 40 GOODWILL 41 OLTA 42 TOTAL LTA 4 TOTAL ASSETS 487 31.750 9.500 17.174 16,677 75,101 20,522 10.464 16,047 13 164 60,197 OUTSTANDING SHARES DIVIDENDS NET CF FM OPER ACTIV LTA PURCH 480 3,034 18,365 25.927 1.127 30 723 15,613 61.797 14,548 11 202 87,547 162,648 48.866 13,350 8,897 71,113 131,310 RATIOS BLANK PTS AMAZON WALMART Ready Type here to search a ** . N D G HI WALMART WALMART ***Calculate ratios based on 2018 numbers; only use 2017 when an average is needed*** ***Calculate ratios based on 2018 numbers; only use 2017 when an average is 2018 2017 1 NET SALES 9 MEMBERSHIP & OTHER INCOME 10 TOTAL REVENUE 11 C/G/S 12 GROSS MARGIN OPER EXP 14 OPER INC 15 INTER INC 16 INTEREST EXP 17 NET INTER 18 LOSS ON DEBT CANC 19 INC FM CONTIN OPS B4 TXS 20 INC TXS 21 INC EM CONTIN OPS 22 LESS MIN INTER 2 NI-WALMART 2018 495,761 4,582 500,343 373,396 126,947 106,510 20,437 152 2.330 2,178 3,136 15,123 4,600 10,523 (661) 9,862 2017 481,317 4,556 485,873 361 256 124,617 101,853 22,764 100 2,367 20,397 LIABILITIES & S/E CURR LIAB ST DEBT ACCR LIAB ACCR INC TX CURR PORTION OF LTD CAP LEASE OBLIGS TOTAL CL 5.257 46,092 22,122 645 3,738 667 78,521 1,099 41.433 20,654 921 2.256 565 66.928 20,497 6,204 14,293 (650) 13,643 LONG TERM LIAB LTD LEASE LID DEF INC TX TOTAL LTL TOTAL LIAB 30.045 6.780 8,354 45,179 123,700 36,015 6.003 9.344 51,362 118,290 25 ASSETS 26 CURRENT ASSETS 27 CASH 6,756 6.867 S/E C/S, 10 PV RATIOS-BLANK PTS AMAZON WALMART 295 See 305 Type here to search a e w 99 e 1:08 AZ G H E D 3.136 15,123 4.600 10.523 (661) 9,862 20,497 6,204 14,293 (650) 13,643 LONG TERM LIAB LTD LEASE LTD DEF INC TX TOTAL LTL TOTAL LIAB 30.045 6,780 8,354 45,179 123,700 36,015 6,003 9,344 51,362 118,290 c LOSS ON DEBT CANC 19 INC FM CONTIN OPS B4 TXS 20 INC TXS 21 INC EM CONTIN OPS 22 LESS MIN INTER 23 NI WALMART 24 24 25 ASSETS 26 CURRENT ASSETS 27 CASH 28 A/R net 29 INVEN 20 PPDS - TOTAL CA 32 23 LONG-TERM ASSETS 34 IPPE 35 -A/D 36 NET PPE 17 GOODWILL 38 OTHER LTA 39 TOTAL LTA 40 TOTAL ASSETS 41 42 6.756 5,614 43,783 3.511 59,664 6,867 5.835 43,046 1,941 57,689 S/E C/S, 10 PV APIC RE ACCUM OTH COMP INC (LOSS) TOT WALMART S/E MIN INTER TOT S/E TOTAL LIAB & S/E 295 2.648 85.107 (10,181) 77,869 2.953 80,822 204,522 305 2,371 89,354 (14,232) 77,798 2.737 80,535 198,825 197,857 (83,039) 114,818 18 242 11.798 144,858 204,522 191,129 (76,951) 114,178 17,037 9.921 141,136 198,825 OUTSTANDING SHARES TOT DIVIDENDS NET CF FM OPER ACTIV ITA PURCH 2.995 6,124 28,337 10.426 3.101 6,216 31,673 13,082 RATIOS-BLANK PTS AMAZON WALMART Ready