Question: Here is a project I have worked on generating the income statement, balance sheet, and cash flow statements for Walmart and then their competitor Amazon

Here is a project I have worked on generating the income statement, balance sheet, and cash flow statements for Walmart and then their competitor Amazon by using the EDGAR site. I now need to generate the following ratios and I have no idea how. Can you please explain?

Here is a project I have worked on generating theHere is a project I have worked on generating theHere is a project I have worked on generating theHere is a project I have worked on generating theHere is a project I have worked on generating theHere is a project I have worked on generating the
Amazon.Com, Inc Balance Sheet As of December 31, 2023, December 31, 2022, and December 31, 2021 $s in Millions LD CO DI UI A W N - 2021 2022 2023 ASSETS Current assets: 10 Cash and cash quivalents $ 36,220 $ 53,888 $ 73,387 11 Marketable securities 59,829 16,138 13,393 12 Inventories 32,640 34,405 33,318 13 Accounts receivable, net and other 32.891 42,360 52.253 14 Total Current Assets 161,580 146,791 172,351 15 Property and equipment, net 160,281 186,715 204,177 16 Operating leases 56,082 66,123 72,513 17 Good will 15,371 20,288 22,789 18 Other assets 27,235 42,758 56,024 19 Total assets $ 420,549 $ 462.675 $ 527,854 20 LIABILITIES AND STOCKHOLDERS EQUITY 21 Current liabilities: 22 Accounts payable $ 78,664 $ 79,600 $ 84,981 23 Accrued expenses and other 51,775 62,566 64,709 24 Unearned revenue 11,827 13,227 15,227 25 Total current liabilities $ 142,266 155,393 164,917 26 Long-term lease liabilities 67651 72,968 77,297 27 Long-term debt 48744 67,150 58,314 28 Other long-term liabilities 23643 21,121 25,451 29 Commitments and contingencies (Note 7) 30 Stockholders' equity 31 Preferred stock ($0.01 parvalue; 500 shares authorized; no shares issued or outstanding) 0 0 0 32 Common stock (0.01 par value; 100,000 shares authorized; 10,757 33 and 18,898 shares issued; 10,242 and 10,383 shares outstanding) 106 108 109 34 Treasury stock, at cost [1,837) (7,837) -7837 35 Additional paid-in captial 55,437 75,066 99,025 36 Accumulated other comprehensive income (loss) (1,376) (4,487) (3,040) 37 Retained earnings 85,915 83.193 113,618 38 Total stockholders' equity 138,245 146,043 201,875 39 Total liabilities and stockholders' equity $ 420,549 $ 462,675 $ 527,854 40Amazon.Com, Inc Statement of Cash Flow As of December 31, 2023, December 31, 2022, and December 31, 2021 $s in Millions Year Ended December 31, 2021 2022 2023 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD 42377 $ 36477 $ 54,253 OPERATING ACTIVITIES: Metincome (loss) 33,364 (2,722) 30,425 Adjustments to reconcile netincome (loss) to net cash from operating activites: Depreciation and amartization of property and equipment and capitalized content costs, 34,433 41,921 48,663 operating lease assets, and other Stock-based compensation 12,757 19,621 24,023 Mon-operating expense (income), net (14,308) 16,966 {748} Deferred income taxes (310} 18,148) (5,876) Changes in operating assets and liabilities: Inventories (9,487} 2,592) 1,449 Accounts receivable, net and other (9,145} 18,622) 18,348) Other asets (9,018) (13,275) (12,265) Accounts payable 3,602 2,945 5,473 Accrued expenses and other 2,123 (1,558) (2,428) Unearned revenues 2314 2,216 4,578 Met cash provided by (used in) operating activites 46,327 46,752 54,946 INVESTING ACTIVITES: Purchases of property and equipment 161,053) (63,645) (52,729) Proceeds from property and equipment sales and incentives 5,657 5,324 4,596 Acquistions, net cash of acquired, non-marketable investments, and other (1,963) 18,316) 19,839) Sales and maturities of marketable securities 59,384 31,601 5,627 Purchases of marketable securities (60,157) 12,565) 11,488) Met cash provided by (used in) investing activities (58,154) (37,601) (49,833) FINAMCING ACTIVITIES: Common stock repurchased - (6,000) - Proceeds from short-term debt, and other 7.956 41,553 18,129 Repayments of short-term debt, and other (7,753) (37,554 (25,677) Proceeds from long-term debt 19,003 21,166 - Repayments of long-term debt (1,590) 11,258) 13,676) Principal repayments of finance leases (11,163} (7,941) (4,384) Principal repayments of financing obligations (162) (248) (271) Met cash provided by (used in) financing activities 6,291 9,718 (13,879) Foreign currency effect on cash, cash equivalents, and restricted cash (364) 11,093) 403 Met increase (decrease)in cash,cash equivalents, and restricted cash (5,900} 17,776 19,637 CASH, CASH EQUIVALENTS,AND RESTRICTED CASH,END OF PERIOD 36477 $ 54,253 73,890 . Amazon.Com, Inc Income Statement As of December 31, 2023, December 31, 2022, and December 31, 2021 $s in Millions 2021 2022 2023 Net product sales $ 241,787 $ 242,901 $ 255,887 Net service sales 228,035 271,082 318,898 Total net sales 469,822 513,983 674,785 10 Operating expenses: 11 Cost of sales 272,344 288,831 304,739 12 Fulfillment 75,111 84,299 90,619 13 Technology and infrastructure 56,052 73,213 85,622 14 Sales and amrketing 32,551 42,238 44,370 General and administrative 8,823 11,891 11,816 16 Other operating expense (income), net 52 1,263 767 17 Total operating expenses 444,943 501,735 637,933 18 Operating income 24,879 12,248 36,852 19 Interest income 448 989 2,949 20 Interest expense (1,809) (2,367) (3,182) 21 Other income (expense), net 14,633 (16,806) 938 22 Total non-operating income (expense) 13,272 18,184) 705 23 Income (loss) before income taxes 38,151 (5,936 37,557 24 Benefit (provision) for income taxes 4791 3217 -7120 25 Equity-method investment activity, net of tax 4 -3 .12 26 Net income (loss) 33364 2722 30425 27 Basic earnings per share $ 3.30 $ 0.27) $ 2.95 28 Diluated earnings per share $ 3.24 $ 0.27) $ 2.90 29 Weighted-average shares used in computation of earnings per share: 30 Basic 10117 10189 10304 31 Diluated 10,296 10,189 10,492 32v Lu Read & Interact: Revsine, Collin: * | M Reading Mode: Chapter 1: The [ X | @ EDGAR Entity Landing Page XBRL Viewer X C 25 sec.gov/ix?doc=/Archives/edgar/data/0000104169/000010416924000056/wmt-20240131.htm GB geekboxi Menu Sections Search Facts Q Q Data Tags T More Filters Facts 1,399 Tagged Sections Search Sections Walmart Inc. Consolidated Balance Sheets Cover 2 As of January 31, (Amounts in millions) 2024 2023 Financial Statements ASSETS Current assets: Notes to Financial Statements 16 Cash and cash equivalents 2.867 8,625 Receivables, net 5,796 7.935 Net Income Per Common Share Inventories 34,892 36,376 Prepaid expenses and other 2.327 Total current assets 76,877 75.635 Shareholders' Equity Property and equipment, net 110,810 100, 760 Accumulated Other Comprehensive Loss Operating lease right-of-use assets 13.675 13,355 Finance lease right-of-use assets, net 3.855 4.919 Accrued Liabilities Goodwill 28,115 28,174 Other long-term assets 17,071 20,134 Total assets 252,399 43,197 Short-term Borrowings and Long-term Debt LIABILITIES, REDEEMABLE NONCONTROLLING INTEREST, AND EQUITY Leases Current liabilities: Short-term borrowings 575 372 Fair Value Measurements Accounts payabl 36.812 35,742 Accrued liabilities 25,735 31, 126 Accrued income taxes Taxes Long-term debt due within one year Operating lease obligations due within one year 1.457 Contingencies Finance lease obligations due within one year 367 Total current liabilities 92,195 Retirement-Related Benefits Long-term debt 36.132 34,649 Long-term operating lease obligations 12 943 12.828 Disposals, Acquisitions and Related Items Long-term finance lease obligations 4,843 Deferred income taxes and other 14,625 14,638 Segments and Disaggregated Revenue Commitments and contingencies Subsequent Event Redeemable noncontrolling interest 122 237 Pay vs Performance Disclosure Equity: Common stock Capital in excess of par value 4,34 4,430 Insider Trading Arrangements Retained earnings 83,135 Accumulated other comprehensive loss (11,650) Summary of Significant Accounting Policies Total Walmart shareholders' equity 33,861 76,693 Noncontrolling interest 6.485 7.06T Accounting Policies 1 Total equity 30,345 35,754 252,399 243,197 Notes Tables 12 Total liabilities, redeemable noncontrolling interest, and equity 42 See accompanying notes. Notes Details 56v Lu Read & Interact: Revsine, Collin: * | M Reading Mode: Chapter 1: The [ X | @ EDGAR Entity Landing Page * @ XBRL Viewer 0 G 25 sec.gov/ix?doc=/Archives/edgar/data/0000104169/000010416924000056/wmt-20240131.htm GB geekboxit Menu Sections Search Facts Q Data >Tags T More Filters Facts 1,399 Search Sections Walmart Inc. Consolidated Statements of Cash Flows Cover 2 Fiscal Years Ended January 31, Financial Statements 6 (Amounts in millions) 2024 2023 2022 Cash flows from operating activities: Notes to Financial Statements 16 Consolidated net income 16.270 $ 11,292 $ 13.940 Adjustments to reconcile consolidated net income to net cash provided by operating activities: Net Income Per Common SH Depreciation and amortization 11,853 10,945 10,658 Net unrealized and realized (gains) and losses 3, 193 1.683 2.440 Shareholders' Equity Losses on disposal of business operations Deferred income taxes ITS Loss on extinguishment of debt 2.410 Accumulated Other Comprehensive Other operating activities J.642 1.915 1.652 Loss Changes in certain assets and liabilities, net of effects of acquisitions and dispositions: Receivables, net 240 (1,796 Accrued Liabilities Inventories 525 (1,764) Accounts payable Short-term Borrowings and Long- Accrued liabilities 1.404 term Debt Accrued income taxes Net cash provided by operating activities 24, IST Leases Cash flows from investing activities: Payments for property and equipment 13, 106 Fair Value Measurements Proceeds from the disposal of property and equipment Proceeds from disposal of certain operations, net of divested cash Taxes Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities 6.015) Contingencies Cash flows from financing activities: Retirement-Related Benefits Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt 15:010) Disposals, Acquisitions and Related Premiums paid to extinguish debt Items Dividends paid Purchase of Company stock Segments and Disaggregated Dividends paid to noncontrolling interest Revenue Purchase of noncontrolling interest sale of subsidiary stock Subsequent Event Other financing activities Net cash used in financing activities 17, 035) (22,825) Pay vs Performance Disclosure Effect of exchange rates on cash, cash equivalents and restricted cash (140) 4,802 Insider Trading Arrangements Net increase (decrease) in cash, cash equivalents and restricted cash 5.993 Change in cash and cash equivalents reclassified from assets held for sale 1,848 Cash, cash equivalents and restricted cash at beginning of year 14,834 17.785 Summary of Significant Accounting Cash, cash equivalents and restricted cash at end of year 9.935 14,834 Policies Supplemental disclosure of cash flow information: Accounting Policies 1 Income taxes paid 3.310 3.918 Interest paid 2,051 2,237 Notes Tables 12 See accompanying notes. Notes Details 42v Lu Read & Interact: Revsine, Collins x | M Reading Mode: Chapter 1: The [ x | @ EDGAR Entity Landing Page * @ XBRL Viewer * + X G 2 sec.gov/ix?doc=/Archives/edgar/data/0000104169/000010416924000056/wmt-20240131.htm GB geekboxit =Menu Sections Search Facts Q Data Tags T More Filters Facts 1,399 Rogers, Arkansas Cover 2 March 15, 2024 Financial Statements 6 53 Notes to Financial Statements 16 Net Income Per Common Share Shareholders' Equity Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, Accumulated Other Comprehensive (Amounts in millions, except per share data) 2024 2023 2022 Loss Revenues: Net sales 642,637 605.831 567,762 Accrued Liabilities Membership and other income 5.488 5,408 4,992 Total revenues 48,125 611,289 172,754 Short-term Borrowings and Long- Costs and expenses: term Debt Cost of sales 190,142 463,72 29,000 Operating, selling, general and administrative expenses 30.971 27,140 17,812 Operating income 27,012 20,428 25,942 Leases interest: Debt 2.259 1.674 Fair Value Measurements Finance lease 341 320 Interest income Taxes Interest, net 1,856 Loss on extinguishment of debt 2410 Other (gains) and losses 3.027 3.000 Contingencies Income before income taxes 21,545 17.016 18.696 Provision for income taxes 4.756 Retirement-Related Benefits Consolidated net income 16,270 11,292 13,940 Consolidated net (income) loss attributable to noncontrolling interest (735 ) (267 ) Disposals, Acquisitions and Related Consolidated net income attributable to Walmart 11,680 13.673 Items Net income per common share: Segments and Disaggregated Basic net income per common share attributable to Walmart 1.92 $ 1.43 $ 1.63 Diluted net income per common share attributable to Walmart 191 167 Revenue Weighted-average common shares outstanding Subsequent Event Basic 3.077 5.171 3.376 Diluted 5,105 5,202 3,415 Pay vs Performance Disclosure Dividends declared per common share 0.7600 $ 0.7467 $ 0.753 Insider Trading Arrangements 54 Summary of Significant Accounting Policies Accounting Policies 1 Walmart Inc. Notes Tables 12 Consolidated Statements of Comprehensive Income 42 Fiscal Years Ended January 31, Notes Details (Amounts in millions) 2024 2023 2022

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!