one tab if for amazon the other is the problem below for walmart.

thank you

PROJECT INFORMATION 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. 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. 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. Amazon Financial Statement Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions Total net sales Operating expenses: Cost of sales Fulfillment Marketing Expense Technology and content General and administrative Other operating expense, net Total operating expenses Operating income (loss) Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income before income taxes Provision for income taxes Equity method investment activity, net of tax Net income Basic earnings per share Diluted earnings per share Weighted average shares used in computation of earnings per share: Basic (in shares) Diluted (in shares) Net product sales Total net sales Net service sales Total net sales Page 12 Months Ended Dec 31, 2018 Dec 31, 2017 $ 232587 $177.866 Consolidated Balance Sheets - USD 15) Sin Millions Dec 31, 2016 Current assets: $ 135,987 Cash and cash equivalents Marketable securities 58.265 Inventories 17,619 Accounts receivable, net and other 7,233 Total current assets 16,085 Property and equipment, net 139,156 34,027 13,814 28,837 111.934 25.249 10.069 22,620 296 220,466 34674 214 173,760 4,105 12.421 202 (848) 1417 (183) 16 2,432 Goodwill 167 Other assets 131.801 Total assets 4.186 Current liabilities: 100 Accounts payable (484) Accrued expenses and other 90 Unearned revenue (294) Total current liabilities 3.892 Long-term debt 11.425) Other long term labies 196) Commitments and contingencies Note 7) $2,371 Stockholders' equity $5.01 Preferred stock, 50.01 par value: Authored shares-500 issued and outstanding shares- none (1.160 11.261 1,197 (300) 1306 17691 $ 10.073 $ 20.58 $ 3.033 56.32 $ 20.14 5615 $4.50 Common stock, 5001 par value: Authored shares - 5.000 issued shares. 507 and 514 Outstanding shares and 491 Treasury stock at cost 474 Additional pada capital 454 Accumulated other comprehensive loss Retained earnings $ 54,665 Total stockholders' equity Total ablities and stockholders' equity $41.322 $ 141,915 5116,573 $ 90,972 $ 59,293 Page 2 > Rao - zoom + C 31, 2017 Consolidated Statements of Cash Flows. USD SDS in Millions 12 Months Ended Dec 31, 2017 Dec 11, 2018 Dec 31, 2016 $ 21,856 $ 15,175 10.073 3,033 2,371 15.341 1147 8.116 2,975 213 $ 20,522 Statement of Cash Flows (Abstract] 10,464 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD 16.047 OPERATING ACTIVITIES 13,164 Net income 60,197 Adjustments to reconcile net income to net cash from operating activities: 48,866 Depreciation of property and equipment and other amortization, including capitalued content costs 13.350 Stock-based compensation 8,897 Other operating expense, net 131,310 Other expense income net Deferred income taxes 34,616 Changes in operating assets and abilities 18.170 inventories 5,097 Accounts receivable, net and other 57,883 Accounts payable 24,743 Accrued expenses and other 20.975 Unearned revenue Net cash provided by used in operating activities INVESTING ACTIVITIES 0Purchases of property and equipment 200 (245) 13.583) 14,780) 7.100 14.615) 3263 472 1.151 0723 13.435 5.030 1.724 1.955 17,203 12.16 (11.55 (7.804 5 Proceeds from property and equipment incentives 2.104 1,067 (13.972) (116) 12.186) 240 07.100 (12.731) 0300 19516 768 568) 17.49) 1622 (110 11,837) Acquisitions, net of cash acquired, and other 21,389 Sales and maturities of marketable securities (484) Purchases of marketable securities 8.636 Net cash provided by used in investing activities 27,709 FINANCING ACTIVITIES: $ 131,310 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 (327) 3.360 147 13.7151 2001 99 351 10317 12.173 1932 21 19.534 101615 53.54 S 1209 Ratios WALMART 0.799 61,897 77,477 AMAZON 1.098 75,101 68,391 Current Ratio Current Assets Current Liabilities Debt to Asset Ratio Return on Equity Return on Assets Inventory Turnover Days in Inventory Accounts Receivable Turnover Times Interest Earned Free Cash Flow Gross Profit Rate Profit Margin Asset Turnover For an opportunity to earn 5 points extra credit, please read the posted article "WalMart has already lost its battle with Amazon". Prepare a 1-1% page (max) double spaced paper with your opinion on the statements in the article. For the potential to earn the full 5 points you must refer to the ratios that you calculated in the excel portion of the project. You must mention specific ratios and how they support or do not support your position/opinion on the article. Your submission will also be graded for correct spelling, sentence structure, and grammar. Your paper must be prepared in Word (no other programs accepted). You must submit your Word document to the correct submission link on the Canvas site before 5pm on the due date. PROJECT INFORMATION 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. 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. 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. Amazon Financial Statement Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions Total net sales Operating expenses: Cost of sales Fulfillment Marketing Expense Technology and content General and administrative Other operating expense, net Total operating expenses Operating income (loss) Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income before income taxes Provision for income taxes Equity method investment activity, net of tax Net income Basic earnings per share Diluted earnings per share Weighted average shares used in computation of earnings per share: Basic (in shares) Diluted (in shares) Net product sales Total net sales Net service sales Total net sales Page 12 Months Ended Dec 31, 2018 Dec 31, 2017 $ 232587 $177.866 Consolidated Balance Sheets - USD 15) Sin Millions Dec 31, 2016 Current assets: $ 135,987 Cash and cash equivalents Marketable securities 58.265 Inventories 17,619 Accounts receivable, net and other 7,233 Total current assets 16,085 Property and equipment, net 139,156 34,027 13,814 28,837 111.934 25.249 10.069 22,620 296 220,466 34674 214 173,760 4,105 12.421 202 (848) 1417 (183) 16 2,432 Goodwill 167 Other assets 131.801 Total assets 4.186 Current liabilities: 100 Accounts payable (484) Accrued expenses and other 90 Unearned revenue (294) Total current liabilities 3.892 Long-term debt 11.425) Other long term labies 196) Commitments and contingencies Note 7) $2,371 Stockholders' equity $5.01 Preferred stock, 50.01 par value: Authored shares-500 issued and outstanding shares- none (1.160 11.261 1,197 (300) 1306 17691 $ 10.073 $ 20.58 $ 3.033 56.32 $ 20.14 5615 $4.50 Common stock, 5001 par value: Authored shares - 5.000 issued shares. 507 and 514 Outstanding shares and 491 Treasury stock at cost 474 Additional pada capital 454 Accumulated other comprehensive loss Retained earnings $ 54,665 Total stockholders' equity Total ablities and stockholders' equity $41.322 $ 141,915 5116,573 $ 90,972 $ 59,293 Page 2 > Rao - zoom + C 31, 2017 Consolidated Statements of Cash Flows. USD SDS in Millions 12 Months Ended Dec 31, 2017 Dec 11, 2018 Dec 31, 2016 $ 21,856 $ 15,175 10.073 3,033 2,371 15.341 1147 8.116 2,975 213 $ 20,522 Statement of Cash Flows (Abstract] 10,464 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD 16.047 OPERATING ACTIVITIES 13,164 Net income 60,197 Adjustments to reconcile net income to net cash from operating activities: 48,866 Depreciation of property and equipment and other amortization, including capitalued content costs 13.350 Stock-based compensation 8,897 Other operating expense, net 131,310 Other expense income net Deferred income taxes 34,616 Changes in operating assets and abilities 18.170 inventories 5,097 Accounts receivable, net and other 57,883 Accounts payable 24,743 Accrued expenses and other 20.975 Unearned revenue Net cash provided by used in operating activities INVESTING ACTIVITIES 0Purchases of property and equipment 200 (245) 13.583) 14,780) 7.100 14.615) 3263 472 1.151 0723 13.435 5.030 1.724 1.955 17,203 12.16 (11.55 (7.804 5 Proceeds from property and equipment incentives 2.104 1,067 (13.972) (116) 12.186) 240 07.100 (12.731) 0300 19516 768 568) 17.49) 1622 (110 11,837) Acquisitions, net of cash acquired, and other 21,389 Sales and maturities of marketable securities (484) Purchases of marketable securities 8.636 Net cash provided by used in investing activities 27,709 FINANCING ACTIVITIES: $ 131,310 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 (327) 3.360 147 13.7151 2001 99 351 10317 12.173 1932 21 19.534 101615 53.54 S 1209 Ratios WALMART 0.799 61,897 77,477 AMAZON 1.098 75,101 68,391 Current Ratio Current Assets Current Liabilities Debt to Asset Ratio Return on Equity Return on Assets Inventory Turnover Days in Inventory Accounts Receivable Turnover Times Interest Earned Free Cash Flow Gross Profit Rate Profit Margin Asset Turnover For an opportunity to earn 5 points extra credit, please read the posted article "WalMart has already lost its battle with Amazon". Prepare a 1-1% page (max) double spaced paper with your opinion on the statements in the article. For the potential to earn the full 5 points you must refer to the ratios that you calculated in the excel portion of the project. You must mention specific ratios and how they support or do not support your position/opinion on the article. Your submission will also be graded for correct spelling, sentence structure, and grammar. Your paper must be prepared in Word (no other programs accepted). You must submit your Word document to the correct submission link on the Canvas site before 5pm on the due date