Question

In: Accounting

Examine WALMART cash flow statement for the most recent year only (e.g.: 2017). Analyze whether the...

Examine WALMART cash flow statement for the most recent year only (e.g.: 2017). Analyze whether the cash flow is “healthy” or not.

Solutions

Expert Solution

Analysis of Cash flow Statement of WALMART
Financial Year 2017

The cash flow statement (consolidated) of WALMART presents the following figures:

  • Opening Cash and Cash Equivalents: $8705 million
  • Closing Cash and Cash Equivalents: $6,867 million
  • Cash flow from Operating Activities: $31,530 million
  • Cash flow from Investing Activities: $(13,987) million
  • Cash flow from Financing Activities: $(18,929) million

Although a plain looking at the financial statements show a decrease of $1,838 million of cash and cash equivalents during the year, it is not a bad sign. The company has generated a cash surplus of $31,530 million from its core business activities (operating activities) which is quite impressive. The WALMART group has generated cash which is enough to cover substantial cash needs for investment and settlement of long-term liabilities without the need for depleting the existing cash reserves to a dangerously low level or without the need to raise the finance from external sources. The company has also paid a cash dividend of $6,216 million which is also a healthy sign which depicts the sufficiency of cash available.

Overall, the cash flows are healthy for WALMART group during the financial year 2017.


Related Solutions

7/ In preparing a company's statement of cash flows for the most recent year using the...
7/ In preparing a company's statement of cash flows for the most recent year using the indirect method, the following information is available: Net income for the year was $ 54,000 Accounts payable decreased by 20,000 Accounts receivable increased by 27,000 Inventories increased by 7,000 Cash dividends paid were 14,400 Depreciation expense was 22,000 Net cash provided by operating activities was:   Multiple Choice $46,000. $71,600. $22,000. $126,000. $32,000. 8/ Mercury Company reports depreciation expense of $41,000 for Year 2. Also,...
A company's most recent annual Free Cash Flow is $180,000,000. Free cash flow is expected to...
A company's most recent annual Free Cash Flow is $180,000,000. Free cash flow is expected to grow by 15% per year for the next 10 years and then grow by 3% per year thereafter. Investors required rate of return is 11%. What is the current value of the stock? a. $11,300,755,080 b. $2,250,000,000 c. $5,404,011,121 d. $1,636,363,636
Cash Flow Statement       2016     2017   Cash, beginning of year   $ 1,512.00   $ 1,176.00 Operating Activities Net...
Cash Flow Statement       2016     2017   Cash, beginning of year   $ 1,512.00   $ 1,176.00 Operating Activities Net Income     $ 1,627.00   $ 2,827.00 Plus Depreciation   $    908.00   $ 1,292.00 Minus increase in accounts receivable   $ (4,034.00)   $ (5,648.00) Minus increase in inventory   $ (3,302.00)   $ (4,732.00) Minus increase in prepaid expenses   $ (1,360.00)   $ (1,700.00) Plus increase in accounts payable   $ 2,388.00   $ 3,997.00 Plus increase in income taxes payable   $    252.00   $       -   Plus increase in accruals & other cur. Liab.  ...
Walmart Target Common size comparative analysis-Cash Flow Common size comparative analysis- Cash Flow For the year...
Walmart Target Common size comparative analysis-Cash Flow Common size comparative analysis- Cash Flow For the year ended January 31, 2018 For the year ended February 3, 2018 Details 2018 Details 2018 $ $ Net Income $9,862,000 Net Income $2,934,000 Cash Flows-Operating Activities Cash Flows-Operating Activities Depreciation $10,529,000 Depreciation $2,445,000 Net Income Adjustments $4,042,000 Net Income Adjustments $229,000 Changes in Operating Activities Changes in Operating Activities Accounts Receivable ($1,074,000) Accounts Receivable 0 Changes in Inventories ($140,000) Changes in Inventories ($348,000) Other...
Using the following free cash flow data: Year                Cash Flow 2017                $4,000,000
Using the following free cash flow data: Year                Cash Flow 2017                $4,000,000 2018                $4,400,000 Prepare a 10-year cash flow forecast based upon the rate of growth in cash flow between 2017 and 2018. Calculate the net present value of the forecasted cash flows assuming an immediate investment cost of $18,500,000 Please show your work so I can recreate in excel
Walmart company research project Walmart company cash - flow : monthly projection.explain.
Walmart company research project Walmart company cash - flow : monthly projection.explain.
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year...
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year ended January 31, 2017 Details 2018 Details 2017 $ $ Total Revenue $500,343,000 Total Revenue $485,873,000 Cost of Revenue $373,396,000 Cost of Revenue $361,256,000 Gross Profit $126,947,000 Gross Profit $124,617,000 Sales, General and Admin. $106,510,000 Sales, General and Admin. $101,853,000 Operating Income $20,437,000 Operating Income $22,764,000 Add’l income/expense items ($2,984,000) Add’l income/expense items $100,000 Earnings Before Interest and Tax $17,453,000 Earnings Before Interest and...
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year...
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year ended January 31, 2017 Details 2018 Details 2017 $ $ Total Revenue $500,343,000 Total Revenue $485,873,000 Cost of Revenue $373,396,000 Cost of Revenue $361,256,000 Gross Profit $126,947,000 Gross Profit $124,617,000 Sales, General and Admin. $106,510,000 Sales, General and Admin. $101,853,000 Operating Income $20,437,000 Operating Income $22,764,000 Add’l income/expense items ($2,984,000) Add’l income/expense items $100,000 Earnings Before Interest and Tax $17,453,000 Earnings Before Interest and...
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year...
Walmart Income Statement For the year ended January 31, 2018 Walmart Income Statement For the year ended January 31, 2017 Details 2018 Details 2017 $ $ Total Revenue $500,343,000 Total Revenue $485,873,000 Cost of Revenue $373,396,000 Cost of Revenue $361,256,000 Gross Profit $126,947,000 Gross Profit $124,617,000 Sales, General and Admin. $106,510,000 Sales, General and Admin. $101,853,000 Operating Income $20,437,000 Operating Income $22,764,000 Add’l income/expense items ($2,984,000) Add’l income/expense items $100,000 Earnings Before Interest and Tax $17,453,000 Earnings Before Interest and...
C. Construct the statement of cash flows for the most recent year(last photo.) (please give formulas...
C. Construct the statement of cash flows for the most recent year(last photo.) (please give formulas or equations) a. Britton String Corp. manufactures specialty strings for musical instruments and tennis racquets. Its most recent  sales were $880 million; operating costs (excluding depreciation) were equal to 85% of sales; net fixed assets were $300 million; depreciation amounted to 10% of net fixed assets; interest expenses were $22 million; the state-plus-federal corporate tax rate was 25%; and it paid 40% of its net...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT