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
