Compute and analyze the financial data using a Microsoft® Excel® spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so others can see how you arrived at your calculations and analysis. Items should be submitted in Microsoft® Excel®; indicate your recommendation in the Microsoft® Excel® spreadsheet: Calculate a 5-year projected cash flow. And create 1- 2 slide on defining projected cash flow and your work Attached is what needs to be followed in order to get all calculations Annual Data Statement of cash flow All numbers in thousands Period Ending 29-Jan-16 30-Jan-15 31-Jan-14 Net Income 2,546,000 2,698,000 2,286,000 Operating Activities, Cash Flows Provided By or Used In Depreciation 1,587,000 1,586,000 1,562,000 Adjustments To Net Income 673,000 77,000 54,000 Changes In Accounts Receivables Changes In Liabilities 594,000 315,000 610,000 Changes In Inventories -582,000 170,000 -396,000 Changes In Other Operating Activities -34,000 83,000 -5,000 Total Cash Flow From Operating Activities 4,784,000 4,929,000 4,111,000 Investing Activities, Cash Flows Provided By or Used In Capital Expenditures -1,197,000 -880,000 -940,000 Investments -175,000 -256,000 -223,000 Other Cash flows from Investing Activities 29,000 48,000 -123,000 Total Cash Flows From Investing Activities -1,343,000 -1,088,000 -1,286,000 Financing Activities, Cash Flows Provided By or Used In Dividends Paid -957,000 -822,000 -733,000 Sale Purchase of Stock -3,800,000 -3,768,000 -3,545,000 Net Borrowings 1,209,000 805,000 1,324,000 Other Cash Flows from Financing Activities 55,000 24,000 -15,000 Total Cash Flows From Financing Activities -3,493,000 -3,761,000 -2,969,000 Effect Of Exchange Rate Changes -9,000 -5,000 -6,000 Change In Cash and Cash Equivalents -61,000 75,000 -150,000 Annual Data , Income statement All numbers in thousands Period Ending 29-Jan-16 30-Jan-15 31-Jan-14 Total Revenue 59,074,000 56,223,000 53,417,000 Cost of Revenue 38,504,000 36,665,000 34,941,000 Gross Profit 20,570,000 19,558,000 18,476,000 Operating Expenses Research Development Selling General and Administrative 14,115,000 13,281,000 12,865,000 Non Recurring Others 1,484,000 1,485,000 1,462,000 Total Operating Expenses Operating Income or Loss 4,971,000 4,792,000 4,149,000 Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest And Taxes 4,419,000 4,276,000 3,673,000 Interest Expense Income Before Tax 4,419,000 4,276,000 3,673,000 Income Tax Expense 1,873,000 1,578,000 1,387,000 Minority Interest Net Income From Continuing Ops 2,546,000 2,698,000 2,286,000 Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income 2,546,000 2,698,000 2,286,000 Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 2,546,000 2,698,000 2,286,000
