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.

Please complete the formulas for Walmart and please provide the formulas used.

Walmart

Amazon

PLEASE INCLUDE ANY FORMULAS USED.

When you have downloaded both sets of statements, you will copy over the following 2018 statement information for both companies to this file under each company's Tab and you will need to complete the project in this file. This file is the file you must upload Consolidated Income Statement, Consolidated Balance Sheet, Consolidated Statements of Cash Flows You will see three columns with the headings of 2018, 2017, 2016, with the financial data underneath it. 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. I have completed the first set of account titles. 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. Next use the numbers you have entered to calculate the ratios requested. 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. 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. Ratios WALMART AMAZON Current Ratio Formula Formula Current Assets These numbers would be cell referenced These numbers would be cell Current Liabilities These numbers would be cell referenced These numbers would be cellr Current Ratio 1.098 Current Assests 75,101 | Current Liabilities 68,391 Debt to Asset Ratio 0.732 Total Liabilities 119,099 Total Assests 162,648 Return on Equity 0.231 Net Income $ 10,073 Shareholders Equity 43,549 Return on Assets 0.062 Net Income | $10,073 Total Assets 162,648 Inventory Turnover 8.378 Cost of Goods Sold 139,156 Average Inventory 16610.5 Days in Inventory 44.000 Average Inventory 16610.5 Cost of Goods Sold 139156.000 Accounts Receivable Turnover 15.609 Net Sales $ 232,887 Average Account Receivable 14920.5 Times Interest Earned 8.766 EBIT $ 12,421 Total Interest Expenses 1,417 Free Cash Flow 44,150 Operating Cash Flow 30,723 Capital Expenditure (13,427) Gross Profit Rate 0.403 Gross Profit 93,731 Net Sales $ 232,887 Profit Margin 4.330|| Net Profit $ 10,073 Net Sales $ 232,887 Asset Turnover 3.100 Net Sales $ 232,887 Total Assests 75101 Walmart Financial Statements Jan. 31, 2019 Jan 31, 2018 Consolidated Statements of Income - USD ($) shares in Millions, Sin Milions 12 Months Ended Jan. 31, 2018 Jan 31, 2019 Jan. 31, 2017 Revenues Net Sales Membership and other income Consolidated Balance Sheets - USD ($I $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventaries $510,329 4,076 $ 495,761 4,582 $ 481 317 4,556 $ 7,722 6323 44269 $ 6,756 5.614 43,783 514 405 500,343 495 273 3,511 61 897 59,564 385 301 107,147 21,957 373,396 106,510 361,256 101,853 22,764 20437 185810 1814931 104 317 185,154 (77479) 107,675 1,975 2,044 323 (217) 2.129 Total revenues Casts and expenses: Cost of sales Operating, seling, general and administrative expenses Operating income Interest: Debt Capital lease and financing obligations Interest income Interest, net Lass on extingukshment of debt Other pro and losses Income before income takes Provision for income taxes Consolidated net income Consolidated net income attributable ta nancontrolling 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 outstandine: 1,978 352 (152) 2,178 3,135 (100) 2,267 12,760 (5,6821 7,078 31,181 14822 219 295 12,703 (5,560) 7.143 18,242 11.798 204,522 15.123 11,460 4281 7179 509) $6,670 20,497 6,204 14.293 650) $ 13613 10.523 (651) S 9862 5.257 Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less acumulated deareciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property undercapital case and financing obligations, net Goodwil Other interm assets Total assets Curren labes: Short-lerin borrowines Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations cue within one year Total current abilities Long term debt Long-term capital lease and financine oblications Deferred income taxes and other Corintments and contingencies Equity! Cominon stock Capital in excess of par value Retained earrines Accumulated other comprehensive loss Total Walmart shareholders equity Noncantroling Interest Totalequity Totallisbities and equity 5225 47090 22.159 46.092 22.122 545 3,738 $2.28 $ 2.26 $3.29 $ 3.28 $4.10 $ 4.38 1876 729 77.477 43520 6683 11981 2929 2.945 $2.08 2,995 3.010 $ 2.014 3,101 3,112 Diluted Dividends declared per common share 78.521 30,045 6.780 8,354 $2 295 283 2,965 80,785 (11 542] 72495 2,648 85.107 (10,181) 77.869 2,953 80,822 $ 204,522 79634 $ 219.295 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2018 Jan. 31, 2019 Jan. 31, 2017 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net cash provided by operating activities: $ 7,179 $ 10,523 $ 14,293 10,529 10,678 3,516 4,850 (499) 0 (304) 3,136 1,210 10,080 0 0 761 0 206 1,734 (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 (10,344) 519 876 (10,051) 378 1,046 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 acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes INet 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) (14,656) (431) (24,036) (375) (77) (9,079) (53) 15,872 (3,784) (1,673) 137 (2,055) 4,148 7,476 (13,061) (3,059) (6,124) (8,296) (6,102) (7,410) (431) (690) 0 (629) (2,537) (438) 742 7,014 7,756 (261) (19,875) 487 (130) 7,144 7,014 (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 Amazon Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, Dec. 31, 2018 2017 $ 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 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.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 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 38,192 23,663 6,536 68,391 23,495 27,213 34,616 18,170 5,097 57,883 24,743 20,975 5 5 (1,837) 26,791 (1,035) 19,625 43,549 162,648 (1,837) 21,389 (484) 8,636 27,709 131310 macon Financial Statement Consolidated Statements of Cash Flows - USD $ $ In Millons Consolidated Balance Sheets - USD () Sin Millions Dec 31, 2018 Dec 31, 2017 12 Months Ended Dec 31, 2017 Dec 31, 2018 Dec 31, 2016 Statement of Cash Flows Abstract CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: $ 19,934 $ 16,175 $31.750 9500 17,174 $ 20,522 10464 16,047 Current assebe Cash and ash equivalents Markelalleries Inventories Ac rew , net and other Totalment assets Peacetyl ent, ne Gogdel 10,073 9,033 2,271 11.478 15,341 5,418 8,115 2975 4.215 Adjustments to reconcile net income to net cash from operating activities: Dertien opgery and unent and other amortization industry capitalized content Stock-based compensation Other operating Papers, ne! Other expanse (income.net Delerdines Changes in operating assets and abilities: 75 101 61,707 14 548 11.200 162,648 30,197 48,266 12.350 8,897 131,310 200 (2921 1201 1291 1245 34,516 33,192 23652 (1,5141 (4,515) 11,583 14,780 18.120 13.4351 5,087 7.100 5280 1.724 BR 391 23,496 27,213 1.151 1955 17203 24,743 20,975 30,723 12,265 Total assets Current abilities: Accounts payable And espers and other Uneamed revenue Totalment initie Long term deb Other lorem libilis Commitments and contingendes (Note 71 Stockhokers' Guit Preferred stock, 30.01 ar value Added shares - 500 led and outstanding shares Common stock, $0.01 parvave: Authored share 5.000 issued shares 507 and 514 Outstanding Treasury stock, at cost Adding paid-in aptal Accumulated other comprehensive loss Retained camings Total stockholders' equity Tecallbisan stockholders euity (11,4651 171041 (11.427) 2,104 12,186) (13.9721 (1837) 25,791 (1,5321 21,69 94627 7,100) (12,369) (12,7211 (27.084 (116) 4577 17.2401 19.5151 Accounts receivablent and other Auris payable Accrued cxpenses and other Une med revers Nct cash provided by used in operating acts INVESTING ACTIVITIES: Purchases of property and equipment Proceeds from property and equipment inocnthes Acquisitions, net of cash acquired, and other Sales and mounties of marketable securities Purchase of Marketable Securities Netcash provided by used in westing activities FINANONG ACTIVITIES: Proces from re cebit and other payments of long-term debeard oder Principal repayments of capitalase obligations Prins paire payments of france lease obigations Netcash provided by used in financine activities Femign currency effect on cash, cash cuivalents, and restricted cash Net increase dorease in cash, cashe.valents and restricted cash CASH.CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SLIPPLEMENTAL CASH FLOW INFORMATION: Cash paid for new onlarg term debe Cash paid forint on capital and financeinaseobigations Cash paid for income taxes, nct of refunds Property and equpment m ed under tapital leases Property and equipment Acquired under ..to w eases 19,625 $162,648 27,709 131,310 (668 0,449 16,228 11,2011 14,799 (200) 9.928 13271 13.860 (147) 13,7161 (7.26 1,922 10317 32,173 3.759 19934 21.85G 319 205 10,635 $ 3,511 9.637 $ 3,541 $1,200