Note that the cash flow statement provided is an indirect statement:
The Excel file includes an "Analysis" tab. Complete the information in that tab for the company we're analyzing. Complete all information on this tab and substantiate your conclusions (i.e. show calculations, provide commentary if appropriate). The tab will also have a place for you to put in general analytical comments about that company (i.e. what are they doing well, what are they doing poorly, what can you tell about the company based on the numbers, etc.). Approach this as if you were an external analyst brought in to advise the management team.
Here are a few other pointers:
•Complete the information for the most recent year (you don't need to do the analysis for every year).
•Ratios and rate of change data in the income statement should be represented as a percentage.
•Use 2 decimal points of precision
•When providing the narrative for the "Source of change in cash" talk through the changes for the most recent year, not changes from the previous year to the current year.
Attachment:- Company-Analysis-Assignment.rar