Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. |
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. |
E F G H MN OP Ratios WALMART AMAZON 5 Current Ratio 0.799 1.098 Days in Inventory Profit Margin 8 Current Assets 61,897 75.101 10 Current Liabilities 77.477 68,391 11 Accounts Receivable Turnover Asset Turnover 0.637 0.7321 13 Debt to Asset Ratio (CH.2) 14 15 16 Total Liabilities 17 18 Total Assets 19 139,661 119,099 219,295 162,648 Times Interest Earned 21 Return on Equity (CH.11) 6670.000 28 Return on Assets (CH.9) HT Free Cash Flow wwwww non na 35 Inventory Turnover (CH.6) Gross Profit Rate Info and Instructions Walmart Amazon Ratios Ratio Formulas + B C D E F. HI JK M N O P 1 Walmart Financial Statements 2 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31,2019 Jan. 31, 2018 Jan. 31, 2017 $7,179 $ 10,523 $14,293 $510,329 4,076 514,405 $495,761 4,582 500,343 $481,317 4,556 485,873 10,529 10,080 4 Revenues: 5 Net Sales Membership and other income Total revenues Costs and expenses: Cost of sales 10 Operating, selling, general and administrative expenses Operating income 12 Interest: 10,678 3,516 4,850 (499) 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 761 11 (304) 3,136 1,210 1,734 206 13 Debt 1,975 371 (217) 2,129 1,978 352 (152) 2.178 3,136 2,044 323 (100) 2,267 15 16 (368) (1,311) 1,831 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 14 Capital lease and financing obligations Interest income Interest, net Loss on extinguishment of debt 18 Other (gains) and losses 19 Income before income taxes 20 Provision for income taxes 21 Consolidated net income 22 Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: 25 Basic net income per common share attributable to Walmart 28 Diluted net income per common share attributable to Walmart Weighted average common shares outstanding: Basic Diluted Dividends declared per common share 8,368 11,460 4,281 7,179 (509) $6,670 15,123 4,600 10,523 (661) $9,862 20,497 6,204 14,293 (650) $ 13,643 Consolidated Balance Sheets - USD ($) $ in Millions Jan 31, 2019 Jan. 31, 2018 Current assets: Cash and cash equivalents $7,722 $6,756 Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other 3,623 3,511 Total current assets 61,897 59,664 Property and equipment: Property and equipment 185,810 185,154 Less accumulated depreciation (81,493) 77,479 Property and equipment, net 104,317 107,675 Property under capital lease and financing Property under capital lease and financing obligations 12,760 12,703 Less accumulated amortization (5,682) (5,560) Property under capital lease and financing obligations, net 7,078 7,143 Goodwill 31,181 18,242 Other long-term assets 14,822 11,798 Total assets 219,295 204,522 Current liabilities: Short-term borrowings 5,225 5,257 Accounts payable 47,060 46,092 Accrued liabilities 22,159 22,122 Accrued income taxes 428 645 Long-term debt due within one year 1,876 3,738 Capital lease and financing obligations due within one year 729 Total current liabilities 77,477 78,521 Long-term debt 43,520 30,045 Long-term capital lease and financing obligations 6,683 6,780 Deferred income taxes and other 11,981 8,354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value 2,965 2,648 Retained earnings 80,785 85,107 Accumulated other comprehensive loss (11,542) (10,181) Total Walmart shareholders' equity 72,496 77,869 Noncontrolling interest 7,138 2,953 Total equity 79,634 80,822 Total liabilities and equity $ 219,295 $ 204,522 10,344 519 876 10,051 378 1,046 24 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net Depreciation and amortization Unrealized Gain (Loss) on Investments (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of 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 Purchase of available for sale securities 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 period Supplemental disclosure of cash flow information: Income taxes paid Interest paid 10,619 456 662 (1,901) (2,463) (31) (13,896) $ 2.28 $2.26 $3.29 $3.28 $4.40 $4.38 667 (14,656) (431) (24,036) (375) (77) (9,079) 2,929 2,945 $2.08 2,995 3,010 $2.04 3,101 3,112 (1,673) (53) 15,872 (3,784) 137 (2,055) 6,102 (7,410) (431) 4,148 7,476 (13,061) (3,059) 6,124 (8,296) (690) (8) (261) (19,875) 487 (130) 7,144 7,014 (629) (2,537) (438) 742 7,014 7,756 6,216 (8,298) (479) (90) (398) (19,072) (452) (1,747) 8,891 7,144 3,982 $2,348 6,179 $2,450 4,507 $2,351 Info and Instructions Walmart Amazon Ratios Ratio Formulas @ J -- H G H I IK L M. Dec 31, 2018 Dec. 31, 2017 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec 31, 2018 Dec 31, 2017 Dec. 31, 2016 $ 232,887 $177,866 $135,987 12 Months Ended Dec. 31, 2018 Dec 31, 2017 Dec 31, 2016 5 $21,856 $ 19,934 $ 16,175 10,073 3,033 2,371 88,265 17,619 7,233 16,085 2,432 $31,750 9,500 17.174 16,677 75,101 61,797 14,548 11,202 162,648 $20,522 10,464 16,047 13,164 60,197 48,866 13,350 8,897 131,310 167 139,156 34,027 13,814 28,837 4,336 296 220,466 12,421 440 1,417 (183) (1,160) 11,261 1,197 15,341 5,418 274 219 441 11,478 4,215 202 (292) (29) 1 Amazon Financial Statement 2 Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions 4 Total net sales Operating expenses: 6 Cost of sales Fulfillment Marketing Expense Technology and content 10 General and administrative Other operating expense, net 12 Total operating expenses 13 Operating income (loss) 14 Interest income Interest expense Other income lexpense), net 17 Total non-operating income (expense) 18 Income before income taxes Provision for income taxes 20 Equity-method investment activity, net of tax 21 Net income Basic earnings per share Diluted earnings per share 24 Weighted average shares used in computation of earnings per share: Basic (in shares) 26 Diluted (in shares) 27 Net product sales 28 Total net sales 29 Net service sales 30 Total net sales 8,116 2,975 160 (20) (246) 111,934 25,249 10,069 22,620 3,674 214 173,760 4,106 202 (848) 346 (300) 3,806 (769) (4) $3,033 $6.32 $6.15 131,801 4,186 100 (484) 90 (294) 3,892 (1,425) Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.01par value: Authorized shares - 500 Issued and outstanding Common stock, $0.01 par value: Authorized shares - 5,000 Issued shares - 507 and Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 16 38,192 23,663 6,536 68,391 23,495 27,213 34,616 18,170 5,097 57,883 24,743 20,975 (1,314) (4,615) 3,263 472 1,151 30,723 (3,583) (4,780) 7.100 283 738 18,365 (1,426) (3,436) 5,030 1,724 1,955 17,203 (96) 22 23 $10,073 $20.68 $20.14 $2,371 $5.01 $ 4.90 Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: Net income Adjustments to reconcile net income to net cash from operating Depreciation of property and equipment and other amortization, including capitalized Stock-based compensation Other operating expense, net Other expense (income), net 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: Purchases of property and equipment Proceeds from property and equipment incentives 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 FINANCING ACTIVITIES: 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 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 EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on long-term debt Cash paid for interest on capital and finance lease obligations Cash paid for income taxes, net of refunds Property and equipment acquired under capital leases Property and equipment acquired under build-to-suit leases 13,427 2,104 (2,186) 8,240 (7,100) (12,369) (11,955) 1897 (13,972) 9,677 (12,731) (27,084) 25 (7,804) 1,067 (116) 4,577 (7,240) (9,516) (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 487 500 (1,837) 21,389 (484) 8,636 27,709 $ 131,310 480 493 474 484 $141,915 $ 118,573 $94,665 $90,972 $59,293 $41,322 768 (668) (7,449) (337) (7,686) (351) 10,317 32,173 16,228 (1,301) (4,799) (200) 9,928 713 1,922 21,856 618 (327) (3,860) (147) (3,716) (212) 3,759 19,934 290 206 854 575 1,184 10,615 $3,641 328 319 957 9,637 $3,541 412 5,704 $1,209 Info and Instructions Walmart Amazon Ratios Ratio Formulas + 0 -- E F G H MN OP Ratios WALMART AMAZON 5 Current Ratio 0.799 1.098 Days in Inventory Profit Margin 8 Current Assets 61,897 75.101 10 Current Liabilities 77.477 68,391 11 Accounts Receivable Turnover Asset Turnover 0.637 0.7321 13 Debt to Asset Ratio (CH.2) 14 15 16 Total Liabilities 17 18 Total Assets 19 139,661 119,099 219,295 162,648 Times Interest Earned 21 Return on Equity (CH.11) 6670.000 28 Return on Assets (CH.9) HT Free Cash Flow wwwww non na 35 Inventory Turnover (CH.6) Gross Profit Rate Info and Instructions Walmart Amazon Ratios Ratio Formulas + B C D E F. HI JK M N O P 1 Walmart Financial Statements 2 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31,2019 Jan. 31, 2018 Jan. 31, 2017 $7,179 $ 10,523 $14,293 $510,329 4,076 514,405 $495,761 4,582 500,343 $481,317 4,556 485,873 10,529 10,080 4 Revenues: 5 Net Sales Membership and other income Total revenues Costs and expenses: Cost of sales 10 Operating, selling, general and administrative expenses Operating income 12 Interest: 10,678 3,516 4,850 (499) 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 761 11 (304) 3,136 1,210 1,734 206 13 Debt 1,975 371 (217) 2,129 1,978 352 (152) 2.178 3,136 2,044 323 (100) 2,267 15 16 (368) (1,311) 1,831 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 14 Capital lease and financing obligations Interest income Interest, net Loss on extinguishment of debt 18 Other (gains) and losses 19 Income before income taxes 20 Provision for income taxes 21 Consolidated net income 22 Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: 25 Basic net income per common share attributable to Walmart 28 Diluted net income per common share attributable to Walmart Weighted average common shares outstanding: Basic Diluted Dividends declared per common share 8,368 11,460 4,281 7,179 (509) $6,670 15,123 4,600 10,523 (661) $9,862 20,497 6,204 14,293 (650) $ 13,643 Consolidated Balance Sheets - USD ($) $ in Millions Jan 31, 2019 Jan. 31, 2018 Current assets: Cash and cash equivalents $7,722 $6,756 Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other 3,623 3,511 Total current assets 61,897 59,664 Property and equipment: Property and equipment 185,810 185,154 Less accumulated depreciation (81,493) 77,479 Property and equipment, net 104,317 107,675 Property under capital lease and financing Property under capital lease and financing obligations 12,760 12,703 Less accumulated amortization (5,682) (5,560) Property under capital lease and financing obligations, net 7,078 7,143 Goodwill 31,181 18,242 Other long-term assets 14,822 11,798 Total assets 219,295 204,522 Current liabilities: Short-term borrowings 5,225 5,257 Accounts payable 47,060 46,092 Accrued liabilities 22,159 22,122 Accrued income taxes 428 645 Long-term debt due within one year 1,876 3,738 Capital lease and financing obligations due within one year 729 Total current liabilities 77,477 78,521 Long-term debt 43,520 30,045 Long-term capital lease and financing obligations 6,683 6,780 Deferred income taxes and other 11,981 8,354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value 2,965 2,648 Retained earnings 80,785 85,107 Accumulated other comprehensive loss (11,542) (10,181) Total Walmart shareholders' equity 72,496 77,869 Noncontrolling interest 7,138 2,953 Total equity 79,634 80,822 Total liabilities and equity $ 219,295 $ 204,522 10,344 519 876 10,051 378 1,046 24 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net Depreciation and amortization Unrealized Gain (Loss) on Investments (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of 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 Purchase of available for sale securities 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 period Supplemental disclosure of cash flow information: Income taxes paid Interest paid 10,619 456 662 (1,901) (2,463) (31) (13,896) $ 2.28 $2.26 $3.29 $3.28 $4.40 $4.38 667 (14,656) (431) (24,036) (375) (77) (9,079) 2,929 2,945 $2.08 2,995 3,010 $2.04 3,101 3,112 (1,673) (53) 15,872 (3,784) 137 (2,055) 6,102 (7,410) (431) 4,148 7,476 (13,061) (3,059) 6,124 (8,296) (690) (8) (261) (19,875) 487 (130) 7,144 7,014 (629) (2,537) (438) 742 7,014 7,756 6,216 (8,298) (479) (90) (398) (19,072) (452) (1,747) 8,891 7,144 3,982 $2,348 6,179 $2,450 4,507 $2,351 Info and Instructions Walmart Amazon Ratios Ratio Formulas @ J -- H G H I IK L M. Dec 31, 2018 Dec. 31, 2017 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec 31, 2018 Dec 31, 2017 Dec. 31, 2016 $ 232,887 $177,866 $135,987 12 Months Ended Dec. 31, 2018 Dec 31, 2017 Dec 31, 2016 5 $21,856 $ 19,934 $ 16,175 10,073 3,033 2,371 88,265 17,619 7,233 16,085 2,432 $31,750 9,500 17.174 16,677 75,101 61,797 14,548 11,202 162,648 $20,522 10,464 16,047 13,164 60,197 48,866 13,350 8,897 131,310 167 139,156 34,027 13,814 28,837 4,336 296 220,466 12,421 440 1,417 (183) (1,160) 11,261 1,197 15,341 5,418 274 219 441 11,478 4,215 202 (292) (29) 1 Amazon Financial Statement 2 Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions 4 Total net sales Operating expenses: 6 Cost of sales Fulfillment Marketing Expense Technology and content 10 General and administrative Other operating expense, net 12 Total operating expenses 13 Operating income (loss) 14 Interest income Interest expense Other income lexpense), net 17 Total non-operating income (expense) 18 Income before income taxes Provision for income taxes 20 Equity-method investment activity, net of tax 21 Net income Basic earnings per share Diluted earnings per share 24 Weighted average shares used in computation of earnings per share: Basic (in shares) 26 Diluted (in shares) 27 Net product sales 28 Total net sales 29 Net service sales 30 Total net sales 8,116 2,975 160 (20) (246) 111,934 25,249 10,069 22,620 3,674 214 173,760 4,106 202 (848) 346 (300) 3,806 (769) (4) $3,033 $6.32 $6.15 131,801 4,186 100 (484) 90 (294) 3,892 (1,425) Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.01par value: Authorized shares - 500 Issued and outstanding Common stock, $0.01 par value: Authorized shares - 5,000 Issued shares - 507 and Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 16 38,192 23,663 6,536 68,391 23,495 27,213 34,616 18,170 5,097 57,883 24,743 20,975 (1,314) (4,615) 3,263 472 1,151 30,723 (3,583) (4,780) 7.100 283 738 18,365 (1,426) (3,436) 5,030 1,724 1,955 17,203 (96) 22 23 $10,073 $20.68 $20.14 $2,371 $5.01 $ 4.90 Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: Net income Adjustments to reconcile net income to net cash from operating Depreciation of property and equipment and other amortization, including capitalized Stock-based compensation Other operating expense, net Other expense (income), net 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: Purchases of property and equipment Proceeds from property and equipment incentives 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 FINANCING ACTIVITIES: 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 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 EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on long-term debt Cash paid for interest on capital and finance lease obligations Cash paid for income taxes, net of refunds Property and equipment acquired under capital leases Property and equipment acquired under build-to-suit leases 13,427 2,104 (2,186) 8,240 (7,100) (12,369) (11,955) 1897 (13,972) 9,677 (12,731) (27,084) 25 (7,804) 1,067 (116) 4,577 (7,240) (9,516) (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 487 500 (1,837) 21,389 (484) 8,636 27,709 $ 131,310 480 493 474 484 $141,915 $ 118,573 $94,665 $90,972 $59,293 $41,322 768 (668) (7,449) (337) (7,686) (351) 10,317 32,173 16,228 (1,301) (4,799) (200) 9,928 713 1,922 21,856 618 (327) (3,860) (147) (3,716) (212) 3,759 19,934 290 206 854 575 1,184 10,615 $3,641 328 319 957 9,637 $3,541 412 5,704 $1,209 Info and Instructions Walmart Amazon Ratios Ratio Formulas + 0
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