2. Choose three methods of analysis depicted in chapter 9 (excluding vertical/horizontal analysis) and apply them to Walmart's financial statements (5 points for each type of analysis). Please state what you are calculating - for example, quick ratio, and show me the math with your answer. Use the Ratio/ Percentage and Trend Analysis's to apply to the financial statements. The financial statements are shown below. Show work as well. Thank you. Walmart Inc. Consolidated Statements of Income (Amounts in millions, except per share data) Revenues: Net sales Membership and other income Total revenues Costs and expenses: 2021 Fiscal Years Ended January 31, 2020 2019 $ 555,233 $ 519,926 $ 510,329 3,918 4,038 4,076 559,151 523,964 514,405 Cost of sales Operating, selling, general and administrative expenses Operating income Interest: Debt 420,315 394,605 385,301 116,288 108,791 107,147 22,548 20,568 21,957 1,976 2,262 1,975 Finance, capital lease and financing obligations Interest income Interest, net Other (gains) and losses Income before income taxes 339 337 371 (121) (189) (217) 2,194 2,410 2,129 (210) (1,958) 8,368 20,564 20,116 11,460 Provision for income taxes 6,858 4,915 4,281 Consolidated net income 13,706 15,201 7,179 Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart (196) (320) (509) $ 13,510 $ 14,881 S 6,670 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 outstanding: Basic Diluted Dividends declared per common share See accompanying notes. $ 4.77 $ 5.22 S 2.28 4.75 5.19 2.26 2,831 2,850 2,929 2,847 2,868 2,945 $ 2.16 $ 2.12 2.08 Walmart Inc. Consolidated Statements of Comprehensive Income (Amounts in millions) Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Other comprehensive income (loss), net of income taxes Currency translation and other Net investment hedges Cash flow hedges Minimum pension liability Other comprehensive income (loss), net of income taxes Other comprehensive (income) loss attributable to noncontrolling interest Other comprehensive income (loss) attributable to Walmart Comprehensive income, net of income taxes Comprehensive (income) loss attributable to noncontrolling interest Comprehensive income attributable to Walmart See accompanying notes. 2021 Fiscal Years Ended January 31, 2020 2019 13,706 S 15,201 $ 7,179 (196) (320) (509) 13,510 14,881 6,670 842 286 (226) (221) 122 272 235 (399) (290) (30) (1,244) 131 826 (1,235) (113) 213 (28) 188 1,039 (1,263) 75 14,532 13,966 7,066 17 (348) (321) $ 14,549 S 13,618 6,745 (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Goodwill Other long-term assets Total assets LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Total current liabilities Long-term debt Long-term operating lease obligations Long-term finance lease 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' equity Noncontrolling interest Total equity Total liabilities and equity See accompanying notes. Walmart Inc. Consolidated Balance Sheets As of January 31, 2021 2020 S 17,741 9,465 6,516 6,284 44,949 44,435 20,861 1,622 90,067 61,806 92,201 105,208 13,642 17,424 4,005 4,417 28,983 31,073 23,598 16,567 S 252,496 S 236,495 S 224 S 575 49,141 46,973 37,966 22,296 242 280 3,115 5,362 1,466 1,793 491 511 92,645 77,790 41,194 43,714 12,909 16,171 3,847 4,307 14,370 12,961 282 284 3,646 3,247 88,763 83,943 (11,766) (12,805) 80,925 74,669 6,606 6,883 87,531 81,552 S 252,496 S 236,495 Walmart Inc. Consolidated Statements of Shareholders' Equity Capital in Accumulated Other Total Walmart Common Stock Excess of Retained Comprehensive Shareholders' Noncontrolling Total (Amounts in millions) Shares Amount Par Value Earnings Income (Loss) Equity Interest Equity Balances as of February 1, 2018 Adoption of new accounting standards, net of income taxes Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.08 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Noncontrolling interest of acquired entity Other Balances as of January 31, 2019 Adoption of new accounting standards on February 1, 2019, net of income taxes Consolidated net income Other comprehensive income (loss), net of income taxes 2,952 $ 295 $ 2,648 $ 85,107 $ (10,181) $ 77,869 $ 2,953 $ 80,822 2,361 (1,436) 925 (1) 924 6,670 6,670 509 7,179 75 75 (188) (113) - (6,102) (6,102) (6,102) (80) (8) (245) (7,234) (7,487) (7,487) (488) (488) 4,345 4,345 1 562 (17) 546 8 554 2,878 288 2,965 80,785 (11,542) 72,496 7,138 79,634 (266) (266) (34) (300) 14,881 - 14,881 320 15,201 (1,263) (1,263) 28 (1,235) Cash dividends declared - (6,048) ($2.12 per share) (6,048) (6,048) Purchase of Company stock (53) (5) (199) (5,435) (5,639) (5,639) Cash dividend declared to noncontrolling interest Other (475) (475) 7 1 481 26 508 (94) 414 Balances as of January 31, 2,832 284 2020 Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.16 per share) Purchase of Company stock Cash dividends declared to noncontrolling interest Other Balances as of January 31, 2021 See accompanying notes. (20) 9 2,821 $ 282 $ | ||: 3,247 83,943 (12,805) 74,669 6,883 81,552 13,510 13,510 196 13,706 1,039 1,039 (213) 826 - (6,116) (6,116) (6,116) (97) (2,559) (2,658) (2,658) (365) (365) 496 3,646 $ (15) 88,763 $ 481 105 586 (11,766) $ 80,925 $ 6,606 S 87,531 Walmart Inc. Consolidated Statements of Cash Flows Fiscal Years Ended January 31, (Amounts in millions) 2021 2020 2019 Cash flows from operating activities: Consolidated net income 13,706 $ 15,201 $ 7,179 Adjustments to reconcile consolidated net income to net cash provided by operating activities: Depreciation and amortization 11,152 10,987 10,678 Net unrealized and realized (gains) and losses (8,589) (1,886) 3,516 Losses on disposal of business operations 8,401 15 4,850 Asda pension contribution (1,036) Deferred income taxes 1,911 320 (499) Other operating activities 1,521 1,981 1,734 Changes in certain assets and liabilities, net of effects of acquisitions and dispositions: Receivables, net Inventories Accounts payable (1,086) 154 (368) (2,395) (300) (1,311) 6,966 (274) 1,831 Accrued liabilities Accrued income taxes Net cash provided by operating activities Cash flows from investing activities: 4,623 186 183 (136) (93) (40) 36,074 25,255 27,753 Payments for property and equipment (10,264) (10,705) (10,344) Proceeds from the disposal of property and equipment 215 321 519 Proceeds from the disposal of certain operations 56 833 876 Payments for business acquisitions, net of cash acquired (180) (56) (14,656) Other investing activities 102 479 (431) Net cash used in investing activities (10,071) (9,128) (24,036) Cash flows from financing activities: Net change in short-term borrowings (324) (4,656) (53) Proceeds from issuance of long-term debt 5,492 15,872 Repayments of long-term debt (5,382) (1,907) (3,784) Dividends paid (6,116) (6,048) (6,102) Purchase of Company stock (2,625) (5,717) (7,410) Dividends paid to noncontrolling interest (434) (555) (431) Other financing activities (1,236) (908) (629) Net cash used in financing activities (16,117) (14,299) (2,537) Effect of exchange rates on cash, cash equivalents and restricted cash 235 (69) (438) Net increase in cash, cash equivalents and restricted cash Cash and cash equivalents reclassified as assets held for sale Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of year 10,121 1,759 742 (1,848) 9,515 7,756 7,014 S 17,788 $ 9,515 S 7,756 Supplemental disclosure of cash flow information: Income taxes paid Interest paid See accompanying notes. 5,271 $ 3,616 S 3,982 2,216 2,464 2,348