can you please help me with the statement of cash flows spreadsheet i attached. i am baving difficulty with it
2020 2019 Cash Flows from Operations Net Income Depreciation (combined with PP&E) Change in Accounts Receivable Change in Inventories Change in Other Current Assets Change in Accounts Payable Change in Other Current Liabilities Total Cash Flows from Operations Cash Flows from Investing Change in Short-term Investments Change in Net Plant & Equipment Change in Other Long-term assets Total Cash Flows from Investing Cash Flows from Financing Change in Short-term Debt Change in Long-term Debt Change in Other Long-term Liabilities Change in Common Stock Change in Other Equity Cash Dividends Paid to Shareholders Total Cash Flows from Financing Net Change in Cash Balance Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 $ 6,756 5,614 43,783 3,511 59,664 $ 9,465 6,284 44,435 1,622 61,806 105,208 17,424 4,417 0 31,073 16,567 236,495 $ 7,722 6,283 44,269 3,623 61,897 104,317 0 0 7,078 31,181 14,822 219,295 185,154 (77,479) 107,675 12,703 (5,560) 7,143 18,242 11,798 204,522 Consolidated Balance Sheets - USD ($) $ In Millions 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 Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: 6 Short-term borrowings 7 Accounts payable 8 Accrued liabilities -9 Accrued income taxes CO Long-term debt due within one year 1 Operating lease obligations due within one year 22 Finance lease obligations due within one year 23 Capital lease and financing obligations due within one year 24 Total current liabilities 25 Long-term debt 26 Long-term operating lease obligations 27 Long-term finance lease obligations 28 Long-term capital lease and financing obligations 29 Deferred income taxes and other 30 commitments and contingencies 31 Equity: 32 Common stock 33 Capital in excess of par value 34 Retained earnings 35 Accumulated other comprehensive loss 36 Total Walmart shareholders' equity 37 Noncontrolling interest 38 Total equity 39 Total liabilities and equity 40 41 575 46,973 22,296 280 5,362 1,793 511 0 77,790 43,714 16,171 4,307 0 12,961 5,225 47,060 22,159 428 1,876 0 0 729 77,477 43,520 0 0 6,683 11,981 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 284 3,247 83,943 (12,805) 74,669 6,883 81,552 $ 236,495 288 2,965 80,785 (11,542 72,496 7,138 79,634 $ 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 12 Months Ended Jan. 31, 2019 Jan. 31, 2020 Jan 31, 2018 $ 519,926 4,038 523,964 $ 510,329 4,076 514,405 $ 495,761 4,582 500,343 394,605 108,791 20,568 385,301 107,147 21,957 373,396 106,510 20,437 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Revenues: Net Sales Membership and other income Total revenues Costs and expenses: Cost of sales Operating selling general and administrative expenses Operating income Interest: Debt Finance, capital lease and financing obligations Interest income Interest, net Loss on extinguishment of debt Other (gains) and losses 8 Income before income taxes 9 Provision for income taxes 0 Consolidated net income 1 Consolidated net income attributable to noncontrolling interest 22 Consolidated net income attributable to Walmart 23 Net income per common share: 24 Basic net income per common share attributable to Walmart 25 Diluted net income per common share attributable to Walmart 26 Weighted average common shares outstanding: 27 Basic (in shares) 28 Diluted (in shares) 29 Dividends declared per common share 30 2,262 337 (189) 2,410 0 (1,958) 20,116 4,915 15,201 (320) $ 14,881 1,975 371 (217) 2,129 0 8,368 11,460 4,281 7,179 (509) $6,670 1,978 352 (152) 2,178 3,136 0 15,123 4,600 10,523 (661) $ 9,862 $5.22 $5.19 $ 2.28 $ 2.26 $ 3.29 $ 3.28 2,850 2,868 $ 2.12 2,929 2,945 $ 2.08 2,995 3,010 $2.04 32 33 34 35 26 2020 2019 Cash Flows from Operations Net Income Depreciation (combined with PP&E) Change in Accounts Receivable Change in Inventories Change in Other Current Assets Change in Accounts Payable Change in Other Current Liabilities Total Cash Flows from Operations Cash Flows from Investing Change in Short-term Investments Change in Net Plant & Equipment Change in Other Long-term assets Total Cash Flows from Investing Cash Flows from Financing Change in Short-term Debt Change in Long-term Debt Change in Other Long-term Liabilities Change in Common Stock Change in Other Equity Cash Dividends Paid to Shareholders Total Cash Flows from Financing Net Change in Cash Balance Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 $ 6,756 5,614 43,783 3,511 59,664 $ 9,465 6,284 44,435 1,622 61,806 105,208 17,424 4,417 0 31,073 16,567 236,495 $ 7,722 6,283 44,269 3,623 61,897 104,317 0 0 7,078 31,181 14,822 219,295 185,154 (77,479) 107,675 12,703 (5,560) 7,143 18,242 11,798 204,522 Consolidated Balance Sheets - USD ($) $ In Millions 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 Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: 6 Short-term borrowings 7 Accounts payable 8 Accrued liabilities -9 Accrued income taxes CO Long-term debt due within one year 1 Operating lease obligations due within one year 22 Finance lease obligations due within one year 23 Capital lease and financing obligations due within one year 24 Total current liabilities 25 Long-term debt 26 Long-term operating lease obligations 27 Long-term finance lease obligations 28 Long-term capital lease and financing obligations 29 Deferred income taxes and other 30 commitments and contingencies 31 Equity: 32 Common stock 33 Capital in excess of par value 34 Retained earnings 35 Accumulated other comprehensive loss 36 Total Walmart shareholders' equity 37 Noncontrolling interest 38 Total equity 39 Total liabilities and equity 40 41 575 46,973 22,296 280 5,362 1,793 511 0 77,790 43,714 16,171 4,307 0 12,961 5,225 47,060 22,159 428 1,876 0 0 729 77,477 43,520 0 0 6,683 11,981 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 284 3,247 83,943 (12,805) 74,669 6,883 81,552 $ 236,495 288 2,965 80,785 (11,542 72,496 7,138 79,634 $ 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 12 Months Ended Jan. 31, 2019 Jan. 31, 2020 Jan 31, 2018 $ 519,926 4,038 523,964 $ 510,329 4,076 514,405 $ 495,761 4,582 500,343 394,605 108,791 20,568 385,301 107,147 21,957 373,396 106,510 20,437 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Revenues: Net Sales Membership and other income Total revenues Costs and expenses: Cost of sales Operating selling general and administrative expenses Operating income Interest: Debt Finance, capital lease and financing obligations Interest income Interest, net Loss on extinguishment of debt Other (gains) and losses 8 Income before income taxes 9 Provision for income taxes 0 Consolidated net income 1 Consolidated net income attributable to noncontrolling interest 22 Consolidated net income attributable to Walmart 23 Net income per common share: 24 Basic net income per common share attributable to Walmart 25 Diluted net income per common share attributable to Walmart 26 Weighted average common shares outstanding: 27 Basic (in shares) 28 Diluted (in shares) 29 Dividends declared per common share 30 2,262 337 (189) 2,410 0 (1,958) 20,116 4,915 15,201 (320) $ 14,881 1,975 371 (217) 2,129 0 8,368 11,460 4,281 7,179 (509) $6,670 1,978 352 (152) 2,178 3,136 0 15,123 4,600 10,523 (661) $ 9,862 $5.22 $5.19 $ 2.28 $ 2.26 $ 3.29 $ 3.28 2,850 2,868 $ 2.12 2,929 2,945 $ 2.08 2,995 3,010 $2.04 32 33 34 35 26