At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major

expansions for the company in the next five years. The board is considering $5 million. Take the most recent financial statements and set of

projected financial statements based on the given assumptions. The CEO requests that you to write report (including the financial statements)

for her.

A. Generate a projected income statement based on the given scenario.

B. Analyze the impact on the income statement based on the given scenario.

C. Generate a projected statement of retained earnings based on the given scenario.

D. Analyze the impact on the statement of retained earnings based on the given scenario.

E. Generate a projected balance sheet based on the given scenario.

F. Analyze the impact on the balance sheet based on the given scenario.

G. Generate a projected cash flow statement based on the given scenario.

H. Analyze the impact on the cash flow statement based on the given scenario.

ACC 620 Final Project Guidelines and Rubric Overview According to the AICPA (American Institute of Certified Public Accountants), a CPA in today's environment must not only have a high level of technical competence and a sense of commitment to service, but must also have good communications and analytical skills and the ability to work well with people. Employers are looking for individuals who have the ability to analyze and evaluate complex business problems and the interpersonal skills and maturity to make decisions in a client and customer service environment. By continuing to use the company that you adopted in ACC 610, you will apply the technical competence and other skills required by today's CPAs. Through casestudy analysis, you will develop skills such as communication, presentation, and interpersonal relations in conjunction with technical accounting knowledge. If you have transferred directly into ACC 620 and have not had the opportunity to choose a company, you will do so at this time. You will also use this company in ACC 630. Throughout ACC 620 and ACC 630, you will apply the concepts you are learning using the financial data and business scenarios of a prominent retail company. You may choose from Wal-Mart, Target, Sears, Kroger, or Amazon. ACC 620: Financial Reporting II is a continuation of ACC 610. In ACC 620, your focus in the final project will be on developing skills in critical thinking and applying accounting theories and practices according to generally accepted accounting principles (GAAP). You will be analyzing situations and communicating results to decision makers with an emphasis on stockholders' equity, income measurement, income taxes, pensions, leases, and statements of changes in financial positions. The project is divided into three milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be submitted in Modules Three, Five, and Seven. The final product will be submitted in Module Nine. In this assignment, you will demonstrate your mastery of the following course outcomes: Analyze stockholder sections of balance sheets for how they inform stakeholders of equity positioning Interpret income measurement for determining the accuracy of financial statements Analyze the effect of income taxes and their impact on financial statement accounts for appropriate estimation and planning Evaluate various pension plans for their implications on balance sheets and income statements Differentiate between operating and capital leases for addressing their impact on balance sheets and income statements Analyze complex financial statements for informing stakeholders in making economic decisions Prompt You will continue to work with the retail company you have chosen either in ACC 610 or at the beginning of this class. If you are transferring into SNHU's financial reporting courses, you will choose from five retail companies (Wal-Mart, Target, Sears, Kroger, or Amazon). This company will be yours throughout the Financial Reporting Series (ACC 610, ACC 620, ACC 630). You will adopt this company to apply learning concepts in authentic scenarios. Through this assessment, you will continue building your Financial Reporting Series portfolio. Your portfolio pieces for this project will include memos, spreadsheets, and a final report. At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major expansions for the company in the next five years. The board is considering issuing a total amount of stock worth $5 million. The CEO has asked you to analyze the impact of issuing this stock on the income statement, statement of retained earnings, balance sheet, and cash flow statement. Take the most recent financial statements and prepare a set of projected financial statements based on the given assumptions. Specifically, the following critical elements must be addressed: I. Stockholders' Equity A. Determine how your company got its initial financial start in terms of debt (liabilities) or equity (capital). Support your response. B. Analyze the equity section of your company's balance sheet as compared to your company's industry average. Rate the company's performance against its competitors. C. Review your company's dividend policy and its history. Based on the information, discuss the trends over the past year. II. Income Measurement/Revenue Recognition A. Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) came together on a unified project to outline the accounting principles for recognizing revenue and to develop a common revenue standard for U.S. GAAP and IFRS. Research IAS-18, Revenue, and discuss how it would apply to your company. B. Review your company's revenue over the past two years. Analyze the change in revenue (increase/decrease) and give the reasons for this change. C. Reflecting upon your company's balance sheet, identify the unearned revenue accounts listed. How does your company handle the proper accounting treatment with regard to recognizing revenue from unearned revenue accounts? III. Income Taxes A. If Congress voted to eliminate corporate taxes, what would be the effect on your company's income statement and balance sheet? Defend your response. B. Calculate the income tax rate for your chosen company. What effect will an increase in income of $2,000,000 have on your company? C. What are the effects on the balance sheet and income statement? Justify your response. D. How much did your company pay in foreign taxes last year? What percentage of its income is United States vs. foreign? IV. Leases A. B. C. D. What are the differences between operating and capital leases? Describe the particular leases of your company based on the liability section of your company's balance sheet. What impact have the leases had on the company's financial statements for the most recent year? Discuss the advantages and disadvantages of leasing a building versus purchasing one. V. Pensions Address the following elements in the form of a memo to your CEO: A. From your company's financial information, what type of pension plan does it have? Discuss the reasons why your company has chosen this particular plan. B. What was the effect of the pension plan on your company's financial statements? Defend your response. C. Your CEO has informed youthe controller of your companythat the board of directors has made the decision to look at other options of types of retirement plans. Investigate what other alternatives would be available, and determine which would be appropriate for your particular company. VI. Statement of Changes in Financial Position A. From the perspective of an investor, determine whether or not you would invest in your chosen company based on the company's statement of changes in financial position (SCFP). Support your opinion. B. Review the company's SCFP for any concerns that may need to be addressed. As controller of your company, prepare a memo to your CEO, giving a summary report for possible recommendations. VII. Report for CEO At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major expansions for the company in the next five years. The board is considering $5 million. Take the most recent financial statements and prepare a set of projected financial statements based on the given assumptions. The CEO requests that you prepare a written report (including the financial statements) for her. A. Generate a projected income statement based on the given scenario. B. Analyze the impact on the income statement based on the given scenario. C. Generate a projected statement of retained earnings based on the given scenario. D. Analyze the impact on the statement of retained earnings based on the given scenario. E. Generate a projected balance sheet based on the given scenario. F. Analyze the impact on the balance sheet based on the given scenario. G. Generate a projected cash flow statement based on the given scenario. H. Analyze the impact on the cash flow statement based on the given scenario. Milestones Milestone One: Stockholders' Equity and Revenue Recognition In Module Three, you will submit critical elements I and II for review by your instructor. It is important that you incorporate your instructor's feedback from this milestone into your final submission. This milestone will be graded with the Milestone One Rubric. Milestone Two: Income Taxes and Pensions In Module Five, you will submit critical elements III and V for review by your instructor. It is important that you incorporate your instructor's feedback from this milestone into your final submission. This milestone will be graded with the Milestone Two Rubric. Milestone Three: Leases and Changes in Financial Position In Module Seven, you will submit critical elements IV and VI for review by your instructor. It is important that you incorporate your instructor's feedback from this milestone into your final submission. This milestone will be graded with the Milestone Three Rubric. Final Submission: Financial Reporting Series Portfolio In Module Nine, you will submit your final project. It should be a complete, polished artifact containing all of the critical elements of the final product, including critical element VII: Report for the CEO. It should reflect the incorporation of feedback gained throughout the course. This submission will be graded with the Final Project Rubric. Deliverables Milestone One Two Three Deliverable Stockholders' Equity and Revenue Recognition Module Due Three Grading Graded separately; Milestone One Rubric Five Graded separately; Milestone Two Rubric Leases and Changes in Financial Position Seven Graded separately; Milestone Three Rubric Final Submission: Financial Reporting Series Portfolio Nine Graded separately; Final Project Rubric Income Taxes and Pensions Final Project Rubric Guidelines for Submission: Your portfolio should be 6-10 pages (including spreadsheets, memos, and summary), double-spaced, with one-inch margins, 12point Times New Roman font, and APA format. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Stockholders' Equity: Initial Financial Start Exemplary Meets \"Proficient\" criteria and uses concrete examples to substantiate claims (100%) Stockholders' Equity: Industry Average Meets \"Proficient\" criteria and uses concrete examples to substantiate claims (100%) Stockholders' Equity: Dividend Policy Meets \"Proficient\" criteria, and discussion is exceptionally clear and contextualized (100%) Income Measurement/ Revenue Recognition: IAS-18 Meets \"Proficient\" criteria and uses concrete examples to substantiate claims (100%) Income Measurement/ Revenue Recognition: Revenue Meets \"Proficient\" criteria, and rationale is well supported with concrete evidence (100%) Proficient Determines whether the company obtained its startup financing from debt or equity and supports response (90%) Analyzes the company's equity section as compared to the industry average and accurately rates the company's performance against competitors (90%) Analyzes the company's dividend policy and its history to discuss the trends over the past year (90%) Discusses IAS-18's application to the company (90%) Needs Improvement Determines whether the company obtained its startup financing from debt or equity, but does not support response (70%) Analyzes the company's equity section as compared to the industry average, but does not accurately rate the company's performance against competitors (70%) Analyzes the company's dividend policy and its history, but does not discuss the trends over the past year (70%) Discusses IAS-18's application to the company, but discussion is cursory or lacks detail (70%) Not Evident Does not identify how the company obtained its startup financing (0%) Analyzes the change in revenue and gives the reasons for the change (90%) Analyzes the change in revenue, but does not give the reasons for the change (70%) Value 4.8 Does not analyze the company's equity section (0%) 4.8 Does not analyze the company's dividend policy (0%) 4.8 Does not research IAS-18 (0%) 4.8 Does not analyze the change in revenue (0%) 4.8 Income Measurement/ Revenue Recognition: Unearned Revenue Meets \"Proficient\" criteria and displays a nuanced understanding of the company's internal processes (100%) Income Taxes: Corporate Taxes Meets \"Proficient\" criteria, and defense is well supported with quantitative evidence (100%) Income Taxes: Increase in Income Meets \"Proficient\" criteria, and determination is well supported with quantitative evidence (100%) Accurately calculates the income tax rate for the company and determines the effect an increase in income would have on the company (90%) Income Taxes: Effects Meets \"Proficient\" criteria, and justification is well supported with quantitative evidence (100%) Accurately determines the effects on the balance sheet and income statement and justifies response (90%) Income Taxes: Foreign Taxes Identifies unearned revenue accounts listed as well as how the company handles the proper accounting treatment with regard to recognizing revenue from unearned revenue accounts (90%) Accurately describes the effect on the company's income statement and balance sheet if Congress voted to eliminate corporate taxes, and defends response (90%) Accurately determines how much the company paid in foreign taxes last year and what percentage of its income was United States versus foreign (100%) Identifies unearned revenue accounts listed, but does not determine how the company handles the proper accounting treatment with regard to recognizing revenue from unearned revenue accounts (70%) Describes the effect on the company's income statement and balance sheet if Congress voted to eliminate corporate taxes, but does not defend response, description contains inaccuracies, or defense is illogical (70%) Calculates the income tax rate for the company and determines the effect an increase in income would have on the company, but calculation or determination contains inaccuracies (70%) Determines the effects on the balance sheet and income statement, but determination contains inaccuracies, does not justify determination, or justification is illogical (70%) Determines how much the company paid in foreign taxes last year and what percentage of its income was United States versus foreign, but determination contains inaccuracies (70%) Does not identify unearned revenue accounts listed (0%) 4.8 Does not describe the effect on the company's income statement and balance sheet (0%) 4.8 Does not calculate the income tax rate for the company (0%) 4.8 Does not determine the effects on the balance sheet and income statement (0%) 4.8 Does not determine how much the company paid in foreign taxes last year (0%) 4.8 Leases: Operating and Capital Meets \"Proficient\" criteria, and description is exceptionally clear and contextualized (100%) Comprehensively describes the differences between operating and capital leases (90%) Leases: Particular Meets \"Proficient\" criteria, and description is exceptionally clear and contextualized (100%) Describes the particular leases of the company based on the liability section of the company's balance sheet (90%) Leases: Impact Meets \"Proficient\" criteria, and defense is well supported with concrete examples (100%) Comprehensively discusses the impact the leases had on the company's financial statements for the most recent year (90%) Leases: Building Meets \"Proficient\" criteria and uses concrete examples to illustrate claims (100%) Comprehensively discusses the advantages and disadvantages of leasing a building versus purchasing one (90%) Meets \"Proficient\" criteria and shows a nuanced understanding of the company's decisionmaking rationale (100%) Meets \"Proficient\" criteria, and defense is well supported with concrete examples (100%) Discusses the type of pension plan the company has and the reasons why the company has chosen that plan (90%) Accurately determines the effect of the pension plan on the company's financial statements and defends response (90%) Pensions: Pension Plan Pensions: Effect Describes the differences between operating and capital leases, but description is cursory or lacks detail (70%) Describes the particular leases of the company, but does not base description on the liability section of the company's balance sheet (70%) Discusses the impact the leases had on the company's financial statements for the most recent year, but discussion is cursory or lacks detail (70%) Discusses the advantages and disadvantages of leasing a building versus purchasing one, but discussion is cursory or lacks detail (70%) Discusses the type of pension plan the company has, but does not discuss the reasons why the company chose that plan (70%) Determines the effect of the pension plan on the company's financial statements, but determination lacks accuracy, does not defend determination, or defense is weak or illogical (70%) Does not describe the differences between operating and capital leases (0%) 4.8 Does not describe the particular leases of the company (0%) 4.8 Does not discuss the impact the leases had on the company's financial statements (0%) 4.8 Does not discuss the advantages and disadvantages of leasing a building versus purchasing one (0%) 4.8 Does not identify the type of pension plan the company has (0%) 4.8 Does not determine the effect of the pension plan on the company's financial statements (0%) 4.8 Pensions: Other Options Meets \"Proficient\" criteria and is well supported with concrete examples (100%) Evaluates other types of retirement plans available and determines which would be appropriate for the company (90%) Statement of Changes in Financial Position: Invest Meets \"Proficient\" criteria, and opinion is well supported with concrete examples (100%) Determines whether or not to invest in the company based on the SCFP and supports opinion (90%) Statement of Changes in Financial Position: Recommendations Meets \"Proficient\" criteria, and recommendations are well supported and logical (100%) Composes a memo to the CEO making recommendations that would effectively resolve any concerns identified in the SCFP (90%) Report for CEO: Projected Income Statement Report for CEO: Impact on the Income Statement Meets \"Proficient\" criteria and cites specific, relevant examples from the projected statement (100%) Report for CEO: Projected Statement of Retained Earnings Report for CEO: Impact on the Statement of Retained Earnings Generates a projected income statement based on the given scenario (100%) Analyzes the impact on the income statement based on the given scenario (90%) Generates a projected statement of retained earnings based on the given scenario (100%) Meets \"Proficient\" criteria and cites specific, relevant examples from the projected statement (100%) Analyzes the impact on the statement of retained earnings based on the given scenario (90%) Evaluates other types of retirement plans available, but does not determine which would be appropriate for the company (70%) Determines whether or not to invest in the company based on the SCFP, but does not support opinion, or support for opinion is weak or illogical (70%) Composes a memo to the CEO making recommendations to address concerns identified in the SCFP, but recommendations would not effectively resolve concerns (70%) Generates a projected income statement, but does not use the given scenario (70%) Analyzes the impact on the income statement, but does not base analysis on the given scenario (70%) Generates a projected statement of retained earnings, but does not use the given scenario (70%) Analyzes the impact on the statement of retained earnings, but does not base analysis on the given scenario (70%) Does not evaluate other types of retirement plans available (0%) 4.8 Does not determine whether or not to invest in the company (0%) 1.6 Does not compose a memo to the CEO (0%) 1.6 Does not generate a projected income statement (0%) 1.6 Does not analyze the impact on the income statement (0%) 1.6 Does not generate a projected statement of retained earnings (0%) 1.6 Does not analyze the impact on the statement of retained earnings (0%) 1.6 Report for CEO: Projected Balance Sheet Meets \"Proficient\" criteria and cites specific, relevant examples from the projected statement (100%) Generates a projected balance sheet based on the given scenario (100%) Analyzes the impact on the balance sheet based on the given scenario (90%) Report for CEO: Impact on the Cash Flow Statement Meets \"Proficient\" criteria and cites specific, relevant examples from the projected statement (100%) Generates a projected cash flow statement based on the given scenario (100%) Analyzes the impact on the cash flow statement based on the given scenario (90%) Articulation of Response Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to-read format (100%) Report for CEO: Impact on the Balance Sheet Report for CEO: Projected Cash Flow Statement Submission has no major errors related to citations, grammar, spelling, syntax, or organization (90%) Generates a projected balance sheet, but does not use the given scenario (70%) Analyzes the impact on the balance sheet, but does not base analysis on the given scenario (70%) Generates a projected cash flow statement, but does not use the given scenario (70%) Analyzes the impact on the cash flow statement, but does not base analysis on the given scenario (70%) Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas (70%) Does not generate a projected balance sheet (0%) 1.6 Does not analyze the impact on the balance sheet (0%) 1.6 Does not generate a projected cash flow statement (0%) 1.6 Does not analyze the impact on the cash flow statement (0%) 1.6 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%) 2.4 Total 100% WAL-MART STORES INC (WMT) CashFlowFlag INCOME STATEMENT Fiscal year ends in January. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Sales, General and administrative Total operating expenses Operating income Interest Expense Other income (expense) Income before income taxes Provision for income taxes Minority interest Other income Net income from continuing operations Net income from discontinuing ops Other Net income Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA 2013-01 2014-01 2015-01 2016-01 469,162.00 476,294.00 485,651.00 482,130.00 352,488.00 358,069.00 365,086.00 360,984.00 116,674.00 118,225.00 120,565.00 121,146.00 88,873.00 88,873.00 27,801.00 2,251.00 187.00 25,737.00 7,981.00 757.00 757.00 17,756.00 93,418.00 93,418.00 27,147.00 2,461.00 113.00 24,799.00 7,985.00 736.00 736.00 16,814.00 285.00 (736.00) 16,363.00 16,363.00 97,041.00 97,041.00 24,105.00 2,548.00 81.00 21,638.00 6,558.00 386.00 386.00 15,080.00 (757.00) 16,999.00 16,999.00 91,353.00 91,353.00 26,872.00 2,335.00 119.00 24,656.00 8,105.00 673.00 673.00 16,551.00 144.00 (673.00) 16,022.00 16,022.00 5.04 5.02 4.90 4.88 5.07 5.05 4.58 4.57 3,374.00 3,389.00 36,489.00 3,269.00 3,283.00 35,861.00 3,230.00 3,243.00 36,433.00 3,207.00 3,217.00 33,640.00 (386.00) 14,694.00 14,694.00 Dollar Trend 2017-01 TTM 2015-2016 2016-2017 2017-2018 485,873.00 487,511.00 (3,521.00) 3,743.00 361,256.00 362,400.00 (4,102.00) 272.00 124,617.00 125,111.00 581.00 3,471.00 101,853.00 102,385.00 3,623.00 4,812.00 101,853.00 102,385.00 3,623.00 4,812.00 22,764.00 22,726.00 (3,042.00) (1,341.00) 2,367.00 2,380.00 87.00 (181.00) 100.00 111.00 (32.00) 19.00 20,497.00 20,457.00 (3,161.00) (1,141.00) 6,204.00 6,228.00 (1,427.00) (354.00) 650.00 626.00 (350.00) 264.00 650.00 626.00 (350.00) 264.00 14,293.00 14,229.00 (1,734.00) (787.00) (285.00) (650.00) (626.00) 350.00 (264.00) 13,643.00 13,603.00 (1,669.00) (1,051.00) 13,643.00 13,603.00 (1,669.00) (1,051.00) 4.40 4.42 (0.49) (0.18) 4.38 4.40 (0.48) (0.19) 3,101.00 3,074.00 (23.00) (106.00) 3,112.00 3,085.00 (26.00) (105.00) 32,944.00 33,080.00 (2,793.00) (696.00) % Trend 2015-20162016-2017 -1% 1% -1% 0% 0% 3% 4% 4% -11% 4% -28% -13% -18% -48% -48% -10% 5% 5% -6% -7% 23% -5% -5% 68% 68% -5% -48% -10% -10% 68% -7% -7% -10% -10% -4% -4% -1% -1% -8% -3% -3% -2% 2017-2018 WAL-MART STORES INC (WMT) CashFlowFlag BALANCE SHEET Fiscal year ends in January. USD in millions except per share data. Assets Current assets Cash Cash and cash equivalents Total cash Receivables Inventories Prepaid expenses Other current assets Total current assets Non-current assets Property, plant and equipment Land Fixtures and equipment Other properties Property and equipment, at cost Accumulated Depreciation Property, plant and equipment, net Goodwill Other long-term assets Total non-current assets Total assets Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt Capital leases Accounts payable Taxes payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities Long-term debt Capital leases Deferred taxes liabilities Minority interest Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity Common stock Additional paid-in capital Retained earnings 2013-01 7,781.00 7,781.00 6,768.00 43,803.00 1,588.00 2014-01 2015-01 2016-01 9,135.00 9,135.00 6,778.00 45,141.00 2,224.00 8,705.00 8,705.00 5,624.00 44,469.00 1,441.00 59,940.00 7,281.00 7,281.00 6,677.00 44,858.00 1,909.00 460.00 61,185.00 63,278.00 60,239.00 25,612.00 43,699.00 102,413.00 171,724.00 (55,043.00) 116,681.00 20,497.00 5,987.00 143,165.00 203,105.00 26,184.00 45,756.00 106,738.00 178,678.00 (60,771.00) 117,907.00 19,510.00 6,149.00 143,566.00 204,751.00 26,261.00 47,851.00 108,522.00 182,634.00 (65,979.00) 116,655.00 18,102.00 5,671.00 140,428.00 203,706.00 25,624.00 49,950.00 112,480.00 188,054.00 (71,538.00) 116,516.00 16,695.00 6,131.00 139,342.00 199,581.00 12,392.00 327.00 38,080.00 5,062.00 15,957.00 6,402.00 287.00 38,410.00 3,613.00 16,560.00 5,453.00 551.00 38,487.00 3,065.00 17,063.00 71,818.00 11,773.00 309.00 37,415.00 3,520.00 16,239.00 89.00 69,345.00 65,272.00 64,619.00 38,394.00 3,023.00 7,613.00 5,395.00 519.00 54,944.00 126,762.00 41,771.00 2,788.00 8,017.00 5,084.00 1,491.00 59,151.00 128,496.00 41,086.00 2,606.00 8,805.00 4,543.00 38,214.00 5,816.00 7,321.00 3,065.00 57,040.00 122,312.00 54,416.00 119,035.00 332.00 3,620.00 72,978.00 323.00 2,362.00 76,566.00 323.00 2,462.00 85,777.00 317.00 1,805.00 90,021.00 Accumulated other comprehensive inc (587.00) Total stockholders' equity 76,343.00 Total liabilities and stockholders' equity 203,105.00 (2,996.00) 76,255.00 204,751.00 (7,168.00) 81,394.00 203,706.00 (11,597.00) 80,546.00 199,581.00 Dollar Trend 2017-01 6,867.00 6,867.00 5,835.00 43,046.00 1,941.00 57,689.00 24,801.00 51,843.00 114,485.00 191,129.00 (76,951.00) 114,178.00 17,037.00 9,921.00 141,136.00 198,825.00 3,355.00 565.00 41,433.00 3,737.00 17,838.00 66,928.00 36,015.00 6,003.00 9,344.00 2,737.00 54,099.00 121,027.00 305.00 2,371.00 89,354.00 2015-2016 1,854.00 1,854.00 101.00 283.00 315.00 (460.00) 2,093.00 77.00 2,095.00 1,784.00 3,956.00 (5,208.00) (1,252.00) (1,408.00) (478.00) (3,138.00) (1,045.00) - 2016-2017 (430.00) (430.00) (1,154.00) (672.00) (783.00) (3,039.00) (637.00) 2,099.00 3,958.00 5,420.00 (5,559.00) (139.00) (1,407.00) 460.00 (1,086.00) (4,125.00) - % Trend 2017-2018 2015-2016 2016-2017 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.2546354 0.0151266 0.0063088 0.1650079 -1 0.0342077 #DIV/0! #DIV/0! 0.0029407 0.0457863 -0.0470717 -0.1702567 -0.0148867 -0.3520683 #DIV/0! -0.0480262 #DIV/0! #DIV/0! -0.0242565 0.0438653 0.0221404 0.0296768 0.0856988 0.0842541 -0.0106185 -0.0011915 -0.0777362 0.0811144 -0.0218575 -0.0077335 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! (14,232.00) 77,798.00 198,825.00 WAL-MART STORES INC (WMT) Statement of CASH FLOW Fiscal year ends in January. USD in millions except per share data. Cash Flows From Operating Activities Net income Depreciation & amortization Deferred income taxes (Gain) Loss from discontinued operations Accounts receivable Inventory Accounts payable Accrued liabilities Income taxes payable Other working capital Other non-cash items Net cash provided by operating activities Cash Flows From Investing Activities Investments in property, plant, and equipment Property, plant, and equipment reductions Acquisitions, net Purchases of investments Other investing charges Net cash used for investing activities Cash Flows From Financing Activities Short-term borrowing Long-term debt issued Long-term debt repayment Repurchases of treasury stock Cash dividends paid Other financing activities Net cash provided by (used for) financing activities Effect of exchange rate changes Net change in cash Cash at beginning of period Cash at end of period Free Cash Flow Operating cash flow Capital expenditure Free cash flow Supplemental schedule of cash flow data Cash paid for income taxes Cash paid for interest 2013-01 2014-01 17,756.00 8,501.00 (133.00) 2015-01 16,695.00 8,870.00 (279.00) (144.00) 17,099.00 9,173.00 (503.00) (285.00) 527.00 25,591.00 (1,667.00) 531.00 103.00 (1,224.00) (566.00) 938.00 23,257.00 (1,229.00) 2,678.00 1,249.00 166.00 (569.00) 785.00 28,564.00 (12,898.00) 532.00 (316.00) (13,115.00) 727.00 (15.00) (12,174.00) 570.00 71.00 (12,611.00) 105.00 (12,298.00) 479.00 (11,125.00) 2,754.00 211.00 (1,478.00) (7,600.00) (5,361.00) (498.00) (11,972.00) 223.00 1,231.00 6,550.00 7,781.00 911.00 7,072.00 (4,968.00) (6,683.00) (6,139.00) (1,210.00) (11,017.00) (442.00) (500.00) 7,781.00 7,281.00 (6,288.00) 5,174.00 (3,904.00) (1,015.00) (6,185.00) (2,853.00) (15,071.00) (514.00) 1,854.00 7,281.00 9,135.00 25,591.00 (12,898.00) 12,693.00 23,257.00 (13,115.00) 10,142.00 28,564.00 (12,174.00) 16,390.00 7,304.00 2,262.00 8,641.00 2,362.00 8,169.00 2,433.00 (614.00) (2,759.00) 1,061.00 271.00 981.00 Dollar Trend 2016-01 2017-01 TTM 2015-2016 15,080.00 9,454.00 (672.00) 14,293.00 10,080.00 761.00 14,229.00 10,243.00 885.00 (703.00) 2,008.00 1,303.00 1,021.00 3,942.00 1,137.00 492.00 (402.00) 206.00 31,530.00 823.00 4,021.00 (111.00) 733.00 (170.00) 69.00 30,722.00 (10,400.00) 563.00 (1,889.00) 167.00 (10,675.00) (10,619.00) 456.00 (1,801.00) (1,901.00) (122.00) (13,987.00) 1,235.00 39.00 (4,432.00) (4,112.00) (6,294.00) (2,558.00) (16,122.00) (1,022.00) (430.00) 9,135.00 8,705.00 (1,673.00) 137.00 (2,055.00) (8,298.00) (6,216.00) (824.00) (18,929.00) (452.00) (1,838.00) 8,705.00 6,867.00 (1,256.00) 10.00 (1,555.00) (7,748.00) (6,192.00) (728.00) (17,469.00) (563.00) (1,052.00) 7,597.00 6,545.00 27,389.00 (11,477.00) 15,912.00 31,530.00 (10,619.00) 20,911.00 30,722.00 (10,400.00) 20,322.00 8,111.00 2,540.00 4,507.00 2,351.00 (491.00) 1,410.00 27,389.00 (11,477.00) 635.00 (2,016.00) (13,742.00) (2,019.00) 281.00 (169.00) 285.00 526.00 (670.00) 54.00 (166.00) 78.00 625.00 (1,175.00) 697.00 65.00 (312.00) 450.00 7,523.00 (5,135.00) (528.00) (3,097.00) 2016-2017 2017-2018 0 -787 626 1433 0 0 1724 1934 -166 492 89 -1204 4141 0 858 -179 -1801 -1901 -289 -3312 0 -2908 98 2377 -4186 % Trend 2015-2016 2016-2017 2017-2018 #DIV/0! #DIV/0! -0.1180770805 -0.05218833 0.0306333806 0.066215359 -1 #DIV/0! #DIV/0! #DIV/0! -0.427990236 -2.45234708 -0.2501867065 0.96314741 0.0432345877 -0.12739831 -1 #DIV/0! -0.1370826011 -0.18126273 0.7961783439 -0.85390071 -0.0411356953 0.151192084 #DIV/0! #DIV/0! 0.1140350877 -0.28188976 #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.0404494382 0.310257611 #DIV/0! #DIV/0! -0.9924623116 2.512820513 0.1352459016 -0.53632671 3.0512315271 1.017996109