Question: Please construct a statement of cash flows using the balance sheet and income statement attached. I also attached the statement of cash flows template our


Format G3. A Fx Assets A 1 A Walmart Balance Sheet 2 Consolidated Balance Sheets - USD (S) S in Millions Jan. 31, 2022 Jan. 31, 2021 3 Current assets: 4. Cash and cash equivalents 5 Receivables, net 6 inventories 7 Prepaid expenses and other 8 Total current assets 9. Property and equipment, net 10 Operating lease right-of-use assets 11 finance lease right-of-use assets, net 12 Goodwill 13 Other long-term assets 14 Total assets \begin{tabular}{r|r} \hline$14,760 & $17,741 \\ \hline 8,280 & 6,516 \\ \hline 56,511 & 44,949 \\ \hline 1,519 & 20,861 \\ \hline 81,070 & 90,067 \\ \hline 94,515 & 92,201 \\ \hline 13,758 & 13,642 \\ \hline 4,351 & 4,005 \\ \hline 29,014 & 28,983 \\ \hline 22,152 & 23,598 \\ \hline 244,860 & 252,496 \\ \hline \end{tabular} 15 Current Habilities: 16. nort-term borrowings 17 Accounts payable 18 Accrued liabilities 19 Accrued income taxes 20 Lonsiterm debt due within one year 21 Operating lease obligations due within one year 22. Finance lease obligations due within one year 23 Total current liabilities 24 Long.term debt: 25 Long-term operating lease obligations: 26 Lons.term finance lease obligations. 27 Deferred income taxes and other: \begin{tabular}{|r|r|} \hline 410 & 224 \\ \hline 55,261 & 49,141 \\ \hline 26,060 & 37,966 \\ \hline 851 & 242 \\ \hline 2,803 & 3,115 \\ \hline 1,483 & 1,466 \\ \hline 511 & 491 \\ \hline 87,379 & 92,645 \\ \hline 34,864 & 41,194 \\ \hline 13,009 & 12,909 \\ \hline 4,243 & 3,847 \\ \hline 13,474 & 14,370 \\ \hline \end{tabular} 28 Commitments and contingencies 29 Equityt 30 Common stock 31 Capital in excess of par value 32 Retained earnings 33 Accumulated other comprehensive loss 34 Total Walmart shareholders' equity 35 Noncontroling interest 36 Total equity 37 Total hablitites and equity. 39 40 41 42 43 44 45 46 47 48 49 50 Statement of Cash Flows Millions of dollars \begin{tabular}{|l|l|l|} \hline Jan. 31, 2022 & Jan. 31, 2021 & Jan. 31, 2020 \\ \hline \end{tabular} Cash Flows from Operations 6 Net Income 7 Depreciation (combined with PP\&E) 8 Change in Accounts Receivable 9 Change in Inventories 10 Change in Other Current Assets 11 Change in Accounts Payable 12 Change in Other Current Liabilities 13 Total Cash Flows from Operations \begin{tabular}{|r|r|r|} \hline 0.01 & & \\ \hline 0.00 & 0.00 & 0.00 \\ \hline 660.00 & -56.00 & 208.00 \\ \hline-374.00 & 944.00 & 1,188.00 \\ \hline 208.00 & 1,132.00 & 2,582.00 \\ \hline-551.00 & 69.00 & 5,486.00 \\ \hline-162.00 & 26.00 & 6,073.00 \\ \hline-218.99 & -149.00 & 1,015.00 \\ \hline \end{tabular} 14 Cash Flows from Investing 15 Change in Short-term Investments 16 Change in Net Plant \& Equipment 17 Change in Other Long-term assets 18 Total Cash Flows from Investing \begin{tabular}{|r|r|r|} \hline 159.00 & 3,220.00 & 1,720.00 \\ \hline-626.00 & 684.00 & -491.00 \\ \hline 1,548.00 & 2,362.00 & 2,477.00 \\ \hline 1,081.00 & 4,898.00 & 1,248.00 \\ \hline \end{tabular} 19 Cash Flows from Financing 20 Change in Short-term Debt 21 Change in Long-term Debt 22 Change in Other Long-term Liabilities 23 Change in Common Stock 24 Change in Other Equity 25 Cash Dividends Paid to Shareholders 26 Total Cash Flows from Financing 27 Net Change in Cash Balance \begin{tabular}{|r|r|r|} \hline-40.00 & -38.00 & -133.00 \\ \hline-94.00 & 132.00 & -258.00 \\ \hline-415.00 & 1,084.00 & 462.00 \\ \hline 1,291.00 & 3,828.00 & 1,580.00 \\ \hline-654.00 & 318.00 & -184.00 \\ \hline4,311.01 & 1,864.00 & -826.00 \\ \hline4,223.01 & 7,188.00 & 641.00 \\ \hline3,361.00 & 2,141.00 & 408.00 \\ \hline \end{tabular} 28 29 Check 30 ok
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
