ACCTG 512: Financial Accounting Theory and Reporting Problems Individual Project of Cash Flow Statement Analysis (20 points) Download Wal-mart Stores Inc. financial statements by clicking on the Activities section in the left-hand menu, selecting the Wal-mart Resources folder, and finally clicking on the file Wal-mart Financial Statements Data. Your final product should consist of a Word document with Excel tables copied and pasted into the document. If needed, follow these instructions to copy an Excel solution as an Excel object and paste it into a Word document: Edit> Paste Special... >Microsoft Excel Worksheet Object. For more information, please see Microsoft's information on linking or embedding Excel worksheets (http://office.microsoft.com/en-us/word-help/link-or-embed-an- excel-worksheet-HA010120810.aspx). Once you have completed answering the following questions upload your file to the assignment dropbox. Requirements: 1. Evaluate the sources and uses of cash for Wal-mart Stores Inc. including: (5 points) a. the major sources and uses of cash flow between operating, investing, and financing activities over the past five years; b. significant determinants of operating cash flows; c. significant determinants of investing cash flows; and d. significant determinants of financing cash flows. From your evaluation, is operating cash flow positive and sufficient to cover capital expenditures? 2. Common size statement analysis (5 points) a. Prepare a common size cash flow statement using net sales as the common size and keep 2 decimal places in the percentage, (for example, 12.43%). b. Are depreciation expenses and capital expenditure significant components in the cash flow statement percentagewise? Is that surprising? c. Percentagewise, is operating cash flow/net sales higher than net income/sales?? Is that good? d. Do operating cash flows meet the needs of investment and distribution? Provide your comment(s) on the trend of the answer to this question?