Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help with the following ratios for walmart and amazon Walmart Financial Statements Consolidated Statements of Income - USD ($) shares in Millions, $ in
need help with the following ratios for walmart and amazon
Walmart Financial Statements Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Revenues: Net Sales Membership and other income $ 519,926 4,038 $ 510,329 4,076 $ 495,761 4,582 523,964 514,405 500,343 394,605 108,791 20,568 385,301 107,147 21,957 373,396 106,510 20,437 2,262 337 1,975 371 (217) 2,129 (189) 0 Total revenues Costs and expenses: Cost of sales Operating, selling, general and administrative expenses Operating income Interest: Debt Finance, capital lease and financing obligations Interest income Interest, net Loss on extinguishment of debt Other (gains) and losses Income before income taxes Provision for income taxes Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: Basic net income per common share attributable to Walmart Diluted net income per common share attributable to Walmart Weighted average common shares outstanding: Basic (in shares) Diluted in shares) Dividends declared per common share 2,410 0 (1,958) 20,116 4,915 15,201 (320) $ 14,881 8,368 11,460 4,281 7,179 (509) $ 6,670 1,978 352 (152) 2,178 3,136 0 15,123 4,600 10,523 (661) $ 9,862 $ 5.22 $ 2.28 $ 2.26 $ 3.29 $ 3.28 $ 5.19 2,850 2,868 $ 2.12 2,929 2,945 $ 2.08 2,995 3,010 $ 2.04 Consolidated Balance Sheets - USD ($) $ in Millions Cash and cash equivalents Receivables, net Inventories Jan. 31, 2020 Jan. 31, 2019 $ 9,465 $ 7,722 6,284 6,283 44,435 44,269 1,622 61,806 105,208 17,424 4,417 0 31,073 16,567 236,495 3,623 61,897 104,317 0 0 7,078 31,181 14,822 219,295 Prepaid expenses and other Total current assets Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term operating lease obligations Long-term finance lease obligations Long-term capital lease and financing obligations Deferred income taxes and other Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 575 46,973 22,296 280 5,362 1,793 511 0 77,790 43,714 16,171 4,307 0 12,961 5,225 47,060 22,159 428 1,876 0 0 729 77,477 43,520 0 0 6,683 11,981 284 3,247 83,943 (12,805) 74,669 6,883 81,552 $ 236,495 288 2,965 80,785 (11,542) 72,496 7,138 79,634 $ 219,295 M 0 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended $ 15,201 $ 7,179 $ 10,523 10,987 (1,886) 15 (1,036) 320 0 1,981 10,678 3,516 4,850 0 (499) 0 1,734 10,529 0 0 0 (304) 3,136 1,210 OOO 154 (300) (274) 186 (93) 25,255 (368) (1,311) 1,831 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net cash provided by operating activities: Depreciation and amortization Unrealized (gains) and losses (Gains) and losses for disposal of business operations Asda pension contribution Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Premiums paid to extinguish debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities Effect of Exchange Rate on Cash, Cash Equivalents, and Restricted Cash Net increase (decrease) in cash, cash equivalents and restricted cash Cash,cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of year Supplemental disclosure of cash flow information: Income taxes paid Interest Paid, Excluding Capitalized Interest, Operating Activities (10,705) 321 833 (56) 479 (9,128) (10,344) 519 876 (14,656) (431) (24,036) (10,051) 378 1,046 (375) (77) (9,079) (4,656) 5,492 (1,907) 0 (6,048) (5,717) (555) 0 (908) (14,299) (69) 1,759 7,756 9,515 (53) 15,872 (3,784) 0 (6,102) (7,410) (431) 0 (629) (2,537) (438) 742 7,014 7,756 4,148 7,476 (13,061) (3,059) (6,124) (8,296) (690) (8) (261) (19,875) 487 (130) 7,144 7,014 3,616 $ 2,464 3,982 $ 2,348 6,179 $ 2,450 1 Amazon Financial Statement Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions 2 12 Months Ended 3 3 Dec 31, 2019 Dec 31, 2018 Dec. 31, 2017 4 5 Total net sales Operating expenses: $ 280,522 $ 232,887 $ 177,866 6 7 Cost of sales 8 Fulfillment Technology and content 165,536 40,232 35,931 139,156 34,027 28,837 111,934 25,249 22,620 9 Marketing 18,878 13,814 10,069 5,203 201 265,981 14,541 832 (1,600) 203 (565) 4,336 296 220,466 12,421 440 10 11 General and administrative 12 Other operating expense (income), net 13 Total operating expenses Operating income 15 Interest income 16 Interest expense 17 Other income (expense), net 18 Total non-operating income (expense) 19 Income before income taxes 20 Provision for income taxes 21 Equity-method investment activity, net of tax 22 Net income 23 Basic earnings per share 24 Diluted earnings per share 25 Weighted average shares used in computation of earnings per share: Basic (in shares) 26 27 Diluted (in shares) 28 Net product sales 29 Total net sales 30 Net service sales 31 Total net sales 13,976 3,674 214 173,760 4,106 202 (848) 346 (300) 3,806 (769) (4) $ 3,033 $ 6.32 $6.15 (1,417) (183) (1,160) 11,261 (1,197) 9 $ 10,073 $20.68 $ 20.14 (2,374) (14) $ 11,588 $ 23.46 $ 23.01 494 487 480 504 500 493 $ 160,408 $ 141,915 $ 118,573 $ 120,114 $ 90,972 $ 59,293 32 22 H 1 J Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2019 Dec 31, 2018 Current assets: Cash and cash equivalents Marketable securities $ 36,092 18,929 $ 31,750 9,500 Inventories Accounts receivable, net and other Total current assets 20,497 20,816 96,334 17,174 16,677 75,101 Property and equipment, net 72,705 61,797 0 25,141 14,754 16,314 225,248 14,548 11,202 162,648 47,183 32,439 8,190 Operating leases Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term lease liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) 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 income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 87,812 39,791 23,414 12,171 38,192 23,663 6,536 68,391 9,650 23,495 17,563 0 0 n 5 5 (1,837) 33,658 (986) 31,220 62,060 $ 225,248 (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 Consolidated Statements of Cash Flows- USD ($) $ in Millions 12 Months Ended Dec. 31, 2019 Dec 31, 2018 Dec. 31, 2017 $32,173 $ 21,856 $ 19,934 11,588 10,073 3,033 21,789 15,341 11,478 Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: : Net income een 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 perdry Other expense (income),net Date Deferred income taxes Changes in operating assets and liabilities: Inventories Accounts receivable, net and other Accounts payable . Accrued expenses and other Unearned revenue Net cash provided by (used in) operating activities . INVESTING ACTIVITIES: Doch Purchases of property and equipment Proceeds from property and equipment sales and incentives Acquisitions, net of cash acquired, and other Sales and maturities of marketable securities 6,864 164 (249) 796 5,418 274 219 441 4,215 202 (292) (29) ( (3,278) (7,681) 8,193 (1,383) 1,711 38,514 (1,314) (4,615) 3,263 472 1,151 30,723 (3,583) (4,780) 7,100 283 738 18,365 (16,861) 4,172 (2461) 22,681 (13,427) (11,955) 2,104 1,897 (2,186) (13,972) 8,240 9,677 (31,812) (24,281) (7,100) (12,731) (12,369) (27,084) 2,273 (2,684) (9,628) (27) (10,066) 70 768 (668) (7449) (337) (7,686) (351) 16,228 (1,301) (4,799) (200) 9,928 713 4,237 10,317 1,922 Purchases of marketable securities Net cash provided by (used in) investing activities FINANCING ACTIVITIES: Proceeds from long-term debt and other Repayments of long-term debt and other Principal repayments of finance leases Principal repayments of financing obligations Net cash provided by (used in) financing activities Foreign currency effect on cash,cash equivalents, and restricted cash Net increase (decrease) in cash, cash equivalents, and restricted cash cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF SUPPLEMENTAL CASH FLOWINFORMATION: Cash paid for interest on long-term debt Cash paid for operating leases Cash paid for interest on capital leases Cash paid for interest on finance leases Cash paid for interest on financing obligations Cash paid for income taxes, net of refunds Assets acquired under operating leases Property and equipment acquired under capital leases Property and equipment acquired under finance leases Property and equipment acquired under build-to-suit arrangements 36,410 32,173 21,856 875 3,361 854 0 0 381 328 0 0 200 647 39 881 7870 194 (1,184) 0 10,615 119 (957) 0 9,637 13,723 $ 1,362 $3,641 $3,541 Ratios WALMART AMAZON Working Ratio $ (2,578.000) 6348.000 EXAMPLE ONLY Current Assets 90,067 132,733 Current Liabilities 92,645 126,385 Current Ratio ME Current Assets Current Liabilities Debt to Asset Ratio Total Debt Total Assets Return on Equity Net Income Total Equity Return on Assets Net Income Total Assets Inventory Turnover 365 Days Inventory Turnover Days in Inventory Accounts Receivable Turnover MOTION 000 0000 DID DIODO DOTTO . Times Interest Earned Free Cash Flow Gross Profit Rate Profit Margin 100 MA IND DONDO Asset Turnover
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started