Answered step by step
Verified Expert Solution
Link Copied!

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.

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

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.
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Walmart Financial Statements Consolidated Statements of income - USD ($) shares in Millions, $ in Millions Jan. 31, 2018 Jan. 31, 2017 12 Months Ended Jan 31, 2018 Jan 31, 2017 Jan. 31, 2016 Revenues: Net sales Membership and other income Consolidated Balance Sheets - USD ($) $ in Millions Current assets Cash and cash ecuivalents Receivables, net Inventories $481,317 $ 495,761 4,582 $ 6,756 5,614 43,783 $ 478,614 9,515 $6,867 5.835 43,046 4,556 500,313 485,873 182,130 3,511 59,664 1,341 57,689 373,316 105,510 20,437 361,756 101,853 22,764 360,984 97,041 24,105 185,154 177,4791 107,675 179,492 171,782) 107,710 Total revenues Costs and expenses: Cast of sales Operating, selling general and administrative expenses Operating income Interest: Debt Capitalisse and financing obligations Interest income Interest, net Gain (los) on extinguishment of cebt Income before income taxes Provision for incorretaxes Corsolidated net income Corsolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: Badcnet Income per common share attributable to Walmart Diluted net income per common share attributable to Walmart Weighted average common shares outstandine: 1,978 352 (152) 2,178 3,136 2,044 323 1100) 2,267 2,027 521 181) 2,467 12.703 5.SGO 2.143 19,242 11,798 204,522 11,637 (5,169) 6,462 17,037 9,921 198,825 21,638 15.123 4.600 6.558 10.523 16611 9,862 20,497 6,204 14.293 16501 13.643 15.080 (385) 14,594 5.257 Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations Property under capital lease and financing obligations Les accumulatec amortization Property under capital lease and financing obligations, net Goodwill Other sets and deferred charges Total assets Current liabilities Short-term borrowines Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities Long term debt Long term capital case and financing abligations Deferred income taxes and other Commitments and contingencies Equity: Common stock Capital in excess af par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders'equity Noncontrolling interest Total eculty Total liabilities and equity $3.29 $ 3.28 $4.40 $4.38 $4.53 $ 4.57 46,092 22,122 645 3,738 667 78,521 30,045 5,780 8,354 1.099 41,433 20,654 921 2,256 565 66.928 36,015 6,003 3.207 Diluted Dividends declared per common share 2.995 3,010 2.04 3.101 3,112 2.00 3,217 1.95 295 2,648 85,107 110,111 77.869 2.953 80,822 $ 204,522 305 2.271 89,854 114,2321 77,798 2.737 80,935 $ 198,825 MN Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2018 Jan. 31, 2017 Jan. 31, 2016 $ 10,523 $ 14,293 $ 15,080 10,080 761 9,454 (672) 10,529 (304) 3,136 1,210 206 1,410 (1,074) -140 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 (19) -703 2,008 1,466 (472) 27,552 (10,051) 378 1,046 (11,477) 635 246 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 Deferred income taxes Gain (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 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 from 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 equivalents at beginning of year Cash and cash equivalents at end of year Supplemental disclosure of cash flow information: Income taxes paid Interest paid (10,619) 456 662 (1,901) (2,463) (122) (13,987) (375) (58) (9,060) (79) (10,675) (1,673) 137 (2,055) 1,235 39 (4,432) 4,148 7,476 (13,061) (3,059) (6,124) (8,296) (690) (8) (261) (19,875) 487 (111) 6,867 6,756 (6,216) (8,298) (479) (90) (398) (19,072) (452) (1,838) 8,705 6,867 (6,294) (4,112) (719) (1,326) (676) (16,285) (1,022) (430) 9,135 8,705 6,179 $2,450 4,507 $2,351 8,111 $2,540 1 Annuncil Scal Consolidated Statements of Operations - USD ($) sharesin Millions, $ in Millions 22 Montha Ended Consolidated Balance Sheets- USD 1515 in Millions Dec 31, 2018 Dec 31, 2017 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 $ 232,887 $ 177.86 $ 135,987 $ 21,750 $ 20,522 4 5 Total na walis Operating expenses: Catian cash wiwwents Nyesele securities 6 Cout of sal 139,155 17,174 15.047 111,934 25,149 10.0ES 22,620 13.814 50, 157 Terable, dhe Total current act: Property and equipment, nat Gootwill 16,085 75.101 61,797 14,505 11,202 13.350 3,897 Cerer 220, 45 4,106 100 (941 1848) 15.170 5,087 x Mariting Experse 9 Technolony and content 10 Gereal and adminisrative 11 Other operating pelsene 12 ingrepen 13 Operating income fossi 14 Inristina 15 Interestepense 16 Other income lupenzel net 17 T eringing 12 Income bctare Income taxes 19 Prevision for incaran 20 Equity method investment activity, not ofta 21 Neincome 22 Basicernings posare 23 Diluted ning per share 24 Weighted av RAM shares used in computation of aming per har: 23 Barclinare 26 Diluted in shares) 27 Ne productes 11.9171 11331 11.11 11.251 (1,1971 38,192 23,663 6,535 1,891 23,495 27,213 100) Tel Current liabilities Hocauns peab Rocrecipes and other Unservence Text current liabilities Long term debt Carlor-lum libilities Commitments and contingencies Note 7 Stockholders' equity Proherred stack $0.01 par value A.thorized cheres-500 Issued and outstanding shares- nord Common stock $301 par value Nethanized shares -5,003 we shares -507 and 514 Outstanding shares (7401 24,743 19,975 $10.075 $20.65 $20.14 $ 3,023 $532 5615 1,4251 1961 $ 2,371 $5.01 $4.901 437 480 Additional pild in capital Hocumulate other comprehensiveless 26,791 11.0351 19,625 21,389 484) 500 $ 141,015 $116.32 $94. 95 Tolakhelde equily Total abilities and sockholders equity $ 162,643 5131320 29 Nesenice ale 30 Total net sales $ 90.972 $59,253 $ 41,322 M N 0 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec. 31, Dec. 31, Dec. 31, 2018 2017 2016 $21,856 $19,934 $16,175 10,073 3,033 2,371 15,341 5,418 274 219 11,478 4,215 202 (292) (29) 8,116 2,975 160 (20) 441 (246) (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 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 activities: Depreciation of property and equipment and other amortization, including capitalized content costs 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) (11,955) 2,104 1,897 (2,186) (13,972) 8,240 9,677 (7,100) (12,731) (12,369) (27,084) (7,804) 1,067 (116) 4,577 (7,240) (9,516) 618 768 (668) (7,449) (337) (7,686) (351) 10,317 32,173 16,228 (1,301) (4,799) (200) 9,928 (327) (3,860) (147) (3,716) (212) 3,759 19,934 713 1,922 21,856 854 575 1,184 10,615 3,641 328 319 957 9,637 3,541 290 206 412 5,704 1,209 Ratios WALMART AMAZON 4 Current Ratio 0.760 1.098 Current Assets DL 59, 664 7 5,101 9 Current Liabilities 78,521 68,391 Total Debt Total Assets Debt to Asset Ratio UU UU UUU UUDU Return on Equity Return on Assets Inventory Turnover Days in Inventory 55 Accounts Receivable Turnover Times Interest Earned Free Cash Flow Gross Profit Rate 88 Profit Margin Asset Turnover 112

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Quality Auditing

Authors: Lance B. Coleman

1st Edition

087389913X, 978-0873899130

More Books

Students also viewed these Accounting questions