Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have been given financial statements for Amazon and Walmart (Income Statement, Balance Sheet, and Statement of Cash Flows). For this project, you will use
You have been given financial statements for Amazon and Walmart (Income Statement, Balance Sheet, and Statement of Cash Flows). For this project, you will use the information in those statements to compute the ratios requested on the Ratios Tab. Current year information is Fiscal or Calendar year ended 2018 for both companies. |
SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: |
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. |
ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES |
Repeat the steps for each of the ratios listed on the Ratio Tab |
Assume all sales were on credit where necessary. |
COGS can also be called Cost of Sales |
Income Tax Expense can also be called the Provision for Income Taxes |
Remember to consider the Statement of Cash Flows when trying to determine cash spent for any particular items. |
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. |
File Home Insert Page Layout Formulas Data Review View Help Search Share Comments X fic G H K L M I 1 Walmart Financial Statements Consolidated Statements of lecont - USD ($) shares in Millions. in Millions 12 Months 12 Montho Ended Jan. 31. Jan. 31. 2018 Jan. 31. 2017 Consolidated Statements of Cask Flors - USD ($) $ in Hillions Jan. 31. Jan. 31. Ended Jan. 31. Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventorics Jan. 31. Jan. 31. 4 Revenues: 5 Nat sales Membership and other income $495,761 4,582 $481,317 4,556 $478,614 3,516 $ 6,756 5.614 43.783 $6,867 5,835 43,046 $ 10,523 $14,293 $15,080 500,343 485,873 3,511 53,664 1,941 57,689 10,080 761 10,529 (304) 3,136 1,210 9,454 (672) 373,336 361,256 101,853 22,764 206 106,510 20,437 1410 185,154 (77,479) 107,675 173,492 (71,782) 107,710 2.044 (1,074) -140 4,086 (402) 1,021 3,942 323 (100) 2,267 12.703 (5,560) 928 (19) -703 2,008 1,466 (472) 27,552 7.143 1.280 492 31673 (557) 28,337 11,637 (5,169) 6,468 17,037 9.921 198,825 Total revenues Costs and expenses: Cost of sales Operating, selling general and administrative expenses 11 Operating income Interest: 13 Debt 14 Capital lease and financing obligations 15 Interest income 16 Interest, net 17 Gain (los) on extinguishment of debt 18 Income before income taxes 19 Provision for income taxes 20 Consolidated net income 21 Consolidated net income attributable to noncontrolling interest 22 Consolidated net income attributable to Walmart 23 Net income per common share: 24 Basic set incont per corno share attributable to Yalmart 25 Diluted net income per common share attributable to Walmart 26 Weighted average common shares outstanding: Basic 28 Diluted Dividends declared per common share 0 1,978 352 (152) 2,178 3.136 15,123 4,600 10,523 1661) 9.662 18,242 11.798 204,522 (10,051) (10,619) 20,497 6,204 14.293 (650) 13,643 456 (11,477) 635 246 1,046 662 5,257 46,092 22.122 645 3,738 482,130 Prepaid expenses and other Total current assets 360,984 Property and equipatat: 97,041 Property and equipment 24,105 Less accumulated depreciation Property and equipment, nct 2,027 Property under capital lease and financing 521 Property under capital lease and financing obligations (81) Lese accumulated amortization 2,467 Property under capital lease and financing obligations, net Goodwill 21,638 Other goate and deferred charges 6,558 Total assets 15,080 Current liabilities: (386) Short-term borrowings 14,694 Accounts payable Accrued liabilities 14.58 Accrued income taxes $4.57 Long-term debt due within one year Capital lease and financing obligations due within one year 3,207 Total current liabilities 3,217 Long-term debt Long-term capitales 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' cquity Noncontrolling interest Total equity Total liabilities and equity 1,099 41.433 20.654 921 2,256 $4.40 Cash flors from operating activities: Consolidated net income Adjustments to reconcile incond from continuing operations to net cash provided by operating activities: Depreciation and amortization Deferred income taxes Gain (loss) on extinguishment of debt Other operating activities Changes in certain assets and liabilities, nct of effects of acquisitions: Receivables, net Intentories 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 diapodol of certain operations Purchase of available for sale securities Investment and 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 fro- issuance of long-term debt Payments of long-term debt Payment for debt extinguishment or debt prepayment cost 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 rates on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalente at beginning of year Cash and cash equivalente at end of year Supplemental disclosure of cash flow information: Income taxes paid laterest paid (1,301) (2,463) (1221 (13,387) $3.29 $ 3.28 (375) (58) (9,060) 1791 $4.38 (10,675) 667 565 (1,673) 1,235 2,895 3,010 2.04 3.101 3,112 2.00 78,521 30,045 6,780 8,354 66,928 36,015 6,003 9,344 1.96 (2,055) (4,432) 4,148 7.476 (13,061) (3,059) 16,124) (8,236) (630) 1) (261) (19,875) 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 (6,216) 18.2981 (479) (30) (398) (13,072) (452) (1838) 8,705 6,867 (6,294) 14,112) (719) (1,326) (676) (16.2851 (1022) (430) 9,135 8,705 (111) 6,867 6,756 6,179 $2,450 4,507 $2,351 8,111 $2,540 Information & Instructions Walmart Amazon Ratios Ratio Formulas + - + 55% File Home Insert Page Layout Formulas Data Review View Help Search Share Comments M1 - * r fir K L M 1 Amazon Financial Statement Consolidated Statescats Of Operations - USD ($) shares in Hillions, in Millions Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2017 Consolidated Statements of Cash Flors - USD ($) $ in Hillions 12 Months Ended Dec. 31. 2018 $ 232,887 Current assets: Dec. Dec. Dec. 31. 2017 $177,866 Dec. 31. 2016 $135,987 Dec. 31. 31. $21,856 $19,934 $16,175 4 Total net sales 5 Operating expelses: 6 Coot of sales 7 Fulfillment 8 Marketing Expense Technology and content 133,156 34.027 13,814 28.837 88,265 17,619 7,233 16,085 Cochond cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and cquipment, net $31,750 9.500 17.174 16,677 75.101 61,797 111,934 25.249 10,069 22,620 20.522 10,464 16,047 13,164 60,197 48,866 10,073 3,033 2,371 15,341 11,478 8.116 3,674 2.432 14,548 13,350 5.418 274 214 167 4,336 296 220,466 12,421 11,202 162,648 8.897 131,310 4.215 202 (292) (29) 2.975 160 (20) (246) 173,760 4,106 441 440 131,801 4,186 100 (484) 202 34,616 90 (1,417) (183) (1,160) 11,261 (1.137) 38,192 23,663 6.536 68,391 23.495 27,213 18,170 5.097 57,883 (648) 346 (300) 3,806 (769) (4) $3,033 $6.32 $6.15 (294) 3.892 (1,425) 10 General and administrative 11 Other operating expense, net 12 Total operating expenses 13 Operating income (losa) 14 Interest income 15 Interest expense 16 Other income (expense), net 17 Total non-operating income (expense) 18 Income before income taxes 19 Provision for income taxes 20 Equity-method inventment activity, net of tax 21 Nat income 22 Basic earnings per share 23 Diluted earnings per share 24 Veighted average shares used in computation of earnings per 25 Basic (in shares) 26 Diluted in shares) 27 Net product sales 28 Total net sales 29 Net gervice sales 30 Total net sales 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 1) Stockholders' equity: Preferred stock, $0.01 par value: Authorised 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' cquity Total liabilities and stockholders' cquity (1,314) (4,615) 3.263 472 1,151 30,723 24,743 20.975 (3,583) (1,426) (4,780) (3,436) 7,100 5,030 283 1.724 738 1,955 18,365 17,203 (96) $ 10,073 $20.68 $20.14 $2,371 $5.01 $4.90 Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS. AHD RESTRICTED CASH. OPERATING ACTIVITIES: Het iacone Adjustments to reconcile net income to net cash from operating activities: Depreciation of property and equipment and other amortization, including capitalized content costs Stock-based compensation Other operating expense, net Other expende (income), net Deferred income taxes Changes in operating assets and liabilities: Inventories Accounts receivable, nct and other Accounts payable Accrued expenses and other Uncarned revenue Net cash provided by (used in) operating activities IHYESTING 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-tera debt and other Repayments of long-term debt and other Principal repayments of capital lease obligations Principal repayment of finance lease obligations Net cash provided by (uded in) financing activities Foreign currency effect on cash, cooh equivalents, and restricted cash Net increase decrease in cash, cash equivalents, and restricted cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENT AL 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, nct of refunds Property and equipment acquired under capital leases Property and equipment acquired under build-to-suit leader 487 (13,427) (11,955) (7,804) 2,104 1,897 1,067 (2,186) (13,972) (116) 8,240 9.677 4,577 (7,100) (12,731) (7,240) (12,369) (27,084) (9,516) 480 4.93 474 Soo (1,837) 26,791 (1,035) 19.625 43,549 $ 162,648 484 (1.837) 21,389 (484) 8,636 27,709 $ 131,310 $ 141,915 $118,573 $ 94,665 $90,972 $59,293 $ 41,322 768 16,228 618 (668) (1,301) (327) (7,449) (4,799) (3,860) (337) (200) (147) (7,686) 9,928 (3,716) (351) 713 (212) 10,317 1,922 3,759 32,173 21,856 19,934 854 328 290 575319 206 1,184957412 10,615 9,637 5,704 3,641 3,541 1,209 Information & Instructions Walmart Amazon Ratios Ratio Formulas @ - + 54% Fie Home insert Page Layout Formulas Data Review View Help Search Share Comments Ratios WALMART AMAZON information & Instructions Walmart Amazon Ratios Ratio Form -- File Home Insert Page Layout Formulas Data Review View Help Search Share Comments X fic G H K L M I 1 Walmart Financial Statements Consolidated Statements of lecont - USD ($) shares in Millions. in Millions 12 Months 12 Montho Ended Jan. 31. Jan. 31. 2018 Jan. 31. 2017 Consolidated Statements of Cask Flors - USD ($) $ in Hillions Jan. 31. Jan. 31. Ended Jan. 31. Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventorics Jan. 31. Jan. 31. 4 Revenues: 5 Nat sales Membership and other income $495,761 4,582 $481,317 4,556 $478,614 3,516 $ 6,756 5.614 43.783 $6,867 5,835 43,046 $ 10,523 $14,293 $15,080 500,343 485,873 3,511 53,664 1,941 57,689 10,080 761 10,529 (304) 3,136 1,210 9,454 (672) 373,336 361,256 101,853 22,764 206 106,510 20,437 1410 185,154 (77,479) 107,675 173,492 (71,782) 107,710 2.044 (1,074) -140 4,086 (402) 1,021 3,942 323 (100) 2,267 12.703 (5,560) 928 (19) -703 2,008 1,466 (472) 27,552 7.143 1.280 492 31673 (557) 28,337 11,637 (5,169) 6,468 17,037 9.921 198,825 Total revenues Costs and expenses: Cost of sales Operating, selling general and administrative expenses 11 Operating income Interest: 13 Debt 14 Capital lease and financing obligations 15 Interest income 16 Interest, net 17 Gain (los) on extinguishment of debt 18 Income before income taxes 19 Provision for income taxes 20 Consolidated net income 21 Consolidated net income attributable to noncontrolling interest 22 Consolidated net income attributable to Walmart 23 Net income per common share: 24 Basic set incont per corno share attributable to Yalmart 25 Diluted net income per common share attributable to Walmart 26 Weighted average common shares outstanding: Basic 28 Diluted Dividends declared per common share 0 1,978 352 (152) 2,178 3.136 15,123 4,600 10,523 1661) 9.662 18,242 11.798 204,522 (10,051) (10,619) 20,497 6,204 14.293 (650) 13,643 456 (11,477) 635 246 1,046 662 5,257 46,092 22.122 645 3,738 482,130 Prepaid expenses and other Total current assets 360,984 Property and equipatat: 97,041 Property and equipment 24,105 Less accumulated depreciation Property and equipment, nct 2,027 Property under capital lease and financing 521 Property under capital lease and financing obligations (81) Lese accumulated amortization 2,467 Property under capital lease and financing obligations, net Goodwill 21,638 Other goate and deferred charges 6,558 Total assets 15,080 Current liabilities: (386) Short-term borrowings 14,694 Accounts payable Accrued liabilities 14.58 Accrued income taxes $4.57 Long-term debt due within one year Capital lease and financing obligations due within one year 3,207 Total current liabilities 3,217 Long-term debt Long-term capitales 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' cquity Noncontrolling interest Total equity Total liabilities and equity 1,099 41.433 20.654 921 2,256 $4.40 Cash flors from operating activities: Consolidated net income Adjustments to reconcile incond from continuing operations to net cash provided by operating activities: Depreciation and amortization Deferred income taxes Gain (loss) on extinguishment of debt Other operating activities Changes in certain assets and liabilities, nct of effects of acquisitions: Receivables, net Intentories 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 diapodol of certain operations Purchase of available for sale securities Investment and 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 fro- issuance of long-term debt Payments of long-term debt Payment for debt extinguishment or debt prepayment cost 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 rates on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalente at beginning of year Cash and cash equivalente at end of year Supplemental disclosure of cash flow information: Income taxes paid laterest paid (1,301) (2,463) (1221 (13,387) $3.29 $ 3.28 (375) (58) (9,060) 1791 $4.38 (10,675) 667 565 (1,673) 1,235 2,895 3,010 2.04 3.101 3,112 2.00 78,521 30,045 6,780 8,354 66,928 36,015 6,003 9,344 1.96 (2,055) (4,432) 4,148 7.476 (13,061) (3,059) 16,124) (8,236) (630) 1) (261) (19,875) 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 (6,216) 18.2981 (479) (30) (398) (13,072) (452) (1838) 8,705 6,867 (6,294) 14,112) (719) (1,326) (676) (16.2851 (1022) (430) 9,135 8,705 (111) 6,867 6,756 6,179 $2,450 4,507 $2,351 8,111 $2,540 Information & Instructions Walmart Amazon Ratios Ratio Formulas + - + 55% File Home Insert Page Layout Formulas Data Review View Help Search Share Comments M1 - * r fir K L M 1 Amazon Financial Statement Consolidated Statescats Of Operations - USD ($) shares in Hillions, in Millions Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2017 Consolidated Statements of Cash Flors - USD ($) $ in Hillions 12 Months Ended Dec. 31. 2018 $ 232,887 Current assets: Dec. Dec. Dec. 31. 2017 $177,866 Dec. 31. 2016 $135,987 Dec. 31. 31. $21,856 $19,934 $16,175 4 Total net sales 5 Operating expelses: 6 Coot of sales 7 Fulfillment 8 Marketing Expense Technology and content 133,156 34.027 13,814 28.837 88,265 17,619 7,233 16,085 Cochond cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and cquipment, net $31,750 9.500 17.174 16,677 75.101 61,797 111,934 25.249 10,069 22,620 20.522 10,464 16,047 13,164 60,197 48,866 10,073 3,033 2,371 15,341 11,478 8.116 3,674 2.432 14,548 13,350 5.418 274 214 167 4,336 296 220,466 12,421 11,202 162,648 8.897 131,310 4.215 202 (292) (29) 2.975 160 (20) (246) 173,760 4,106 441 440 131,801 4,186 100 (484) 202 34,616 90 (1,417) (183) (1,160) 11,261 (1.137) 38,192 23,663 6.536 68,391 23.495 27,213 18,170 5.097 57,883 (648) 346 (300) 3,806 (769) (4) $3,033 $6.32 $6.15 (294) 3.892 (1,425) 10 General and administrative 11 Other operating expense, net 12 Total operating expenses 13 Operating income (losa) 14 Interest income 15 Interest expense 16 Other income (expense), net 17 Total non-operating income (expense) 18 Income before income taxes 19 Provision for income taxes 20 Equity-method inventment activity, net of tax 21 Nat income 22 Basic earnings per share 23 Diluted earnings per share 24 Veighted average shares used in computation of earnings per 25 Basic (in shares) 26 Diluted in shares) 27 Net product sales 28 Total net sales 29 Net gervice sales 30 Total net sales 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 1) Stockholders' equity: Preferred stock, $0.01 par value: Authorised 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' cquity Total liabilities and stockholders' cquity (1,314) (4,615) 3.263 472 1,151 30,723 24,743 20.975 (3,583) (1,426) (4,780) (3,436) 7,100 5,030 283 1.724 738 1,955 18,365 17,203 (96) $ 10,073 $20.68 $20.14 $2,371 $5.01 $4.90 Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS. AHD RESTRICTED CASH. OPERATING ACTIVITIES: Het iacone Adjustments to reconcile net income to net cash from operating activities: Depreciation of property and equipment and other amortization, including capitalized content costs Stock-based compensation Other operating expense, net Other expende (income), net Deferred income taxes Changes in operating assets and liabilities: Inventories Accounts receivable, nct and other Accounts payable Accrued expenses and other Uncarned revenue Net cash provided by (used in) operating activities IHYESTING 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-tera debt and other Repayments of long-term debt and other Principal repayments of capital lease obligations Principal repayment of finance lease obligations Net cash provided by (uded in) financing activities Foreign currency effect on cash, cooh equivalents, and restricted cash Net increase decrease in cash, cash equivalents, and restricted cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENT AL 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, nct of refunds Property and equipment acquired under capital leases Property and equipment acquired under build-to-suit leader 487 (13,427) (11,955) (7,804) 2,104 1,897 1,067 (2,186) (13,972) (116) 8,240 9.677 4,577 (7,100) (12,731) (7,240) (12,369) (27,084) (9,516) 480 4.93 474 Soo (1,837) 26,791 (1,035) 19.625 43,549 $ 162,648 484 (1.837) 21,389 (484) 8,636 27,709 $ 131,310 $ 141,915 $118,573 $ 94,665 $90,972 $59,293 $ 41,322 768 16,228 618 (668) (1,301) (327) (7,449) (4,799) (3,860) (337) (200) (147) (7,686) 9,928 (3,716) (351) 713 (212) 10,317 1,922 3,759 32,173 21,856 19,934 854 328 290 575319 206 1,184957412 10,615 9,637 5,704 3,641 3,541 1,209 Information & Instructions Walmart Amazon Ratios Ratio Formulas @ - + 54% Fie Home insert Page Layout Formulas Data Review View Help Search Share Comments Ratios WALMART AMAZON information & Instructions Walmart Amazon Ratios Ratio Form
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